def tests(): tablename = 'CANDIDATE' DBConfig.setDataDirPattern(os.path.join('..', 'data', 'fec-data', '*')) print(DBConfig.str(tablename)) dt = DiskTable(tablename) file = dt.fsr.filename for row in dt: if file != dt.fsr.filename: file = dt.fsr.filename print(file)
def __init__(self, config_file=None, settings=None, index_mappings=None): ''' :param index_name: :param index_type: ''' if settings is None: self.dbcfg = DBConfig(config_file=config_file) else: self.dbcfg = DBConfig(config_dict=settings) self._settings = self.dbcfg.settings self._index_name = self._settings['index_name'] self._index_type = self._settings['index_type'] self._host = self._settings['host'] self._index_mappings = index_mappings self.es = get_database(self._settings)
def xml_to_db(): """insert into database from xml file""" myconfig=DBConfig() phish_list=test_xmlread() myconfig.connect_db() try: for phish in phish_list: myconfig.insert_db(phish) myconfig.count+=1 myconfig.close_db() print "The phish list have already inserted into database" except Exception as e: print e
def __init__(self, tablename): self.tablename = tablename self.datadic = DBConfig.getDataDic(tablename) self.fieldindex = DBConfig.getFieldIndex(tablename) self.files = DBConfig.getFiles(tablename) self.fsr = FileStreamReader(self.files)
def test_db(): """test the db operation.""" myconfig=DBConfig() myconfig.connect_db() values=['www.aaa.com','555','www.bbb.com'] myconfig.insert_db(values) print myconfig.select_db() myconfig.deldata_db() myconfig.close_db()
def test_createdb(): """create database""" myconfig=DBConfig() myconfig.create_db()