from flask import Flask, g
import sqlite3

app = Flask(__name__)
PATH = "../rsdb"

def connect_db():
    return sqlite3.connect(PATH)

@app.before_request
def before_request():
    g.db = connect_db()

@app.teardown_request
def teardown_request(exception):
    if hasattr(g, 'db'):
        g.db.close()

def insert(table, fields=(), values=()):
    cur = g.db.cursor()
    query = "INSERT INTO playertable (playeruser, playeremail, playerpass, playerpin) VALUES ('test', 'test', 'test', '1111')"
    cur.execute(query)
    g.db.commit()

@app.route('/')
def homepage():
    connect_db()
    insert('no', ('no'), ('no'))
    return "Im here"


if __name__ == "__main__":
    app.run()