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)