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()
