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 test_populatedb( ): temp_file = project0.fetchincidents(url) incidents = project0.extractincidents(temp_file) db = project0.createdb() project0.populatedb(db, incidents) database = sqlite3.connect(db) db = database.cursor() db.execute('select * from incidents;' ) result = db.fetchall() for i in result: assert len(i) == 5
def test_extract_num_of_pages(): data = project0.fetchincidents(url) incidents = project0.extractincidents(data) fp = tempfile.TemporaryFile() fp.write(data) fp.seek(0) pdf = PdfFileReader(fp) d = pdf.getNumPages() #print(d) # assert 0 assert d == 23
def test_populatedb(): data = project0.fetchincidents(url) incidents = project0.extractincidents(data) db = project0.createdb() project0.populatedb(db, incidents) con = sqlite3.connect("normanpd.db") cur = con.cursor() cur.execute( 'SELECT incident_location FROM incidents where nature="Traffic Stop";' ) row = cur.fetchall() assert row[0] == ('48TH AVE NE / E ROBINSON ST', )
def test_table_check(): project0.fetchincidents(url) incidents = project0.extractincidents() project0.createdb() project0.populatedb(incidents) conn = sqlite3.connect('normanpd.db') c = conn.cursor() c.execute( "SELECT arrestee_name FROM arrests WHERE arrestee_birthday = '2/18/1999';" ) f = c.fetchone() assert type(f[0]) == str assert f[0] == 'CHASE LESLIE'
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 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 test_populate_db(): text = project0.fetchincidents(url) incidents = project0.extractincidents(text) project0.createdb() conn = sqlite3.connect('normanpd.db') c = conn.cursor() No_of_obs = len(incidents) for i in range(0, No_of_obs - 1): c.execute("INSERT INTO arrests VALUES(?,?,?,?,?,?,?,?,?)", (incidents[i][0], incidents[i][1], incidents[i][2], incidents[i][3], incidents[i][4], incidents[i][5], incidents[i][6], incidents[i][7], incidents[i][8])) conn.commit() c.execute('SELECT COUNT(case_number)FROM arrests;') obs_populated = c.fetchone() obs_populated = obs_populated[0] assert obs_populated == 13
def test_populate(): df = project0.extractincidents([url3]) conn = project0.createdb() project0.populatedb(df, conn) cursor = conn.cursor() cursor.execute("SELECT * FROM arrests") result = cursor.fetchone() assert result is not None assert result[0] == '2/9/2019 14:43' assert result[1] == '2019-00011057' assert result[2] == '2110 24TH AVE NW' assert result[3] == 'POSSESSION OF CDS' assert result[4] == 'BRADLEY SCOTT BUCHANAN' assert result[5] == '2/18/1979' assert result[6] == '2524 AGNEW AVE OKLAHOMA CITY OK 73108' assert result[7] == 'FDBDC (Jail)' assert result[8] == '0945 - Slater;'
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])
def test_extract(): df = project0.extractincidents([url3]) assert df.size == 216
def test_extractincidents(): temp_file = project0.fetchincidents(url) result = project0.extractincidents(temp_file) for i in result: assert len(i) > 1
def test_count_observations(): text = project0.fetchincidents(url) observations = project0.extractincidents(text) assert len(observations) == 14
def test_extract_length(): data = project0.fetchincidents(url) incidents = project0.extractincidents(data) #extractincidents(data) assert len(incidents[0]) == 5
def test_extract_fields(): project0.fetchincidents(url) l = project0.extractincidents() assert len(l) == 15 assert len(l[0]) == 9