def main(url): # Download data data_raw = project0.fetchincidents(url) # Extract Data incidents = project0.extractincidents(data_raw) # Create Dataase project0.createdb() # Insert Data project0.populatedb(incidents) # Print Status project0.status()
def main(url): # Download data incident_data = project0.fetchincidents(url) # Extract Data incidents = project0.extractincidents(incident_data) # Create Database db = project0.createdb() # Insert Data project0.populatedb(db, incidents) # Print Status project0.status(db)
def test_final_status(): project0.fetchincidents(url) incidents = project0.extractincidents() project0.createdb() project0.populatedb(incidents) s = project0.status() assert type(s) == str
def test_status( ): temp_file = project0.fetchincidents(url) incidents = project0.extractincidents(temp_file) db = project0.createdb() project0.populatedb(db, incidents) result = project0.status(db) for i in result: assert len(i) > 0
def test_random_title(): df = project0.extractincidents([url3]) conn = project0.createdb() project0.populatedb(df, conn) randomrecord = project0.status(conn) assert randomrecord is not None assert len(randomrecord) == 9 assert type(randomrecord[0]) == str
def test_status(): data = project0.fetchincidents(url) incidents = project0.extractincidents(data) db = project0.createdb() project0.populatedb(db, incidents) s = project0.status(db) with open("test.txt", "w") as file: d = file.write(str(s)) # print (d) assert type(d) == int
def main(url): # Download data data = project0.fetch_incidents(url) # Extract Data incidents = project0.extract_incidents(data) # Create Dataset project0.create_db() # Insert Data project0.populate_db(incidents) # Print Status status = project0.status() print(status)
def test_status(): try: data = project0.fetch_incidents( 'http://normanpd.normanok.gov/' 'filebrowser_download/657/2020-03-01%20Daily%' '20Incident%20Summary.pdf') incidents = project0.extract_incidents(data) project0.create_db() project0.populate_db(incidents) status = project0.status() march1 = open("march1.txt", "r").read() assert status == march1 print("passed test status") except AssertionError: print("failed test status")
def main(url): # Download data print("Here are the Arrest record URLs fetched from the Norman PD:\n") print(project0.fetchincidents(url)) print("\n") # Extract Data df = project0.extractincidents(project0.fetchincidents(url)) print( "\nHere are the first 5 records in the database stored from the Norman PD's arrest records:\n" ) print(df.head()) print("\n") # Create Dataase conn = project0.createdb() # Insert Data project0.populatedb(df, conn) # Print Status randomrecord = project0.status(conn) print(randomrecord[0]) type(randomrecord[0])