Getting Started

Prerequisites

• Creating the SchoolMint Reports

Dependencies

• Python3.7

• Pipenv

• Docker

  • Install for Mac

  • Install for Linux

  • Install for Windows

Environment

• Initial environment setup
  • Clone the repo
  • Set up Google service account
  • FTP setup
  • Create .env file
• Schema
  • Schema Setup
    • Automatic Setup: MS SQL
    • Automatic Setup: PostgreSQL
    • Tables
    • Views
    • Stored Procedures
  • Lookup Tables
  • Final ERD
  • Tables & Processes
  • Views

Running the job

Build the Docker image

docker build -t schoolmint .

Run

docker run --rm -it schoolmint

Run with volume mapping

docker run --rm -it -v ${PWD}:/code/ schoolmint

Run with enrollment targets sync (optional)

docker run --rm -it schoolmint --targets