Python create_all示例

示例#1

文件： base.py 项目： RichardScottOZ/SA-Strarigraphy-db

 def setUp(self):
     db.create_all()
     user = User(username="******",
                 email="*****@*****.**",
                 password="******")
     db.session.add(user)
     db.session.commit()

示例#2

文件： base.py 项目： digideskio/fullscalepython-app

 def setUp(self):
     db.create_all()
     user = User(
         email='*****@*****.**',
         username='******',
         password='******',
         admin=True
     )
     duplicate_user = User(
         email='*****@*****.**',
         username='******',
         password='******'
     )
     data = Bathroom(
         name='test bathroom',
         location='NYC',
         open_year_round=True,
         handicap_accessible=True,
         borough='Manhattan',
         latlong="{'lng': -73.9712488, 'lat': 40.7830603}"
     )
     db.session.add(user)
     db.session.add(duplicate_user)
     db.session.add(data)
     db.session.commit()

示例#3

 def setUp(self):
     db.create_all()
     user = User(
         email='*****@*****.**',
         username='******',
         password='******',
         admin=True
     )
     duplicate_user = User(
         email='*****@*****.**',
         username='******',
         password='******'
     )
     data = Bathroom(
         name='test bathroom',
         location='NYC',
         open_year_round=True,
         handicap_accessible=True,
         borough='Manhattan',
         latlong="{'lng': -73.9712488, 'lat': 40.7830603}"
     )
     db.session.add(user)
     db.session.add(duplicate_user)
     db.session.add(data)
     bathroom = Bathroom.query.first()
     user = User.query.first()
     rating = Rating(
         user_id=user.id,
         bathroom_id=bathroom.id,
         rating=5
     )
     db.session.add(rating)
     db.session.commit()

示例#4

文件： base.py 项目： BakanovKirill/meneto-test

 def setUp(self):
     self.db = db
     db.create_all()
     user = User(email="*****@*****.**", password="******")
     db.session.add(user)
     db.session.add(Product(title="Apple", price=2))
     db.session.add(Product(title="Cat", price=10, bogof=True))
     db.session.add(Product(title="Butter", price=4))
     db.session.commit()
     self.user = user

示例#5

def db(app):
    """Create database for the tests."""
    _db.app = app
    with app.app_context():
        _db.create_all()

    yield _db

    # Explicitly close DB connection
    _db.session.close()
    _db.drop_all()

示例#6

def create_users():
    """ Create users """

    # Create all tables
    db.create_all()

    # Adding role
    admin_role = find_or_create_role('Admin')
    user_role = find_or_create_role('User')

    # Add registration
    registration = find_or_create_registration(
        'Eugene', 'Ichinose', u'*****@*****.**', 'initial admin')

    # Add user
    admin_user = find_or_create_user(registration.id, 'adminPW', admin_role.id)
    # Save to DB
    db.session.commit()

示例#7

文件： base.py 项目： SoichiroOta/flask_sample_app

 def setUp(self):
     self.base_title = "Flask Sample App"
     db.create_all()
     user1 = User(name="admin_user",
                  email="*****@*****.**",
                  password="******",
                  admin=True,
                  activated=True,
                  activated_on=datetime.datetime.now())
     user2 = User(name="admin_user2",
                  email="*****@*****.**",
                  password="******",
                  activated=True,
                  activated_on=datetime.datetime.now())
     db.session.bulk_save_objects([user1, user2])
     user = User.query.first()
     micropost = Micropost(content="Lorem ipsum", user_id=user.id)
     db.session.add(micropost)
     db.session.commit()

示例#8

文件： base.py 项目： ddparker/lms

    def setUp(self):
        db.create_all()
        studentUser = Student(email='*****@*****.**',
                              password='******')
        db.session.add(studentUser)
        teacherUser = Teacher(email='*****@*****.**',
                              password='******')
        db.session.add(teacherUser)
        teacherUserTwo = Teacher(email='*****@*****.**',
                                 password='******')
        db.session.add(teacherUserTwo)
        adminUser = Admin(
            email='*****@*****.**',
            password='******',
        )
        db.session.add(adminUser)
        db.session.commit()

        self.client.post('/login',
                         data=dict(email='*****@*****.**',
                                   password='******',
                                   confirm='teacher_user'),
                         follow_redirects=True)

示例#9

 def setUp(self):
     db.create_all()

示例#10

def init_db():
    """ Initialize the database."""
    db.drop_all()
    db.create_all()
    create_users()

示例#11

def create_db():
    """Creates the db tables."""
    db.create_all()

示例#12

文件： base.py 项目： 2hoursleep/iroha-db-api

 def setUp(self):
     db.create_all()
     db.session.commit()

示例#13

文件： manage.py 项目： Stu076/stickynotesdemo

def create_db():
    db.create_all()

示例#14

 def setUp(self):
     db.create_all(bind='agwallet')

示例#15

文件： base.py 项目： QMickael/flask-skeleton

 def setUp(self):
     db.create_all()
     user = User(username="******", password="******", admin=True)
     db.session.add(user)
     db.session.commit()

示例#16

文件： manage.py 项目： andela-jngatia/flask-skeleton

def create_db():
    """Creates the db tables."""
    db.create_all()

示例#17

文件： manage.py 项目： biggstd/AluminumDream

def create_db():
    """Creates the db tables."""
    click.echo('Testing the database table creation...')
    db.create_all()

示例#18

文件： manage.py 项目： shiblu-ahmad/ffm_authentication_authorization_service

                        'workers': workers
                    }

                def load(self):
                    return app

            FlaskApplication().run()


manager.add_command("runserver", GunicornServer(host='0.0.0.0', port=8000))
# manager.add_command("runserver", Server(host='0.0.0.0', port='8000'))
# migrations
manager.add_command('db', MigrateCommand)


@manager.command
def create_db():
    """Creates the db tables."""
    db.create_all()


@manager.command
def drop_db():
    """Drops the db tables."""
    db.drop_all()


if __name__ == '__main__':
    db.create_all()
    manager.run()

示例#19

文件： base.py 项目： AresZhu/flask-skeleton

 def setUp(self):
     db.create_all()
     user = User(email="*****@*****.**", password="******")
     db.session.add(user)
     db.session.commit()

示例#20

def create_db():
    db.drop_all()
    db.create_all()
    db.session.commit()

示例#21

def create_db():
    """Creates database."""
    db.create_all()

示例#22

def create_db():
    """Membuat table"""
    db.create_all()

示例#23

文件： base.py 项目： jayanthns/flask-jwt-auth

 def setUp(self):
     db.create_all()
     db.session.commit()