Tables

• A simple user Table
• Tables for a blog

A simple user Table

For database check Database. Support only one database but it’s an easy fix just extend Table and check database.py.

class User(Table):
    username = CharColumn()

Tables for a blog

class User(Table):
    firstname = CharColumn(max_length=50)
    lastname  = CharColumn(max_length=50)
    role      = CharColumn(index=True, unique=True)

class Post(Table):
    title   = CharColumn(default='Post title', max_length=255)
    id_user = FKeyColumn(table=User, reference='user')

Create your tables

Two ways to create your tables:

User.create_table()
Post.create_table()

# or

database.create_all()