Skip to content

Latest commit

 

History

History
43 lines (30 loc) · 1.89 KB

README.md

File metadata and controls

43 lines (30 loc) · 1.89 KB
Raw

Generate dummy data

This project aims to up personal skills and personal knowledge about databases, recommendation engine using Python and SQL Server. It will leverage personal skills and abilities, this project was internally only and GitHub was as a platform for sharing general things, on repository is used general data and information, other requirements and task was executed in Azure Data Studio using Sql Scripting.

  1. Create virtual env python3 -m venv .venv and activate it
  2. Install pipenv pip3 install pipenv then install project dependencies pipenv install --dev
  3. Copy .env.example into .env update variables accordingly
  4. Run commands with pipenv (pipenv loads .env file this will work as expected os.getenv() will return valid env variable)

Then use it for your up skill tables, generate and print custom data:

pipenv run script-name # to list all scripts write in terminal pipenv scripts

If you don't want to use pipenv export variables with .bashrc | .zshrc.

or run

export DRIVER="{ODBC Driver 18 for SQL Server}" \
export SERVER=some-server \
export DATABASE=some-database \
export USER=some-user \
export PASS=some-pass \
export SCHEMA_NAME=some-schema-name

Development

Before push code into repo use pipenv run init.

To help maintain good quality, a precommit command exists that runs linting and other static code analysis checks, ensuring code adheres to style guidelines and potential errors are caught early.

Dependency for Linux is odbc driver install from microsoft.

For Arch can be found on Aur.

NOTE

If you use in your tables text and ntext turn off .fast_executemany = False.