Simple REST server that fetches data from DB:

README.md

How to use:

1. create virtual environment: virtualenv app-server
2. activate it: . ./app-server/bin/activate
3. add werkzeug package: pip install werkzeug
4. create DB and import data into it: sqlite3 app.db < app.db.sql
5. run the server: python api-server.py
6. you should use URL http://localhost:4000 for your requests

NB! Alternatively you can give http://www.mocky.io/ a go. Here is a working mock: http://www.mocky.io/v2/563da96b1000009b2bbe6c97

api-server.py

from werkzeug.wrappers import Request, Response
import sqlite3
import json
from pprint import pprint

def dict_factory(cursor, row):
    d = {}
    for idx, col in enumerate(cursor.description):
        d[col[0]] = row[idx]
    return d

@Request.application
def application(request):
    db = sqlite3.connect("app.db")
    db.row_factory = dict_factory

    if request.method == "POST":
        new_rule = json.loads(request.data).get("newRule")
        if new_rule:
            db.execute("INSERT INTO rules (rule_name) VALUES (?)",
                      (new_rule,))
            db.commit()
    
    data = db.execute("SELECT * FROM rules").fetchall()
    res = Response(json.dumps(data))
    res.headers.add('Access-Control-Allow-Origin', '*')
    res.headers.add('Access-Control-Allow-Methods',
                    'GET,PUT,POST,DELETE,PATCH')
    res.headers.add('Access-Control-Allow-Headers',
                    'Content-Type, Authorization')
    return res

if __name__ == '__main__':
    from werkzeug.serving import run_simple
    run_simple('localhost', 4000, application, use_reloader=True)

app.db.sql

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE rules( id integer primary key AUTOINCREMENT, rule_name text);
INSERT INTO "rules" VALUES(1,'Must be 5 characters');
INSERT INTO "rules" VALUES(2,'Must not be used elsewhere');
INSERT INTO "rules" VALUES(3,'Must be cool');
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('rules',3);
COMMIT;