LSQ/app.py at master · LogicSoftInd/LSQ · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
from flask import Flask, render_template, request, redirect, url_for, flash, jsonify

import db
import config

app = Flask(__name__)
app.secret_key = config.flask_secret_key

@app.route("/")
def index():
        searchword = request.args.get('search', '')
        if (searchword):
            queries = db.get_queries_for_search(searchword)
            if len(queries) == 0:
                flash("No record found", "error")
                queries = db.get_queries()
        else:
            queries = db.get_queries()

        return render_template("index.html", queries=queries, issearchword=searchword)

@app.route("/queries.json/")
def query_list():
    queries = db.get_queries()
    qlist = [
                {
                    "id":str(query["_id"]),
                    "title":query['title'],
                    "created_by":query['who'],
                    "tags":query['tags']
                }
            for query in queries]
    return jsonify({ "queries": qlist });

@app.route("/query/", methods=["POST"])
def query_add():
    try:
        title = request.form["title"].strip()
        sql = request.form["sql"].strip()
        tags = request.form["tags"].strip()
        desc = request.form["desc"].strip()
        who = request.form["who"].strip()

        if len(title) == 0 or len(sql) == 0:
            flash("Title and Sql are required fields", "error")
            return redirect(url_for("index"))

        db.insert_query(title, sql, tags, desc, who)
        flash("Query Added!", "success")
        return redirect(url_for("index"))

    except Exception as e:
        app.logger.error("Fatal error", exc_info=True)
        flash("Fatal error. Contact Administrator", "error")
        return redirect(url_for("index"))

@app.route("/query/<id>/", methods=["GET", "DELETE"])
def query_view(id):
    query = db.get_query_details(id)
    return render_template("view_query.html", query=query)

@app.route("/query/<id>/json/", methods=["GET"])
def query_json_view(id):
    query = db.get_query_details(id)
    json_val = {
        "title":query['title'],
        "query":query['sql'],
        "tags":query['tags'],
        "description":query['desc'],
        "created_by":query['who']
    }
    return jsonify(json_val)

@app.route("/query/<id>/edit/", methods=["GET", "POST"])
def query_edit(id):
    if request.method == "GET":
        query = db.get_query_details(id)
        return render_template("edit_query.html", query=query)
    elif request.method == "POST":
        try:
            id = request.form["id"].strip()
            title = request.form["title"].strip()
            sql = request.form["sql"].strip()
            tags = request.form["tags"].strip()
            desc = request.form["desc"].strip()
            who = request.form["who"].strip()

            if len(title) == 0 or len(sql) == 0:
                flash("Title and Sql are required fields", "error")
                return redirect(url_for("query_edit", id=id))

            db.update_query(id, title, sql, tags, desc, who)
            flash("Query Modified!", "success")
            return redirect(url_for("query_view", id=id))

        except Exception as e:
            app.logger.error("Fatal error", exc_info=True)
            flash("Fatal error. Contact Administrator", "error")
            return redirect(url_for("index"))

@app.route("/query/<id>/delete/", methods=["GET", "POST"])
def query_delete(id):
    if request.method == "GET":
        query = db.get_query_details(id)
        return render_template("delete_query.html", query=query)
    elif request.method == "POST":
        db.delete_query(id)
        flash("Delete Successful", "success")
        return redirect(url_for("index"))

if __name__ == "__main__":
    app.run(debug=config.flask_debug, port=config.flask_port, host=config.flask_bind_address)