def __init__(self, host=None, user=None, passwd=None): """@__init__ This constructor is responsible for defining class variables. """ self.db_settings = Database() self.list_error = [] self.proceed = True # host address if host: self.host = host else: self.host = self.db_settings.get_db_host() # sql username for above host address if user: self.user = user else: self.user = self.db_settings.get_db_username() # sql password for above username if passwd: self.passwd = passwd else: self.passwd = self.db_settings.get_db_password()
class SQL(object): ## constructor: def __init__(self, host=None, user=None, passwd=None): self.db_settings = Database() self.list_error = [] self.proceed = True # host address if host: self.host = host else: self.host = self.db_settings.get_db_host() # sql username for above host address if user: self.user = user else: self.user = self.db_settings.get_db_username() # sql password for above username if passwd: self.passwd = passwd else: self.passwd = self.db_settings.get_db_password() ## sql_connect: create connection to MySQL / MariaDB def sql_connect(self, database=None): try: if database == None: self.conn = DB.connect(self.host, self.user, self.passwd) else: self.conn = DB.connect(self.host, self.user, self.passwd, db=database) self.cursor = self.conn.cursor() return {'status': True, 'error': None, 'id': None} except DB.Error, error: self.proceed = False self.list_error.append(error) return {'status': False, 'error': self.list_error, 'id': None}
def __init__(self, host=None, user=None, passwd=None): self.db_settings = Database() self.list_error = [] self.proceed = True # host address if host: self.host = host else: self.host = self.db_settings.get_db_host() # sql username for above host address if user: self.user = user else: self.user = self.db_settings.get_db_username() # sql password for above username if passwd: self.passwd = passwd else: self.passwd = self.db_settings.get_db_password()
class SQL(object): """@SQL This class provides an interface to connect, execute commands, and disconnect from a SQL database. It explicitly inherits pythons 'new-style' class. Note: this class is invoked within 'save_xx.py', and 'retrieve_xx.py' modules. Note: this class explicitly inherits the 'new-style' class. """ def __init__(self, host=None, user=None, passwd=None): """@__init__ This constructor is responsible for defining class variables. """ self.db_settings = Database() self.list_error = [] self.proceed = True # host address if host: self.host = host else: self.host = self.db_settings.get_db_host() # sql username for above host address if user: self.user = user else: self.user = self.db_settings.get_db_username() # sql password for above username if passwd: self.passwd = passwd else: self.passwd = self.db_settings.get_db_password() def sql_connect(self, database=None): """@sql_connect This method is responsible for defining the necessary interface to connect to a SQL database. """ try: if database is None: self.conn = DB.connect( self.host, self.user, self.passwd, ) else: self.conn = DB.connect( self.host, self.user, self.passwd, db=database, ) self.cursor = self.conn.cursor() return { 'status': True, 'error': None, 'id': None, } except DB.Error, error: self.proceed = False self.list_error.append(error) return { 'status': False, 'error': self.list_error, 'id': None, }