Mysql Db + simple Flask app on Google Kubernetes Engine

MySql Docker image creation + python code for access + and Database creation + deployment on Google Kubernetes Engine:

Goal of the project is to prepare the necessary configuration files (yaml, py, docker files,...) to deploy a sample DB in a container on Google Kubernetes Engine (instructions of deployment to be included).

The project is divided into multiple sections:

A. MySQL on docker:

1. Write necessary docker-compose files to Create a docker image with Mysql Server and sample Database. Sample DB to be created at the initialisation (sh or python script required) of the docker image and will have persistance and port expose.

Mysql Server version: 5.7

Users: admin with root access, pythonClient with CRUD access to non-admin tables

Sample DB details (tables, column names and data type for each column) to be provided.

2. Write instruction file to run it all

B. Python Mysql Access:

1. Create python script ([login to view URL]) for CRUD access to the DB (5 functions). A configuration file is needed (will contain db info: ip, user, pass, dbname). Each Function takes the filename as a parameter and what else is needed (table name, column name...).

sample: getData(configurationFileName, table, Key_ColumnName, Key_Value) will return a pandas Dataframe if successful or error code if not.

Needed functions: createTable, deleteTable, getData, putData, deleteData

all functions will receive or return data in Pandas DataFrame format.

2. create a sample code to access [login to view URL] (all functions)

C. Flask on docker:

[login to view URL] a basic Flask server ([login to view URL]) on docker image that uses [login to view URL] to access mysql db on the container (from A) with user access and the following routes (using get/post rest Api access):

createTable, deleteTable, getData, putData, deleteData.

All data returned should be in json format.

docker compose files and other configuration files needed in addition to python files.

2. create a sample python code to call the Flask server using requests module and test all functions (login, createTable, deleteTable, getData, putData, deleteData.). The function calling putData will upload an excel file into dataframe and send it to putData on app.py.

This code can be run from anywhere (not on the cluster or on google).

D. Google Kubernetes Engine deployment:

Create configuration files and instruction files to deploy Mysql and Flask on kubernetes (google Kubernetes Engine) assuming we are starting from scratch (cluster doesn’t exist).

All code should be documented (functions should have comments explain all variables and return values, and main part of the code).

Python 3.6+ should be used

All python code should have [login to view URL] using pipreqs

other skills required: Flask, Docker, Kubernetes, Google Kubernetes Engine

Квалификация: Python, MySQL, Linux

Показать больше cloud sql proxy kubernetes, cloud sql postgres kubernetes, google cloud console, google cloud sql connection refused, google cloud, google mysql cloud proxy, cloud sql proxy multiple instances, cloudsql-instance-credentials, simple iphone app builder, program simple iphone app, simple iphone app ideas, iphone simple organizer app, code project simple ebay app, app google engine bb, edit mysql db iphone app, google app engine programmer needed, migrate java app google app engine, php mysql simple timesheet app, quiz app google app engine, filemaker app google app engine

О работодателе:
( 3 отзыв(-а, -ов) ) Beirut, Lebanon

ID проекта: #22025195

4 фрилансеров(-а) в среднем готовы выполнить эту работу за $197


Hello, How are you? My pleasure to bid your project. I've read carefully your project description. I have more than five years experience in development related with your project. Your satisfaction with the project is Больше

$140 USD за 7 дней(-я)
(7 отзывов(-а))

Dear Client, I'm a python developer with 5+ year's of experience that specializes me in multi-platform applications using Pyside /puqt, scrapy , pillow matplotlib. I am also working as a full stack developer, so that I Больше

$100 USD за 7 дней(-я)
(1 отзыв)

Hi! I have read your description and feel confident to fulfill your requirement. I have 9 years of C, C++, C#,QT , ASP.NET, Python, Arduino ,VB,Meta Trader,Raspberry Pi,Meta Trader, Block Chain..... Programming Experie Больше

$298 USD за 7 дней(-я)
(1 отзыв)

Am a certified kubernetes administrator. I have implemented highly available container platform using kubernetes. Developed and deployed microservices based applications. Follow the link below to learn more details htt Больше

$250 USD за 7 дней(-я)
(0 отзывов(-а))