View Source Exzeitable.Database (Exzeitable v0.6.0)

Database interactions

Link to this section Summary

Functions

I want to just do a select: count(c.id)

Get the data using query

We only want letters to avoid SQL injection attacks

Generates the magic SQL fragment that performs search dynamically. Searches across columns that are searchable. Replaces nulls with a space. Created outside macro to bypass ecto restrictions

Link to this section Functions

Link to this function

get_record_count(params)

View Source
@spec get_record_count(map()) :: integer()

I want to just do a select: count(c.id)

@spec get_records(map()) :: [map()]

Get the data using query

@spec prefix_search(String.t()) :: String.t()

We only want letters to avoid SQL injection attacks

@spec tsvector_string([keyword()]) :: String.t()

Generates the magic SQL fragment that performs search dynamically. Searches across columns that are searchable. Replaces nulls with a space. Created outside macro to bypass ecto restrictions