def list_active_legislators_first(): query = 'select bioguide_id from bioguide_legislatorrole group by bioguide_id order by max(end_date) desc, bioguide_id' from MySQLdb import Connection cursor = Connection('localhost', 'capwords', 'capwords', 'capwords').cursor() cursor.execute(query) results = [x[0] for x in cursor.fetchall()] return results
def __init__(self, config): ''' Constructor ''' self.config=config conn=Connection(**config) if not conn: #print("connection failed") pass self.cursor=conn.cursor() self.conn=conn
def connect(self): try: self.__connect = Connection(host=self.__host, user=self.__user, passwd=self.__password, db=self.__db, port=self.__port, connect_timeout=self.__timeout) self.__cursor = self.__connect.cursor(DictCursor) self.__connected = True except Exception as e: raise MySQLAPIException(e)
def GenerateConn(dbname, host="localhost", port=3306, user="******", passwd="123456", charset='utf8'): conn = Connection(host=host, port=port, user=user, passwd=passwd, db=dbname, charset=charset) return conn
def db_connect(): while True: try: mysqldb = Connection(host=database['host'], user=database['user'], passwd=database['password'], db=database['db'], charset=database['charset']) except Exception: print('error') continue else: return mysqldb
def create_connection(*args, **kwargs): print(kwargs) if not kwargs: raise ValueError("Must send connection details") if not kwargs.get("host", None) or not kwargs.get( "user", None) or not kwargs.get("passwd", None): raise ValueError("Arguments 'host', 'user' and 'passwd' are required") connection = None try: connection = Connection(host=kwargs.get("host", None), user=kwargs.get("user", None), passwd=kwargs.get("passwd", None), database=kwargs.get("database", "mysql")) print("Connection to MySQL DB successful") except Error as e: traceback.print_exc() raise return connection
# -*- coding:utf-8 -*- __author__ = 'wanggen' import os from MySQLdb import Connection conn = Connection(host='wg-linux', user='******', passwd='wanggen', db='groupon', charset='utf8') cursor = conn.cursor() cursor.execute('select * from ecp_orders limit 10') cursor.close() a = """ ls -l ../ """ files = os.popen(a).read() with open('test', mode='wr') as f: f.write(files)