from flask import Flask
from flask import request
from flask import render_template
import sqlite3 as sq


app = Flask(__name__)




@app.route("/")
@app.route("/form")
def form():

	l = []


	with sq.connect("dota.bd") as con:

		cur = con.cursor()
		cur.execute("""CREATE TABLE IF NOT EXISTS users( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,fname TEXT, lname TEXT, gender TEXT);""")
		con.commit()

		for row in cur.execute("SELECT gender FROM users;"):

			l.append(*row)

	return "<br>".join(l)

@app.route('/template', methods=['GET','POST','DELETE'])
def template():
	if request.method == 'POST':

		with sq.connect("dota.bd") as con:

			cur = con.cursor()
			cur.execute("""CREATE TABLE IF NOT EXISTS users( INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,fname TEXT, lname TEXT, gender TEXT);""")
			cur.execute("""INSERT INTO users (gender) VALUES ('m') """)



	if request.method == 'DELETE':

		with sq.connect("dota.bd") as con:

			cur = con.cursor()
			cur.execute("""CREATE TABLE IF NOT EXISTS users( INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,fname TEXT, lname TEXT, gender TEXT);""")
			cur.execute(""" DELETE FROM users WHERE ID in(SELECT MAX(ID) FROM users)  """)



	l = []


	with sq.connect("dota.bd") as con:

		cur = con.cursor()
		cur.execute("""CREATE TABLE IF NOT EXISTS users( INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,fname TEXT, lname TEXT, gender TEXT);""")
		con.commit()

		for row in cur.execute("SELECT gender FROM users;"):

			l.append(*row)




	return render_template("form.html",l=l)




if __name__ == "__main__":


	app.run(debug=True)