- 论坛徽章:
- 0
|
import logging
from DBUtils.PooledDB import PooledDB
if not settings.IS_DEV:
logging.info('mssql dbpool initing!')
# args = (5,30,0,50,0,0,None)
# conn_kwargs = {'host':'.', 'user':settings.MSSQL_USER, 'password':settings.MSSQL_PASSWD,'database':settings.MSSQL_DATABASE_NAME,'trusted':True}
# databaseConnPool = PooledDB(pymssql, *args, **conn_kwargs)
logging.info('mssql dbpool init end!')
'''
get mssql connection
'''
def __getConnection():
conn = None
try:
conn = databaseConnPool.connection()
#pymssql.connect(host=".",user=settings.MSSQL_USER,password=settings.MSSQL_PASSWD,database=settings.MSSQL_DATABASE_NAME,trusted=True)
except pymssql.MssqlDatabaseException,e:
if e.number == 2714 and e.severity == 16:
if conn is not None:conn.close()
raise Exception, 'connect database has wrong1'
else:
if conn is not None:conn.close()
raise Exception, 'connect database has wrong2'
return conn |
我用了连接池的,先凑合着看吧,以前写的可能有点错误,我用的 import pymssql |
|