def test2():
from qfcommon.base import logger, dbpool
logger.install('stdout')
DATABASE = {
'test': # connection name, used for getting connection from pool
{
'engine': 'mysql', # db type, eg: mysql, sqlite
'db': 'test', # db name
'host': '127.0.0.1', # db host
'port': 3306, # db port
'user': '******', # db user
'passwd': '123456', # db password
'charset': 'utf8', # db charset
'conn': 2
} # db connections in pool
}
dbpool.install(DATABASE)
with dbpool.get_connection('test') as conn:
for i in range(0, 10):
myid = new_id64(conn=conn)
print time.time(), time.localtime()[:]
print myid,
unpack_id64(myid)
print unpack_time_id64(myid)
def install(self):
if self.settings.HOME not in sys.path:
sys.path.insert(0, self.settings.HOME)
tplcf = self.settings.TEMPLATE
if tplcf["tmp"] and not os.path.isdir(tplcf["tmp"]):
os.mkdir(tplcf["tmp"])
if tplcf["path"]:
template.install(tplcf["path"], tplcf["tmp"], tplcf["cache"], self.settings.CHARSET)
for s in self.settings.STATICS:
log.info("add static")
static_root = self.document_root + s
def server_static(filepath):
return static_file(filepath, root=static_root)
r = Route(app=self.bottle, rule=s + "<filepath:path>", method="GET", callback=server_static)
self.bottle.add_route(r)
if self.settings.DATABASE:
dbpool.install(self.settings.DATABASE)
for appname in self.settings.APPS:
self.add_app(appname)
def test():
import settings
import web
dbpool.install(settings.DATABASE)
class Hello:
@with_user
def GET(self):
print self.user
print 'userid :', self.user.ses.get('userid', 0)
if self.user.is_login():
print 'user login'
else:
print 'user not login'
if self.user.ses.data:
print 'user:%d' % self.user.ses.get('userid', 0)
else:
print 'no user'
self.user.userid = 10128
self.user.login()
return '<a href="/11">gogo</a>'
urls = ('/.*', 'Hello')
app = web.application(urls, locals())
app.run()
def install(self):
if self.settings.HOME not in sys.path:
sys.path.insert(0, self.settings.HOME)
tplcf = self.settings.TEMPLATE
if tplcf['tmp'] and not os.path.isdir(tplcf['tmp']):
os.mkdir(tplcf['tmp'])
if tplcf['path']:
template.install(tplcf['path'], tplcf['tmp'], tplcf['cache'],
self.settings.CHARSET)
if self.settings.DATABASE:
dbpool.install(self.settings.DATABASE)
for appname in self.settings.APPS:
self.add_app(appname)
# coding: utf-8
'''订单测试'''
import json
import time
import datetime
import urllib
from qiantai_config import *
from qiantai_util import *
import random
import nose
import cmp_struct
from qfcommon.base import dbpool
from qfcommon.base.dbpool import with_database
dbpool.install(DATABASE)
class TestOther:
def setUp(self):
self.txamt = 1
self.url = '%s/trade/v1/query' % QT_API
def _order(self):
url = '%s/trade/v1/payment' % QT_API
out_trade_sn = int(time.time() * 10000)
param = {
'txamt': self.txamt,
'txcurrcd': 'CNY',
'pay_type': 800201,
'out_trade_no': out_trade_sn,
'txdtm': datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"),
#coding: utf-8
from qfcommon.base import dbpool
from qfcommon.base.dbpool import with_database
import sys, os
HOME = os.path.dirname(os.path.abspath(__file__))
sys.path.append(os.path.join(HOME))
import qiantai_config
dbpool.install(qiantai_config.DATABASE)
class test:
@with_database('qiantai')
def get_customer(self):
where = {
'app_code': qiantai_config.TEST_APP['app_code'],
}
appid = self.db.select_one('app', fields='id', where=where)
where1 = {
'app_id': str(appid['id']),
}
ret = self.db.select('customer',
where=where1,
fields='`balance`,`out_user`',
other='LIMIT 10')
if not ret:
return "error"
return ret
from qfcommon.base import logger
log = logger.install('stdout')
from qfcommon.base import loader
loader.loadconf_argv(HOME)
import urllib2
import urllib
import logging
import string
import datetime
import traceback
import json
import config
from qfcommon.base import dbpool
dbpool.install(config.DATABASE)
#from requests import post,get
from qfcommon.base.http_client import Urllib2Client
from qfcommon.base.dbpool import with_database, get_connection_exception, get_connection
from qfcommon.server.client import ThriftClient
import logging
import time
import datetime
from qfcommon.thriftclient.qf_wxmp import QFMP
from qfcommon.thriftclient.qf_wxmp.ttypes import WXToken
def start():
now = int(time.time())
if args.runmode == 'debug':
import config_debug as config
elif args.runmode == 'production':
import config
else:
raise RuntimeError('invalid runmode')
if args.log_stdout:
log = logger.install('stdout')
else:
log = logger.install(config.LOGFILE)
if args.activity_id:
push_activity_id_list = args.activity_id
install(config.DATABASE)
def get_actvs():
'''获取活动列表'''
actvs = None
date = args.date
with get_connection('qf_marketing') as db:
where = {'type': 3, 'status' : ('in', [1,2])}
if push_activity_id_list:
where['id'] = ('in', push_activity_id_list)
else:
timestamp = int(time.mktime(date.timetuple()))
where['start_time'] = 'between', (timestamp, timestamp+24*3600-1)
actvs = db.select('activity', where=where)
return actvs
import xlrd
import time
from qfcommon.base import logger, dbpool
from qfcommon.base.dbpool import get_connection_exception
log = logger.install('stdout')
# 线下环境
dbpool.install({
'qf_mis': {
'engine': 'mysql',
'db': 'qf_mis',
'host': '172.100.101.107',
# 'host': '172.100.101.156',
'port': 3306,
'user': '******',
'passwd': '123456',
'charset': 'utf8',
'conn': 16,
}
})
wb = xlrd.open_workbook('area_code.xls')
sh = wb.sheet_by_name(u'2017-11-07')
nrows = sh.nrows
all_data = []
now = time.strftime('%Y-%m-%d %H:%M:%S')
for i in xrange(nrows):
if i == 0:
continue
import socket
import binascii
import traceback
import base64
from ctypes import *
from thrift import Thrift
from thrift.transport import TSocket
from thrift.transport import TTransport
from thrift.protocol import TBinaryProtocol
HOME = os.path.dirname(os.path.abspath(__file__))
sys.path.append(os.path.join(HOME, "gen-py"))
import config
from encryptor import Encryptor
libencutil = CDLL("./encutil/libencutil.so")
from qfcommon.base import dbpool
dbpool.install(config.DATABASE)
class Sender:
def __init__(self):
self.cookie = None
self.trade_webserver = config.trade_webserver
self.openapi_webserver = config.openapi_webserver
def __pack(self, data, do_encrypt, transfer_key):
pack_str = create_string_buffer(10240)
pack_len = 0
need_enc = json.dumps(data)
tsk = binascii.unhexlify(transfer_key)
a = c_int(pack_len)
pi = pointer(a)
