示例#1
0
    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()
示例#2
0
    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()
示例#5
0
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,
            }
示例#6
0
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,
            }