#coding: utf-8

import tornado.web
import sqlite3

conn = sqlite3.connect('c:/toz.db')
c = conn.cursor()

try:
    c.execute('''CREATE TABLE users (nom text, prenom text, age int)''')
except sqlite3.OperationalError:
    pass


class BaseHandler(tornado.web.RequestHandler):
    def get(self):
        self.render('page.html')


class Saver(tornado.web.RequestHandler):
    def post(self):
        nomm = self.get_argument('nom')
        pren = self.get_argument('prenom')
        age = int(self.get_argument('age'))
        c.execute("insert into users values (?, ?, ?)", (nomm, pren, age))
        conn.commit()
        self.redirect('/success')

class Getter(tornado.web.RequestHandler):
    def get(self):
        c.execute('select * from users')
        res = c.fetchall()
        #search about fetchmany(int), fetchone() to get only some records or one (note that after getting it, the cursor will increment)
        resultat = []
        for i in res:
            resultat.append(i)
        self.write(str(resultat))