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 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 oracle_select():
with OracleConnect() as conn:
sql = common_select_sql()
res = common_select(conn, sql)
return res
def oracle_field_error():
with OracleConnect() as conn:
sql = common_field_error_sql()
res = common_select(conn, sql)
return res
def sqlserver_field_error():
sql = common_field_error_sql()
res = common_select(conn, sql)
return res
def sqlserver_table_error():
sql = common_table_error_sql()
res = common_select(conn, sql)
return res
def sqlserver_select():
sql = common_select_sql()
res = common_select(conn, sql)
return res
def pymysql_table_error():
sql = common_table_error_sql()
res = common_select(pymysql_conn, sql)
return res
def pymysql_select():
sql = common_select_sql()
res = common_select(pymysql_conn, sql)
return res
def pymysql_field_error():
sql = common_field_error_sql()
res = common_select(pymysql_conn, sql)
return res
def oursql_select():
sql = common_select_sql()
res = common_select(oursql_conn, sql)
return res
def mysqldb_select():
sql = common_select_sql()
res = common_select(mysqldb_conn, sql)
return res
def mysqldb_field_error():
sql = common_field_error_sql()
res = common_select(mysqldb_conn, sql)
return res
def mysqldb_table_error():
sql = common_table_error_sql()
res = common_select(mysqldb_conn, sql)
return res
