18 lines
561 B
Python
18 lines
561 B
Python
from flask import Flask, render_template, request
|
|
import sqlite3
|
|
|
|
db = sqlite3.connect("file:coglog.sqlite?mode=ro", check_same_thread=False, uri=True)
|
|
app = Flask(__name__)
|
|
|
|
@app.route("/")
|
|
def index():
|
|
return render_template("index.html")
|
|
|
|
@app.route("/query", methods=["GET", "POST"])
|
|
def query():
|
|
cs = db.cursor()
|
|
try:
|
|
cs.execute(request.form.get("query"))
|
|
except sqlite3.OperationalError:
|
|
return "lol retard got filtered by SQL"
|
|
return render_template("query.html", result=cs.fetchall(), query=request.form.get("query")) |