from flask import Flask, render_template, request
from main import Psql
app = Flask(__name__)
psql = Psql(input())
@app.route("/", methods=['post', 'get'])
def display_table():
if request.method == 'POST':
command = request.form.get('command')
message = psql.execute_fetch(command)
return render_template("response.html", command=command, message=message)
table_list = psql.execute_fetch(
"SELECT table_name FROM information_schema.tables WHERE (table_schema = 'public') ORDER BY table_name;")
data = {}
for table in table_list:
table_data = psql.get_table_contents(table[0])
data.update({table[0]: table_data})
return render_template("main.html", data=data)
def init():
psql.execute_file("sql/create_tables.sql")
psql.execute_file("./sql/subject.sql")
psql.execute_file("./sql/teachers.sql")
psql.execute_file("./sql/clients.sql")
print("database initialised")
from flask import Flask, render_template, request
import json
from pymongo import MongoClient
from main import Psql
app = Flask(__name__)
psql = Psql('1324', dbname='lab_3', user='******', host='localhost')
client = MongoClient("mongodb://*****:*****@app.route("/", methods=['post', 'get'])
def mongo_display():
data = {}
for collection in ("clients", "mechanics", "profession", "progress"):
d = client["db"][collection].find({})
data[collection] = list(d)
return render_template("main.html", data=data)
@app.route("/postgre", methods=['post', 'get'])
def postgre_display():
if request.method == 'POST':
command = request.form.get('command')
message = psql.execute_fetch(command)
return render_template("response.html",
command=command,
message=message)
from flask import Flask, render_template, request
from main import Psql
app = Flask(__name__)
psql = Psql('postgres', dbname='lab', user='******', host='localhost')
@app.route("/", methods=['post', 'get'])
def table_display():
if request.method == 'POST':
command = request.form.get('command')
print(command)
message = psql.execute_fetch(command)
return render_template("response.html",
command=command,
message=message)
table_list = psql.execute_fetch(
"SELECT table_name FROM information_schema.tables WHERE (table_schema = 'public') ORDER BY table_name;"
)
data = {}
for table in table_list:
table_data = psql.get_table_contents(table[0])
data.update({table[0]: table_data})
return render_template("main.html", data=data)
from main import Psql
import json
psql = Psql('mysecretpassword',
dbname='postgres',
user='******',
host='localhost')
psql.execute_file("./sql_files/CREATE_TABLE.sql")
psql.execute_file("./sql_files/load_sample_data.sql")
print("database initialised")
table_list = psql.execute_fetch(
"SELECT table_name FROM information_schema.tables WHERE (table_schema = 'public') ORDER BY table_name;"
)
data = {}
for table in table_list:
table_data = psql.get_table_contents(table[0])
data.update({table[0]: table_data})
print(data)
for key in data:
l_d_ = [{data[key][0][i]: data[key][1][j][i]
for i in range(3)} for j in range(len(data[key][1]))]
with open(f"{key}.json", "w") as f:
json.dump(l_d_, f)
from flask import Flask, render_template, request, redirect, url_for
from main import Psql
app = Flask(__name__)
psql = Psql('administratorpass',
dbname='labs',
user='******',
host='localhost')
@app.route("/", methods=['post', 'get'])
def table_display():
if request.method == 'POST':
command = request.form.get('command')
message = psql.execute(command)
if message:
return render_template("response.html", command = command, message = message)
else:
return redirect(url_for('table_display'))
table_list = psql.execute("SELECT table_name FROM information_schema.tables WHERE (table_schema = 'public') ORDER BY table_name;")
data = {}
for table in table_list:
table_data = psql.get_table_data(table[0])
data.update({table[0]: table_data})
return render_template("main.html", data=data)
from flask import Flask, render_template, request
import json
from pymongo import MongoClient
from main import Psql
app = Flask(__name__)
psql = Psql('vfvf3212', dbname='postgres', user='******', host='localhost')
client = MongoClient("mongodb://*****:*****@app.route("/", methods=['post', 'get'])
def mongo_display():
data = {}
for collection in ("orders", "films", "directors", "users"):
d = client["db"][collection].find({})
data[collection] = list(d)
return render_template("main.html", data=data)
@app.route("/p", methods=['post', 'get'])
def postgre_display():
if request.method == 'POST':
command = request.form.get('command')
message = psql.execute_fetch(command)
return render_template("response.html",
command=command,
message=message)
from flask import Flask, render_template, request
from main import Psql
app = Flask(__name__)
psql = Psql('postgres',
dbname='lab4base',
user='******',
host='localhost',
port="5430")
@app.route("/", methods=['post', 'get'])
def table_display():
if request.method == 'POST':
command = request.form.get('command')
message = psql.execute(command)
return render_template("response.html",
command=command,
message=message)
table_list = psql.execute(
"SELECT table_name FROM information_schema.tables WHERE (table_schema = 'public') ORDER BY table_name;"
)
data = {}
for table in table_list:
table_data = psql.get_table_data(table[0])
data.update({table[0]: table_data})
return render_template("main.html", data=data)