def get_case_by_id(self, id): conn = psycopg2.connect(dbname=self.name, user=self.user, password=self.password, host=self.host) with conn.cursor() as cursor: conn.autocommit = True cursor.execute('SELECT * FROM cases WHERE case_id = %s', (id, )) records = cursor.fetchall() conn.close() if len(records) > 0: case = Case(records[0]) return case
def get_all_cases(self): conn = psycopg2.connect(dbname=self.name, user=self.user, password=self.password, host=self.host) records = [] with conn.cursor() as cursor: cursor.execute('SELECT * FROM cases') records = cursor.fetchall() conn.close() cases = [] if len(records) > 0: for rec in records: case = Case(rec) cases.append(case) return cases
def get_all_cases_waiting_for_appointment(self): conn = psycopg2.connect(dbname=self.name, user=self.user, password=self.password, host=self.host) records = [] with conn.cursor() as cursor: cursor.execute('SELECT * FROM cases WHERE status = %s', ('ожидает назначения ответственных', )) records = cursor.fetchall() conn.close() cases = [] if len(records) > 0: for rec in records: case = Case(rec) cases.append(case) return cases
def get_teacher_completed_cases(self, teacher_id): conn = psycopg2.connect(dbname=self.name, user=self.user, password=self.password, host=self.host) records = [] with conn.cursor() as cursor: cursor.execute( 'SELECT * FROM cases WHERE (status = %s) AND (t_id = %s) ORDER BY title', ('завершено', teacher_id)) records = cursor.fetchall() conn.close() cases = [] if len(records) > 0: for rec in records: case = Case(rec) cases.append(case) return cases
def get_cases_which_need_teacher_editing(self, teacher_id): conn = psycopg2.connect(dbname=self.name, user=self.user, password=self.password, host=self.host) records = [] with conn.cursor() as cursor: cursor.execute( 'SELECT * FROM cases WHERE (status = %s OR status = %s) AND (t_id = %s) ORDER BY title', ('ожидается проверка правок плана консультации', 'ожидается проверка правок резолюции', teacher_id)) records = cursor.fetchall() conn.close() cases = [] if len(records) > 0: for rec in records: case = Case(rec) cases.append(case) return cases
def get_cases_by_teacher_id(self, teacher_id): conn = psycopg2.connect(dbname=self.name, user=self.user, password=self.password, host=self.host) records = [] with conn.cursor() as cursor: conn.autocommit = True cursor.execute('SELECT * FROM cases WHERE t_id = %s', (teacher_id, )) records = cursor.fetchall() conn.close() cases = [] if len(records) > 0: for rec in records: cs = Case(rec) cases.append(cs) return cases else: return None