def test_handler_add_addresses_from_file_inserts_one_record(self, mock_init_db): handler = DatabaseHandler('unit_test_db.sqlite3') with open('test_file.csv', 'w') as f: f.write('latitude,longitude\n') f.write('8,12\n') handler.add_addresses_from_file('test_file.csv') c = handler.conn.cursor() c.execute("SELECT latitude, longitude FROM addresses") row = c.fetchone() self.assertEqual((8, 12), row)
def test_handler_add_addresses_from_file_inserts_one_record( self, mock_init_db): handler = DatabaseHandler('unit_test_db.sqlite3') with open('test_file.csv', 'w') as f: f.write('latitude,longitude\n') f.write('8,12\n') handler.add_addresses_from_file('test_file.csv') c = handler.conn.cursor() c.execute("SELECT latitude, longitude FROM addresses") row = c.fetchone() self.assertEqual((8, 12), row)