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