def __init__(self):
self.conn = dbo.db_connect()
self.reg_shp = r'((?i)[a-z]{1,5}_pls_\d{2,3}(?:_Project)?.shp$)'
self.reg_txt = r'((?i)[a-z]{1,5}_total.txt)'
self.main_dir = "./data/claims"
self.completed_files = [
'AK_pls_07',
'AK_total',
'/AZ_pls_10',
'AZ_TOTAL',
'AR_TOTAL',
'CA_pls_10',
'CA_TOTAL',
'CO_pls_10',
'CO_TOTAL',
'FL_pls_10',
'FL_TOTAL',
'ID_pls_10',
'ID_TOTAL',
'MT_pls_10',
'MT_TOTAL',
'NE_pls_10',
'NE_TOTAL',
'NV_pls_10',
]
import src.database_operations as dbo
conn = dbo.db_connect()
f = open('data/mines.txt', encoding='latin-1')
lines = f.readlines()
data = [tuple(line.strip().split('\t')) for line in lines]
# for x in data:
# if len(x[2])>200:
# print (len(x[2]), x[2])
try:
query = "INSERT INTO public.mines VALUES (%s, %s, %s, %s, %s, %s, %s)"
dbo.execute_query(conn, query, data[1:], multiple=True)
except Exception as e:
print(e)
conn.close()
def __init__(self):
self.conn = dbo.db_connect()
def __init__(self):
self.conn = dbo.db_connect()
# self.reg_shp = r'(.shp$)'
self.shapefile = "./data/faults/sectionsALL.shp"