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