import src.Constants.ProjectPaths pp = src.Constants.ProjectPaths.ProjectPathsStore.DataSnapshots.value railwaysPath = pp + "\\railwaysSnapshot20190128.json" stationsPath = pp + "\\stationsSnapshot20190128.json" import src.JSONTool as jst railways = jst.JSONDeserialize(railwaysPath) stations = jst.JSONDeserialize(stationsPath) for r in railways: num = int(r['Number']) for s in stations: for location in s['WMSData']['LocationPoints']: print(s['Name'], location)
railwaysPath = pp + "\\railwaysSnapshot20190128.json" stationsPath = pp + "\\stationsSnapshot20190128.json" #^^^PATHS UP HERE^^^ import Reports.ReportMergedRailways as railwaysSource import Reports.ReportMergedStations as stationsSource railways = railwaysSource.returnMergedRailways() stations = stationsSource.returnMergedStations() import src.Constants.ProjectPaths pp = src.Constants.ProjectPaths.ProjectPathsStore.DataSnapshots.value import src.JSONTool as jst jst.JSONSerialize(stations, stationsPath) jst.JSONSerialize(railways, railwaysPath)
import Reports.Datasets.Railways_Dataset as Source_Railways import Reports.Datasets.RailwayUnits_Dataset as Source_RailwayUnits import Reports.Datasets.Stations_Dataset as Source_Stations Railways_Geometries = Source_Railways.ReturnGeometriesPartialDataset() RailwayUnits_Geometries = Source_RailwayUnits.ReturnGeometriesPartialDataset() Stations_Geometries = Source_Stations.ReturnGeometriesPartialDataset() for r in Railways_Geometries: r['Value'] = 'LINESTRING(' + r['Value'] + ')' for u in RailwayUnits_Geometries: u['Value'] = 'MULTIPOLYGON(((' + u['Value'] + ')))' for s in Stations_Geometries: s['Value'] = 'POINT(' + s['Value'] + ')' Geometries_Dataset = RailwayUnits_Geometries + Railways_Geometries + Stations_Geometries for row in Geometries_Dataset: row['Value'] = row['Value'].replace(',', '#') row['Value'] = row['Value'].replace(' ', ',') row['Value'] = row['Value'].replace('#', ' ') import src.JSONTool as jst path = 'C:\\Users\\Dell\\source\\repos\\MalopolskaRailNetwork\\MalopolskaRailNetwork\\Data\\DataSnapshots\\FinalDatasets\\Geometries_Dataset.json' jst.JSONSerialize(Geometries_Dataset, path) print("serialising done - geometries")
TypesOfAPoint_Dataset = [] index = 1 for t in Hashset: SingleType = dict() SingleType['Id'] = index SingleType['AbbreviatedName'] = t TypesOfAPoint_Dataset.append(SingleType) index += 1 def ReturnTypesOfAPointDataset(): return TypesOfAPoint_Dataset def ReturnHashtableNamesToIds(): Hashtable = dict() for t in TypesOfAPoint_Dataset: Hashtable[t['AbbreviatedName']] = t['Id'] return Hashtable import src.JSONTool as jst path = 'C:\\Users\\Dell\\source\\repos\\MalopolskaRailNetwork\\MalopolskaRailNetwork\\Data\\DataSnapshots\\FinalDatasets\\TypesOfAPoint_Dataset.json' jst.JSONSerialize(TypesOfAPoint_Dataset, path) print("serialising done - types of a point")
import DataReaders.wwwReaders.wwwReader as SourceOfRollingStock RawRollingStock = SourceOfRollingStock.returnRollingStockList() RollingStock_Dataset = [] for r in RawRollingStock: car = dict() car['Id'] = r['Id'] car['OwnerId'] = r['OwnerId'] car['Name'] = r['Name'] RollingStock_Dataset.append(car) def ReturnRollingStockDataset(): return RollingStock_Dataset import src.JSONTool as jst path = 'C:\\Users\\Dell\\source\\repos\\MalopolskaRailNetwork\\MalopolskaRailNetwork\\Data\\DataSnapshots\\FinalDatasets\\RollingStock_Dataset.json' jst.JSONSerialize(RollingStock_Dataset, path) print("serialising done")
import DataReaders.wwwReaders.wwwReader as SourceOwners OwnersRaw = SourceOwners.ownersDBList Owners_Dataset = [] for o in OwnersRaw: owner = dict() owner['Id'] = o['Id'] owner['Name'] = o['Name'] Owners_Dataset.append(owner) def ReturnOwnersDataset(): return Owners_Dataset import src.JSONTool as jst path = 'C:\\Users\\Dell\\source\\repos\\MalopolskaRailNetwork\\MalopolskaRailNetwork\\Data\\DataSnapshots\\FinalDatasets\\Owners_Dataset.json' jst.JSONSerialize(Owners_Dataset, path) print("serialising done")
def GetStationsSnapshot_List(): stations = jst.JSONDeserialize(stationsPath) return stations
import DataReaders.wwwReaders.wwwReader as SourceOfPhotosToObjects PhotosToObjectsRaw = SourceOfPhotosToObjects.returnPhotosToObjectsList() PhotosToObjects_Dataset = [] for pto in PhotosToObjectsRaw: photoToObject = dict() photoToObject['Id'] = pto['Id'] photoToObject['PhotoId'] = pto['PhotoId'] photoToObject['ObjectId'] = pto['ObjectId'] PhotosToObjects_Dataset.append(photoToObject) def ReturnPhotosToObjectsDataset(): return PhotosToObjects_Dataset import src.JSONTool as jst path = 'C:\\Users\\Dell\\source\\repos\\MalopolskaRailNetwork\\MalopolskaRailNetwork\\Data\\DataSnapshots\\FinalDatasets\\PhotosToObjects_Dataset.json' jst.JSONSerialize(PhotosToObjects_Dataset, path) print("serialising done - photos to objects")
def GetRailwaysSnapshot_List(): railways = jst.JSONDeserialize(railwaysPath) return railways
new['GeometryId'] = None else: new['GeometryId'] = index geometry = dict() geometry['Id'] = index geometry['Value'] = r['Geometry'] index += 1 Railways_Dataset.append(new) if (geometry is not None): Geometries_Partial_Dataset.append(geometry) geometry = None ProcessDatasets() def ReturnRailwaysDataset(): return Railways_Dataset def ReturnGeometriesPartialDataset(): return Geometries_Partial_Dataset import src.JSONTool as jst path = 'C:\\Users\\Dell\\source\\repos\\MalopolskaRailNetwork\\MalopolskaRailNetwork\\Data\\DataSnapshots\\FinalDatasets\\Railways_Dataset.json' jst.JSONSerialize(Railways_Dataset, path) print("serialising done")
import DataReaders.wwwReaders.wwwReader as SourceOfPhotos PhotosRaw = SourceOfPhotos.returnPhotosList() Photos_Dataset = [] for p in PhotosRaw: photo = dict() photo['Id'] = p['Id'] photo['AdditionDateTime'] = p['AdditionDateTime'] photo['FilePath'] = p['FilePath'] photo['Description'] = p['Description'] Photos_Dataset.append(photo) def ReturnPhotosDataset(): return Photos_Dataset import src.JSONTool as jst path = 'C:\\Users\\Dell\\source\\repos\\MalopolskaRailNetwork\\MalopolskaRailNetwork\\Data\\DataSnapshots\\FinalDatasets\\Photos_Dataset.json' jst.JSONSerialize(Photos_Dataset, path) print("serialising done - photos")
rel['RailwayId'] = int(r['LineId']) rel['GeometriesId'] = None Relationships_Dataset.append(rel) index_relationships += 1 print('done so far') #TODO #process each station and create full relations list def ReturnGeometriesPartialDataset(): return Geometries_Dataset def ReturnStationsDataset(): return Stations_Dataset import src.JSONTool as jst path = 'C:\\Users\\Dell\\source\\repos\\MalopolskaRailNetwork\\MalopolskaRailNetwork\\Data\\DataSnapshots\\FinalDatasets\\Stations_Dataset.json' jst.JSONSerialize(Stations_Dataset, path) path_relations = 'C:\\Users\\Dell\\source\\repos\\MalopolskaRailNetwork\\MalopolskaRailNetwork\\Data\\DataSnapshots\\FinalDatasets\\StationsToGeometries_Dataset.json' jst.JSONSerialize(Relationships_Dataset, path_relations) print("serialising done - stations")
for u in Units_Raw: unit = dict() unit['Id'] = index unit['Name'] = u['ZAKLAD'] unit['GeometriesId'] = index Units_Dataset.append(unit) geometry = dict() geometry['Id'] = index geometry['Value'] = u['GEOM'] Geometries_Partial_Dataset.append(geometry) index += 1 def ReturnUnitsDataset(): return Units_Dataset def ReturnGeometriesPartialDataset(): return Geometries_Partial_Dataset import src.JSONTool as jst path = 'C:\\Users\\Dell\\source\\repos\\MalopolskaRailNetwork\\MalopolskaRailNetwork\\Data\\DataSnapshots\\FinalDatasets\\RailwayUnits_Dataset.json' jst.JSONSerialize(Units_Dataset, path) print("serialising done")