Returns an %Ecto.Changeset{} for tracking bus route changes.

Examples

iex> change_bus_route(bus_route)
%Ecto.Changeset{data: %BusRoute{}}

Returns an %Ecto.Changeset{} for tracking contact changes.

Examples

iex> change_contact(contact)
%Ecto.Changeset{data: %Contact{}}

Returns an %Ecto.Changeset{} for tracking course changes.

Examples

iex> change_course(course)
%Ecto.Changeset{data: %Course{}}

Returns an %Ecto.Changeset{} for tracking credit provider changes.

Examples

iex> change_credit_provider(credit_provider)
%Ecto.Changeset{data: %CreditProvider{}}

Returns an %Ecto.Changeset{} for tracking enrollment changes.

Examples

iex> change_enrollment(enrollment)
%Ecto.Changeset{data: %Enrollment{}}

Returns an %Ecto.Changeset{} for tracking session changes.

Examples

iex> change_session(session)
%Ecto.Changeset{data: %Session{}}

Creates a bus route.

Examples

iex> create_bus_route(%{field: value})
{:ok, %BusRoute{}}

iex> create_bus_route(%{field: bad_value})
{:error, %Ecto.Changeset{}}

Creates a contact.

Examples

iex> create_contact(%{field: value})
{:ok, %Contact{}}

iex> create_contact(%{field: bad_value})
{:error, %Ecto.Changeset{}}

Creates a course.

Examples

iex> create_course(%{field: value})
{:ok, %Course{}}

iex> create_course(%{field: bad_value})
{:error, %Ecto.Changeset{}}

Creates a credit provider.

Examples

iex> create_credit_provider(%{field: value})
{:ok, %CreditProvider{}}

iex> create_credit_provider(%{field: bad_value})
{:error, %Ecto.Changeset{}}

Creates an enrollment.

Examples

iex> create_enrollment(%{field: value})
{:ok, %Enrollment{}}

iex> create_enrollment(%{field: bad_value})
{:error, %Ecto.Changeset{}}

Creates/updates a bus route.

Examples

iex> create_or_update_bus_route(%{field: value})
{:ok, %BusRoute{}}

iex> create_or_update_bus_route(%{field: bad_value})
{:error, %Ecto.Changeset{}}

Creates/updates a contact.

Examples

iex> create_or_update_contact(%{field: value})
{:ok, %Contact{}}

iex> create_or_update_contact(%{field: bad_value})
{:error, %Ecto.Changeset{}}

Creates/updates a course.

Examples

iex> create_or_update_course(%{field: value})
{:ok, %Course{}}

iex> create_or_update_course(%{field: bad_value})
{:error, %Ecto.Changeset{}}

Creates/updates a credit provider.

Examples

iex> create_or_update_credit_provider(%{field: value})
{:ok, %CreditProvider{}}

iex> create_or_update_credit_provider(%{field: bad_value})
{:error, %Ecto.Changeset{}}

Creates/updates an enrollment.

Examples

iex> create_or_update_enrollment(%{field: value})
{:ok, %Enrollment{}}

iex> create_or_update_contact(%{field: bad_value})
{:error, %Ecto.Changeset{}}

Creates/updates a session.

Examples

iex> create_or_update_session(%{field: value})
{:ok, %Session{}}

iex> create_or_update_contact(%{field: bad_value})
{:error, %Ecto.Changeset{}}

Creates a session.

Examples

iex> create_session(%{field: value})
{:ok, %Session{}}

iex> create_session(%{field: bad_value})
{:error, %Ecto.Changeset{}}

Deletes a bus route.

Examples

iex> delete_bus_route(bus_route)
{:ok, %BusRoute{}}

iex> delete_bus_route(bus_route)
{:error, %Ecto.Changeset{}}

Deletes a contact.

Examples

iex> delete_contact(contact)
{:ok, %Contact{}}

iex> delete_contact(contact)
{:error, %Ecto.Changeset{}}

Deletes a course.

Examples

iex> delete_course(course)
{:ok, %Course{}}

iex> delete_course(course)
{:error, %Ecto.Changeset{}}

Deletes a credit provider.

Examples

iex> delete_credit_provider(credit_provider)
{:ok, %CreditProvider{}}

iex> delete_credit_provider(credit_provider)
{:error, %Ecto.Changeset{}}

Delete all empty contacts from the database.

Empty contacts sometimes make it in because they're merged or deleted in Portico, which makes their cache record have an empty first/last name. We keep the cache record in Portico so we know what happened, but just pull them from the cache in Z so that they don't show up in searches etc.

Deletes a enrollment

Examples

iex> delete_enrollment(enrollment)
{:ok, %Enrollment{}}

iex> delete_enrollment(enrollment)
{:error, %Ecto.Changeset{}}

Deletes a session

Examples

iex> delete_session(session)
{:ok, %Session{}}

iex> delete_session(session)
{:error, %Ecto.Changeset{}}

Gets a single bus route, by portico_id.

Returns nil if the BusRoute does not exist.

Examples

iex> get_bus_route("portico_id")
%BusRoute{}

iex> get_bus_route("bad_id")
nil

Gets a single bus route, by portico_id.

Raises Ecto.NoResultsError if the BusRoute does not exist.

Examples

iex> get_bus_route!("portico_id")
%BusRoute{}

iex> get_bus_route!("bad_id")
** (Ecto.NoResultsError)

Gets a single contact, by portico_contact_id.

Returns nil if the Contact does not exist.

Examples

iex> get_contact("portico_contact_id")
%Contact{}

iex> get_contact("bad_id")
nil

Gets a single contact, by portico_contact_id.

Raises Ecto.NoResultsError if the Contact does not exist.

Examples

iex> get_contact!("portico_contact_id")
%Contact{}

iex> get_contact!("bad_id")
** (Ecto.NoResultsError)

Gets a single course, by portico_course_id.

Returns nil if the Course does not exist.

Examples

iex> get_course("portico_course_id")
%Course{}

iex> get_course("bad_id")
nil

Gets a single course, by portico_course_id.

Raises Ecto.NoResultsError if the Course does not exist.

Examples

iex> get_course!("portico_course_id")
%Course{}

iex> get_course!("bad_id")
** (Ecto.NoResultsError)

Gets a single credit provider, by portico_id.

Returns nil if the CreditProvider does not exist.

Examples

iex> get_credit_provider("portico_id")
%CreditProvider{}

iex> get_credit_provider("bad_id")
nil

Gets a single credit provider, by portico_id.

Raises Ecto.NoResultsError if the CreditProvider does not exist.

Examples

iex> get_credit_provider!("portico_id")
%CreditProvider{}

iex> get_credit_provider!("bad_id")
** (Ecto.NoResultsError)

Gets a single enrollment by sis_enrollment_id

Returns nil if none are found

Examples

iex> get_enrollment("abc")
%Enrollment{}

iex> get_enrollment("123")
nil

Gets a single enrollment by sis_enrollment_id

(Portico uses a compound key for this)

Raises Ecto.NoResultsError if the Enrollment does not exist.

Examples

iex> get_enrollment("abc")
%Enrollment{}

iex> get_enrollment("123")
** (Ecto.NoResultsError)

Gets a single session by portico_session_id

Returns nil if none are found

Examples

iex> get_session("abc")
%Session{}

iex> get_session("123")
nil

Gets a single session by portico_session_id

(Portico uses a compound key for this)

Raises Ecto.NoResultsError if the Session does not exist.

Examples

iex> get_session("abc")
%Session{}

iex> get_session("123")
** (Ecto.NoResultsError)

Returns the list of bus routes.

Examples

iex> list_bus_routes()
[%BusRoute{}, ...]

Returns the list of contacts.

Examples

iex> list_contacts()
[%Contact{}, ...]

Returns the list of courses.

Examples

iex> list_courses()
[%Course{}, ...]

Returns the list of credit providers.

Examples

iex> list_credit_providers()
[%CreditProvider{}, ...]

Returns the list of enrollments

Examples

iex> list_enrollments()
[%Enrollment{}, ...]

Returns the list of sessions

Examples

iex> list_sessions()
[%Session{}, ...]

Generates a query of ZSchemas.Flat.Course records that have active_session_ids which overlap what is passed to this function

Returns an Ecto.Query for re-use in other searches

Opts

This function takes the following opts:

• initial_query - a previous query to chain. Defaults to ZSchemas.Flat.Course

Generates a query of ZSchemas.Flat.Course records where min_grade and max_grade complement a given grade.

Returns an Ecto.Query for re-use in other searches

Opts

This function takes the following opts:

• initial_query - a previous query to chain. Defaults to ZSchemas.Flat.Course

Generates a query of ZSchemas.Flat.Course records where language_level is <= the passed level (as an integer)

See sis_data::language_levels in Portico for the map of integers to fluency.

Returns an Ecto.Query for re-use in other searches

Opts

This function takes the following opts:

• initial_query - a previous query to chain. Defaults to ZSchemas.Flat.Course

Updates a bus route.

Examples

iex> update_bus_route(bus_route, %{field: new_value})
{:ok, %BusRoute{}}

iex> update_bus_route(bus_route, %{field: bad_value})
{:error, %Ecto.Changeset{}}

Updates a contact.

Examples

iex> update_contact(contact, %{field: new_value})
{:ok, %Contact{}}

iex> update_contact(contact, %{field: bad_value})
{:error, %Ecto.Changeset{}}

Updates a course.

Examples

iex> update_course(course, %{field: new_value})
{:ok, %Course{}}

iex> update_course(course, %{field: bad_value})
{:error, %Ecto.Changeset{}}

Updates a credit provider.

Examples

iex> update_credit_provider(credit_provider, %{field: new_value})
{:ok, %CreditProvider{}}

iex> update_credit_provider(credit_provider, %{field: bad_value})
{:error, %Ecto.Changeset{}}

Updates an enrollment

Examples

iex> update_enrollment(enrollment, %{field: new_value})
{:ok, %Enrollment{}}

iex> update_enrollment(enrollment, %{field: bad_value})
{:error, %Ecto.Changeset{}}

Updates a session

Examples

iex> update_session(session, %{field: new_value})
{:ok, %Session{}}

iex> update_session(session, %{field: bad_value})
{:error, %Ecto.Changeset{}}