from alphamind.data.standardize import standardize
from alphamind.data.winsorize import winsorize_normal
from alphamind.data.quantile import quantile
from sqlalchemy import create_engine, select, and_, or_
from sqlalchemy.pool import NullPool
import sqlalchemy as sa
from sqlalchemy.orm import sessionmaker
from models import Alpha191
import sys
sys.path.append('../..')
from ultron.cluster.invoke.app_engine import create_app
app = create_app('factor_analysis')
def update_destdb(destsession, table_name, sets):
sets = sets.where(pd.notnull(sets), None)
sql_pe = 'INSERT INTO {0} SET'.format(table_name)
updates = ",".join("{0} = :{0}".format(x) for x in list(sets))
sql_pe = sql_pe + '\n' + updates
sql_pe = sql_pe + '\n' + 'ON DUPLICATE KEY UPDATE'
sql_pe = sql_pe + '\n' + updates
session = destsession()
print('update_destdb')
for index, row in sets.iterrows():
dict_input = dict(row)
#dict_input['trade_date'] = dict_input['trade_date'].to_pydatetime()
session.execute(sql_pe, dict_input)
# -*- coding: utf-8 -*-
from ultron.cluster.invoke.app_engine import create_app
app = create_app('alphax', ['calc_engine'])
import sys
sys.path.append('../..')
from ultron.cluster.invoke.app_engine import create_app
app = create_app('distributed',['jpy.task1','jpy.task2'])
# -*- coding: utf-8 -*-
import sys
import pdb
sys.path.append('..')
from ultron.cluster.invoke.app_engine import create_app
app = create_app('q10_app_engine')
@app.task
def send_mail(email):
print('sending email %s' % (email))
import time
return "success"
# -*- coding: utf-8 -*-
from ultron.cluster.invoke.app_engine import create_app
app = create_app('earning_expectation', ['calc_engines'])
import sys
sys.path.append('../../..')
from ultron.cluster.invoke.app_engine import create_app
app = create_app('factor_analysis', ['jpy.task1', 'jpy.task2'])