Prerequisites

• Python3. See Python3 Tutorial

• Virtualenv. See Virtual Environments Tutorial

• Pip. See Quickstart to installing Python modules

Installing

1. Fetch the latest copy of the project from github

git clone https://github.com/edasi/kool.git

2. Setup a virtual environment

python3 -m venv kool-env

On Windows, run:

kool-env\Scripts\activate.bat

On Unix or MacOS, run:

source kool-env/bin/activate

3. Install requirements

pip install -U pip
pip install -r requirements.txt

Code Examples

On python interactive shell, start by extending class User to create a Student.

from kool.contrib.auth import User

# Extending class User
class Student(User):
    pass

student = Student(first_name='John', last_name='Doe', email='john@doe.com', password='secretpwd')

student.save()

To insert another student record in an existing table

from kool.db.models import table

# Get Student table to perform CRUD operations
student = table(Student)

student.insert({'first_name': 'Mary', 'last_name': 'Doe', 'email': 'mary@doe.com', 'password': 'secretpwd2'})

To query an existing table

from kool.db.models import where

student.filter(where('last_name') == 'Doe')

To perform complex queries

from kool.db.flatfile import Query

Student = Query()

student.filter((Student.first_name == 'John') | (Student.first_name == 'Mary'))

Test Coverage

Test coverage is covered by coverage and pytest-cov tools. Local test reports are built in html format inside the htmlcov/ directory that is automatically generated when pytest is run. However, online test reports are built by CircleCI