예제 #1
0
    def load_SQL_database(self):
        table_columns = [
            "ResultID", "FeatureCode", "Variable", "Unit", "Type",
            "Organization", "Date Created"
        ]
        self.table.set_columns(table_columns)
        db = self.get_selected_database()

        if not len(db):
            return

        if db["args"]["engine"] == "sqlite":
            session_factory = dbconnection2.createConnection(
                engine=db["args"]["engine"], address=db["args"]["address"])
            session = db2.connect(session_factory)
            series = session.getAllSeries()
        elif db["args"]["engine"] == "postgresql":  # db is postresql
            session_factory = dbUtilities.build_session_from_connection_string(
                db["connection_string"])
            session = db2.connect(session_factory)
            series = session.getAllSeries()
        else:
            # Fails if db is not sqlite or postresql
            raise Exception("Failed to load database")

        if not series:
            self.table.empty_list_message.Show()
            return

        self.table.empty_list_message.Hide()
        data = self.series_to_table_data(series)

        self.table.set_table_content(data)
예제 #2
0
    def load_SQL_database(self):
        table_columns = ["ResultID", "FeatureCode", "Variable", "Unit", "Type", "Organization", "Date Created"]
        self.table.set_columns(table_columns)
        db = self.get_selected_database()

        if not len(db):
            return

        if db["args"]["engine"] == "sqlite":
            session_factory = dbconnection2.createConnection(engine=db["args"]["engine"], address=db["args"]["address"])
            session = db2.connect(session_factory)
            series = session.getAllSeries()
        elif db["args"]["engine"] == "postgresql":  # db is postresql
            session_factory = dbUtilities.build_session_from_connection_string(db["connection_string"])
            session = db2.connect(session_factory)
            series = session.getAllSeries()
        else:
            # Fails if db is not sqlite or postresql
            raise Exception("Failed to load database")

        if not series:
            self.table.empty_list_message.Show()
            return

        self.table.empty_list_message.Hide()
        data = self.series_to_table_data(series)

        self.table.set_table_content(data)
예제 #3
0
 def get_current_database_session(self, dbName=None):
     if dbName is not None:
         dbs = engine.getDbConnections()
         for db in dbs.iterkeys():
             if dbs[db]['name'] == dbName:
                 self._currentDbSession = dbUtilities.build_session_from_connection_string(
                     dbs[db]['connection_string'])
                 break
     return self._currentDbSession
예제 #4
0
 def get_current_database_session(self, dbName=None):
     if dbName is not None:
         dbs = engine.getDbConnections()
         for db in dbs.iterkeys():
             if dbs[db]['name'] == dbName:
                 self._currentDbSession = dbUtilities.build_session_from_connection_string(
                     dbs[db]['connection_string'])
                 break
     return self._currentDbSession
예제 #5
0
 def get_database_session(self):
     """
     Connect to the respective database and return the session
     Exception is raised if it is not a sqlite or postresql
     :return:
     """
     db = self.get_selected_database()
     if db["args"]['engine'] == "sqlite":
         session_factory = dbconnection.createConnection(engine=db["args"]["engine"], address=db["args"]["address"],
                                                  db=db["args"]["db"], user=db["args"]["user"],
                                                  password=db["args"]["pwd"])
         session = db2.connect(session_factory)
         return session
     elif db["args"]["engine"] == "postgresql":
         session_factory = dbUtilities.build_session_from_connection_string(db['connection_string'])
         session = db2.connect(session_factory)
         return session
     else:
         raise Exception("Failed to load simulations database")
예제 #6
0
 def get_database_session(self):
     """
     Connect to the respective database and return the session
     Exception is raised if it is not a sqlite or postresql
     :return:
     """
     db = self.get_selected_database()
     if db["args"]['engine'] == "sqlite":
         session_factory = dbconnection.createConnection(
             engine=db["args"]["engine"],
             address=db["args"]["address"],
             db=db["args"]["db"],
             user=db["args"]["user"],
             password=db["args"]["pwd"])
         session = db2.connect(session_factory)
         return session
     elif db["args"]["engine"] == "postgresql":
         session_factory = dbUtilities.build_session_from_connection_string(
             db['connection_string'])
         session = db2.connect(session_factory)
         return session
     else:
         raise Exception("Failed to load simulations database")