Python create_allの例

コード例 #1

ファイル: testing.py プロジェクト: TerryKingston/schoolbloc

 def setUp(self):
     app.config.from_object('config')
     app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite://'
     self.app = app.test_client(use_cookies=False)
     with app.app_context():
         db.create_all()
     self._create_roles()

コード例 #2

ファイル: tests.py プロジェクト: TerryKingston/schoolbloc

    def setUp(self):
        """ Uses an in memory sqlite database for testing """
        app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite://'
        db.init_app(app)
        with app.app_context():
            db.create_all()

        db.session.add(Role(role_type='admin'))
        db.session.add(Role(role_type='teacher'))
        db.session.add(Role(role_type='student'))
        db.session.commit()

コード例 #3

ファイル: full_tests.py プロジェクト: TerryKingston/schoolbloc

    def reset_db(self):
        db.drop_all()
        db.create_all()
        # flaskr.init_db()

        db.session.add(Role(role_type='admin'))
        db.session.add(Role(role_type='teacher'))
        db.session.add(Role(role_type='student'))
        db.session.add(Role(role_type='parent'))
        db.session.add(User(username='******', password='******', role_type='admin'))
        db.session.add(User(username='******', password='******', role_type='teacher'))
        db.session.add(User(username='******', password='******', role_type='student'))
        db.session.add(User(username='******', password='******', role_type='parent'))
        db.session.add(User(username='******', password='******', role_type='student'))
        db.session.add(User(username='******', password='******', role_type='student'))
        db.session.add(Day(name='Monday'))
        db.session.add(Day(name='Tuesday'))
        db.session.add(Day(name='Wednesday'))
        db.session.add(Day(name='Thursday'))
        db.session.add(Day(name='Friday'))
        db.session.add(Day(name='Saturday'))
        db.session.add(Day(name='Sunday'))
        db.session.commit()

コード例 #4

ファイル: classroom_tests.py プロジェクト: TerryKingston/schoolbloc

 def setUp(self):
     """ Uses an in memory sqlite database for testing """
     app.config["SQLALCHEMY_DATABASE_URI"] = "sqlite://"
     db.init_app(app)
     with app.app_context():
         db.create_all()

コード例 #5

ファイル: run.py プロジェクト: TerryKingston/schoolbloc

similiar, but slightly different from the production run.py, in
which it will setup logging to go to our emails (optional) and
using redis instead of an in memory dictionary for session
storage
"""
from schoolbloc import app, db
from schoolbloc.scheduler.models import Day, Student, Parent, \
    ParentStudentMapper
from schoolbloc.users.models import Role, User

if __name__ == '__main__':
    # Set the log level to debug for development
    app.logger.setLevel('DEBUG')

    # Create the development sqlite databases if they don't already exist
    db.create_all()

    # I'm lazy, just gonna try adding stuff and catching exception if it exists
    try:
        db.session.add(Role(role_type='admin'))
        db.session.add(Role(role_type='teacher'))
        db.session.add(Role(role_type='student'))
        db.session.add(Role(role_type='parent'))
        db.session.add(User(username='******', password='******', role_type='admin'))
        db.session.add(User(username='******', password='******', role_type='teacher'))
        db.session.add(User(username='******', password='******', role_type='student'))
        db.session.add(User(username='******', password='******', role_type='student'))
        db.session.add(User(username='******', password='******', role_type='student'))
        db.session.add(User(username='******', password='******', role_type='parent'))
        db.session.add(Day(name='Monday'))
        db.session.add(Day(name='Tuesday'))