ODOT-PTS / TNExT

a web-based software tool developed for the visualization, analysis, and reporting of regional and statewide transit networks in the state of Oregon
15 stars 4 forks source link

modifiers/dbupdate/readDBinfo gives xml content-type, but returns csv data. #53

Closed ed-g closed 7 years ago

ed-g commented 7 years ago

http://tna.trilliumtransit.com:8080/TNAtoolAPI-Webapp/modifiers/dbupdate/readDBinfo

ed-g commented 7 years ago
$ curl -v http://tna.trilliumtransit.com:8080/TNAtoolAPI-Webapp/modifiers/dbupdate/readDBinfo
*   Trying 173.255.247.210...
* Connected to tna.trilliumtransit.com (173.255.247.210) port 8080 (#0)
> GET /TNAtoolAPI-Webapp/modifiers/dbupdate/readDBinfo HTTP/1.1
> Host: tna.trilliumtransit.com:8080
> User-Agent: curl/7.47.0
> Accept: */*
> 
< HTTP/1.1 200 OK
< Server: Apache-Coyote/1.1
< Content-Type: application/json
< Transfer-Encoding: chunked
< Date: Mon, 11 Sep 2017 23:35:17 GMT
< 
* Connection #0 to host tna.trilliumtransit.com left intact
databaseIndex,dbnames,spatialConfigPaths,ConfigPaths,connectionURL,username,password,censusMappingSource,gtfsMappingSource1,gtfsMappingSource2#$#0,Summer 2016,com/model/database/connections/spatial/summer16.cfg.xml,com/model/database/connections/transit/summer16.cfg.xml,jdbc:postgresql://localhost:5432/summer16,postgres,postgres%OSU237ie,com/model/database/connections/spatial/mapping/mapping.hbm.xml,com/model/database/connections/transit/mapping/GtfsMapping.hibernate.xml,com/model/database/connections/transit/mapping/HibernateGtfsRelationalDaoImpl.hibernate.xml#$#1,17-Mar,com/model/database/connections/spatial/march17.cfg.xml,com/model/database/connections/transit/march17.cfg.xml,jdbc:postgresql://localhost:5432/march17,postgres,postgres%OSU237ie,com/model/database/connections/spatial/mapping/mapping.hbm.xml,com/model/database/connections/transit/mapping/GtfsMapping.hibernate.xml,com/model/database/connections/transit/mapping/HibernateGtfsRelationalDaoImpl.hibernate.xmled@drevil:~/src/TNAST_MAVEN/TNAtoolAPI-Webapp

Note there also do not appear to be newlines between csv lines. No idea if this is a DOS<->Unix translation bug or it might be OK.

ed-g commented 7 years ago

OSU server also gives no newlines between csv file lines so this might be OK.

$ curl -v http://tnasoftwaretool.engr.oregonstate.edu:8080/TNAtoolAPI-Webapp/modifiers/dbupdate/readDBinfo
databaseIndex,dbnames,spatialConfigPaths,ConfigPaths,connectionURL,username,password,censusMappingSource,gtfsMappingSource1,gtfsMappingSource2#$#0,Fall 2015,com/model/database/connections/spatial/fall15.cfg.xml,com/model/database/connections/transit/fall15.cfg.xml,jdbc:postgresql://tnasoftwaretool.engr.oregonstate.edu:5432/fall15,postgres,postgres%OSU237ie,com/model/database/connections/spatial/mapping/mapping.hbm.xml,com/model/database/connections/transit/mapping/GtfsMapping.hibernate.xml,com/model/database/connections/transit/mapping/HibernateGtfsRelationalDaoImpl.hibernate.xml#$#1,Winter 2016,com/model/database/connections/spatial/winter16.cfg.xml,com/model/database/connections/transit/winter16.cfg.xml,jdbc:postgresql://tnasoftwaretool.engr.oregonstate.edu:5432/winter16,postgres,postgres%OSU237ie,com/model/database/connections/spatial/mapping/mapping.hbm.xml,com/model/database/connections/transit/mapping/GtfsMapping.hibernate.xml,com/model/database/connections/transit/mapping/HibernateGtfsRelationalDaoImpl.hibernate.xml#$#2,Spring 2016,com/model/database/connections/spatial/spring16.cfg.xml,com/model/database/connections/transit/spring16.cfg.xml,jdbc:postgresql://tnasoftwaretool.engr.oregonstate.edu:5432/spring16,postgres,postgres%OSU237ie,com/model/database/connections/spatial/mapping/mapping.hbm.xml,com/model/database/connections/transit/mapping/GtfsMapping.hibernate.xml,com/model/database/connections/transit/mapping/HibernateGtfsRelationalDaoImpl.hibernate.xml#$#3,Summer 2016,com/model/database/connections/spatial/summer16.cfg.xml,com/model/database/connections/transit/summer16.cfg.xml,jdbc:postgresql://tnasoftwaretool.engr.oregonstate.edu:5432/summer16,postgres,postgres%OSU237ie,com/model/database/connections/spatial/mapping/mapping.hbm.xml,com/model/database/connections/transit/mapping/GtfsMapping.hibernate.xml,com/model/database/connections/transit/mapping/HibernateGtfsRelationalDaoImpl.hibernate.xml#$#4,Fall 2016,com/model/database/connections/spatial/fall16.cfg.xml,com/model/database/connections/transit/fall16.cfg.xml,jdbc:postgresql://tnasoftwaretool.engr.oregonstate.edu:5432/fall16,postgres,postgres%OSU237ie,com/model/database/connections/spatial/mapping/mapping.hbm.xml,com/model/database/connections/transit/mapping/GtfsMapping.hibernate.xml,com/model/database/connections/transit/mapping/HibernateGtfsRelationalDaoImpl.hibernate.xml#$#5,Winter 2017,com/model/database/connections/spatial/winter17.cfg.xml,com/model/database/connections/transit/winter17.cfg.xml,jdbc:postgresql://tnasoftwaretool.engr.oregonstate.edu:5432/winter17,postgres,postgres%OSU237ie,com/model/database/connections/spatial/mapping/mapping.hbm.xml,com/model/database/connections/transit/mapping/GtfsMapping.hibernate.xml,com/model/database/connections/transit/mapping/HibernateGtfsRelationalDaoImpl.hibernate.xml#$#6,March 2017,com/model/database/connections/spatial/march17.cfg.xml,com/model/database/connections/transit/march17.cfg.xml,jdbc:postgresql://tnasoftwaretool.engr.oregonstate.edu:5432/march17,postgres,postgres%OSU237ie,com/model/database/connections/spatial/mapping/mapping.hbm.xml,com/model/database/connections/transit/mapping/GtfsMapping.hibernate.xml,com/model/database/connections/transit/mapping/HibernateGtfsRelationalDaoImpl.hibernate.xml#$#7,April 2017,com/model/database/connections/spatial/april17.cfg.xml,com/model/database/connections/transit/april17.cfg.xml,jdbc:postgresql://tnasoftwaretool.engr.oregonstate.edu:5432/april17,postgres,postgres%OSU237ie,com/model/database/connections/spatial/mapping/mapping.hbm.xml,com/model/database/connections/transit/mapping/GtfsMapping.hibernate.xml,com/model/database/connections/transit/mapping/HibernateGtfsRelationalDaoImpl.hibernate.xml#$#8,May 2017,com/model/database/connections/spatial/may17.cfg.xml,com/model/database/connections/transit/may17.cfg.xml,jdbc:postgresql://tnasoftwaretool.engr.oregonstate.edu:5432/may17,postgres,postgres%OSU237ie,com/model/database/connections/spatial/mapping/mapping.hbm.xml,com/model/database/connections/transit/mapping/GtfsMapping.hibernate.xml,com/model/database/connections/transit/mapping/HibernateGtfsRelationalDaoImpl.hibernate.xml
ed-g commented 7 years ago

Ah, the #$# appears to be a record separator.

ed-g commented 7 years ago

This is strange but likely not a bug. Closing.