示例#1
0
class LocationModel(db.Model):
    """Docstring here."""

    __tablename__ = "location"

    id = db.Column(db.Integer, primary_key=True)
    created_at = db.Column(db.DateTime, default=datetime.now)
    updated_at = db.Column(db.DateTime,
                           default=datetime.now,
                           onupdate=datetime.now)
    barangay_id = db.Column(db.Integer,
                            db.ForeignKey("barangay.id"),
                            nullable=False)
    barangay = db.relationship(BarangayModel, backref="barangay", lazy=True)
    longitude = db.Column(CHAR(16), nullable=False)
    latitude = db.Column(CHAR(16), nullable=False)

    def __init__(self, barangay, longitude, latitude):
        self.barangay = barangay
        self.longitude = longitude
        self.latitude = latitude

    def json(self) -> dict:
        """JSON representation of the LocationModel."""
        return {"id": self.id, "barangay": self.barangay.json()}

    @classmethod
    def find_by_id(cls, id: int) -> "LocationModel":
        return cls.query.filter_by(id=id).first()

    def remove_from_db(self):
        db.session.delete(self)
        db.session.comit()
示例#2
0
class Unimac(BaseModel):
    __tablename__ = 'unimac'

    id = Column(Integer, primary_key=True, nullable=False)
    mac = Column(CHAR(20), nullable=False)
    manu = Column(CHAR(20), nullable=False)
    station = Column(CHAR(20), nullable=False)
    start_time = Column(DateTime,
                        index=True,
                        default=func.current_timestamp(),
                        nullable=False)
    end_time = Column(DateTime,
                      index=True,
                      default=func.current_timestamp(),
                      nullable=False)
    mid_time = Column(TIMESTAMP,
                      default=func.current_timestamp(),
                      nullable=False)
    flag = Column(UnicodeText)
    ap = Column(UnicodeText)
    ap_no_empty = Column(UnicodeText)

    def __repr__(self):
        return '<Unimac id : %r, mac : %r, start_time: %r, end_time: %r>' % (
            self.id, self.mac, self.start_time, self.end_time)

    def get_eval(self, attr, default=None):
        if hasattr(self, attr) and getattr(self, attr):
            return eval(getattr(self, attr))
        else:
            return default
示例#3
0
class OmaQuota(BaseModel):
    __tablename__ = 'oma_quota'
    date = Column(Date, primary_key=True)
    investor_id = Column(CHAR(45), primary_key=True)
    symbol = Column(CHAR(45), primary_key=True)
    sell_quota = Column(Integer)
    buy_quota = Column(Integer)
class Strategy_Intraday_Parameter(BaseModel):
    __tablename__ = 'strategy_intraday_parameter'
    date = Column(Date, primary_key=True)
    strategy_name = Column(CHAR(100), primary_key=True)
    ticker = Column(CHAR(45), primary_key=True)
    parameter = Column(CHAR(45))
    initial_share = Column(Integer)
示例#5
0
class EventMetaDefaultModel(BaseModel):
    __tablename__ = 'eventmeta_default'

    id = Column(Integer, primary_key=True)
    app = Column(CHAR(100))
    name = Column(CHAR(100))
    type = Column(CHAR(100))
    derived = Column(Integer)
    src_variableid = Column(CHAR(100))
    properties = Column(VARCHAR(4000))
    expire = Column(Integer)
    remark = Column(VARCHAR(1000))
    last_modified = Column(Integer)
    config = Column(BLOB)

    def to_eventmeta(self):
        return EventMeta.from_json(self.config)

    @staticmethod
    def from_eventmeta(meta):
        return EventMetaDefaultModel(app=meta.app,
                                     name=meta.name,
                                     type=meta.type,
                                     derived=meta.derived,
                                     src_variableid=str(meta.src_variableid),
                                     properties=json.dumps(
                                         meta.get_dict()["properties"]),
                                     expire=meta.expire,
                                     last_modified=millis_now(),
                                     config=meta.get_json(),
                                     remark=meta.remark)

    def __str__(self):
        return str(self.__dict__)
示例#6
0
class AppInfo(BaseModel):
    __tablename__ = 'server_info'
    server_ip = Column(CHAR(20), primary_key=True)
    server_name = Column(CHAR(40))
    app_name = Column(CHAR(40))
    start_file = Column(CHAR(40), primary_key=True)
    level = Column(Integer)
示例#7
0
class User(Base):
    __tablename__ = 'user'
    id = Column(Integer, primary_key=True)
    uid = Column(CHAR(20), unique=True)
    name = Column(String(20))
    sex = Column(String(20))
    phone_number = Column(CHAR(11), unique=True)
    ID_card = Column(CHAR(18), unique=True)
    wx_id = Column(String(50), unique=True)
    email = Column(String(50), unique=True)
    credit = Column(Integer)
    credit_data = Column(CLOB)
    ceiling = Column(Float)
    owed = Column(Float)
    address = Column(String(100))

    @classmethod
    def add_new_user(cls, phone_number):
        user = User(phone_number=phone_number)
        session.add(user)
        session.commit()
        return user

    @classmethod
    def get_user_by_phone_number(cls, phone_number):
        return session.query(cls).filter_by(phone_number=phone_number).first()
示例#8
0
class LogParserModel(BaseModel):
    __tablename__ = 'logparser'

    id = Column(Integer, primary_key=True)
    source = Column(CHAR(100))
    dest = Column(CHAR(100))
    terms = Column(VARCHAR(4000))
    host = Column(CHAR(100))
    url = Column(CHAR(100))
    remark = Column(VARCHAR(1000))
    status = Column(Integer)
    last_modified = Column(Integer)

    @staticmethod
    def from_dict(logparser):
        return LogParserModel(source=logparser['source'],
                              dest=logparser['dest'],
                              terms=json.dumps(logparser['terms']),
                              host=logparser.get('host', ''),
                              url=logparser.get('url', ''),
                              remark=logparser.get('remark', ''),
                              status=logparser.get('status', 0),
                              last_modified=millis_now())

    def to_dict(self):
        return dict(id=self.id,
                    source=self.source,
                    dest=self.dest,
                    terms=json.loads(self.terms),
                    host=self.host,
                    url=self.url,
                    remark=self.remark,
                    status=self.status)
示例#9
0
class TagModel(BaseModel):
    __tablename__ = 'tags'

    id = Column(Integer, primary_key=True)
    app = Column(CHAR(100))
    name = Column(CHAR(100))
    last_modified = Column(Integer)

    def __str__(self):
        return str(self.__dict__)

    def to_tag(self):
        return {
            'app': self.app,
            'id': self.id,
            'name': self.name,
        }

    @staticmethod
    def from_tag(tag):
        return TagModel(
            app=tag.get('app'),
            name=tag.get('name'),
            last_modified=millis_now(),
        )
示例#10
0
class UserModel(BaseModel):

    __tablename__ = 'user'

    id = Column(Integer, primary_key=True)
    name = Column(CHAR(100))
    password = Column(CHAR(100))
    creator = Column(Integer)
    create_time = Column(Integer)
    last_login = Column(Integer)
    last_modified = Column(Integer)
    is_active = Column(Integer)

    @staticmethod
    def from_dict(user):
        return UserModel(name=user["name"],
                         password=hashlib.sha1(user["password"]).hexdigest(),
                         creator=user["creator"],
                         create_time=user.get("create_time", millis_now()),
                         last_login=user.get("last_login", 0),
                         last_modified=user.get("last_modified", millis_now()),
                         is_active=user.get("is_active", 0))

    def to_dict(self):
        return dict(id=self.id,
                    name=self.name,
                    creator=self.creator,
                    create_time=self.create_time,
                    last_login=self.last_login,
                    is_active=self.is_active)
class FutureMainContract(BaseModel):
    __tablename__ = 'future_main_contract'
    ticker_type = Column(CHAR(20), primary_key=True)
    exchange_id = Column(Integer, primary_key=True)
    pre_main_symbol = Column(CHAR(11))
    main_symbol = Column(CHAR(11))
    update_flag = Column(CHAR(11))
示例#12
0
class Verification(Base):  # 短信验证码及生成用户auth_key时间
    __tablename__ = 'Verification'

    Vphone = Column(CHAR(11), primary_key=True)  #
    Vcode = Column(CHAR(6), nullable=False)
    VT = Column(DateTime(timezone=True),
                default=func.now())  # 待测试是插入数据的时间还是最后一次更新该表的时间 (测试结果为第一次插入时间)
示例#13
0
class PfAccount(BaseModel):
    __tablename__ = 'pf_account'
    id = Column(Integer)
    name = Column(CHAR(45), primary_key=True)
    fund_name = Column(CHAR(100), primary_key=True)
    group_name = Column(CHAR(45), primary_key=True)
    effective_date = Column(DateTime)
    description = Column(CHAR(1000))
示例#14
0
class CountryInfoModel(Base):
  __tablename__ = 'country_info'
  __table_args__ = (
    PrimaryKeyConstraint("iso_alpha2", "iso_alpha3"),
  )
  iso_alpha2 = Column(CHAR(2), ForeignKey("geoname.country_code"), nullable=False)
  iso_alpha3 = Column(CHAR(3), nullable=False)
  geoname_id = Column(Integer, ForeignKey("geoname.geoname_id"))
示例#15
0
class MainSubmainInfo(BaseModel):
    __tablename__ = 'main_submain'
    exchange_id = Column(CHAR(20))
    undl_tickers = Column(CHAR(20))
    start_date = Column(Date)
    end_date = Column(Date)
    main_contract = Column(CHAR(20), primary_key=True)
    sub_main_contract = Column(CHAR(20))
示例#16
0
class AccountTradeRestrictions(BaseModel):
    __tablename__ = 'account_trade_restrictions'
    account_id = Column(Integer, primary_key=True)
    ticker = Column(CHAR(45), primary_key=True)
    exchange_id = Column(Integer, primary_key=True)
    hedgeflag = Column(CHAR(45), primary_key=True)
    max_open = Column(Integer)
    today_open = Column(Integer)

    max_cancel = Column(Integer)
    today_cancel = Column(Integer)

    max_large_cancel = Column(Integer)
    today_large_cancel = Column(Integer)

    max_operation = Column(Integer)
    today_operation = Column(Integer)

    option_max_long = Column(Integer)
    option_long = Column(Integer)

    option_max_short = Column(Integer)
    option_short = Column(Integer)

    max_order_flow_speed = Column(Integer)
    max_cancel_ratio_threshold = Column(Integer)
    max_cancel_ratio = Column(Float)
    min_fill_ratio_threshold = Column(Integer)
    min_fill_ratio_alarm = Column(Float)
    min_fill_ratio_block = Column(Float)
    max_buy_quota = Column(Float)

    today_rejected = Column(Integer)
    today_bid_amount = Column(Float)
    today_ask_amount = Column(Float)
    today_bid_canceled_amount = Column(Float)
    today_buy_amount = Column(Float)
    today_sell_amount = Column(Float)

    def __init__(self):
        self.max_open = 0
        self.today_open = 0
        self.max_cancel = 0
        self.today_cancel = 0
        self.max_large_cancel = 0
        self.today_large_cancel = 0
        self.max_operation = 0
        self.today_operation = 0
        self.option_max_long = 0
        self.option_long = 0
        self.option_max_short = 0
        self.option_short = 0

    def copy(self):
        return copy.deepcopy(self)

    def to_dict(self):
        return {c.name: getattr(self, c.name) for c in self.__table__.columns}
示例#17
0
class StrategyServerParameter(BaseModel):
    __tablename__ = 'strategy_server_parameter'
    date = Column(Date, primary_key=True)
    server_name = Column(CHAR(100), primary_key=True)
    strategy_name = Column(CHAR(100), primary_key=True)
    account_name = Column(CHAR(100), primary_key=True)
    max_long_position = Column(Integer)
    max_short_position = Column(Integer)
    qty_per_trade = Column(Integer)
示例#18
0
class Tls209ApplnIpc(Base):
    __tablename__ = 'tls209_appln_ipc'
    appln_id = Column(INT, primary_key=True, default=0)
    ipc_class_symbol = Column(VARCHAR(15), primary_key=True, default='')
    ipc_class_level = Column(CHAR(1), default='')
    ipc_version = Column(DATE, default='9999-12-31')
    ipc_value = Column(CHAR(1), default='')
    ipc_position = Column(CHAR(1), default='')
    ipc_gener_auth = Column(CHAR(2), default='')
示例#19
0
class StrategyChangeHistory(BaseModel):
    __tablename__ = 'strategy_change_history'
    id = Column(Integer, primary_key=True)
    enable = Column(Integer)
    name = Column(CHAR(45))
    change_type = Column(CHAR(45))  # online/downline
    parameter_server = Column(CHAR(2000))
    update_time = Column(DateTime)
    change_server_name = Column(CHAR(45))
示例#20
0
class Tls803LegalEventCode(Base):
    __tablename__ = 'tls803_legal_event_code'
    event_auth = Column(CHAR(2), primary_key=True, default='')
    event_code = Column(VARCHAR(4), primary_key=True, default='')
    event_impact = Column(CHAR(1), default='')
    event_descr = Column(VARCHAR(250), default='')
    event_descr_orig = Column(VARCHAR(250), default='')
    event_category_code = Column(CHAR(1), default='')
    event_category_title = Column(VARCHAR(100), default='')
示例#21
0
class Tls224ApplnCpc(Base):
    __tablename__ = 'tls224_appln_cpc'
    appln_id = Column(INT, primary_key=True, default=0)
    cpc_class_symbol = Column(VARCHAR(19), primary_key=True, default='')
    cpc_scheme = Column(VARCHAR(5), primary_key=True, default='')
    cpc_version = Column(DATE, default='9999-12-31')
    cpc_value = Column(CHAR(1), default='')
    cpc_position = Column(CHAR(1), default='')
    cpc_gener_auth = Column(CHAR(2), default='')
class AccountPosition(BaseModel):
    __tablename__ = 'account_position'
    date = Column(Date, primary_key=True)
    id = Column(Integer, primary_key=True)
    symbol = Column(CHAR(45), primary_key=True)
    hedgeflag = Column(CHAR(10), primary_key=True)
    long = Column(Float, default=0)
    long_cost = Column(Float, default=0)
    long_avail = Column(Float, default=0)
    day_long = Column(Float, default=0)
    day_long_cost = Column(Float, default=0)
    short = Column(Float, default=0)
    short_cost = Column(Float, default=0)
    short_avail = Column(Float, default=0)
    day_short = Column(Float, default=0)
    day_short_cost = Column(Float, default=0)
    fee = Column(Float, default=0)
    close_price = Column(Float)
    note = Column(CHAR(3600))
    delta = Column(Float)
    gamma = Column(Float)
    theta = Column(Float)
    vega = Column(Float)
    rho = Column(Float)
    yd_position_long = Column(Float, default=0)
    yd_position_short = Column(Float, default=0)
    yd_long_remain = Column(Float, default=0)
    yd_short_remain = Column(Float, default=0)
    prev_net = Column(Float, default=0)
    purchase_avail = Column(Float, default=0)
    frozen = Column(Float, default=0)
    update_date = Column(DateTime, default=datetime.datetime)

    td_buy_long = 0
    td_sell_short = 0
    td_pur_red = 0
    td_merge_split = 0

    def __init__(self):
        self.td_buy_long = 0
        self.td_sell_short = 0
        self.td_pur_red = 0
        self.td_merge_split = 0
        self.long = 0
        self.long_cost = 0.0
        self.long_avail = 0
        self.yd_position_long = 0
        self.yd_long_remain = 0
        self.short = 0
        self.short_cost = 0.0
        self.short_avail = 0
        self.yd_position_short = 0
        self.yd_short_remain = 0

    def print_info(self):
        print 'yd_position_long:', self.yd_position_long, ',td_buy_long:', self.td_buy_long, \
',td_sell_short:', self.td_sell_short,',td_pur_red:', self.td_pur_red, ',td_merge_split:', self.td_merge_split
def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    with op.batch_alter_table('modules', schema=None) as batch_op:
        batch_op.add_column(sa.Column('cc_uuid', CHAR(32), nullable=False))
        batch_op.create_foreign_key('fk_modules_cc_uuid', 'cc_informations', ['cc_uuid'], ['uuid'])

    with op.batch_alter_table('schemas', schema=None) as batch_op:
        batch_op.add_column(sa.Column('cc_uuid', CHAR(32), nullable=False))
        batch_op.create_foreign_key('fk_schemas_cc_uuid', 'cc_informations', ['cc_uuid'], ['uuid'])
示例#24
0
class SBHash(Base):
    __tablename__ = 'sbclient_v4_hashes'

    hash = Column(CHAR(64), nullable=False, primary_key=True)
    prefix = Column(CHAR(64))
    reflist_id = Column(INTEGER(unsigned=True), ForeignKey('sbclient_v4_lists.id'), nullable=False, primary_key=True)

    reflist = relationship('SBList', back_populates='hashes')
    __table_args__ = (UniqueConstraint('hash', 'reflist_id', name='_hash_reflist'),
                      ForeignKeyConstraint([prefix, reflist_id], [SBPrefix.prefix, SBPrefix.reflist_id]),)
示例#25
0
class Invit(BaseModel):
    __tablename__ = 'Invited'
    id = Column(Integer, primary_key=True, unique=True)
    Name = Column(CHAR(30))
    Phone = Column(VARCHAR(13))
    Invited = Column(VARCHAR(10))
    # Time = Column(Time, default=datatime.now, nullable=False)
    Date = Column(CHAR(50))
    Email = Column(VARCHAR(50))
    Address = Column(VARCHAR(50))
示例#26
0
class UserInfo(BaseModel):
    __tablename__ = 'user_info_table'

    user_id = Column(Integer, primary_key=True)
    telephone = Column(CHAR(11))  # or Column(String(30))
    real_name = Column(CHAR(16))
    nick_name = Column(CHAR(16))
    password = Column(CHAR(64))
    has_update = Column(Boolean(False))

    id_number = Column(CHAR(18))
示例#27
0
class Tls211PatPubln(Base):
    __tablename__ = 'tls211_pat_publn'
    pat_publn_id = Column(INT, primary_key=True, default=0)
    publn_auth = Column(CHAR(2), default='')
    publn_nr = Column(VARCHAR(15), default='')
    publn_nr_original = Column(VARCHAR(100), default='')
    publn_kind = Column(CHAR(2), default='')
    appln_id = Column(INT, default=0)
    publn_date = Column(DATE, default='9999-12-31')
    publn_lg = Column(CHAR(2), default='')
    publn_first_grant = Column(CHAR(1), default='N')
    publn_claims = Column(SMALLINT, default=0)
示例#28
0
class Tls212Citation(Base):
    __tablename__ = 'tls212_citation'
    pat_publn_id = Column(INT, primary_key=True, default=0)
    citn_replenished = Column(INT, primary_key=True, default=0)
    citn_id = Column(SMALLINT, primary_key=True, default=0)
    citn_origin = Column(CHAR(3), default='')
    cited_pat_publn_id = Column(INT, default=0)
    cited_appln_id = Column(INT, default=0)
    pat_citn_seq_nr = Column(SMALLINT, default=0)
    cited_npl_publn_id = Column(INT, default=0)
    npl_citn_seq_nr = Column(SMALLINT, default=0)
    citn_gener_auth = Column(CHAR(2), default='')
示例#29
0
class User(BaseModel):
    __tablename__ = 'eventmeta'

    id = Column(Integer, primary_key=True)
    name = Column(CHAR(100))
    email = Column(CHAR(100))
    password = Column(CHAR(40))
    is_super = Column(Integer)
    attrs = Column(CHAR(3000))
    last_login = Column(Integer, )  #上次登陆时间
    date_joined = Column(Integer, )  #注册时间
    is_active = Column(Integer)  #是否激活,允许登陆
示例#30
0
class DoubanNote(BaseModel):
    __tablename__ = 'doubannote'
    __table_args__ = {
        'mysql_engine': 'InnoDB'
    }

    url = Column(CHAR(255), primary_key=True)
    title = Column(CHAR(255))
    author = Column(CHAR(255))
    tags = Column(CHAR(255))
    snippet = Column(Text)
    comment_num = Column(Integer)
    pub_date = Column(TIMESTAMP, server_default=text('CURRENT_TIMESTAMP'), nullable=False)