models.py

from routes import db
import json

class User(db.Model):

    __tablename__ = 'users'

    # Serial Number
    sno = db.Column(db.Integer, primary_key = True)

    # Organisation
    organisation = db.Column(db.String(128), nullable=False)

    # User Name
    name    = db.Column(db.String(128),  nullable=False)

    # Github username
    github_username = db.Column(db.String(128), nullable = False)

    # New instance instantiation procedure
    def __init__(self, organisation, name, github_username):

        self.organisation = organisation
        self.name    = name
        self.github_username = github_username

    def __repr__(self):
        return json.dumps([self.name, self.github_username])

class Organisation(db.Model):

    __tablename__ = 'organisations'

    # Serial Number
    sno = db.Column(db.Integer, primary_key = True)

    # Organisation
    organisation = db.Column(db.String(128), nullable=False)

    # New instance instantiation procedure
    def __init__(self, organisation):

        self.organisation = organisation

    def __repr__(self):
        return json.dumps([self.organisation])