def drop(self, table_name): db_cursor = self.db_conn.cursor() try: db_cursor.execute(sql.drop_table(table_name)) self.db_conn.commit() except sqlite3.OperationalError: pass # Already dropped?
def purge_database(): """Purge database. Actions: -- Drop all SQL tables """ sql.drop_table('ipps2011') sql.drop_table('ipps2012') sql.drop_table('ipps2013') sql.drop_table('statePopEst')
def __init__(self, *args, **kwargs): super(ShortestForwarding, self).__init__(*args, **kwargs) self.name = 'shortest_forwarding' self.awareness = kwargs["network_awareness"] self.monitor = kwargs["network_monitor"] self.delay_detector = kwargs["network_delay_detector"] self.datapaths = {} self.weight = self.WEIGHT_MODEL[CONF.weight] self.vip = {} self.conn = sql.get_conn(GPATH) self.flowconn = sql.get_conn(FPATH) self.busy = False self.doing_list = set() self.flow_infome = {} self.dotime = 0 self.fltime = 0 sql.drop_table(self.conn, 'switch') sql.create_table(self.conn, TABLESWITCH) sql.drop_table(self.conn, 'flow') sql.create_table(self.conn, TABLEFLOW) self.vip_thread = hub.spawn(self._vip)