def create_user(): db.drop_all() db.create_all() user = User(name=USERNAME, email='*****@*****.**', password='******') db.session.add(user) db.session.commit()
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()
def init_data(): """Fish data for project""" db.drop_all() db.create_all() user = User(username='******', email='*****@*****.**', password='******') user.save()
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()
def tearDown(self): print('\n' * 5) print('-' * 50) self.context.pop() with app.app_context(): self.delete_all() db.drop_all()
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()
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()
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()
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!')
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()
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()
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()
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()
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()
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)
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()
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)
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()
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()
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()
def initdb(): db.session.commit() db.drop_all() db.create_all() click.echo('Init Finished!')
def dropdb(): db.drop_all()
def db_clean(): db.drop_all() db.create_all()
def tearDown(self): db.session.remove() db.drop_all()
def dropall(): db.drop_all() print("all tables dropped! remember to delete directory: migrations")
def tearDown(self): db.session.remove() db.drop_all() self.app_context.pop()
def start(): db.drop_all() db.create_all()
def initdb(): db.session.commit() db.drop_all() rdb.flushall() db.create_all() click.echo("Init finished!")
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()
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})