def main():
candidates = ['bootstrap.ini']
if len(sys.argv) > 1:
candidates.append(sys.argv[1])
config = ConfigParser.SafeConfigParser()
config.read(candidates)
options.define('db_engine', config.get('database', 'db_engine'))
options.define('db_echo', True)
from trade.models import engine, Currency, Instrument, User, Broker, DepositMethods
session = scoped_session(sessionmaker(bind=engine))
for section_name in config.sections():
if section_name == 'currencies':
for id, currency_json in config.items(section_name):
c = json.loads(currency_json)
if Currency.get_currency(session, c[0]):
continue
e = Currency(code=c[0],
sign=c[1],
description=c[2],
is_crypto=c[3],
pip=c[4],
format_python=c[5],
format_js=c[6],
human_format_python=c[7],
human_format_js=c[8])
session.add(e)
session.commit()
if section_name == 'instruments':
for id, instrument_json in config.items(section_name):
currency_description = json.loads(instrument_json)
if Instrument.get_instrument(session, currency_description[0]):
continue
e = Instrument(symbol=currency_description[0],
currency=currency_description[1],
description=currency_description[2])
session.add(e)
session.commit()
if section_name[:4] == 'user':
if not User.get_user(session, config.get(section_name,
'username')):
broker_id = None
broker_username = None
password = base64.b32encode(os.urandom(10))
transaction_fee_buy = None
transaction_fee_sell = None
verified = 0
is_system = False
is_staff = False
is_broker = False
state = None
try:
broker_id = config.getint(section_name, 'broker_id')
except Exception, e:
pass
try:
broker_username = config.get(section_name,
'broker_username')
except Exception, e:
pass
try:
password = config.get(section_name, 'password')
except Exception, e:
pass
try:
transaction_fee_buy = config.getint(
section_name, 'transaction_fee_buy')
except Exception, e:
pass
def main():
candidates = ['bootstrap.ini']
if len(sys.argv) > 1:
candidates.append(os.path.expanduser(sys.argv[1]))
config = ConfigParser.SafeConfigParser()
config.read(candidates)
from trade.models import Base, Currency, Instrument, User, Broker, DepositMethods
db_engine = config.get(
'database', 'sqlalchemy_engine') + ':///' + os.path.expanduser(
config.get('database', 'sqlalchemy_connection_string'))
engine = create_engine(db_engine, echo=True)
#engine.raw_connection().connection.text_factory = str
Base.metadata.create_all(engine)
session = scoped_session(sessionmaker(bind=engine))
for section_name in config.sections():
if section_name == 'currencies':
for id, currency_json in config.items(section_name):
c = json.loads(currency_json)
if Currency.get_currency(session, c[0]):
continue
e = Currency(code=c[0],
sign=c[1],
description=c[2],
is_crypto=c[3],
pip=c[4],
format_python=c[5],
format_js=c[6],
human_format_python=c[7],
human_format_js=c[8])
session.add(e)
session.commit()
if section_name == 'instruments':
for id, instrument_json in config.items(section_name):
currency_description = json.loads(instrument_json)
if Instrument.get_instrument(session, currency_description[0]):
continue
e = Instrument(symbol=currency_description[0],
market=currency_description[1],
currency=currency_description[2],
description=currency_description[3])
session.add(e)
session.commit()
if section_name[:4] == 'user':
broker_id = None
try:
broker_id = config.getint(section_name, 'broker_id')
except Exception, e:
pass
broker_username = None
try:
broker_username = config.get(section_name, 'broker_username')
except Exception, e:
pass
if not User.get_user(session, broker_id,
config.get(section_name, 'username')):
password = base64.b32encode(os.urandom(10))
try:
password = config.get(section_name, 'password')
except Exception, e:
pass
transaction_fee_buy = None
try:
transaction_fee_buy = config.getint(
section_name, 'transaction_fee_buy')
except Exception, e:
pass
