def mysql(sql): data, result = "", "" host = "mysql" user = os.getenv('mysql_user') pw = os.getenv('mysql_passwd') db = os.getenv('mysql_db') port = 3306 # 使用连接池 connection = connect(creator=pymysql, host=host, user=user, password=pw, database=db, autocommit=True, charset='utf8', port=port, cursorclass=pymysql.cursors.DictCursor) try: with connection.cursor() as cursor: cursor.execute(sql) connection.commit() if "select" or "show" in sql: data = cursor.fetchall() except Exception as e: print(e) connection.rollback() else: result = True finally: connection.close() return data, result
def re_connect(self, is_persist=None): if is_persist: persist=DBUtils.PersistentDB.PersistentDB(MySQLdb, 100, host=self.host,user=self.user,passwd=self.passwd,db=self.db) conn = persist.connection() return conn else: conn = connect(MySQLdb, 1000, host=self.host,user=self.user,passwd=self.passwd,db=self.db) return conn
def connect(self): conn = connect(MySQLdb, **self.conn_params) if not conn: raise DatabaseError('can not connect to database: %s %s %s' % (host, user, db)) cursor = conn.cursor() cursor = CursorWrapper(cursor, self) return cursor
def __init__(self): self.credentials = ['localhost', 'username', 'password', 'database'] self.db = connect( creator=pymysql, host=self.credentials[0], user=self.credentials[1], password=self.credentials[2], database=self.credentials[3], autocommit=True, charset='utf8mb4', cursorclass=pymysql.cursors.DictCursor )
def steady_connection(self): """Get a steady, non-persistent DB-API 2 connection.""" return connect(self._creator, self._maxusage, self._setsession, self._failures, self._closeable, *self._args, **self._kwargs)
def steady_connection(self): """Get a steady, unpooled DB-API 2 connection.""" return connect(self._creator, self._maxusage, self._setsession, self._failures, self._ping, True, *self._args, **self._kwargs)
i = i + 1 v = v + ")" return v print("------------------------------------- ".format(dt.datetime.now(), len(db_tables))) print("{}------Scripte Started".format(dt.datetime.now())) change_platform_script('stop') src_db = connect(creator=pymysql, host=source_cred['host'], port=source_cred['port'], user=source_cred['user'], password=source_cred['passwd'], database=source_cred['database'], autocommit=True, charset='utf8mb4', cursorclass=pymysql.cursors.Cursor) src_cursor = src_db.cursor() des_db = connect(creator=pymysql, host=dest_cred['host'], port=dest_cred['port'], user=dest_cred['user'], password=dest_cred['passwd'], database=dest_cred['database'], autocommit=True, charset='utf8mb4', cursorclass=pymysql.cursors.Cursor) des_cursor = des_db.cursor()
def connection(*args, **kwds): kwds["maxusage"] = False return connect(MySQLdb, *args, **kwds)
def connection(*args, **kwds): kwds['maxusage'] = False return connect(MySQLdb, *args, **kwds)
import requests from konlpy.tag import Mecab import pymysql from DBUtils.SteadyDB import connect end_str = 'subwayinfo.cylwhwhcjyca.ap-northeast-2.rds.amazonaws.com' # conn = pymysql.connect(host=end_str, user='******', password='******', # db='subwayinfo', charset='utf8') conn = connect(creator=pymysql, host=end_str, user='******', password='******', database='subwayinfo', charset='utf8') def move_conn(): return conn curs = conn.cursor() mecab = Mecab() num_list = list(map(str, range(1, 10))) num_to_korean_Dict = { '1': '일', '2': '이', '3': '삼', '4': '사', '5': '오',