Test_Log.md

Extraction Test

Removing existing CSV file exists
Confirming that CSV file doesn't exists...
Test Successful
Extracting data and saving...
Testing if CSV file exists...
Extraction Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Reading All Column Test

Executing query...

SELECT name FROM pragma_table_info('air_quality')

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Reading All Column Test

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Reading All Column Test

Getting columns for air_quality
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Reading All Column Test

Getting columns for air_quality
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Reading All Column Test

Getting columns for air_quality
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Reading All Column Test

Getting columns for air_quality
Asserting the air_quality table has six (6) columns
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Reading All Column Test

Getting columns for air_quality
Asserting the air_quality table has six (6) columns
Assert Successful
Reading All Column Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Reading All Column Test

Getting columns for air_quality
Asserting the air_quality table has six (6) columns
Assert Successful
Reading All Column Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Reading All Column Test

Getting columns for air_quality
Asserting the air_quality table has six (6) columns
Assert Successful
Reading All Column Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Reading All Column Test

Getting columns for air_quality
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Reading All Column Test

Getting columns for air_quality
Asserting the air_quality table has six (6) columns
Assert Successful
Reading All Column Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

Reading All Column Test

Getting columns for air_quality
Asserting the air_quality table has six (6) columns
Assert Successful
Reading All Column Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

Reading All Column Test

Getting columns for air_quality
Asserting the air_quality table has six (6) columns
Assert Successful
Reading All Column Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

Reading All Column Test

Getting columns for air_quality
Asserting the air_quality table has six (6) columns
Assert Successful
Reading All Column Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

Reading All Column Test

Getting columns for air_quality
Asserting the air_quality table has six (6) columns
Assert Successful
Reading All Column Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

Reading All Column Test

Getting columns for air_quality
Asserting the air_quality table has six (6) columns
Assert Successful
Reading All Column Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Reading All Column Test

Getting columns for air_quality
Asserting the air_quality table has six (6) columns
Assert Successful
Reading All Column Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
Executing query...

INSERT INTO geo_data (geo_id, geo_place_name, geo_type_name) VALUES ('100000', 'Lancaster', 'UFO')

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Asserting there's now a record in geo_data with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Asserting there's now a record in geo_data with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Asserting there's now a record in geo_data with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Asserting there's now a record in geo_data with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Asserting there's now a record in geo_data with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Asserting there's now a record in geo_data with ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Asserting there's now a record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Record Saving Test Successful

Reading All Column Test

Getting columns for air_quality
Asserting the air_quality table has six (6) columns
Assert Successful
Reading All Column Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Adding new record [(100000, 'Lancaster', 'UFO')]
Asserting there's now a record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Record Saving Test Successful

Record Deletion Test

Asserting there's a record in geo_data for row ID 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Adding new record [(100000, 'Lancaster', 'UFO')]
Asserting there's now a record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Record Saving Test Successful

Record Deletion Test

Asserting there's a record in geo_data for row ID 100000
Getting columns for geo_data
Assert Successful
Deleting record with ID 100000
Getting columns for geo_data
Executing query...

delete from geo_data where geo_id = 100000

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Adding new record [(100000, 'Lancaster', 'UFO')]
Asserting there's now a record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Record Saving Test Successful

Record Deletion Test

Asserting there's a record in geo_data for row ID 100000
Getting columns for geo_data
Assert Successful
Deleting record with ID 100000
Filtering out record with id 100000
Getting columns for geo_data
### Transform and Load Test ### Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

One Record Reading Test

Getting columns for air_quality
Asserting that row[0][data_value] == 16.4
Assert Successful
One Record Reading Test Successful

All Records Reading Test

Executing query...

select * from air_quality

Asserting that len(rows) == 18016
All Records Reading Test Successful

Record Saving Test

Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Saving new record with ID 100000
Adding new record [(100000, 'Lancaster', 'UFO')]
Asserting there's now a record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Record Saving Test Successful

Record Deletion Test

Asserting there's a record in geo_data for row ID 100000
Getting columns for geo_data
Assert Successful
Deleting record with ID 100000
Filtering out record with id 100000
Getting columns for geo_data
Asserting there's no record in geo_data with ID 100000
Getting columns for geo_data
Assert Successful
Record Deletion Test Successful

Reading All Column Test

Getting columns for air_quality
Asserting the air_quality table has six (6) columns
Assert Successful
Reading All Column Test Successful

Executing custom query...

Select air_quality.*, indicator.* from air_quality inner join indicator on air_quality.fn_indicator_id = indicator.indicator_id

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

Select air_quality.*, indicator.* from air_quality inner join indicator on air_quality.fn_indicator_id = indicator.indicator_id

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

Select air_quality.*, indicator.* from air_quality inner join indicator on air_quality.fn_indicator_id = indicator.indicator_id

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

Select air_quality.*, indicator.* from air_quality inner join indicator on air_quality.fn_indicator_id = indicator.indicator_id group by indicator_name, time_period, mean(data_value)

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

SELECT 
    air_quality.*, 
    indicator.*, 
    indicator_name, 
    time_period, 
    AVG(data_value) AS avg_data_value
FROM 
    air_quality
INNER JOIN 
    indicator 
ON 
    air_quality.fn_indicator_id = indicator.indicator_id
GROUP BY 
    indicator_name, time_period

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

SELECT 
    air_quality.*, 
    indicator.*, 
    indicator_name, 
    time_period, 
    AVG(data_value) AS avg_data_value
FROM 
    air_quality
INNER JOIN 
    indicator 
ON 
    air_quality.fn_indicator_id = indicator.indicator_id
GROUP BY 
    air_quality_id, indicator_name, time_period

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

SELECT 
    air_quality.*, 
    indicator.*, 
    indicator_name, 
    time_period, 
    AVG(data_value) AS avg_data_value
FROM 
    air_quality
INNER JOIN 
    indicator 
ON 
    air_quality.fn_indicator_id = indicator.indicator_id
GROUP BY 
    air_quality_id,fn_indicator_id, indicator_name, time_period

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

SELECT 

    indicator.indicator_name, 
    air_quality.time_period, 
    AVG(data_value) AS avg_data_value
FROM 
    air_quality
INNER JOIN 
    indicator 
ON 
    air_quality.fn_indicator_id = indicator.indicator_id
GROUP BY 
    indicator_name, time_period

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

SELECT 
    indicator.indicator_name, 
    air_quality.time_period, 
    AVG(data_value) AS avg_data_value
FROM 
    air_quality
INNER JOIN 
    indicator 
ON 
    air_quality.fn_indicator_id = indicator.indicator_id
GROUP BY 
    indicator_name, time_period

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

SELECT 
    indicator.indicator_name, 
    air_quality.time_period, 
    AVG(data_value) AS avg_data_value
FROM 
    air_quality
INNER JOIN 
    indicator 
ON 
    air_quality.fn_indicator_id = indicator.indicator_id
GROUP BY 
    indicator_name, time_period
ORDER BY 
    indicator_name, time_period

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

SELECT 
    indicator.indicator_name, 
    air_quality.time_period, 
    AVG(data_value) AS avg_data_value
FROM 
    air_quality
INNER JOIN 
    indicator 
ON 
    air_quality.fn_indicator_id = indicator.indicator_id
GROUP BY 
    indicator_name, time_period
ORDER BY 
    indicator_name, time_period

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

SELECT 
    indicator.indicator_name, 
    air_quality.time_period, 
    AVG(data_value) AS avg_data_value
FROM 
    air_quality
INNER JOIN 
    indicator 
ON 
    air_quality.fn_indicator_id = indicator.indicator_id
GROUP BY 
    indicator_name, time_period
ORDER BY 
    indicator_name, time_period

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

SELECT 
    indicator.indicator_name, 
    air_quality.time_period, 
    AVG(data_value) AS avg_data_value
FROM 
    air_quality
INNER JOIN 
    indicator 
ON 
    air_quality.fn_indicator_id = indicator.indicator_id
GROUP BY 
    indicator_name, time_period
ORDER BY 
    indicator_name, time_period

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

SELECT 
    indicator.indicator_name, 
    air_quality.time_period, 
    AVG(data_value) AS avg_data_value
FROM 
    air_quality
INNER JOIN 
    indicator 
ON 
    air_quality.fn_indicator_id = indicator.indicator_id
GROUP BY 
    indicator_name, time_period
ORDER BY 
    indicator_name, time_period

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

SELECT 
    indicator.indicator_name, 
    air_quality.time_period, 
    AVG(data_value) AS avg_data_value
FROM 
    air_quality
INNER JOIN 
    indicator 
ON 
    air_quality.fn_indicator_id = indicator.indicator_id
GROUP BY 
    indicator_name, time_period
ORDER BY 
    indicator_name, time_period

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

SELECT 
    indicator.indicator_name, 
    air_quality.time_period, 
    AVG(data_value) AS avg_data_value
FROM 
    air_quality
INNER JOIN 
    indicator 
ON 
    air_quality.fn_indicator_id = indicator.indicator_id
GROUP BY 
    indicator_name, time_period
ORDER BY 
    indicator_name, time_period

Transform and Load Test

Creating non-lookup table: air_quality
Creating lookup table: indicator
Creating lookup table: geo_data
Tables created.
Skipping the first row...
Inserting table data...
Inserting table data completed
Transform and Load Test Successful

Executing custom query...

SELECT 
    indicator.indicator_name, 
    air_quality.time_period, 
    AVG(data_value) AS avg_data_value
FROM 
    air_quality
INNER JOIN 
    indicator 
ON 
    air_quality.fn_indicator_id = indicator.indicator_id
GROUP BY 
    indicator_name, time_period
ORDER BY 
    indicator_name, time_period