from tornado import ioloop, web
import peewee

from api.routes import api_routes
from web.routes import web_routes


mysql_db = peewee.MySQLDatabase("kyoushitsu",
                                user="root",
                                password="Urfisgod1!",
                                host="127.0.0.1",
                                port= 3306)


class BaseModel(peewee.Model):
    """A base model that will use our MySQL database"""
    class Meta:
        database = mysql_db

class User(BaseModel):
    username = peewee.CharField()

class MainHandler(web.RequestHandler):
    def get(self):
        mysql_db.create_tables([User])

        jordan = User(username = 'Ginger')
        jordan.save()

        jordan = User.select().where(User.username == 'Ginger').get()
        self.write(jordan.username)

def make_app():
    return web.Application(
        [(r"/", MainHandler)]
    )

def main():
    app = make_app()
    app.listen(9001)
    ioloop.IOLoop.current().start()

if __name__ == '__main__':
    main()