https://github.com/VarianceDigital/minimal
https://getbootstrap.com/docs/5.0/content/tables/
https://flask-table.readthedocs.io/en/stable/
https://github.com/GitauHarrison/beautiful-flask-tables
https://flask-mysql.readthedocs.io/en/stable/
https://flask-sqlalchemy.readthedocs.io/en/stable/
https://flask-sqlalchemy.readthedocs.io/en/stable/config/
https://github.com/Gabrielmokhele/Flask-Web-App-with-MySQL-Database-Authentication-and-Notes-Feature
MYSQL DATABASE HOST |
188.245.88.238 |
MYSQL DATABASE PORT |
40000 |
MYSQL DATABASE USER |
My Username |
MYSQL DATABASE PASSWORD |
My Password |
MYSQL DATABASE DB |
Project Database |
MYSQL DATABASE CHARSET |
utf-8 |
Client:
import json
import requests
api_url = 'http://localhost:5000/create-row-in-gs'
create_row_data = {'id': '1235','name':'Joel','created_on':'27/01/2018','modified_on':'27/01/2018','desc':'This is Joel!!'}
print(create_row_data)
r = requests.post(url=api_url, json=create_row_data)
print(r.status_code, r.reason, r.text)
#make a POST request
import requests
dictToSend = {'question':'what is the answer?'}
res = requests.post('http://localhost:5000/tests/endpoint', json=dictToSend)
print('response from server:',res.text)
dictFromServer = res.json()
Server:
from flask import Flask,jsonify,request,make_response,url_for,redirect
import requests, json
app = Flask(__name__)
url = 'https://hooks.zapier.com/hooks/catch/xxxxx/yyyyy/'
@app.route('/create-row-in-gs', methods=['GET','POST'])
def create_row_in_gs():
if request.method == 'GET':
return make_response('failure')
if request.method == 'POST':
t_id = request.json['id']
t_name = request.json['name']
created_on = request.json['created_on']
modified_on = request.json['modified_on']
desc = request.json['desc']
create_row_data = {'id': str(t_id),'name':str(t_name),'created-on':str(created_on),'modified-on':str(modified_on),'desc':str(desc)}
response = requests.post(
url, data=json.dumps(create_row_data),
headers={'Content-Type': 'application/json'}
)
return response.content
if __name__ == '__main__':
app.run(host='localhost',debug=False, use_reloader=True)
#handle a POST request
from flask import Flask, render_template, request, url_for, jsonify
app = Flask(__name__)
@app.route('/tests/endpoint', methods=['POST'])
def my_test_endpoint():
input_json = request.get_json(force=True)
# force=True, above, is necessary if another developer
# forgot to set the MIME type to 'application/json'
print('data from client:', input_json)
dictToReturn = {'answer':42}
return jsonify(dictToReturn)
if __name__ == '__main__':
app.run(debug=True)