def test_MySQLWrapper(number=100):
cfg = ReadConfig('./db.info')
cfgd = cfg.check_config()
sop = cfgd['mysql']['app_eemsop']
print('sop', sop)
####
try:
sql_pool1 = MySQLWrapper(**sop)
except:
print('error')
return -1
time1_start = time.time()
for i in range(int(number)):
sql = 'select * from users where id=%s' % (int(random.random() * 5))
res = sql_pool1.do_work(sql)
print(res)
time1_end = time.time()
time1_spend = time1_end - time1_start
print('my own mysql wraper, query times %s, spend %s s' %
(number, time1_spend))
time2_start = time.time()
for i in range(int(number)):
conn = MySQLdb.connect(**sop)
c = conn.cursor()
c.execute('select * from users where id=%s' %
(int(random.random() * 5)))
res = c.fetchall()
conn.close()
time2_end = time.time()
time2_spend = time2_end - time1_start
print('normal, query times %s, spend %s s' % (number, time2_spend))
return [time1_spend, time2_spend]
def main():
print('db_pool is a database connection pool, as tool class.')
cfg = ReadConfig('./db.info')
cfgd = cfg.check_config()
rp = RedisWrapper(host=cfgd['redis']['91']['host'])
r1 = rp.redis_connect()
rp2 = redis.ConnectionPool(host='172.16.5.91', port=6379)
r2 = redis.Redis(connection_pool=rp2)
print(r1)
print(r2)
test_MySQLWrapper()
def rd(server='91'):
cfg = ReadConfig('./db.info')
cfgd = cfg.check_config()
try:
host = '6379' if not ('host' in cfgd['redis'][server].keys()
) else cfgd['redis'][server]['host']
port = '6379' if not ('port' in cfgd['redis'][server].keys()
) else cfgd['redis'][server]['port']
db = '0' if not ('db' in cfgd['redis'][server].keys()
) else cfgd['redis'][server]['db']
# print(host, port, db)
rp = RedisWrapper(host=host, port=port, db=db, name=server)
except:
return None
return rp.redis_connect()
