finql-postgres

Crates.iofinql-postgres
lib.rsfinql-postgres
version0.3.0
sourcesrc
created_at2021-02-01 21:51:42.632356
updated_at2021-07-06 13:50:56.82007
descriptionInternal crate used by finql implementing the postgres adaptor
homepage
repositoryhttps://github.com/xemwebe/finql
max_upload_size
id349417
size68,595
Mark Beinker (xemwebe)

documentation

README

finql-postgres

finql-postgres is an implementation of the finql-data data handler trait used by the finql crate. The implementation an adaptor to the postgreSQL database. It is only useful in connection with finql.

The implementation is based on sqlx, which uses macros to enable query checking at compile time. In order to achieve this, a valid database must be specified, otherwise the build will fail.

Therefore, pleas follow the following steps to build the library:

  1. Setup a postgreSQL server, e.g. following the documentation on https://www.postgresql.org
  2. Setup a postgreSQL user named finqltester
  3. Upload the file data/finqlpg.sql to a database of your choice, e.g. by
psql <databasename> < data/finqlpg.sql

as some user with write to create new databases, PostgreSQL's default user postgres.

  1. export the database connection string on the command line with
export DATABASE_URL="postgresql://127.0.0.1/<databasename>?user=finqltester&password=<password>&ssl=false"

for a http connection or

export DATABASE_URL="postgresql:///<databasename>?user=finqltester&password=<password>&ssl=false"

for a connection via UNIX socket, depending on your setup.

  1. build the library with cargo build

Please note that this database is only used once for building the library and performing all the compile time checks. Once the build is complete, the database handler is able to set up a new empty database.

Commit count: 301

cargo fmt