import datetime
from db import Db
db = Db.get_db()
class User(db.Model):
__tablename__ = "users"
id = db.Column('user_id', db.Integer, primary_key=True)
username = db.Column('username', db.String(20), unique=True, index=True)
password = db.Column('password', db.String(10))
email = db.Column('email', db.String(50), unique=True, index=True)
registered_on = db.Column('registered_on', db.DateTime)
def __init__(self, username, password, email):
self.username = username
self.password = password
self.email = email
self.registered_on = datetime.utcnow()
def __repr__(self):
return 'username {}'.format(self.username)
