def create_table_sql():
host = request.json['host']
user = request.json['user']
password = request.json['password']
database = request.json['database']
table = request.json['table']
table_structure = request.json['table_structure']
db_obj = db_operations(host, user, password, database, table)
return jsonify(db_obj.create_mysql_table(table_structure))
def delete_mysql_records():
host = request.json['host']
user = request.json['user']
password = request.json['password']
database = request.json['database']
table = request.json['table']
selection_criteria = request.json['selection_criteria']
db_obj = db_operations(host, user, password, database, table)
return jsonify(db_obj.delete_mysql_data(selection_criteria))
def bulk_upload_mysql():
host = request.json['host']
user = request.json['user']
password = request.json['password']
database = request.json['database']
table = request.json['table']
file_location = request.json['file_location']
db_obj = db_operations(host, user, password, database, table)
return jsonify(db_obj.bulk_upload_mysql(file_location))
def insert_record_mysql():
host = request.json['host']
user = request.json['user']
password = request.json['password']
database = request.json['database']
table = request.json['table']
row_structure = request.json['row_structure']
db_obj = db_operations(host, user, password, database, table)
return jsonify(db_obj.insert_mysql_data(row_structure))
def download_data_mysql():
host = request.json['host']
user = request.json['user']
password = request.json['password']
database = request.json['database']
table = request.json['table']
file_location = request.json['file_location']
selection_criteria = request.json['selection_criteria']
db_obj = db_operations(host, user, password, database, table)
return jsonify(
db_obj.download_mysql_data(selection_criteria, file_location))
from flask import Flask,request
from db_operation import db_operations
application = Flask(__name__)
db_operator = db_operations()
@application.route("/insert",methods=["POST"])
def insert_table():
return db_operator.insert(request)
@application.route("/update",methods=["POST"])
def update():
return db_operator.update(request)
@application.route("/delete",methods=["POST"])
def delete():
return db_operator.delete(request)
@application.route("/query",methods=["GET"])
def query():
return db_operator.query()
if __name__=="__main__":
application.run(host='0.0.0.0')