Exemple #1
0
    def initialize(self, event=None):
        # Populate comboboxes -------------------------------------------------
        odbc_drivers_list = dbTools.get_odbc_drivers()
        self.combobox_odbc.AppendItems(odbc_drivers_list)

        db_engines_list = SQLdb.get_engines()
        self.combobox_engine.AppendItems(db_engines_list)

        # Populate the rest ---------------------------------------------------
        options = {
            'engine': '',
            'driver': '',
            'database': '',
            'host': '',
            'user': '',
            'password': '',
            'filepath': ''
        }

        self.section_dict = self.ini_file.get_section(section=self.ini_section,
                                                      option_dict=options)

        self.form_dict = {
            'engines_list': db_engines_list,
            'drivers_list': odbc_drivers_list
        }
        self.form_dict.update(self.section_dict)
        self.populate(self.form_dict)

        self.on_connect = self.connect
        self.on_disconnect = self.disconnect
Exemple #2
0
    def __init__(self,
                 ini_filename='',
                 autosave=False,
                 parent=None,
                 debug=False):
        self.ini_filename = ini_filename
        self.autosave = autosave
        self.parent = parent
        self.debug = debug
        self.database = None

        self.database_dialog = Portlets.Database()
        self.DialogBox = Dialogs.Simple(parent=self.parent)
        self.ini_file = FileSystem.iniFile(self.ini_filename)
        self.portlet = self.database_dialog.create()

        db_engines_list = SQLdb.get_engines()
        self.config_dic = self.get_settings_from_ini()

        odbc_drivers_list = dbTools.get_odbc_drivers()
        self.database_dialog.populate(db_engines_list, odbc_drivers_list,
                                      self.config_dic)

        self.database_dialog.connect_order = self.connect
        self.database_dialog.disconnect_order = self.disconnect
    def populate(self):
        if self.primary_key <> None:
            content_lod = self.db_table.db_object.dictresult('''\
SELECT * FROM %s WHERE %s = %s''' % (self.db_table.name, 
                                     self.primary_key_column, 
                                     self.primary_key))
            self.Form.populate(content_dict=content_lod[0])
        else:
            content_lod = None
        
        # Do callbacks for the population of higher-level widgets.
        for definition_dic in self.definition_lod:
            # First, check if there is a referenced table. If content_lod is empty,
            # pass through to populate the comboboxentry-dropdown-tables!
            foreign_content_dic = None
            if definition_dic.has_key('referenced_table_name'):
                if content_lod <> None:
                    foreign_key = content_lod[0][definition_dic['column_name']]
                else:
                    foreign_key = None
                    
                if foreign_key == None:
                    foreign_key = 'NULL'
                
                foreign_content_lod = self.db_table.db_object.dictresult('''\
SELECT * FROM %s WHERE %s = %s''' % (definition_dic['referenced_table_name'], 
                             definition_dic['referenced_column_name'], 
                             foreign_key))
                if foreign_content_lod <> []:
                    foreign_content_dic = foreign_content_lod[0]
            
            # Second, check if there is a populate function
            if definition_dic.has_key('populate_function'):
                definition_dic['populate_function'](definition_dic['widget_object'], foreign_content_dic)
            
            # Perhaps there is a simple populate_from attribute?
            if definition_dic.has_key('populate_from'):
                populate_from = definition_dic['populate_from']
                if definition_dic.has_key('referenced_table_name'):
                    referenced_table_name = definition_dic['referenced_table_name']
                    referenced_column_name = definition_dic['referenced_column_name']
                    widget = definition_dic['widget_object']
                    
                    if definition_dic.has_key('mask'):
                        mask = definition_dic['mask']
                    else:
                        mask = None
                    
                    populate_from.append(referenced_column_name) 
                    foreign_table = SQLdb.table(self.db_object, referenced_table_name)
                    result_lod = foreign_table.select(populate_from)
                    widget.initialize({'column_name': [populate_from][0], 'mask': mask})
                    widget.populate(result_lod)
                    
                    if foreign_content_dic <> None:
                        widget.set_text(foreign_content_dic[populate_from[0]])
 def connect(self):
     try:
         self.config_dic = self.database_dialog.get_config_dic()
         self.database = SQLdb.database(self.config_dic['engine'], debug=self.debug)
         self.database.connect(database=self.config_dic['database'],
                               driver=self.config_dic['driver'],
                               host=self.config_dic['host'],
                               user=self.config_dic['user'],
                               password=self.config_dic['password'])
         self.database_dialog.set_connected()
         
         # Save .ini-file automatically on connection
         if self.autosave == True:
             self.save_settings_to_ini()
     except Exception, inst:
         self.DialogBox.show(dialog_type='error', title='Fehler', inst=inst)
         self.database_dialog.set_disconnected()
Exemple #5
0
    def connect(self):
        try:
            self.config_dic = self.database_dialog.get_config_dic()
            self.database = SQLdb.database(self.config_dic['engine'],
                                           debug=self.debug)
            self.database.connect(database=self.config_dic['database'],
                                  driver=self.config_dic['driver'],
                                  host=self.config_dic['host'],
                                  user=self.config_dic['user'],
                                  password=self.config_dic['password'])
            self.database_dialog.set_connected()

            # Save .ini-file automatically on connection
            if self.autosave == True:
                self.save_settings_to_ini()
        except Exception, inst:
            self.DialogBox.show(dialog_type='error', title='Fehler', inst=inst)
            self.database_dialog.set_disconnected()
Exemple #6
0
    def initialize(self, event=None):
        # Populate comboboxes -------------------------------------------------
        odbc_drivers_list = dbTools.get_odbc_drivers()
        self.combobox_odbc.AppendItems(odbc_drivers_list)

        db_engines_list = SQLdb.get_engines()
        self.combobox_engine.AppendItems(db_engines_list)

        # Populate the rest ---------------------------------------------------
        options = {"engine": "", "driver": "", "database": "", "host": "", "user": "", "password": "", "filepath": ""}

        self.section_dict = self.ini_file.get_section(section=self.ini_section, option_dict=options)

        self.form_dict = {"engines_list": db_engines_list, "drivers_list": odbc_drivers_list}
        self.form_dict.update(self.section_dict)
        self.populate(self.form_dict)

        self.on_connect = self.connect
        self.on_disconnect = self.disconnect
    def __init__(self, ini_filename='', autosave=False, parent=None, debug=False):
        self.ini_filename = ini_filename
        self.autosave = autosave
        self.parent = parent
        self.debug = debug
        self.database = None

        self.database_dialog = Portlets.Database()
        self.DialogBox = Dialogs.Simple(parent=self.parent)
        self.ini_file = FileSystem.iniFile(self.ini_filename)
        self.portlet = self.database_dialog.create()
        
        db_engines_list = SQLdb.get_engines()
        self.config_dic = self.get_settings_from_ini()
        
        odbc_drivers_list = dbTools.get_odbc_drivers()
        self.database_dialog.populate(db_engines_list, odbc_drivers_list, self.config_dic)

        self.database_dialog.connect_order = self.connect
        self.database_dialog.disconnect_order = self.disconnect
Exemple #8
0
    def connect(self):
        """ Trys to connect the database with given parameters. """

        try:
            self.section_dict = self.get_content()
            self.database = SQLdb.database(self.section_dict.get("engine"))
            self.database.connect(
                database=self.section_dict.get("database"),
                driver=self.section_dict.get("driver"),
                host=self.section_dict.get("host"),
                user=self.section_dict.get("user"),
                password=self.section_dict.get("password"),
                filepath=self.section_dict.get("filepath"),
            )
            self.set_connected()

            # Save .ini-file automatically on connection
            if self.autosave == True:
                self.save_settings()
        except Exception, inst:
            self.set_disconnected()
            self.ErrorDialog.show(message="Datenbank konnte nicht verbunden werden.", instance=inst)
Exemple #9
0
    def connect(self):
        ''' Trys to connect the database with given parameters. '''

        try:
            self.section_dict = self.get_content()
            self.database = SQLdb.database(self.section_dict.get('engine'))
            self.database.connect(database=self.section_dict.get('database'),
                                  driver=self.section_dict.get('driver'),
                                  host=self.section_dict.get('host'),
                                  user=self.section_dict.get('user'),
                                  password=self.section_dict.get('password'),
                                  filepath=self.section_dict.get('filepath'))
            self.set_connected()

            # Save .ini-file automatically on connection
            if self.autosave == True:
                self.save_settings()
        except Exception, inst:
            self.set_disconnected()
            self.ErrorDialog.show(
                message='Datenbank konnte nicht verbunden werden.',
                instance=inst)
Exemple #10
0
    def populate(self):
        if self.primary_key <> None:
            content_lod = self.db_table.db_object.dictresult(
                '''\
SELECT * FROM %s WHERE %s = %s''' %
                (self.db_table.name, self.primary_key_column,
                 self.primary_key))
            self.Form.populate(content_dict=content_lod[0])
        else:
            content_lod = None

        # Do callbacks for the population of higher-level widgets.
        for definition_dic in self.definition_lod:
            # First, check if there is a referenced table. If content_lod is empty,
            # pass through to populate the comboboxentry-dropdown-tables!
            foreign_content_dic = None
            if definition_dic.has_key('referenced_table_name'):
                if content_lod <> None:
                    foreign_key = content_lod[0][definition_dic['column_name']]
                else:
                    foreign_key = None

                if foreign_key == None:
                    foreign_key = 'NULL'

                foreign_content_lod = self.db_table.db_object.dictresult(
                    '''\
SELECT * FROM %s WHERE %s = %s''' %
                    (definition_dic['referenced_table_name'],
                     definition_dic['referenced_column_name'], foreign_key))
                if foreign_content_lod <> []:
                    foreign_content_dic = foreign_content_lod[0]

            # Second, check if there is a populate function
            if definition_dic.has_key('populate_function'):
                definition_dic['populate_function'](
                    definition_dic['widget_object'], foreign_content_dic)

            # Perhaps there is a simple populate_from attribute?
            if definition_dic.has_key('populate_from'):
                populate_from = definition_dic['populate_from']
                if definition_dic.has_key('referenced_table_name'):
                    referenced_table_name = definition_dic[
                        'referenced_table_name']
                    referenced_column_name = definition_dic[
                        'referenced_column_name']
                    widget = definition_dic['widget_object']

                    if definition_dic.has_key('mask'):
                        mask = definition_dic['mask']
                    else:
                        mask = None

                    populate_from.append(referenced_column_name)
                    foreign_table = SQLdb.table(self.db_object,
                                                referenced_table_name)
                    result_lod = foreign_table.select(populate_from)
                    widget.initialize({
                        'column_name': [populate_from][0],
                        'mask': mask
                    })
                    widget.populate(result_lod)

                    if foreign_content_dic <> None:
                        widget.set_text(foreign_content_dic[populate_from[0]])