def initialize_trading(self):
self.trading_engine = db_engine(server_type='mssql',
driver='pymssql',
username='******',
password='******',
server_ip='192.168.66.12',
port='1433',
db_name='Trading',
add_info='')
def initialize_gg(self):
self.gg_engine = db_engine(server_type='mssql',
driver='pymssql',
username='******',
password='******',
server_ip='192.168.66.12',
port='1433',
db_name='GOGOAL',
add_info='')
def initialize_rm(self):
self.rm_engine = db_engine(server_type='mssql',
driver='pymssql',
username='******',
password='******',
server_ip='192.168.66.12',
port='1433',
db_name='RiskModel',
add_info='')
def initialize_rm_engine(self):
json = pd.read_json(self.read_json, orient='index')
# json的数据库连接信息里面必须要有risk model数据库的连接信息
assert 'RiskModel' in json.index, 'RiskModel database is not in the json file!\n'
rm = json.ix['RiskModel', :]
# 初始化数据库
self.rm_engine = db_engine(server_type=rm['serverType'], driver=self.driver_map[rm['serverType']],
username=rm['user'], password=rm['password'], server_ip=rm['host'], port=str(rm['port']),
db_name=rm['database'], add_info='')
pass
def initialize_alpha_engine(self):
json = pd.read_json(self.read_json, orient='index')
# json的数据库连接信息里面必须要有取alpha的smart quant数据库的连接信息
assert 'Alpha' in json.index, 'Alpha database is not in the json file!\n'
sq = json.ix['Alpha', :]
# 初始化数据库
self.alpha_engine = db_engine(server_type=sq['serverType'], driver=self.driver_map[sq['serverType']],
username=sq['user'], password=sq['password'], server_ip=sq['host'], port=str(sq['port']),
db_name=sq['database'], add_info='')
pass