public int LoadFromCsv(string path)
{
var result = _session.Execute("select * from detector_for_stations limit 1;");
if (result.Any())
{
return(0);
}
//detectorid,highwayid,milepost,locationtext,detectorclass,lanenumber,stationid
var loader = new CsvLoader(_session, path, @"insert into detector_for_stations (stationid, lanenumber, locationtext, detectorid) values ({0},{1},'{2}',{3})");
return(loader.Load());
}
public int LoadFromCsv(string path)
{
var result = _session.Execute("select * from highways limit 1;");
if (result.Any())
{
return(0);
}
var loader = new CsvLoader(_session, path, "insert into highways (highwayid, shortdirection, direction, highwayname) values ({0},'{1}','{2}','{3}')");
return(loader.Load());
}
public int LoadFromCsv(string path)
{
var result = _session.Execute("select * from loopdata_by_detectorid limit 1;");
if (result.Any())
{
return(0);
}
//detectorid,starttime,volume,speed,occupancy,status,dqflags
var loader = new CsvLoader(_session, path, @"insert into loopdata_by_detectorid (detectorid, starttime, volume, speed, occupancy, status, dqflags) values ({0},'{1}',{2},{3},{4},{5},{6})");
return(loader.Load());
}
public int LoadFromCsv(string path)
{
var result = _session.Execute("select * from stations_northbound limit 1;");
if (result.Any())
{
return(0);
}
//create table stations_northbound (stationid int primary key, milepost float, locationtext text, upstream int, downstream int, numberlanes int, latlon text, length float);
var loader = new CsvLoader(_session, path, @"insert into stations_northbound (stationid, milepost, locationtext, upstream, downstream, numberlanes, latlon, length)
values ({0},{1},'{2}',{3},{4},{5},'{6}',{7})");
return(loader.Load());
}