def add_event(cls, event): # cls.__load_data() # key = str(uuid.uuid4()) # event_data['id'] = key # cls.__events_data[key] = event_data # # return event_data try: session = DbSessionFactory.create_session() db_event = Event() # db_people.last_seen = parse( person.last_seen ) # parse(teacher.certdate) db_event.headline = event.headline db_event.description = event.description db_event.event_type = event.event_type db_event.event_date = parse(event.event_date) # db_car.image = person.image if car.image else random.choice(cls.__fake_image_url) db_event.url1 = event.url1 db_event.url2 = event.url2 # db_car.teacherId = int(teacher.year) # db_people.price = int( person.price ) # db_event.date_created = parse(event.date_created) db_event.id = event.id session.add( db_event ) session.commit() return db_event except Exception as e: print( e ) # for the repr
def delete_event(cls, event_id): # del cls.__events_data[event_id] session = DbSessionFactory.create_session() db_event = session.query(Event).filter(Event.id == event_id).first() if not db_event: return session.delete(db_event) session.commit()
def delete_person(cls, person_id): # del cls.__people_data[person_id] session = DbSessionFactory.create_session() db_person = session.query(Person).filter( Person.id == person_id).first() if not db_person: return session.delete(db_person) session.commit()
def event_by_id(cls, events_id): # cls.__load_data() # return cls.__events_data.get(events_id) session = DbSessionFactory.create_session() event = session.query(Event).filter(Event.id == events_id).first() session.close() return event
def person_by_id(cls, person_id): # cls.__load_data() # return cls.__people_data.get(person_id) session = DbSessionFactory.create_session() person = session.query(Person).filter(Person.id == person_id).first() session.close() return person
def event_by_type(cls, events_type): # cls.__load_data() # return cls.__events_data.get(events_id) session = DbSessionFactory.create_session() # event = session.query(Event).filter(Event.event_type == "'" + events_type + "'") #.first() # event = session.query(Event).filter(Event.event_type = 'Discover').all() #event = session.query(Event).filter(Event.event_type.like('Discover')).all() event = session.query(Event).filter(Event.event_type.like(events_type)).all() #directions = Directions.query.filter_by(key={somestring}).first() session.close() return event
def all_events(cls, limit=None): # cls.__load_data() # # events = list(cls.__events_data.values()) # if limit: # events = events[:limit] # # return events session = DbSessionFactory.create_session() query = session.query(Event).order_by(Event.event_date) if limit: events = query[:limit] else: events = query.all() session.close() return events
def all_people(cls, limit=None): # cls.__load_data() # # people = list(cls.__people_data.values()) # if limit: # people = people[:limit] # # return people session = DbSessionFactory.create_session() query = session.query(Person) # .order_by(Teacher.lName) if limit: people = query[:limit] else: people = query.all() session.close() return people
def update_event(cls, event_data): # key = event_data['id'] # cls.__events_data[key] = event_data # # return event_data session = DbSessionFactory.create_session() db_event = session.query(Event).filter(Event.id == event_data.id).first() # db_car.last_seen = parse(car_data.last_seen) db_event.headline = event_data.headline db_event.description = event_data.description db_event.event_type = event_data.event_type db_event.url1 = event_data.url1 db_event.url2 = event_data.url2 db_event.event_date = parse( event_data.event_date ) session.commit() return db_event
def add_person(cls, person): # cls.__load_data() # key = str(uuid.uuid4()) # person_data['id'] = key # cls.__people_data[key] = person_data # # return person_data try: session = DbSessionFactory.create_session() db_people = Person() # db_people.last_seen = parse( person.last_seen ) # parse(teacher.certdate) db_people.headline = person.headline db_people.fname = person.fname db_people.lname = person.lname db_people.title = person.title db_people.company = person.company db_people.email = person.email db_people.url1 = person.url1 db_people.url2 = person.url2 db_people.description = person.description db_people.address = person.address db_people.city = person.city db_people.state = person.state db_people.interviewed = person.interviewed # db_people.img1 = person.img1 # db_car.image = person.image if car.image else random.choice(cls.__fake_image_url) # db_people.year = person.year # db_car.teacherId = int(teacher.year) # db_people.price = int( person.price ) db_people.id = person.id session.add(db_people) session.commit() return db_people except Exception as e: print(e) # for the repr
def people_interviewed(cls, interviewed, limit=None): # session = DbSessionFactory.create_session() # # person = session.query(Person).filter(Person.interviewed == 'yes') #Person.id == person_id).first() # # session.close() # # return person # ------------ session = DbSessionFactory.create_session() # query = session.query( Person ) # .order_by(Teacher.lName) query = session.query(Person).filter(Person.interviewed == 'yes') if limit: people = query[:limit] else: people = query.all() session.close() return people
def update_person(cls, person): # key = person_data['id'] # cls.__people_data[key] = person_data # # return person_data # id,name,title,company,email,url1,url2,description, address, city,state,img1 session = DbSessionFactory.create_session() db_person = session.query(Person).filter( Person.id == person.id).first() # db_car.last_seen = parse(car_data.last_seen) db_person.headline = person.headline db_person.fname = person.fname db_person.lname = person.lname db_person.title = person.title db_person.company = person.company db_person.email = person.email db_person.url1 = person.url1 db_person.url2 = person.url2 # db_person.date_interviewed = person.date_interviewed db_person.description = person.description db_person.address = person.address db_person.city = person.city db_person.state = person.state # db_person.img1 = person.img1 # db_car.image = car_data.image if car_data.image else random.choice(cls.__fake_image_url) # db_car.brand = car_data.brand # db_car.damage = car_data.damage # db_car.id = car_data.id # db_car.price = car_data.price # db_car.year = car_data.year session.commit() return db_person
def init_db(config): settings = config.get_settings() db_file = settings.get('db_filename') DbSessionFactory.global_init(db_file)