Testing needs to be updated for new table structures
Created by: 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.
Imported comments:
By jessewagner on 2015-03-14 21:26:31 UTC
No worries, I'll handle it, should hopefully be done by tonight :)
By jessewagner on 2015-03-14 21:54:18 UTC
@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? :)
By joshproehl on 2015-03-16 21:53:30 UTC
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..)
By jessewagner on 2015-03-17 03:35:27 UTC
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 :)