Mejram

The name

Mejram is the swedish name for Marjoram. Like any spice it is intended to give flavor to the analysis of sql databases.

Goal

The goal is to be able to analyse relational databases with a large number of tables. Many of the databases I've seen related to managing a specific domain (enterprise system) have around 200-300 tables. Even though this is not to large to analyse by hand, it can definitelly be to cumbersome. If you use sql server and the relations are well maintained. That is: The referential constraints are present where they should be. Then you don't need to use this tool. You can use sql server manager. The problem is that it's often a mixture of well maintained referential constraints and implied (i.e. can be gleaned by the naming convention in the database) but not formal.

Setup

I've found that the best way to get started is to copy paste Mejram.Console into your own repository and do some small changes (remember to change ProjectReference on Mejram to a PackageReference).

Testing

You need to either install postgresql locally or use docker. The easiest way is to use docker.

Make sure to create your own .env file. You can use the .env.example file as a template. Make sure to change the passwords.

cp .env.sample .env

Then you can start the database.

docker-compose up pg -d

Make sure to import the database.

./pg/import-pagila-data.sh

Then you can run the tests by having an environment variable with the right connection string.

source .env
export SAKILA_TEST_CONN=$LOCAL_PG_CONN
dotnet test csharp