Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var express = require('express');
- var cassandra = require('cassandra-driver');
- var path = require('path');
- var async = require('async');
- var app = express();
- //Connect to the cluster
- var cassandraClient = new cassandra.Client({contactPoints: ['localhost'], keyspace: 'demo'});
- var port = 8080;
- var router = express.Router();
- var stateDictionary = {
- "AL":"alabama",
- "AK":"alaska",
- "AS":"americanSamoa",
- "AZ":"arizona",
- "AR":"arkansas",
- "CA":"california",
- "CO":"colorado",
- "CT":"connecticut",
- "DE":"delaware",
- "DC":"districtOfColumbia",
- "FM":"federatedStatesOfMicronesia",
- "FL":"florida",
- "GA":"georgia",
- "GU":"guam",
- "HI":"hawaii",
- "ID":"idaho",
- "IL":"illinois",
- "IN":"indiana",
- "IA":"iowa",
- "KS":"kansas",
- "KY":"kentucky",
- "LA":"louisiana",
- "ME":"maine",
- "MH":"marshallIslands",
- "MD":"maryland",
- "MA":"massachusetts",
- "MI":"michigan",
- "MN":"minnesota",
- "MS":"mississippi",
- "MO":"missouri",
- "MT":"montana",
- "NE":"nebraska",
- "NV":"nevada",
- "NH":"newHampshire",
- "NJ":"newJersey",
- "NM":"newMexico",
- "NY":"newYork",
- "NC":"northCarolina",
- "ND":"northDakota",
- "MP":"northernMarianaIslands",
- "OH":"ohio",
- "OK":"oklahoma",
- "OR":"oregon",
- "PW":"palau",
- "PA":"pennsylvania",
- "PR":"puertoRico",
- "RI":"rhodeIsland",
- "SC":"southCarolina",
- "SD":"southDakota",
- "TN":"tennessee",
- "TX":"texas",
- "UT": "utah",
- "VT": "vermont",
- "VI": "virginIslands",
- "VA": "virginia",
- "WA": "washington",
- "WV": "westVirginia",
- "WI": "wisconsin",
- "WY": "wyoming"
- };
- function getNewInfoFormat(OldStateInfoFormat)
- {
- var citymap = {
- alabama: {
- center: {lat: 32.806671, lng: -86.791130},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- alaska: {
- center: {lat: 61.370716, lng: -152.404419},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- arizona: {
- center: {lat: 33.729759, lng: -111.431221},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- arkansas: {
- center: {lat: 34.969704, lng: -92.373123},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- california: {
- center: {lat: 36.116203, lng: -119.681564},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- colorado: {
- center: {lat: 39.059811, lng: -105.311104},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- connecticut: {
- center: {lat: 41.597782, lng: -72.755371},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- delaware: {
- center: {lat: 39.318523, lng: -75.507141},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- districtOfColumbia: {
- center: {lat: 38.897438, lng: -77.026817},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- florida: {
- center: {lat: 27.766279, lng: -81.686783},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- georgia: {
- center: {lat: 33.040619, lng: -83.643074},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- hawaii: {
- center: {lat: 21.094318, lng: -157.498337},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- idaho: {
- center: {lat: 44.240459, lng: -114.478828},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- illinois: {
- center: {lat: 40.349457, lng: -88.986137},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- indiana: {
- center: {lat: 39.849426, lng: -86.258278},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- iowa: {
- center: {lat: 42.011539, lng: -93.210526},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- kansas: {
- center: {lat: 38.526600, lng: -96.726486},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- kentucky: {
- center: {lat: 37.668140, lng: -84.670067},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- louisiana: {
- center: {lat: 31.169546, lng: -91.867805},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- maine: {
- center: {lat: 44.693947, lng: -69.381927},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- maryland: {
- center: {lat: 39.063946, lng: -76.802101},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- massachusetts: {
- center: {lat: 42.230171, lng: -71.530106},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- michigan: {
- center: {lat: 43.326618, lng: -84.536095},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- minnesota: {
- center: {lat: 45.694454, lng: -93.900192},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- mississippi: {
- center: {lat: 32.741646, lng: -89.678696},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- missouri: {
- center: {lat: 38.456085, lng: -92.288368},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- montana: {
- center: {lat: 46.921925, lng: -110.454353},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- nebraska: {
- center: {lat: 41.125370, lng: -98.268082},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- nevada: {
- center: {lat: 38.313515, lng: -117.055374},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- newHampshire: {
- center: {lat: 43.452492, lng: -71.563896},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- newJersey: {
- center: {lat: 40.298904, lng: -74.521011},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- newMexico: {
- center: {lat: 34.840515, lng: -106.248482},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- newYork: {
- center: {lat: 42.165726, lng: -74.948051},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- northCarolina: {
- center: {lat: 35.630066, lng: -79.806419},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- northDakota: {
- center: {lat: 47.528912, lng: -99.784012},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- ohio: {
- center: {lat: 40.388783, lng: -82.764915},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- oklahoma: {
- center: {lat: 35.565342, lng: -96.928917},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- oregon: {
- center: {lat: 44.572021, lng: -122.070938},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- pennsylvania: {
- center: {lat: 40.590752, lng: -77.209755},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- rhodeIsland: {
- center: {lat: 41.680893, lng: -71.511780},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- southCarolina: {
- center: {lat: 33.856892, lng: -80.945007},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- southDakota: {
- center: {lat: 44.299782, lng: -99.438828},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- tennessee: {
- center: {lat: 35.747845, lng: -86.692345},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- texas: {
- center: {lat: 31.054487, lng: -97.563461},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- utah: {
- center: {lat: 40.150032, lng: -111.862434},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- vermont: {
- center: {lat: 44.045876, lng: -72.710686},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- virginia: {
- center: {lat: 37.769337, lng: -78.169968},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- washington: {
- center: {lat: 47.400902, lng: -121.490494},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- westVirginia: {
- center: {lat: 38.491226, lng: -80.954453},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- wisconsin: {
- center: {lat: 44.268543, lng: -89.616508},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- },
- wyoming: {
- center: {lat: 42.755966, lng: -107.302490},
- codeSt: OldStateInfoFormat["state_code"],
- errors: OldStateInfoFormat["error_count"],
- session: OldStateInfoFormat["session_count"]
- }
- };
- var stateName = stateDictionary[OldStateInfoFormat["state_code"]];
- return citymap[stateName];
- }
- function getNewCityFormat(OldCityFormat)
- {
- console.log(OldCityFormat["city_name"]);
- console.log(OldCityFormat);
- console.log(OldCityFormat.city_name);
- console.log(OldCityFormat["state_code"]);
- var geocoder = new google.maps.Geocoder();
- var cityLat = 0;
- var cityLng = 0;
- geocoder.geocode( { 'address': OldCityFormat["city_name"] + ', us'}, function(results, status) {
- cityLat = results[0].geometry.location.lat();
- cityLng = results[0].geometry.location.lng();
- console.log("lat" + cityLat);
- console.log("lng"+ cityLng);
- });
- return {
- country: OldCityFormat["city_name"],
- center: {lat: cityLat, lng: cityLng},
- errors: OldCityFormat["error_count"],
- session: OldCityFormat["session_count"]
- }
- }
- router.get('/api/allData', function(req, res) {
- var query = "select * from state_network_statistic";
- cassandraClient.execute(query, function(err, result) {
- var models = {};
- for(var i = 0; i<result.rows.length; i++) {
- var model = {};
- var row = result.rows[i];
- models[stateDictionary[row["state_code"]]] = getNewInfoFormat(row);
- }
- res.setHeader('Access-Control-Allow-Origin','*');
- res.json(models);
- });
- });
- router.get('/api/getCitiesForState', function(req, res) {
- var stCode = req.query["stCode"];
- cassandraClient.execute("select * from state_network_statistic where state_code = ?",[req.query["stCode"]], function(err, result) {
- var models = [];
- for(var i = 0; i < result.rows.length; i++) {
- var row = result.rows[i];
- console.log(result.rows[i]);
- console.log(row);
- models[i] = getNewCityFormat(row);
- }
- res.setHeader('Access-Control-Allow-Origin','*');
- res.json(models);
- });
- });
- router.get('/', function(req, res) {
- res.setHeader('Access-Control-Allow-Origin','*');
- res.sendFile(path.join(__dirname + '/index4.html'));
- });
- app.use(router);
- app.listen(port);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement