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))