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"