Spaces:
Sleeping
Sleeping
File size: 924 Bytes
5b065c1 |
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 |
from flask import Flask, request
import chdb
import os
app = Flask(__name__, static_folder="public", static_url_path="")
@app.route('/', methods=["GET"])
def clickhouse():
query = request.args.get('query', default="", type=str)
format = request.args.get('default_format', default="CSV", type=str)
if not query:
return app.send_static_file('play.html')
res = chdb.query(query, format)
return res.get_memview().tobytes()
@app.route('/', methods=["POST"])
def play():
query = request.data
format = request.args.get('default_format', default="CSV", type=str)
if not query:
return app.send_static_file('play.html')
res = chdb.query(query, format)
return res.get_memview().tobytes()
@app.errorhandler(404)
def handle_404(e):
return app.send_static_file('play.html')
host = os.getenv('HOST', '0.0.0.0')
port = os.getenv('PORT', 7860)
app.run(host=host, port=port)
|