ldpos-sqlite-dal

Knex Postgres Data Access Layer for LDPoS

Usage no npm install needed!

<script type="module">
  import ldposSqliteDal from 'https://cdn.skypack.dev/ldpos-sqlite-dal';
</script>

README

ldpos-sqlite-dal

SQLite Dat Access Layer for LDPoS.

Install docker

Install docker-engine or docker-desktop
Make sure docker command is available on the path.

Starting postgres

Run yarn start:db to start postgres instance inside docker
Type ctrl+c, yarn stop:dbto stop & remove old db instance.

Working with database migrations

Create migration using yarn migrate:make migrration_name e.g. yarn migrate:make create_table_table_name
Set migration names descriptive, follow snake case for migration name and table names (column names can be kept camelCase).
To run migration against db, run

    yarn migrate

To rollback migration

    yarn migrate:rollback

Creating seeds

Create migration using yarn seed:make seed_name e.g. yarn seed:make accounts
follow snake case for seeds and seed name is usually table name.
To run seeds against db, run

    yarn seed