def __init__(self):
self.dbase = EntityDB.instance()
self.table = 'entityindices'
id = pyfwk.DBCol('id', 'INTEGER PRIMARY KEY')
entity = pyfwk.DBCol('entity', 'INTEGER')
indices = pyfwk.DBCol('indices', 'INTEGER')
self.columns = [id, entity, indices]
self.validate()
def __init__(self):
self.dbase = EntityDB.instance()
self.table = 'indices'
id = pyfwk.DBCol('id', 'INTEGER PRIMARY KEY')
symbol = pyfwk.DBCol('symbol', 'TEXT')
name = pyfwk.DBCol('name', 'TEXT')
self.columns = [id, symbol, name]
self.validate()
def __init__(self):
self.dbase = EntityDB.instance()
self.table = 'industry'
id = pyfwk.DBCol('id', 'INTEGER PRIMARY KEY')
sector = pyfwk.DBCol('sector', 'INTEGER')
name = pyfwk.DBCol('name', 'TEXT')
self.columns = [id, sector, name]
self.validate()
def __init__(self):
self.dbase = EntityDB.instance()
self.table = 'entityfund'
id = pyfwk.DBCol('id', 'INTEGER PRIMARY KEY')
entity = pyfwk.DBCol('entity', 'INTEGER')
category = pyfwk.DBCol('category', 'INTEGER')
fundfamily = pyfwk.DBCol('fundfamily', 'INTEGER')
self.columns = [id, entity, category, fundfamily]
self.validate()
def __init__(self):
self.dbase = CalendarDB.instance()
self.table = 'tick'
id = pyfwk.DBCol('id', 'INTEGER PRIMARY KEY')
iso = pyfwk.DBCol('iso', 'INTEGER')
hour = pyfwk.DBCol('hour', 'INTEGER')
period = pyfwk.DBCol('period', 'INTEGER')
minute = pyfwk.DBCol('minute', 'INTEGER')
self.columns = [id, iso, hour, period, minute]
self.validate()
def __init__(self):
self.dbase = CalendarDB.instance()
self.table = 'session'
id = pyfwk.DBCol('id', 'INTEGER PRIMARY KEY')
year = pyfwk.DBCol('year', 'INTEGER')
month = pyfwk.DBCol('month', 'INTEGER')
day = pyfwk.DBCol('day', 'INTEGER')
weekday = pyfwk.DBCol('weekday', 'INTEGER')
calendar = pyfwk.DBCol('calendar', 'INTEGER')
self.columns = [id, year, month, day, weekday, calendar]
self.validate()
def __init__(self):
self.dbase = EntityDB.instance()
self.table = 'entity'
id = pyfwk.DBCol('id', 'INTEGER PRIMARY KEY')
symbol = pyfwk.DBCol('symbol', 'TEXT')
name = pyfwk.DBCol('name', 'TEXT')
type = pyfwk.DBCol('type', 'INTEGER')
exchange = pyfwk.DBCol('exchange', 'INTEGER')
profile = pyfwk.DBCol('profile', 'INTEGER')
self.columns = [id, symbol, name, type, exchange, profile]
self.validate()