[][src]Module covid19db::dbschema

Structs

CDataSet

The CDataSet struct represents a row in the cdataset table. It is an instance of sqlx::FromRow for the benefit of users of sqlx::query_as.

CovidTracking

The CovidTracking struct represents a row in the covid19tracking table. It is an instance of sqlx::FromRow for the benefit of users of sqlx::query_as.

OWID

The OWID struct represents a row in the rtlive table. It is an instance of sqlx::FromRow for the benefit of users of sqlx::query_as.

RTLive

The RTLive struct represents a row in the rtlive table. It is an instance of sqlx::FromRow for the benefit of users of sqlx::query_as.

Functions

initdb

Initialize a database. This will drop all indices and tables related to this project, then re-create them, thus emptying them and readying them to receive data.

querystr_jd_to_datestr

Returns a SQLite query string converting the Julian date to a date string for the given column

querystr_jd_to_day

Returns a SQLite query string converting the Julian date to a day

querystr_jd_to_month

Returns a SQLite query string converting the Julian date to a month

querystr_jd_to_year

Returns a SQLite query string converting the Julian date to a year