def create_random_activity(self, categories):
randomized_categories = random.sample(set(categories),2)
if 'museum' in randomized_categories:
a = Activity(name='The famouse museum',category_ids=['museum'])
elif 'food' in randomized_categories:
a = Activity(name='The famous restaurnat',category_ids=['food','asianfood'])
else:
a = Activity(name='The famouse activity',category_ids=['laidback'])
return a.to_dict()
def readActivity(self):
"""
Read one activity and insert it in the database
"""
data = json.load(self.path)
for row in data["data"]:
self.result.append(
Activity(row["EquipementId"], row["ActLib"],
row["EquipementId"]))
def read_Activities(self):
"""
Reading of the entire installation table
"""
c = self.conn.cursor()
c.execute('SELECT * FROM activite')
result = c.fetchall()
activites = []
for a in result:
activites.append(Activity(a[0], a[1], 0))
return activites
def read_activities(self):
"""
Reads all the activities from the 'activites' table
"""
c = self.conn.cursor()
c.execute('SELECT * FROM activites')
rows = c.fetchall()
activities = []
for row in rows:
activities.append(Activity(row[0], row[1], 0))
return activities
def read_One_Activity(self, number):
"""
Read the entry of the given number
"""
c = self.conn.cursor()
c.execute('SELECT * FROM activite WHERE number = :givenNumber',
{'givenNumber': number})
result = c.fetchone()
try:
activity = Activity(result[0], result[1], 0)
except:
return "Il n'y a pas d'activité qui possède ce numéro"
return activity
def read_activity(self, number):
"""
Reads the activity which has the given number from the 'activites' table
"""
c = self.conn.cursor()
c.execute('SELECT * FROM activites WHERE ac.numero = :numero',
{'numero': number})
row = c.fetchone()
try:
activity = Activity(row[0], row[1], 0)
except TypeError:
return '<h2>Aucune activité ne correspond à ce numéro</h2>'
return activity
def read_Informations(self, activity, city):
"""
Read information about a sport in a city
"""
c = self.conn.cursor()
#c.execute("""SELECT i.number, i.name, e.number, e.name, a.number, a.name FROM installation i JOIN equipement e ON i.number = e.installationNumber JOIN equipement_activite ea ON e.number = ea.number_equipment JOIN activite a ON ea.number_activity = a.number WHERE i.city = ' + city + ' AND a.name LIKE '% + activity + %'""")
c.execute(
"SELECT DISTINCT i.number, i.name, e.number, e.name, a.number, a.name FROM installation i, equipement e, equipement_activite ea, activite a WHERE i.number = e.installationNumber AND e.number = ea.number_equipment AND ea.number_activity = a.number AND i.city = ' + city + ' AND a.name LIKE '% + activity + %'"
"")
result = c.fetchall()
query = []
for r in result:
query.append(Installation(r[0], r[1]), Equipment(r[0], r[1]),
Activity(r[0], r[1]))
print(query)
return query
def get_infos(self, activity_name, city):
"""
Gives all the installations, equipments and activities which match the given activity and city
"""
c = self.conn.cursor()
c.execute("""SELECT i.numero, i.nom, e.numero, e.nom, a.numero, a.nom
FROM installations i
JOIN equipements e ON i.numero = e.numero_installation
JOIN equipements_activites ea ON e.numero = ea.numero_equipement
JOIN activites a ON ea.numero_activite = a.numero
WHERE LOWER(i.ville) = LOWER('""" + city + """') AND a.nom LIKE '%""" +
activity_name + """%'""")
rows = c.fetchall()
results = []
for row in rows:
results.append(
(Installation(row[0],
row[1]), Equipment(row[2], row[3], row[0]),
Activity(row[4], row[5], row[2])))
return results
def read_activities(self, path):
"""
Reads a JSON file which contains data for the activities
>>> reader = ReadJSON()
>>> activities = reader.read_activities("data/test_activite.json")
>>> (activities[0].number, activities[0].name, activities[0].equipment_number)
('3501', 'Gymnastique volontaire', ' 213704')
"""
file = open(path)
data = json.load(file)
result = []
pbar = ProgressBar(
widgets=['Reading activities JSON: ',
Percentage(), ' ',
ETA()])
for line in pbar(data["data"]):
result.append(
Activity(line["ActCode"], line["ActLib"],
line["EquipementId"]))
return result
def extract_test_data(testdata, excel_dict):
for item in excel_dict:
for key in item:
if item[key] == "":
item[key] = None
testdata.append(Activity(**item))
