def pymysql_position_connect():
position_conn = pymysql.connect(MYSQL_CONF['host'], MYSQL_CONF['name'],
MYSQL_CONF['pwd'], MYSQL_CONF['db'],
MYSQL_CONF['port'])
sql = common_select_sql()
res = common_select_conn(position_conn, sql)
return res
def psycopg2cffi_uri_no_port_connect():
conn_uri_no_port = psycopg2cffi.connect(
"postgresql://%s:%s@%s/%s" % (PG_CONF['user'], PG_CONF['password'],
PG_CONF['host'], PG_CONF['database']))
sql = common_select_sql()
res = common_select_conn(conn_uri_no_port, sql)
return res
def sqlserver_keyword_connect():
driver_ = 'DRIVER={FreeTDS};SERVER=%s;PORT=%s;DATABASE=%s;UID=%s;PWD=%s' %\
(SQL_SERVER_CONF['host'], SQL_SERVER_CONF['port'], SQL_SERVER_CONF['db'], SQL_SERVER_CONF['name'],
SQL_SERVER_CONF['pwd'])
keyword_conn = pyodbc.connect(driver_)
sql = common_select_sql()
res = common_select_conn(keyword_conn, sql)
return res
def psycopg2cffi_connectstring_connect():
conn_connectstring = psycopg2cffi.connect(
"dbname=%s user=%s password=%s host=%s port=%s" %
(PG_CONF['database'], PG_CONF['user'], PG_CONF['password'],
PG_CONF['host'], PG_CONF['port']))
sql = common_select_sql()
res = common_select_conn(conn_connectstring, sql)
return res
def oracle_makedsn_conn():
makedsn_conn = cx_Oracle.connect(
ORACLE_CONF['name'], ORACLE_CONF['pwd'],
cx_Oracle.makedsn(ORACLE_CONF['host'], ORACLE_CONF['port'],
ORACLE_CONF['xe']))
sql = common_select_sql()
res = common_select_conn(makedsn_conn, sql)
return res
def oracle_connectstring_conn():
connectstring_conn = cx_Oracle.connect(
"%s/%s@%s:%s/%s" %
(ORACLE_CONF['name'], ORACLE_CONF['pwd'], ORACLE_CONF['host'],
ORACLE_CONF['port'], ORACLE_CONF['xe']))
sql = common_select_sql()
res = common_select_conn(connectstring_conn, sql)
return res
def psycopg2cffi_no_port_connect():
conn_no_port = psycopg2cffi.connect(host=PG_CONF['host'],
user=PG_CONF['user'],
password=PG_CONF['password'],
database=PG_CONF['database'])
sql = common_select_sql()
res = common_select_conn(conn_no_port, sql)
return res
def psycopg2cffi_no_support_connect():
conn_no_support = psycopg2cffi.connect(
"postgresql:///%s?host=%s&port=%s&user=%s&password=%s" %
(PG_CONF['database'], PG_CONF['host'], PG_CONF['port'],
PG_CONF['user'], PG_CONF['password']))
sql = common_select_sql()
res = common_select(conn_no_support, sql)
return res
def psycopg2cffi_no_support_connect_two():
conn_no_support_two = psycopg2cffi.connect(
"postgresql://%s:%s@[%s]:%s/%s" %
(PG_CONF['user'], PG_CONF['password'], PG_CONF['IPv6_address'],
PG_CONF['port'], PG_CONF['database']))
sql = common_select_sql()
res = common_select(conn_no_support_two, sql)
return res
def psycopg2ct_dbname_connect():
conn_dbname = psycopg2ct.connect(host=PG_CONF['host'],
port=PG_CONF['port'],
user=PG_CONF['user'],
password=PG_CONF['password'],
dbname=PG_CONF['database'])
sql = common_select_sql()
res = common_select_conn(conn_dbname, sql)
return res
def pymysql_keyword_connect():
keyword_conn = pymysql.connect(host=MYSQL_CONF['host'],
port=MYSQL_CONF['port'],
user=MYSQL_CONF['name'],
passwd=MYSQL_CONF['pwd'],
db=MYSQL_CONF['db'])
sql = common_select_sql()
res = common_select(keyword_conn, sql)
return res
def oursql_no_port_connect():
# 省略port
no_port_conn = oursql.connect(MYSQL_CONF['host'],
MYSQL_CONF['name'],
MYSQL_CONF['pwd'],
db=MYSQL_CONF['db'])
sql = common_select_sql()
res = common_select_conn(no_port_conn, sql)
return res
def oursql_position_connect():
# 标准位置参数连接
position_conn = oursql.connect(MYSQL_CONF['host'],
MYSQL_CONF['name'],
MYSQL_CONF['pwd'],
port=MYSQL_CONF['port'],
db=MYSQL_CONF['db'])
sql = common_select_sql()
res = common_select_conn(position_conn, sql)
return res
def pymysql_dict_conn():
connection_param = {
'host': MYSQL_CONF['host'],
'port': MYSQL_CONF['port'],
'user': MYSQL_CONF['name'],
# 0.7.9
# 'password': MYSQL_CONF['pwd'],
# 0.6
'passwd': MYSQL_CONF['pwd'],
'db': MYSQL_CONF['db']
}
dict_conn = pymysql.connect(**connection_param)
sql = common_select_sql()
res = common_select_conn(dict_conn, sql)
return res
def sqlserver_select():
sql = common_select_sql()
res = common_select(conn, sql)
return res
def oursql_fetch_all():
sql = common_select_sql()
res = common_fetch_all(oursql_conn, sql)
return res
def test_psycopg2cffi_select():
sql = common_select_sql()
common_execute(conn, sql)
return 'test_psycopg2cffi_select ok'
def pymysql_fetch_all():
sql = common_select_sql()
res = common_fetch_all(pymysql_conn, sql)
return res
def oracle_fetch_all():
with OracleConnect() as conn:
sql = common_select_sql()
res = common_fetch_all(conn, sql)
return res
def oracle_position_conn():
with OracleConnect() as conn:
sql = common_select_sql()
res = common_select(conn, sql)
return res
def oursql_select():
sql = common_select_sql()
res = common_select(oursql_conn, sql)
return res
def mysqldb_fetch_one():
sql = common_select_sql()
res = common_fetch_one(mysqldb_conn, sql)
return res
def mysqldb_select():
sql = common_select_sql()
res = common_select(mysqldb_conn, sql)
return res
def pymysql_select():
sql = common_select_sql()
res = common_select(pymysql_conn, sql)
return res
def mysqldb_position_conn():
position_conn = MySQLdb.connect(MYSQL_CONF['host'], MYSQL_CONF['name'],
MYSQL_CONF['pwd'], MYSQL_CONF['db'])
sql = common_select_sql()
res = common_select_conn(position_conn, sql)
return res
def sqlserver_fetch_all():
sql = common_select_sql()
res = common_fetch_all(conn, sql)
return res
