def main():
values = Configuration.values()
print values
dbconn = SQLUtils(
host=values['mysql-db']['sms_api_config']['host'],
port=values['mysql-db']['sms_api_config']['port'],
database=values['mysql-db']['sms_api_config']['db'],
user=values['mysql-db']['sms_api_config']['user'],
password=values['mysql-db']['sms_api_config']['password'])
result = dbconn.run_query(query_type="select", query=query, fetchall=True)
q = []
for r in result:
client_id = create_sha256_signature(r['suffix'], r['email'])
secret_key = create_client_id(r['email'])
print client_id, secret_key, r['email']
print update_query % (client_id, secret_key, r['id'])
q.append(update_query % (client_id, secret_key, r['id']))
dbconn.run_query("update", update_query, None, None)
'-------------------------'
for i in q:
print i + ';'
def init(self):
'''
@description:
intializes:
- configurations
- db connections
'''
Configuration.initialize()
values = Configuration.values()
self.dbconn = SQLUtils(
host=values['mysql-db']['sms_api_config']['host'],
port=values['mysql-db']['sms_api_config']['port'],
database=values['mysql-db']['sms_api_config']['db'],
user=values['mysql-db']['sms_api_config']['user'],
password=values['mysql-db']['sms_api_config']['password'])
self.redisconn = gredis.client.Connection(
address=str(values['redis_servers']['sms_api']['host']),
port=int(values['redis_servers']['sms_api']['port']))
self.redisconn.connect()
print '-------'
print 'redis:'
print 'port: %s' % values['redis_servers']['sms_api']['port']
print 'host: %s' % values['redis_servers']['sms_api']['host']
print '\n'
print 'sql:'
print 'port: %s' % values['mysql-db']['sms_api_config']['host']
print 'host: %s' % values['mysql-db']['sms_api_config']['port']
print 'db: %s' % values['mysql-db']['sms_api_config']['db']
print 'user: %s' % values['mysql-db']['sms_api_config']['user']
print 'password: %s' % values['mysql-db']['sms_api_config']['password']
print '-------'
def init(self):
'''
@description:
intializes:
- configurations
- db connections
'''
Configuration.initialize()
values = Configuration.values()
self.dbconn = SQLUtils(
host=values['mysql-db']['sms_api_config']['host'],
port=values['mysql-db']['sms_api_config']['port'],
database=values['mysql-db']['sms_api_config']['db'],
user=values['mysql-db']['sms_api_config']['user'],
password=values['mysql-db']['sms_api_config']['password'])
def __init__(self):
'''
@description:
- initializes DB connections
and other configurations
'''
self.pool = Pool(1000) # used for spawning threads
values = Configuration.values()
# -- initializes DB --
self.dbconn = SQLUtils(
host=values['mysql-db']['sms_api_config']['host'],
port=values['mysql-db']['sms_api_config']['port'],
database=values['mysql-db']['sms_api_config']['db'],
user=values['mysql-db']['sms_api_config']['user'],
password=values['mysql-db']['sms_api_config']['password'])
print '-------'
print 'DB:'
print 'port: %s' % values['mysql-db']['sms_api_config']['host']
print 'host: %s' % values['mysql-db']['sms_api_config']['port']
print 'db: %s' % values['mysql-db']['sms_api_config']['db']
print 'user: %s' % values['mysql-db']['sms_api_config']['user']
print 'password: %s' % values['mysql-db']['sms_api_config']['password']
print '-------'
# -- initializes dragonpay related config --
self.api_url = values['dragonpay']['api_url']
self.merchant_id = values['dragonpay']['merchant_id']
self.secret_key = values['dragonpay']['secret_key']
self.host = values['dragonpay']['host']
self.api_get_txn_status_url = values['dragonpay'][
'api_get_txn_status_url']
self.uri = values['dragonpay']['uri']
parse_command_line()
if options.config == 'prod':
url = URL('https://%s' % values['dragonpay']['host'])
else:
url = URL('http://%s' % values['dragonpay']['host'])
self.http_conn = HTTPClient.from_url(url, concurrency=10)
'paypal_website_domain'] # 'www.sandbox.paypal.com'
# used to point to website and say that transaction is now underway (after checkout)
website_callback_url = paypal_settings[
'website_base_url'] #'http://10.11.2.225:28003'
# get the maximum amount an account can purchase per month using paypal
max_purchase_value_per_month = paypal_settings['max_purchase_value_per_month']
# setup the paypal mysql dao
# must implement the dao interface
mysql_cfg = Configuration.values()['mysql-db']['sms_api_config']
sql_util = SQLUtils(host=mysql_cfg['host'],
port=mysql_cfg['port'],
database=mysql_cfg['db'],
user=mysql_cfg['user'],
password=mysql_cfg['password'])
mysql_dao = PaypalMysqlDAO(sql_util=sql_util)
PaypalToken.db_util = mysql_dao
PaypalToken.cache_dao = PaypalPaymentCheckout.paypal_cache_dao = PaypalRedisDao(
redisconn=redisconn,
config_mode=config_mode,
paypal_pending_payment_flag_ttl=paypal_settings['purchase_waiting_time'])
PaypalPaymentCheckout.purchase_history_dao = PaypalPurchaseHistoryMysqlDAO(
sql_util=sql_util)
send_testmin_vercode, verify_testmin_vercode, \
save_testmin, generate_code
"""
dbconn = SQLUtils(host=values[options.config]['mysql-db']['sms_api_config']['host'],
port=values[options.config]['mysql-db']['sms_api_config']['port'],
database=values[options.config]['mysql-db']['sms_api_config']['db'],
user=values[options.config]['mysql-db']['sms_api_config']['user'],
password=values[options.config]['mysql-db']['sms_api_config']['password'])
redisconn = gredis.client.Connection(address=str(values[options.config]['redis_servers']['sms_api_match']['host']),
port=int(values[options.config]['redis_servers']['sms_api_match']['port']))
"""
dbconn = SQLUtils(host='10.11.2.225',
port=3306,
database='sms_api',
user='******',
password='')
redisconn = gredis.client.Connection(address='10.11.2.238', port=6414)
redisconn.connect()
Account.dbconn = dbconn
Verification.dbconn = dbconn
Verification.redisconn = redisconn
'''
ERROR TESTS
'''
testmin = '09111111111'
invalid_long_code = 'c70a4ef428ca65ee0d8b23fd3a33bf1b'
Verification.get( code=invalid_long_code )
if __name__ == '__main__':
parse_command_line()
Configuration.initialize()
values = Configuration.values()
dbconn = SQLUtils(host=values['mysql-db']['sms_api_config']['host'],
port=values['mysql-db']['sms_api_config']['port'],
database=values['mysql-db']['sms_api_config']['db'],
user=values['mysql-db']['sms_api_config']['user'],
password=values['mysql-db']['sms_api_config']['password'])
Verification.cache_dao
Verification.dao = VerificationDao( dbconn=dbconn )
redisconn = gredis.client.Connection( address=str(values['redis_servers']['sms_api']['host']), port=int(values['redis_servers']['sms_api']['port']))
redisconn.connect()
print redisconn
Verification.cache_dao = EmailVerificationRedisDAO( redis_conn=redisconn )
