Testing needs to be updated for new table structures

[joshproehl]

Highways now has an opposite_highwayid, and stations table is now different.

This breaks all the tests, since the testing information is based on the old stuff. The testingdb.sql needs to be updated, and any broken tests as well.

[jessewagner]

No worries, I'll handle it, should hopefully be done by tonight :)

[jessewagner]

@joshproehl: Howdy! I am getting an error message when i run testingdb.sql, i've tried looking in the database with my limited db knowledge and can't find this variable/field anywhere:
CREATE SCHEMA
ERROR: column "segment_geom" does not exist
LINE 12: , (ST_AsGeoJson(ST_Transform(segment_geom, 4326))...
^
ERROR: column "segment_geom" does not exist
LINE 6: segment_geom IS NOT NULL ...
^
CREATE FUNCTION

any ideas? :)

[joshproehl]

The new stations table has a column named segment_geom in it, and no columns named segment_raw, segment_100k, etc... (Stations also are only live if they have an end_date column that IS NULL, which is new... So there may be multiple rows with the same stationid in the new table, watch out!)

Because of this you'll need to dump a new CREATE TABLE statement for the testingdb file, as well as all new data to be inserted into it. My suggestion on that would be to try and pull data with the same stationids as what is in the old testingdb file, which should give you mostly the same values to be inserted..)

[jessewagner]

Where do I actually dump this data from? Do I make it up or pull it from routelandia.its.pdx.edu or log in to capstoneaa.cs.pdx.edu and dump from that staging database? Sorry for the dumb questions :)