My Project
Loading...
Searching...
No Matches
database_utils.py File Reference

Namespaces

namespace  lg_agent
namespace  lg_agent.database_utils

Functions

str lg_agent.database_utils.get_courseID_by_code (sqlite3.Connection conn, str course_code)
str lg_agent.database_utils.get_courseID_by_title (sqlite3.Connection conn, str course_title)
list lg_agent.database_utils.get_coops (sqlite3.Connection conn)
list lg_agent.database_utils.get_courseIDs_by_filters (sqlite3.Connection conn, schemas.CourseFilters filters)
dict lg_agent.database_utils.get_course_info_by_id (sqlite3.Connection conn, str course_id)
str lg_agent.database_utils.get_course_description_by_id (sqlite3.Connection conn, str course_id)
list lg_agent.database_utils.get_sectionIDs_by_filters (sqlite3.Connection conn, schemas.SectionFilters filters)
dict lg_agent.database_utils.get_section_info_by_id (sqlite3.Connection conn, str section_id)
list lg_agent.database_utils.get_upcoming_events (sqlite3.Connection conn)
list lg_agent.database_utils.get_event_dates_by_name (sqlite3.Connection conn, str event_name)
dict lg_agent.database_utils.get_student_basic_info (sqlite3.Connection conn, int student_id)
str lg_agent.database_utils.get_advisor_email (sqlite3.Connection conn, str advisor_name)
list lg_agent.database_utils.get_student_course_history (sqlite3.Connection conn, int student_id)
list lg_agent.database_utils.get_student_interests (sqlite3.Connection conn, int student_id)
list lg_agent.database_utils.get_student_tracked_sections (sqlite3.Connection conn, int student_id)
list lg_agent.database_utils.get_program_requirements_by_title (sqlite3.Connection conn, str program_title)
str lg_agent.database_utils.insert_student_interests (sqlite3.Connection conn, int student_id, list[str] interest)
str lg_agent.database_utils.insert_student_tracked_section (sqlite3.Connection conn, int student_id, str course_code, str section_number)
dict lg_agent.database_utils.get_data_with_hierarchy (sqlite3.Connection conn, str table, int targetID)
str lg_agent.database_utils._format_hierarchy_node (dict node, int depth=0)
str lg_agent.database_utils.hierarchy_data_to_string (dict hierarchy_data)
str lg_agent.database_utils.get_data_with_hierarchy_string (sqlite3.Connection conn, str table, str targetID)
list lg_agent.database_utils.get_ids_by_field_value (sqlite3.Connection conn, str table, str field, str value)
list lg_agent.database_utils.get_ids_by_parent (sqlite3.Connection conn, str table, str targetID)
list lg_agent.database_utils.get_students_by_advisor (sqlite3.Connection conn, str advisorID)
str lg_agent.database_utils.async_get_courseID_by_code (aiosqlite.Connection conn, str course_code)
str lg_agent.database_utils.async_get_courseID_by_title (aiosqlite.Connection conn, str course_title)
dict lg_agent.database_utils.async_get_course_info_by_id (aiosqlite.Connection conn, str course_id)
list lg_agent.database_utils.async_get_coops (aiosqlite.Connection conn)
list lg_agent.database_utils.async_get_courseIDs_by_filters (aiosqlite.Connection conn, schemas.CourseFilters filters)
str lg_agent.database_utils.async_get_course_description_by_id (aiosqlite.Connection conn, str course_id)
list lg_agent.database_utils.async_get_sectionIDs_by_filters (aiosqlite.Connection conn, schemas.SectionFilters filters)
dict lg_agent.database_utils.async_get_section_info_by_id (aiosqlite.Connection conn, str section_id)
 lg_agent.database_utils.async_get_upcoming_events (aiosqlite.Connection conn)
list lg_agent.database_utils.async_get_event_dates_by_name (aiosqlite.Connection conn, str event_name)
dict lg_agent.database_utils.async_get_student_basic_info (aiosqlite.Connection conn, int student_id)
list lg_agent.database_utils.async_get_student_course_history (aiosqlite.Connection conn, int student_id)
list lg_agent.database_utils.async_get_student_interests (aiosqlite.Connection conn, int student_id)
list lg_agent.database_utils.async_get_student_tracked_sections (aiosqlite.Connection conn, int student_id)
list lg_agent.database_utils.async_get_program_requirements_by_title (aiosqlite.Connection conn, str program_title)
str lg_agent.database_utils.async_insert_student_interests (aiosqlite.Connection conn, int student_id, list[str] interest)
str lg_agent.database_utils.async_insert_student_tracked_section (aiosqlite.Connection conn, int student_id, str course_code, str section_number)

Variables

 lg_agent.database_utils.PARENT_DIR = os.path.abspath(os.path.join(os.path.dirname(__file__), '..'))