Python query примеры использования

Пример #1

	def check_employee_exists(self, username):
		employees = session.query(Employee).filter(
			Employee.username == username
			).all()
		if len(employees) == 0:
			return True
		return False

Пример #2

	def check_username(self, username):
		employees = session.query(Employee).filter(
			Employee.username == username
			).all()
		if len(employees) == 1:
			return True 
		else:
			return False		

Пример #3

	def delete_room(self, room):
		meetings = session.query(Meeting).filter(Meeting.room == room.id).all()
		for m in meetings:
			for em in m.employees:
				session.delete(em)
			session.delete(m)
		session.delete(room)
		session.commit()

Пример #4

	def get_meetings_by_date_and_user(self, date, employee):
		meetings = session.query(Meeting).join(
			EmployeeMeeting).filter(
			Meeting.date == date).filter(
			EmployeeMeeting.employee == employee).filter(
			or_(
				EmployeeMeeting.pending == True,
				EmployeeMeeting.accepted == True
				)).all()
		return meetings

Пример #5

	def add_room(self, roomname, number, building, capacity=None):
		try:
			if capacity:
				room = Room(roomname=roomname, number=number, building=building, capacity=capacity)
			else:
				room = Room(roomname=roomname, number=number, building=building)
			session.add(room)
			session.commit()
			room = session.query(Room).filter(Room.number == number).filter(Room.building == building).one()
			return room
		except Exception as e:
			session.rollback()
			handle_exception()
			return False

Пример #6

	def create_meeting(self, title, room_id, owner_id, date, timeslots=None, employees=None):
		meeting = Meeting(title=title, room=room_id, owner=owner_id, date=date)
		
		if employees:
			for employee in employees:
				rel = EmployeeMeeting()
				rel.employee = employee
				meeting.employees.append(rel)


		if timeslots:
			meeting.timeslots = timeslots

		session.add(meeting)
		session.flush()
		meeting_id = meeting.id
		session.commit()
		return session.query(Meeting).filter(Meeting.id == meeting_id).one()

Пример #7

	def get_all_employees(self):
		return session.query(Employee).all()

Пример #8

	def get_employee_by_username(self, username):
		employee = session.query(Employee).filter(Employee.username == username).one()
		return employee

Пример #9

	def get_employee(self, employee_id):
		employee = session.query(Employee).filter(Employee.id == employee_id).one()
		return employee

Пример #10

	def get_room_meetings_by_date(self, room, date):
		return session.query(Meeting).filter(Meeting.room == room.id).filter(Meeting.date == date).all()

Пример #11

	def get_room_by_name(self, roomname):
		room = session.query(Room).filter(Room.roomname == roomname).first()
		return room

Пример #12

	def get_all_rooms(self):
		return session.query(Room).all()

Пример #13

	def delete_employee(self, employee_id):
		employee = session.query(Employee).filter(Employee.id == employee_id).one()
		session.delete(employee)
		session.commit()

Пример #14

	def get_timeslot(self, timeslot_id):
		return session.query(TimeSlot).filter(TimeSlot.id == timeslot_id).one()

Пример #15

	def get_owned_meetings(self, owner_id):
		meetings = session.query(Meeting).filter(
			Meeting.owner == owner_id
			).all()
		return meetings

Пример #16

	def get_meetings_by_user(self, employee):
		meetings = session.query(Meeting).join(
			EmployeeMeeting).filter(
			EmployeeMeeting.employee == employee).all()
		return meetings	

Пример #17

	def get_employee_meeting(self, meeting_id, employee_id):
		return session.query(EmployeeMeeting).filter(
			EmployeeMeeting.meeting_id == meeting_id).filter(
			EmployeeMeeting.employee_id == employee_id).one()

Пример #18

	def get_room_by_id(self, room_id):
		room = session.query(Room).filter(Room.id == room_id).one()
		return room