Python String Examples

Example #1

File: sys_role.py Project: chenguang281/homework

class SysRole(db.Model):
    __tablename__ = 'sys_role'

    id = db.Column(db.Integer, primary_key=True, index=True)
    role_name = db.Column(db.String(50))
    describe = db.Column(db.String(100))
    status = db.Column(db.Integer, server_default=db.FetchedValue())
    create_time = db.Column(db.DateTime, server_default=db.FetchedValue())
    update_time = db.Column(db.DateTime, server_default=db.FetchedValue())

Example #2

class SetDictionary(db.Model):
    __tablename__ = 'set_dictionary'

    id = db.Column(db.Integer, primary_key=True, index=True)
    num = db.Column(db.Integer)
    table_code = db.Column(db.String(50), index=True)
    column_code = db.Column(db.String(50))
    name = db.Column(db.String(255))
    value = db.Column(db.String(255))
    status = db.Column(db.Integer)

Example #3

class SysUser(db.Model):
    __tablename__ = 'sys_user'

    id = db.Column(db.Integer, primary_key=True, index=True)
    username = db.Column(db.String(50))
    password = db.Column(db.String(50))
    status = db.Column(db.Integer, server_default=db.FetchedValue())
    email = db.Column(db.String(100))
    mobile = db.Column(db.String(100))
    create_time = db.Column(db.DateTime, server_default=db.FetchedValue())
    update_time = db.Column(db.DateTime, server_default=db.FetchedValue())

Example #4

File: sys_login_log.py Project: chenguang281/homework

class SysLoginLog(db.Model):
    __tablename__ = 'sys_login_log'

    id = db.Column(db.Integer, primary_key=True, index=True)
    token = db.Column(db.String(100))
    ip = db.Column(db.String(100))
    create_time = db.Column(db.DateTime)
    userID = db.Column(db.String(32))
    username = db.Column(db.String(50))
    status = db.Column(db.Integer)
    update_time = db.Column(db.DateTime)

Example #5

File: sys_menu.py Project: chenguang281/homework

class SysMenu(db.Model):
    __tablename__ = 'sys_menu'

    id = db.Column(db.Integer, primary_key=True, index=True)
    menu_name = db.Column(db.String(50))
    url = db.Column(db.String(100))
    icon = db.Column(db.String(50))
    order = db.Column(db.Integer)
    type = db.Column(db.Integer, server_default=db.FetchedValue())
    status = db.Column(db.Integer, server_default=db.FetchedValue())
    create_time = db.Column(db.DateTime, server_default=db.FetchedValue())
    update_time = db.Column(db.DateTime, server_default=db.FetchedValue())
    pid = db.Column(db.Integer)