Ejemplo n.º 1
0
def create_user():
    db.drop_all()
    db.create_all()

    user = User(name=USERNAME, email='*****@*****.**', password='******')
    db.session.add(user)
    db.session.commit()
Ejemplo n.º 2
0
def create_user():
    db.drop_all()
    db.create_all()

    user = User(name=USERNAME, email='*****@*****.**', password='******')
    db.session.add(user)
    db.session.commit()
Ejemplo n.º 3
0
def init_data():
    from imports import (
            Widget,Article,Page,
            User,Setting,Type,
            Template,Tag,Role,
            Category,Block,Profile,
            ContactMessage)
    """Fish data for project"""
    if prompt_bool('Do you want to kill your db?'):
        if squ.database_exists(db.engine.url):
            squ.drop_database(db.engine.url)
    try:
        db.drop_all()
    except:
        pass
    try:
        squ.create_database(db.engine.url)
        db.create_all()
    except:
        pass

    user = User.query.filter(User.email=='*****@*****.**').first()
    if user is None:
       user = User(username='******', email='*****@*****.**', password='******')
    user.save()
Ejemplo n.º 4
0
def init_data():
    """Fish data for project"""
    db.drop_all()
    db.create_all()

    user = User(username='******', email='*****@*****.**', password='******')
    user.save()
Ejemplo n.º 5
0
def init_data():
    """Fish data for project"""
    db.drop_all()
    db.create_all()

    admin = User(username=app.config['ADMIN_USERNAME'], email=app.config['ADMIN_EMAIL'], password=app.config['ADMIN_PASSWORD'])
    admin.save()
Ejemplo n.º 6
0
 def tearDown(self):
     print('\n' * 5)
     print('-' * 50)
     self.context.pop()
     with app.app_context():
         self.delete_all()
         db.drop_all()
Ejemplo n.º 7
0
def init_data():
    """Fish data for project"""
    db.drop_all()
    db.create_all()

    user = User(username='******', email='*****@*****.**', password='******')
    user.save()
Ejemplo n.º 8
0
 def setUp(self):
     self.app = app.test_client()
     self.app_context = app.app_context()
     self.app_context.push()
     db.drop_all()
     db.create_all()
     self.admin_role = self._create_admin_role()
Ejemplo n.º 9
0
 def setUp(self):
     self.context = app.test_request_context()
     self.context.push()
     self.client = app.test_client()
     self.runner = app.test_cli_runner()
     db.drop_all()
     db.create_all()
     print('-' * 50)
     print('\n' * 5)
def setup():
    db.drop_all()
    db.create_all()
    fake_users = [
        User('chencheng', '*****@*****.**'),
        User('lxgui', '*****@*****.**')
    ]
    db.session.add_all(fake_users)
    db.session.commit()
Ejemplo n.º 11
0
def init_data():
    """Fish data for project"""
    db.drop_all()
    db.create_all()

    admin = User(
        username=app.config["ADMIN_USERNAME"], email=app.config["ADMIN_EMAIL"], password=app.config["ADMIN_PASSWORD"]
    )
    admin.save()
Ejemplo n.º 12
0
def initdb():
    """Initialize database."""
    from social_flask_sqlalchemy import models as models_
    engine = db.get_engine()
    models_.PSABase.metadata.drop_all(engine)   # PSABase = declarative_base()
    db.session.commit()
    db.drop_all()
    db.create_all()
    models_.PSABase.metadata.create_all(engine)
    click.echo('Init finished!')
Ejemplo n.º 13
0
def setup():
    db.drop_all()
    db.create_all()
    fake_users = [
        User('xiaoming', '*****@*****.**'),
        User('dongweiming', '*****@*****.**'),
        User('admin', '*****@*****.**')
    ]
    db.session.add_all(fake_users)
    db.session.commit()
Ejemplo n.º 14
0
def setup():
    db.drop_all()
    db.create_all()
    fake_users = [
        User("xiaoming", "*****@*****.**"),
        User("xiaohua", "*****@*****.**"),
        User("xiaozhang", "*****@*****.**"),
    ]
    db.session.add_all(fake_users)
    db.session.commit()
Ejemplo n.º 15
0
def setup():
    db.drop_all()
    db.create_all()
    fake_users = [
        User('xiaoming', '*****@*****.**'),
        User('lilei', '*****@*****.**'),
        User('admin', '*****@*****.**'),
    ]
    db.session.add_all(fake_users)
    db.session.commit()
Ejemplo n.º 16
0
def setup():
    db.drop_all()
    db.create_all()
    fake_users = [
        User('xiaoming', '*****@*****.**'),
        User('dongwweiming', '*****@*****.**'),
        User('admin', '*****@*****.**')
    ]
    db.session.add_all(fake_users)
    db.session.commit()
Ejemplo n.º 17
0
def db(app):
    """A database for the tests."""
    _db.app = app
    with app.app_context():
        _db.create_all()

    yield _db

    _db.session.close()
    _db.drop_all()
Ejemplo n.º 18
0
def runPcap():
    db.drop_all()
    db.create_all()

    pcap = Pcap('p2.pcap')
    pcap.add()
    print(pcap.pid)
    pcap_res = PcapRes(pcap.pid, b'1234')
    pcap_res.add()
    npcap = PcapRes.query.get(1)  #filter_by(pid=1).first()
    print(npcap)
    return str(npcap)
Ejemplo n.º 19
0
def init_data():
    """Fish data for project"""
    if prompt_bool('Do you want to kill your db?'):
        db.drop_all()
    try:
       db.create_all()
    except:
        pass

    user = User.query.filter(User.email=='*****@*****.**').first()
    if user is None:
       user = User(username='******', email='*****@*****.**', password='******')
    user.save()
Ejemplo n.º 20
0
def forge(count):
    from faker import Faker

    db.drop_all()
    db.create_all()

    fake = Faker()
    click.echo("Working...")

    for i in range(count):
        message = Message(name=fake.name(),
                          body=fake.sentence(),
                          timestamp=fake.date_time_this_year())

        db.session.add(message)

    db.session.commit()

    click.echo("Created %d fake messages." % count)
Ejemplo n.º 21
0
def init_data():
    """Fish data for project"""
    if prompt_bool('Do you want to kill your db?'):
    try:
        db.drop_all()
    except:
        pass
    try:
        db.create_all()
    except:
        pass

manager.add_command('shell', Shell(make_context=lambda:{'app': app, 'db': db}))


if __name__ == '__main__':
    manager.add_command('clean',Clean())
    manager.add_command('urls',ShowUrls())
    manager.add_command('mrbob',mrbob_manager)
    manager.run()
Ejemplo n.º 22
0
def init_data():
    from imports import (Widget, Article, Page, User, Setting, Type, Template,
                         Tag, Role, Category, Block, Profile, ContactMessage)
    """Fish data for project"""
    if prompt_bool('Do you want to kill your db?'):
        if squ.database_exists(db.engine.url):
            squ.drop_database(db.engine.url)
    try:
        db.drop_all()
    except:
        pass
    try:
        squ.create_database(db.engine.url)
        db.create_all()
    except:
        pass

    user = User.query.filter(User.email == '*****@*****.**').first()
    if user is None:
        user = User(username='******',
                    email='*****@*****.**',
                    password='******')
    user.save()
Ejemplo n.º 23
0
def initdb():
    """Init/reset database."""

    db.drop_all()
    db.create_all()
    # Init/reset data.

    demo = Usr(
            name=u'demo', 
            email=u'*****@*****.**', 
            password=u'123456', 
            role_id=USER,
            status_id=ACTIVE,
            user_detail=UserDetail(
                age=10,
                url=u'http://demo.example.com', 
                deposit=100.00,
                location=u'Hangzhou', 
                bio=u'Demo Guy is ... hmm ... just a demo guy.'),
            )
    admin = Usr(
            name=u'admin', 
            email=u'*****@*****.**', 
            password=u'123456', 
            role_id=ADMIN,
            status_id=ACTIVE,
            user_detail=UserDetail(
                age=10,
                url=u'http://admin.example.com', 
                deposit=100.00,
                location=u'Hangzhou', 
                bio=u'admin Guy is ... hmm ... just a admin guy.'),
            )
    db.session.add(demo)
    db.session.add(admin)
    db.session.commit()
Ejemplo n.º 24
0
def initdb():
    db.session.commit()
    db.drop_all()
    db.create_all()
    click.echo('Init Finished!')
Ejemplo n.º 25
0
def dropdb():
    db.drop_all()
Ejemplo n.º 26
0
def db_clean():
    db.drop_all()
    db.create_all()
Ejemplo n.º 27
0
 def tearDown(self):
     db.session.remove()
     db.drop_all()
Ejemplo n.º 28
0
def dropall():
    db.drop_all()
    print("all tables dropped! remember to delete directory: migrations")
Ejemplo n.º 29
0
 def tearDown(self):
     db.session.remove()
     db.drop_all()
     self.app_context.pop()
Ejemplo n.º 30
0
def initdb():
    db.session.commit()
    db.drop_all()
    db.create_all()
    click.echo('Init Finished!')
def start():
    db.drop_all()
    db.create_all()
Ejemplo n.º 32
0
def initdb():
    db.session.commit()
    db.drop_all()
    rdb.flushall()
    db.create_all()
    click.echo("Init finished!")
Ejemplo n.º 33
0
 def tearDown(self):
     db.session.remove()
     db.drop_all()
Ejemplo n.º 34
0
def setup():
    db.drop_all()
    db.create_all()
    fake_users = [User('xiaoming'), User('dongsan'), User('lishi')]
    db.session.add_all(fake_users)
    db.session.commit()
Ejemplo n.º 35
0
app = Flask(__name__)
app.config.from_object('config')
app.config['DATABASE_QUERY_TIMEOUT'] = 0.0001
app.config['SQLALCHEMY_RECORD_QUERIES'] = True
db.init_app(app)

formatter = logging.Formatter(
    "[%(asctime)s] {%(pathname)s:%(lineno)d} %(levelname)s - %(message)s")
handler = RotatingFileHandler('slow_query.log', maxBytes=10000, backupCount=10)
handler.setLevel(logging.WARN)
handler.setFormatter(formatter)
app.logger.addHandler(handler)

with app.app_context():
    db.drop_all()
    db.create_all()


@app.route('/users', methods=['POST'])
def users():
    username = request.form.get('name')

    user = User(username)
    print 'User ID: {}'.format(user.id)
    db.session.add(user)
    db.session.commit()

    return jsonify({'id': user.id})