def init_categories():
#Pere
rootLieu = try_push_category("Lieux", "Lieux presents sur la carte" , None)
#Fils
if rootLieu != None :
try_push_category("Bar/Cafe", "Bar" , rootLieu.id)
try_push_category("Hopital", "Hopital" , rootLieu.id)
try_push_category("Musee", "Musee" , rootLieu.id)
try_push_category("Oeuvre d'art", "Oeuvre d'art" , rootLieu.id)
try_push_category("Monument", "Monument" , rootLieu.id)
try_push_category("Police", "Police" , rootLieu.id)
try_push_category("Autre", "Autres Lieux" , rootLieu.id)
try_push_category("Restaurant", "Restaurant" , rootLieu.id)
try_push_category("Night Club", "Night Club" , rootLieu.id)
rootTrans = try_push_category("Transport", "Transport" , rootLieu.id)
try_push_category("Velo'v", "Station Velov" , rootTrans.id)
try_push_category("Parking", "Parking" , rootTrans.id)
try_push_category("Tcl", "Transport en commun lyonnais" , rootTrans.id)
rootEvent = try_push_category("Evenement" , "Evenements presents sur la carte" , None)
rootEventUser = try_push_category("Evenement utilisateur", "Evenements ajoutes par des utilisateurs" , rootEvent.id)
try_push_category("Evenement Facebook", "Evenements collectes sur Facebook" , rootEvent.id)
try_push_category("Soiree", "Soiree divers" , rootEventUser.id)
try_push_category("Concert", "Concert Divers" , rootEventUser.id)
try_push_category("Spectacle", "Scpectacle divers" , rootEventUser.id)
try_push_category("Associatif", "Evenements associatif" , rootEventUser.id)
try_push_category("Sport", "Evenements sportifs" , rootEventUser.id)
try_push_category("Etudiant", "Evenement Etudiant" , rootEventUser.id)
try_push_category("Conference", "Soiree divers" , rootEventUser.id)
try_push_category("Autre", "Autre Evenment" , rootEventUser.id)
else :
service.logMessage(".INIT : Categories OK")
def createVelovTable(urlSource) :
service.logMessage(".Loading of json from the server Velov ")
urllib.urlretrieve(urlSource, "velov.json")
json_file = open('velov.json')
data = json.load(json_file)
listVelov = []
service.logMessage(".Parsing the json file")
categorie = Category.query.filter_by(nom = "Velo'v").first()
admin_user = User.query.filter_by(pseudo="admin").first()
for i in range(0, data["nb_results"]):
#data["nb_results"]
title = "Velov de " + data["values"][i][2]
if data["values"][i][11]=="OPEN":
description = "Etat : " + "OUVERT"
else:
description = "Etat : " + "FERME"
lat = data["values"][i][8]
lnd = data["values"][i][9]
obj = Pin('velov', title, lnd, lat, admin_user.id, [categorie], description)
obj.data1 = data["values"][i][12]
obj.data2 = data["values"][i][13]
obj.typeSpecificID = data["values"][i][17]
listVelov.append(obj);
json_file.close()
os.remove('velov.json')
return listVelov
def createVelovTable(urlSource):
service.logMessage(".Loading of json from the server Velov ")
urllib.urlretrieve(urlSource, "velov.json")
json_file = open('velov.json')
data = json.load(json_file)
listVelov = []
service.logMessage(".Parsing the json file")
categorie = Category.query.filter_by(nom="Velo'v").first()
admin_user = User.query.filter_by(pseudo="admin").first()
for i in range(0, data["nb_results"]):
#data["nb_results"]
title = "Velov de " + data["values"][i][2]
if data["values"][i][11] == "OPEN":
description = "Etat : " + "OUVERT"
else:
description = "Etat : " + "FERME"
lat = data["values"][i][8]
lnd = data["values"][i][9]
obj = Pin('velov', title, lnd, lat, admin_user.id, [categorie],
description)
obj.data1 = data["values"][i][12]
obj.data2 = data["values"][i][13]
obj.typeSpecificID = data["values"][i][17]
listVelov.append(obj)
json_file.close()
os.remove('velov.json')
return listVelov
def loadSncfData() :
service.logMessage(".TCL : Getting data")
list = createPointOfInterestTable()
service.logMessage(".TCL : Updating the database")
for l in list :
service.updatePointOfInterestByIdPointOfInterest(l)
service.logMessage(".TCL : I'm up to date !")
def loadData() :
service.logMessage(".PointOfInterests : Getting data")
list = createPointOfInterestTable()
service.logMessage(".PointOfInterests : Updating the database")
for l in list :
service.updatePointOfInterestByIdPointOfInterest(l)
service.logMessage(".PointOfInterests : I'm up to date !")
def refreshFacebookData():
service.logMessage(".Facebook : Getting Facebook Events")
list = createFacebookTable()
service.logMessage(".Facebook : Updating the database")
for v in list:
service.updateFacebookByIdFacebook(v)
service.logMessage(".Facebook : I'm up to date")
def createPointOfInterestTable() :
service.logMessage("Loading json sncf file")
json_file = open('sncf.json')
data = json.load(json_file)
listPointOfInterest = []
service.logMessage("Parsing the json sncf file")
i = 0
while i < 88 :
idUser = 1
title = data["node"][i]["tag"][0]["-v"]
lat = data["node"][i]["-lat"]
lng = data["node"][i]["-lon"]
obj = Pin('pointOfInterest', title, lng, lat, idUser, [], "")
obj.typeSpecificID = data["node"][i]["-id"]
listPointOfInterest.append(obj)
i+=1
json_file.close()
return listPointOfInterest
def createPointOfInterestTable():
service.logMessage("Loading json sncf file")
json_file = open('sncf.json')
data = json.load(json_file)
listPointOfInterest = []
service.logMessage("Parsing the json sncf file")
i = 0
while i < 88:
idUser = 1
title = data["node"][i]["tag"][0]["-v"]
lat = data["node"][i]["-lat"]
lng = data["node"][i]["-lon"]
obj = Pin('pointOfInterest', title, lng, lat, idUser, [], "")
obj.typeSpecificID = data["node"][i]["-id"]
listPointOfInterest.append(obj)
i += 1
json_file.close()
return listPointOfInterest
def init_categories():
#Pere
rootLieu = try_push_category("Lieux", "Lieux presents sur la carte", None)
#Fils
if rootLieu != None:
try_push_category("Bar/Cafe", "Bar", rootLieu.id)
try_push_category("Hopital", "Hopital", rootLieu.id)
try_push_category("Musee", "Musee", rootLieu.id)
try_push_category("Oeuvre d'art", "Oeuvre d'art", rootLieu.id)
try_push_category("Monument", "Monument", rootLieu.id)
try_push_category("Police", "Police", rootLieu.id)
try_push_category("Autre", "Autres Lieux", rootLieu.id)
try_push_category("Restaurant", "Restaurant", rootLieu.id)
try_push_category("Night Club", "Night Club", rootLieu.id)
rootTrans = try_push_category("Transport", "Transport", rootLieu.id)
try_push_category("Velo'v", "Station Velov", rootTrans.id)
try_push_category("Parking", "Parking", rootTrans.id)
try_push_category("Tcl", "Transport en commun lyonnais", rootTrans.id)
rootEvent = try_push_category("Evenement",
"Evenements presents sur la carte", None)
rootEventUser = try_push_category(
"Evenement utilisateur", "Evenements ajoutes par des utilisateurs",
rootEvent.id)
try_push_category("Evenement Facebook",
"Evenements collectes sur Facebook", rootEvent.id)
try_push_category("Soiree", "Soiree divers", rootEventUser.id)
try_push_category("Concert", "Concert Divers", rootEventUser.id)
try_push_category("Spectacle", "Scpectacle divers", rootEventUser.id)
try_push_category("Associatif", "Evenements associatif",
rootEventUser.id)
try_push_category("Sport", "Evenements sportifs", rootEventUser.id)
try_push_category("Etudiant", "Evenement Etudiant", rootEventUser.id)
try_push_category("Conference", "Soiree divers", rootEventUser.id)
try_push_category("Autre", "Autre Evenment", rootEventUser.id)
else:
service.logMessage(".INIT : Categories OK")
def init_admin_user():
admin_user = User.query.filter_by(pseudo="admin").first()
if admin_user == None:
service.logMessage(".INIT : Ajout de l'admin")
u = User("admin", "pass")
service.addObject(u)
service.logMessage(".INIT : Ajout de l'utilisateur 'admin'")
else:
service.logMessage(".INIT : Admin OK")
def init_admin_user():
admin_user = User.query.filter_by(pseudo="admin").first()
if admin_user == None:
service.logMessage(".INIT : Ajout de l'admin")
u = User("admin", "pass")
service.addObject(u)
service.logMessage(".INIT : Ajout de l'utilisateur 'admin'")
else:
service.logMessage(".INIT : Admin OK")
def try_push_category(name, descr , idFather ):
categorie = Category.query.filter_by(nom = name).first()
if categorie == None:
service.logMessage(".INIT : Ajout de la categorie" + name)
c = Category(name, descr , idFather)
return service.addObject(c)
def refreshVelovData(urlSource):
list = createVelovTable(urlSource)
service.logMessage(".Updating the database")
for v in list:
service.updateVelovByIdVelov(v)
service.logMessage(".Velo'v is up to date")
def createPointOfInterestTable() :
global title
listPointOfInterest = []
#POI sncf
service.logMessage(".Loading sncf file")
json_file_tcl = open('sncf.json')
dataSncf = json.load(json_file_tcl)
service.logMessage(".Parsing the json tcl file")
categorie = Category.query.filter_by(nom = "Tcl").first()
for i in range (0, 88) :
idUser = 1
title = dataSncf["node"][i]["tag"][0]["-v"]
lat = dataSncf["node"][i]["-lat"]
lng = dataSncf["node"][i]["-lon"]
obj = Pin('stationTCL', title, lng, lat, idUser, [categorie], "")
obj.typeSpecificID = dataSncf["node"][i]["-id"]
listPointOfInterest.append(obj)
json_file_tcl.close()
#POI cafes
service.logMessage(".Loading cafes file")
json_file_cafes = open('cafes.json')
dataCafes = json.load(json_file_cafes)
#listPointOfInterest = []
service.logMessage(".Parsing the cafe file")
categorie = Category.query.filter_by(nom = "Bar/Cafe").first()
for i in range (0,241):
for j in dataCafes["node"][i]["tag"] :
if j["_k"] == "name" :
title = j["_v"]
idUser = 1
lat = dataCafes["node"][i]["_lat"]
lng = dataCafes["node"][i]["_lon"]
obj = Pin('cafe', title, lng, lat, idUser, [categorie], "")
obj.typeSpecificID = dataCafes["node"][i]["_id"]
listPointOfInterest.append(obj)
json_file_cafes.close()
#POI restaurants
service.logMessage(".Loading Restaurants file")
json_file_restaurants = open('restaurants.json')
dataRestaurants = json.load(json_file_restaurants)
service.logMessage(".Parsing restaurant file")
categorie = Category.query.filter_by(nom = "Restaurant").first()
for i in range (0,738):
for j in dataRestaurants["node"][i]["tag"] :
if j["-k"] == "name" :
title = j["-v"]
idUser = 1
lat = dataRestaurants["node"][i]["-lat"]
lng = dataRestaurants["node"][i]["-lon"]
obj = Pin('restaurant',title, lng, lat, idUser, [categorie], "")
obj.typeSpecificID = dataRestaurants["node"][i]["-id"]
listPointOfInterest.append(obj)
json_file_restaurants.close()
#POI hopitaux
service.logMessage(".Loading hospital file")
json_file_hopitaux = open('hopitaux.json')
dataHopitaux = json.load(json_file_hopitaux)
service.logMessage(".Parsing hospital file")
categorie = Category.query.filter_by(nom = "Hopital").first()
for i in range (0,20):
for j in dataHopitaux["node"][i]["tag"] :
if j["-k"] == "name" :
title = j["-v"]
idUser = 1
lat = dataHopitaux["node"][i]["-lat"]
lng = dataHopitaux["node"][i]["-lon"]
obj = Pin('hopital',title, lng, lat, idUser, [categorie], "")
obj.typeSpecificID = dataHopitaux["node"][i]["-id"]
listPointOfInterest.append(obj)
json_file_hopitaux.close()
#POI nightclubs
service.logMessage(".Loading nightclubs file")
json_file_nc = open('nightClubs.json')
dataNC = json.load(json_file_nc)
service.logMessage(".Parsing Night Club")
categorie = Category.query.filter_by(nom = "Night Club").first()
for i in range (0,10):
for j in dataNC["node"][i]["tag"] :
if j["-k"] == "name" :
title = j["-v"]
idUser = 1
lat = dataNC["node"][i]["-lat"]
lng = dataNC["node"][i]["-lon"]
obj = Pin('nightClub',title, lng, lat, idUser, [categorie], "")
obj.typeSpecificID = dataNC["node"][i]["-id"]
listPointOfInterest.append(obj)
json_file_nc.close()
#POI police
service.logMessage(".Loading police file")
json_file_police = open('police.json')
dataPolice = json.load(json_file_police)
service.logMessage(".Parsing police stations")
categorie = Category.query.filter_by(nom = "Police").first()
for i in range (0,31):
for j in dataPolice["node"][i]["tag"] :
if j["-k"] == "name" :
title = j["-v"]
idUser = 1
lat = dataPolice["node"][i]["-lat"]
lng = dataPolice["node"][i]["-lon"]
obj = Pin('police',title, lng, lat, idUser, [categorie], "")
obj.typeSpecificID = dataPolice["node"][i]["-id"]
listPointOfInterest.append(obj)
json_file_police.close()
#POI monuments
service.logMessage(".Loading monuments file")
json_file_monuments = open('monuments.json')
dataMonuments = json.load(json_file_monuments)
categorie = Category.query.filter_by(nom = "Monument").first()
for i in range (0,37):
for j in dataMonuments["node"][i]["tag"] :
if j["-k"] == "name" :
title = j["-v"]
idUser = 1
lat = dataMonuments["node"][i]["-lat"]
lng = dataMonuments["node"][i]["-lon"]
obj = Pin('monument',title, lng, lat, idUser, [categorie], "")
obj.typeSpecificID = dataMonuments["node"][i]["-id"]
listPointOfInterest.append(obj)
json_file_monuments.close()
return listPointOfInterest
def refreshVelovData(urlSource):
list = createVelovTable(urlSource)
service.logMessage(".Updating the database")
for v in list:
service.updateVelovByIdVelov(v)
service.logMessage(".Velo'v is up to date")
def try_push_category(name, descr, idFather):
categorie = Category.query.filter_by(nom=name).first()
if categorie == None:
service.logMessage(".INIT : Ajout de la categorie" + name)
c = Category(name, descr, idFather)
return service.addObject(c)