class User(base.common.orm.sql_base):
__tablename__ = 'users'
id = Column(CHAR(10), ForeignKey(AuthUser.id), primary_key=True)
first_name = Column(String(64))
last_name = Column(String(64))
data = Column(Text)
auth_user = relationship("AuthUser", back_populates="user")
def __init__(self, id_user, first_name, last_name, data):
self.id = id_user
self.first_name = first_name
self.last_name = last_name
self.data = data
class Pool(Base):
__tablename__ = "pool"
id = Column(Integer, primary_key=True, comment="配對池代號")
placeId = Column(CHAR(4), nullable=False, comment="商店代號")
userId = Column(String(100), nullable=False, comment="等待者")
createdAt = Column(DateTime,
nullable=False,
server_default=func.now(),
comment="建立時間")
deletedAt = Column(DateTime, nullable=True, comment="刪除時間")
status = Column(Boolean, nullable=False, default=False, comment="是否有配對")
def __repr__(self):
return "<Pool: {}, {}, {}, {}, {}>".format(self.id, self.userId,
self.createdAt,
self.deletedAt, self.status)
class IfBscBondcreditMin(Base):
__tablename__ = 'if_bsc_bondcredit_min'
vc_scode = Column(VARCHAR(20), primary_key=True, nullable=False)
vc_code = Column(VARCHAR(16))
l_market = Column(VARCHAR(50))
vc_ratecompany_name = Column(VARCHAR(128))
l_begin_date = Column(VARCHAR(50), primary_key=True, nullable=False)
l_end_date = Column(VARCHAR(50), primary_key=True, nullable=False)
c_credit_rank = Column(CHAR(1))
d_updatetime = Column(DateTime)
vc_source = Column(VARCHAR(20))
vc_update_operater = Column(VARCHAR(20))
def __str__(self):
return 'vc_scode' + '$*' + 'l_end_date' + '$*' + 'l_begin_date'
class ArticleImage(Base):
__tablename__ = 'ArticleImages'
article_id = Column(Integer,
ForeignKey('Articles.article_id'),
primary_key=True)
image_id = Column(Integer, primary_key=True)
time = Column(VARCHAR(50))
url = Column(CHAR(100))
def to_dict(self):
return {
'article_id': self.article_id,
'image_id': self.image_id,
'time': self.time,
'url': self.url
}
class Obiekt(Base):
__tablename__ = 'obiekt'
id_obiekt = Column(Numeric(12, 0), primary_key=True)
obiekt_nazwa = Column(String(100))
obiekt_ulica_nr = Column(String(10))
obiekt_kod_pocztowy = Column(CHAR(5))
gps_latitude = Column(Numeric(15, 12))
gps_longitude = Column(Numeric(15, 12))
id_miasto = Column(ForeignKey('miasto.id_miasto'))
id_jednostka = Column(ForeignKey('jednostka.id_jednostka'))
temp_wew_proj = Column(Numeric(3, 1))
obiekt_ulica = Column(String(150))
jednostka = relationship('Jednostka')
miasto = relationship('Miasto')
def test_char_length(self, metadata, connection):
t1 = Table(
"t1",
metadata,
Column("c1", VARCHAR(50)),
Column("c2", NVARCHAR(250)),
Column("c3", CHAR(200)),
Column("c4", NCHAR(180)),
)
t1.create(connection)
m2 = MetaData()
t2 = Table("t1", m2, autoload_with=connection)
eq_(t2.c.c1.type.length, 50)
eq_(t2.c.c2.type.length, 250)
eq_(t2.c.c3.type.length, 200)
eq_(t2.c.c4.type.length, 180)
class Books(Base):
__tablename__ = 'books'
bookID = Column(CHAR(5), primary_key=True)
bookName = Column(VARCHAR(50), unique=True)
bookOriginPrice = Column(DOUBLE)
bookType = Column(VARCHAR(10), nullable=False)
def __init__(self, name, price, btype):
self.bookName = name
self.bookOriginPrice = price
self.bookType = btype
def __repr__(self):
return '<Books %r %r>' % (self.bookName, self.bookOriginPrice,
self.bookType)
class MdDay(Base):
__tablename__ = 'md_day'
stock = Column(CHAR(6), primary_key=True, nullable=False)
d_day = Column(Date, primary_key=True, nullable=False, index=True)
open = Column(Float)
high = Column(Float)
low = Column(Float)
close = Column(Float)
volume = Column(BIGINT(20))
amount = Column(BIGINT(20))
free_turn = Column(Float)
adj_factor = Column(Float)
is_suspension = Column(BIT(1))
is_maxupordown = Column(TINYINT(4))
is_st = Column(TINYINT(4), nullable=False, server_default=text("'0'"))
class User(Base):
__tablename__ = 'user'
id = Column(BIGINT(20), primary_key=True, comment='主键')
level_id = Column(BIGINT(20),
nullable=False,
server_default=text("'0'"),
comment='会员等级ID')
password = Column(String(128), nullable=False)
username = Column(String(40), comment='登录名、昵称')
mobile = Column(String(11))
email = Column(String(80))
experience = Column(BIGINT(20),
nullable=False,
server_default=text("'0'"),
comment='经验值')
sex = Column(Enum('hide', 'male', 'female', 'other'),
nullable=False,
server_default=text("'hide'"),
comment='性别(男 male ，女 female 隐藏 hide)')
avatar = Column(String(255),
nullable=False,
server_default=text("''"),
comment='头像')
sign = Column(String(255), server_default=text("''"), comment='会员签名')
login_count = Column(BIGINT(20),
nullable=False,
server_default=text("'0'"),
comment='登陆次数')
last_login_ip = Column(String(40),
nullable=False,
server_default=text("''"),
comment='最后登陆IP')
last_login_at = Column(BIGINT(13), comment='最后登录UTC时间')
ref_user_id = Column(CHAR(32), comment='推荐人ID，空字符串表示为推荐人')
status = Column(TINYINT(1),
nullable=False,
server_default=text("'1'"),
comment='状态:( 0 禁用；1 启用, 默认1)')
deleted = Column(TINYINT(1),
nullable=False,
server_default=text("'0'"),
comment='已删除的 1 是 0 否 默认 0')
created_at = Column(BIGINT(13), comment='创建记录UTC时间')
reg_ip = Column(String(40), comment='注册IP')
reg_client = Column(String(20),
comment='客户端：web wechat android ios mobile')
class UserRoleMap(db.Model):
__tablename__ = 'user_role_map'
__table_args__ = {
'mysql_engine': 'InnoDB',
'mysql_charset': 'utf8mb4',
'mysql_collate': 'utf8mb4_unicode_ci'
}
id = Column(Integer, primary_key=True, autoincrement=True)
user = Column(String(255), nullable=True)
role = Column(String(255), nullable=True)
valid = Column(CHAR(1), nullable=False, server_default='1')
created_at = Column(DateTime, nullable=False, server_default=func.now())
updated_at = Column(DateTime,
nullable=False,
server_default=func.now(),
onupdate=func.now())
class KHACHHANG(db.Model): # Khách hàng
ID_KH = Column(Integer, autoincrement=True, primary_key=True)
MA_KH = Column(CHAR(7), nullable=False, unique=True)
TENKH = Column(Text, nullable=False, unique=True)
DIACHI = Column(Text)
SDT = Column(String(11))
NGUOILH = Column(Text) # Người liên hệ
phieuxuat = db.relationship('PHIEUXUAT',
backref='owner_phieuxuat_khachhang',
lazy='dynamic')
def __init__(self, MA_KH, TENKH, DIACHI, SDT, NGUOILH):
self.MA_KH = MA_KH
self.TENKH = TENKH
self.DIACHI = DIACHI
self.SDT = SDT
self.NGUOILH = NGUOILH
class ContentChannelmetadata(Base):
__tablename__ = "content_channelmetadata"
id = Column(CHAR(32), primary_key=True)
name = Column(String(200), nullable=False)
description = Column(String(400), nullable=False)
tagline = Column(String(150))
author = Column(String(400), nullable=False)
version = Column(Integer, nullable=False)
thumbnail = Column(Text, nullable=False)
last_updated = Column(String)
min_schema_version = Column(String(50), nullable=False)
root_id = Column(ForeignKey("content_contentnode.id"),
nullable=False,
index=True)
root = relationship("ContentContentnode")
class UserAddress(Base):
__tablename__ = 'user_addresses'
id = Column(Integer, primary_key = True, nullable = False, autoincrement = True)
user_id = Column(CHAR(36), ForeignKey('users.id'), nullable = False, index = True)
address = Column(String(256), nullable = False)
size = Column(Integer, nullable = False)
kind = Column(Integer, nullable = False)
rooms = Column(Integer, nullable = False, default = 0)
baths = Column(Integer, nullable = False, default = 0)
user_addr_index = Column(Integer, nullable = False)
latitude = Column(DOUBLE, nullable = False)
longitude = Column(DOUBLE, nullable = False)
geohash5 = Column(String(5), nullable = False)
geohash6 = Column(String(6), nullable = False)
user = relationship(User)
class OUI_MAS(Base):
__tablename__ = "OUI_MAS"
'''
MA-S (small) 36-bit prefix
'''
id = Column(Integer, primary_key=True)
assignment = Column(CHAR(8))
organization = Column(String)
organization_address = Column(String)
def __init__(self, assignment = None, organization = None, organization_address = None):
self.assignment = assignment
self.organization = organization
self.organization_address = organization_address
class LimPaisA(Base):
__tablename__ = 'lim_pais_a'
__table_args__ = {'schema': 'bcim'}
id_objeto = Column(Integer, primary_key=True)
nome = Column(String(100))
nomeabrev = Column(String(50))
geometriaaproximada = Column(String(3))
sigla = Column(String(3))
codiso3166 = Column(CHAR(3))
geom = Column(Geometry('MULTIPOLYGON', 4674, from_text='ST_GeomFromEWKT', name='geometry'), index=True)
id_produtor = Column(Integer)
id_elementoprodutor = Column(Integer)
cd_insumo_orgao = Column(Integer)
nr_insumo_mes = Column(SmallInteger)
nr_insumo_ano = Column(SmallInteger)
tx_insumo_documento = Column(String(60))
def test_char_length(self):
metadata = self.metadata
t1 = Table(
"t1",
metadata,
Column("c1", VARCHAR(50)),
Column("c2", NVARCHAR(250)),
Column("c3", CHAR(200)),
Column("c4", NCHAR(180)),
)
t1.create()
m2 = MetaData(testing.db)
t2 = Table("t1", m2, autoload=True)
eq_(t2.c.c1.type.length, 50)
eq_(t2.c.c2.type.length, 250)
eq_(t2.c.c3.type.length, 200)
eq_(t2.c.c4.type.length, 180)
class Resident(db.Model):
"""
Defines a Resident as represented in the database. Along with some utility functions.
Args:
user_id (int): Must be the same as the corresponding `User.id`.
Returns:
A Resident Model object.
"""
__tablename__ = 'residents'
user_id = Column(Integer, ForeignKey('users.id'), primary_key=True)
room_number = Column(CHAR(255), ForeignKey('rooms.number', onupdate='cascade'))
mealplan_pin = Column(Integer, ForeignKey('mealplan.pin'))
created = Column(DateTime, default=datetime.utcnow)
updated = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
user = relationship('User', uselist=False, single_parent=True,
cascade='delete, delete-orphan')
packages = relationship('Package', cascade='delete, delete-orphan')
meal_plan = relationship('MealPlan', uselist=False, single_parent=True,
cascade='delete, delete-orphan')
def __init__(self, user_id):
super(Resident, self).__init__(user_id=user_id)
def __repr__(self):
"""
Allows Resident to be printed.
Returns:
str: A string representation of this Resident.
"""
return 'Resident([user_id={user_id}, room_number={room_number},' \
'created={created}, updated={updated}])'.format(**self.__dict__)
def json(self):
"""
Get JSON representation of this Resident.
Returns:
A JSON representation of this Resident.
"""
return jsonify(
user_id=self.user_id,
room_number=self.room_number,
created=self.created,
updated=self.updated
)
class DeptManager(Base):
__tablename__ = 'dept_manager'
dept_no = Column(CHAR(4),
ForeignKey('departments.dept_no'),
index=True,
primary_key=True)
emp_no = Column(Integer,
ForeignKey('employees.emp_no'),
index=True,
primary_key=True)
from_date = Column(Date, nullable=False)
to_date = Column(Date, nullable=False)
dept = relationship('Department')
def __str__(self):
return "({}, {})".format(self.dept_no, self.emp_no)
class ContentFile(Base):
__tablename__ = "content_file"
id = Column(CHAR(32), primary_key=True)
checksum = Column(String(400), nullable=False)
extension = Column(String(40), nullable=False)
available = Column(Boolean, nullable=False)
file_size = Column(Integer)
preset = Column(String(150), nullable=False)
supplementary = Column(Boolean, nullable=False)
thumbnail = Column(Boolean, nullable=False)
priority = Column(Integer)
contentnode_id = Column(ForeignKey("content_contentnode.id"), index=True)
lang_id = Column(ForeignKey("content_language.id"), index=True)
contentnode = relationship("ContentContentnode")
lang = relationship("ContentLanguage")
def get_table(metadata):
return Table('updates', metadata,
Column('id', INT(), primary_key=True, autoincrement=True),
Column('codename', VARCHAR(30), nullable=False),
Column('version', VARCHAR(20), nullable=False),
Column('android', VARCHAR(5), nullable=False),
Column('branch', VARCHAR(15), nullable=False),
Column('type', VARCHAR(11), nullable=False),
Column('method', VARCHAR(8), nullable=False),
Column('size', BIGINT(), nullable=True),
Column('md5', CHAR(32), nullable=True, unique=True),
Column('filename', TEXT(), nullable=False, unique=True),
Column('link', TEXT(), nullable=False),
Column('changelog', TEXT(), nullable=True, default='Bug fixes and system optimizations.'),
Column('date', DATE(), nullable=True),
Column('inserted_on', TIMESTAMP(), default=current_timestamp()),
ForeignKeyConstraint(['codename'], ['devices.codename']))
class Order(Base):
__tablename__ = "orders"
OrderID = Column(SmallInteger, primary_key=True)
CustomerID = Column(CHAR(6))
EmployeeID = Column(SmallInteger)
OrderDate = Column(Date)
RequiredDate = Column(Date)
ShippedDate = Column(Date)
ShipVia = Column(SmallInteger)
Freight = Column(Float)
ShipName = Column(String(40))
ShipAddress = Column(String(60))
ShipCity = Column(String(15))
ShipRegion = Column(String(15))
ShipPostalCode = Column(String(10))
ShipCountry = Column(String(15))
def get_table(metadata):
return Table(
'firmware', metadata,
Column('id', INT(), primary_key=True, autoincrement=True),
Column('codename', VARCHAR(30), nullable=False),
Column('version', VARCHAR(20), nullable=False),
Column('android', VARCHAR(5), nullable=False),
Column('branch', VARCHAR(15), nullable=False),
Column('size', BIGINT(), nullable=True),
Column('md5', CHAR(32), nullable=True, unique=True),
Column('filename', TEXT(), nullable=False, unique=True),
Column('github_link', TEXT(), nullable=False),
Column('osdn_link', TEXT(), nullable=True),
Column('date', DATE(), nullable=True),
Column('inserted_on', TIMESTAMP(), default=current_timestamp()),
ForeignKeyConstraint(['codename'], ['devices.codename'],
use_alter=True))
class AccessInfo(Base):
__tablename__ = 'access_info'
id = Column(INTEGER(11), primary_key=True)
name = Column(String(255), nullable=False)
sex = Column(CHAR(2), nullable=False)
phone = Column(String(255), nullable=False)
id_card = Column(String(255), nullable=False)
idcard_sha256 = Column(String(255), nullable=False)
address = Column(String(1000))
people_num = Column(String(1000))
plate_num = Column(String(255))
cause = Column(String(2000), nullable=False)
carry = Column(String(1000))
time_start = Column(String(255), nullable=False)
time_end = Column(String(255), nullable=False)
respondent_name = Column(String(255), nullable=False)
respondent_dept = Column(String(255), nullable=False)
class Charity(Base):
__tablename__ = 'charities'
eid = Column(CHAR(10), primary_key=True)
organization_name = Column(String(200), nullable=False, index=True)
cover_photo = Column(String(200))
mission = Column(Text)
city = Column(String(200), index=True)
state = Column(String(100), index=True)
zip_code = Column(String(10), index=True)
logo_url = Column(String(200))
aka_name = Column(String(200), index=True)
geographic_areas_served = Column(Text)
website_url = Column(String(200))
year_founded = Column(Integer)
codes = relationship("Ntee",
foreign_keys='Ntee.charity_id',
backref="charities")
class Channel(Main):
table: str = 'channel'
_table = Table(
table, metadata,
Column('channel_id', String(24), primary_key=True, unique=True),
Column('title', String(100), nullable=False),
Column('description', Text),
Column('age', TINYINT(1), server_default=text("9")),
Column('effect', TINYINT(1), server_default=text("2")),
Column('language', CHAR(2)), Column('tag', String(900),
nullable=False),
Column('category', TINYINT(1)),
Column('created',
DateTime,
nullable=False,
server_default=text("current_timestamp()")),
Column('updated', DateTime))
class Pegawai(Base):
__tablename__ = "pegawai"
id = Column(String(11), primary_key=True, index=True)
nama_lengkap = Column(String(60))
nama_panggilan = Column(String(60), nullable=True)
tempat_lahir = Column(String(20), nullable=True)
tanggal_lahir = Column(DateTime, nullable=True)
jenis_kelamin = Column(CHAR(1), default='L')
no_hp = Column(String(16), nullable=True)
no_wa = Column(String(16), nullable=True)
created_at = Column(DateTime, default=datetime.now)
update_at = Column(DateTime, default=datetime.now, onupdate=datetime.now)
deleted_at = Column(DateTime, nullable=True)
user = relationship("User", back_populates="pegawai")
class Order(Base):
__tablename__ = 'orders'
OrderID = Column(SmallInteger, primary_key=True, server_default=text("nextval('orders_orderid_seq'::regclass)"))
CustomerID = Column(CHAR(6))
EmployeeID = Column(SmallInteger)
OrderDate = Column(Date)
RequiredDate = Column(Date)
ShippedDate = Column(Date)
ShipVia = Column(SmallInteger)
Freight = Column(Float)
ShipName = Column(String(40))
ShipAddress = Column(String(60))
ShipCity = Column(String(15))
ShipRegion = Column(String(15))
ShipPostalCode = Column(String(10))
ShipCountry = Column(String(15))
class Viagem(Base):
__tablename__ = 'bagagens_viagens'
ID = Column(BigInteger().with_variant(Integer, 'sqlite'),
primary_key=True,
autoincrement=True)
cpf = Column(CHAR(11), index=True)
data_chegada = Column(DateTime(), index=True)
origem = Column(CHAR(3), index=True)
destino = Column(CHAR(3), index=True)
localizador = Column(CHAR(10), index=True)
voo = Column(CHAR(10), index=True)
codigo_vu = Column(CHAR(17), index=True)
class WkUserInfo(db.Model):
__tablename__ = 'wk_user_info'
id = Column(String(36),
primary_key=True,
server_default=text("''"),
comment='用户表')
user_name = Column(String(20),
nullable=False,
server_default=text("''"),
comment='姓名')
user_phone = Column(String(11),
nullable=False,
server_default=text("''"),
comment='用户电话号码')
user_pwd = Column(String(50), server_default=text("''"), comment='用户密码')
user_herf = Column(String(255),
nullable=False,
server_default=text("''"),
comment='股票个人链接 (*经济人有两个个人链接）')
user_qr_code = Column(String(255),
nullable=False,
server_default=text("''"),
comment='股票二维码 (*经纪人有两个二维码）')
user_referral_code = Column(String(50),
nullable=False,
index=True,
comment='用户推荐码')
user_up_referral_code = Column(String(50), comment='用户上级推荐码')
user_role = Column(String(20),
comment='用户角色：100003 代理商，100004 经纪人，100005 客户')
register_date_time = Column(DateTime,
nullable=False,
comment='注册时间 / 添加时间')
del_state = Column(CHAR(1),
nullable=False,
server_default=text("'0'"),
comment='删除状态：0 存在，1 已删除')
user_herf_futures = Column(String(255), comment='期货个人链接 (*经济人有两个个人链接）')
user_qr_code_futures = Column(String(255), comment='期货二维码 (*经纪人有两个二维码）')
type = Column(TINYINT(4), comment='区分客户用 (*1 为期货 2 为股票）')
identity_number = Column(String(50), comment='身份证号码')
last_login_time = Column(BIGINT(20), comment='最近登录时间')
wk_company_futures_id = Column(String(36), comment='公司 (*期货公司 id)')
wk_company_securities_id = Column(String(36), comment='公司 (*证券公司 id)')
class Article(Base):
__tablename__ = "articles"
id = Column(Integer, primary_key=True)
hash = Column(String(32), unique=True)
slug = Column(String(255), index=True)
title = Column(String(255), index=True)
content = Column(Text, nullable=True, index=True)
status = Column(CHAR(1), index=True)
published = Column(DateTime, nullable=True)
# relationships
authors = relationship(
"Author",
secondary=article_authors,
backref=backref("authors", lazy="dynamic"),
lazy="dynamic",
)
tags = relationship(
"Tag",
secondary=article_tags,
backref=backref("tags", lazy="dynamic"),
lazy="dynamic",
)
images = relationship(
"Image",
secondary=article_images,
backref=backref("images", lazy="dynamic"),
lazy="dynamic",
)
media = relationship(
"Media",
secondary=article_media,
backref=backref("media", lazy="dynamic"),
lazy="dynamic",
)
misc = relationship(
"Misc",
secondary=article_misc,
backref=backref("misc", lazy="dynamic"),
lazy="dynamic",
)
def __repr__(self):
return "<Article(id='{id}', title='{title}')>".format(
id=self.id, title=self.title
)
