PyJeeves/README.md

22 lines
621 B
Markdown
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

# PyJeeves Module
This project is a Jeeves data extraction and integration project.
## Initial creation of database schema.
```bash
docker run --link db --network marcus_default -v /srv/pyjeeves/config.yml:/app/config.yml gitlab.lndvll.se:5500/lindvallskaffe/pyjeeves python ./pyjeeves/db_raw.py
```
## Connecting to DB with client
```bash
docker run -it --network marcus_default --link db:mysql --rm mysql sh -c 'exec mysql -h"db" -P"3306" -uroot -p"ROOT_PW"'
```
## Forcing updates
You may force updates of objects by setting RowUpdatedDt to null.
For example:
´update jvs_customers set RowUpdatedDt = null;´