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