def list_users():
try:
access_token = request.args.get('accessToken')
helper = DatabaseHelper()
return helper.list_users(access_token)
except Exception as e:
return "API Error\n" + e.message
def delete_project(id):
try:
access_token = request.args.get('accessToken')
helper = DatabaseHelper()
return helper.delete_project(id, access_token)
except Exception as e:
return "API Error\n" + e.message
def login():
try:
email = request.data.get("email")
password = request.data.get("password")
helper = DatabaseHelper()
return helper.login(email, password)
except Exception as e:
return "API Error\n" + e.message
def create_project():
try:
owner_id = request.data.get("owner_id")
name = request.data.get("name")
description = request.data.get("description")
due_date = request.data.get("due_date")
helper = DatabaseHelper()
return helper.create_project(owner_id, name, description, due_date)
except Exception as e:
return "API Error\n" + e.message
def register():
try:
email = request.data.get("email")
password = request.data.get("password")
firstname = request.data.get("firstname")
lastname = request.data.get("lastname")
helper = DatabaseHelper()
return helper.register(email, password, firstname, lastname)
except Exception as e:
return "API Error\n" + e.message
def __init__(self, model):
self.database = DatabaseHelper()
self.model = model
import paho.mqtt.client as mqtt #import the client1
from database_helper import DatabaseHelper
import paho.mqtt.client as mqtt
import re
username = "******"
password = "******"
database_helper = DatabaseHelper("employeerecords.db")
def start_record(args):
return database_helper.start_record(*args)
def stop_record(args):
return database_helper.stop_record()
def delete_employee(args):
return database_helper.delete_employee(args)
def show_list(args):
return database_helper.show_list(*args)
def update_employee(args):
return database_helper.update_employee(*args)
from config_reader import ConfigReader
from database_helper import DatabaseHelper
from json import loads
from flask import Flask, jsonify, request
app = Flask('CountriesREST')
cr = ConfigReader()
host, dbname, user, password = cr.get_database_config()
db = DatabaseHelper(host, dbname, user, password)
@app.route('/countries', methods=['GET'])
def get_countries():
result = db.execute_select('SELECT id, name, continent FROM public.countries')
return db.transform_dataset_into_json(result)
@app.route('/countries/<id>', methods=['GET'])
def get_country(id):
script = 'SELECT id, name, continent FROM public.countries WHERE id = {}'.format(id)
result = db.execute_select(script)
return db.transform_row_into_json(result)
@app.route('/countries/<id>', methods=['DELETE'])
def delete_country(id):
script = 'DELETE FROM public.countries WHERE id = {}'.format(id)
db.execute_script(script)
message = 'Country {} was deleted!'.format(id)
dic = {'message': message}
return jsonify(dic)
from flask import Flask
from database_helper import DatabaseHelper
app = Flask(__name__)
db_instance = DatabaseHelper()
@app.route('/api/tasks', methods=["GET"])
def get():
db_instance.get_a_todo()
@app.route('/api/tasks/bystatus/<status>', methods=["GET"])
def get_by_status(status):
db_instance.get_a_todo_by_status(status)
@app.route('/api/tasks/byid/<id>', methods=["GET"])
def get_a_todo_by_id(id):
db_instance.get_a_todo_by_id(id)
@app.route('/api/tasks/delete/<id>', methods=["DELETE"])
def delete(id):
db_instance.delete_a_to_do(id)
@app.route('/api/tasks/post', methods=["POST"])
def post():
db_instance.add_a_todo()
