def init_data():
"""Fish data for project"""
db.drop_all()
db.create_all()
user = User(username='******', email='*****@*****.**', password='******')
user.save()
def register():
'''can remove the '#' to create the user table ! '''
db.create_all()
username = request.json.get("username")
password = request.json.get("password")
email = request.json.get("email")
if Users.query.filter_by(username=username).first():
return jsonify({
'username': username,
'password': password,
'tips': 'Reppeat of username!',
'err_code': 402
})
elif Users.query.filter_by(email=email).first():
return jsonify({
'username': username,
'password': password,
'tips': "This email has signed!",
'err_code': 403
})
avatar = username + '.jpg'
user = Users(username, email, avatar)
user.hash_password(password)
db.session.add(user)
db.session.commit()
return jsonify({
'username': username,
'password': password,
'tips': 'Okay,you can sign in now!',
'err_code': 200
})
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 query_user():
with db.session.no_autoflush:
db.create_all()
rt_user = {}
start_index = int(request.args.get('startIndex'))
last_index = int(request.args.get('lastIndex'))
key = request.args.get('username')
user = Users.query.filter_by(username=key).first()
produces = Resource.query.filter_by(author=key).all()
followers = Relation.query.filter_by(vid=user.uid).all()
res = query_passages(start_index, last_index, types=3, keyword=key)
# avatar_path = config.AVATARDIR + user.avatar
rt_user['produces'] = len(produces)
rt_user['followers'] = len(followers)
rt_user['following'] = len(user.relation)
rt_user['username'] = user.username
rt_user['uid'] = user.uid
rt_user['brief'] = user.brief
rt_user['avatar'] = get_file_url(avatar_client, Config.avatar_bucket,
user.avatar)
rt_user['sex'] = user.sex
if res[0] == {}:
return jsonify({
'tips': 'All loaded!',
'user': rt_user,
'contents': res[0]
})
return jsonify({'tips': 'Successed!', 'user': rt_user, 'contents': res[0]})
def create_user():
db.drop_all()
db.create_all()
user = User(name=USERNAME, email='*****@*****.**', password='******')
db.session.add(user)
db.session.commit()
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 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 init_data():
"""Fish data for project"""
db.drop_all()
db.create_all()
user = User(username='******', email='*****@*****.**', password='******')
user.save()
def create_user():
db.drop_all()
db.create_all()
user = User(name=USERNAME, email='*****@*****.**', password='******')
db.session.add(user)
db.session.commit()
def setup():
db.drop_all()
db.create_all()
fake_users = [
User('chencheng', '*****@*****.**'),
User('lxgui', '*****@*****.**')
]
db.session.add_all(fake_users)
db.session.commit()
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 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 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 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('dongwweiming', '*****@*****.**'),
User('admin', '*****@*****.**')
]
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 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 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 resource():
db.create_all()
datas = {}
current_path = request.args.get('currentPath')
start_index = int(request.args.get('startIndex'))
last_index = int(request.args.get('lastIndex'))
if current_path == 'home':
datas = query_passages(start_index, last_index, types=1, keyword=None)
elif current_path == 'following':
datas = query_passages(start_index,
last_index,
types=2,
keyword=g.user.uid)
return jsonify(datas[0])
def create_app():
app = Flask(__name__)
app.config['UPLOAD_FOLDER'] = config.UPLOAD_FOLDER
app.config['MAX_CONTENT_LENGTH'] = config.MAX_CONTENT_LENGTH
app.config['SQLALCHEMY_DATABASE_URI'] = config.SQLALCHEMY_DATABASE_URI
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db.init_app(app)
with app.app_context():
db.create_all()
album.register_api(app)
task.register_api(app)
return app
def add():
if request.method == 'GET':
return render_template('add.html')
else:
db.create_all()
t = []
for i in request.form.values():
t.append(i)
user,password,fullname,sex,phone,role,department,post=t
en = Employer(fullname,sex,phone,role,department,post)
us = User(user,password)
db.session.add(en)
db.session.add(us)
db.session.commit()
return 'ok'
def add_admire_message(pid):
db.create_all()
uid = g.user.uid
vid = Resource.query.filter_by(pid=pid).first().uid # get author uid
m_type = 1
pid = pid
m_content = '觉得很赞'
m_status = True
if not (Message.query.filter_by(uid=g.user.uid, pid=pid).first()):
admire_message = Message(uid=uid,
vid=vid,
pid=pid,
m_type=m_type,
m_content=m_content,
m_status=m_status)
db.session.add(admire_message)
db.session.commit()
def create_app():
app = Flask(__name__)
register_blueprint(app)
bootstrap = Bootstrap(app)
# load conffig
app.config.from_object('secure')
app.config.from_object('settings')
db.init_app(app)
with app.app_context():
# Extensions like Flask-SQLAlchemy now know what the "current" app
# is while within this block. Therefore, you can now run........
db.create_all()
login_manager.login_view = 'web.login'
login_manager.login_message = '请先登录'
login_manager.init_app(app)
return app
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()
MAIL_USERNAME = None
#MAIL_USERNAME = '******'
MAIL_PASSWORD = '******'
app.config['MAIL_SERVER'] = 'smtp.126.com'
app.config['MAIL_PORT'] = 25
app.config['MAIL_USE_TLS'] = True
app.config['MAIL_USERNAME'] = MAIL_USERNAME
app.config['MAIL_PASSWORD'] = MAIL_PASSWORD
app.config[
'SQLALCHEMY_DATABASE_URI'] = "mysql://*****:*****@127.0.0.1/test?charset=utf8"
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True
db.init_app(app)
# db.drop_all(app=app) # Only for debugging
db.create_all(app=app)
login_manager.init_app(app)
login_manager.session_protection = "strong"
login_manager.login_view = "login"
mail = Mail(app)
#================ USER FUNCTION =============
## Get info of another user
#@app.route('/get_user', methods=['POST'])
#@login_required
#def get_user():
# form = {k:request.form[k].strip() for k in request.form}
# if utils.validate_userid(int(form['user_id'])):
# user = User.query.filter_by(id=int(form['user_id'])).first()
def initdb():
db.create_all()
def setUp(self):
db.create_all()
self.user = User(username='******',
email='*****@*****.**',
password='******')
self.user.save()
def initdb():
db.session.commit()
db.drop_all()
db.create_all()
click.echo('Init Finished!')
def create():
db.create_all()
return 'ok'
def initdb():
db.session.commit()
db.drop_all()
rdb.flushall()
db.create_all()
click.echo("Init finished!")
def initdb():
db.session.commit()
db.drop_all()
db.create_all()
click.echo('Init Finished!')
def create_all():
db.create_all()
# data = User.query.filter(User.password=='999',User.username=='999').all()
# print(data)
return "创建成功"
def start():
db.drop_all()
db.create_all()
def setUp(self):
db.create_all()
self.user = User(username='******', email='*****@*****.**', password='******')
self.user.save()
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})
@app.after_request
import json
from flask import Flask, abort, request, jsonify, g, url_for, make_response, Response, current_app
from flask_sqlalchemy import SQLAlchemy
from flask_httpauth import HTTPBasicAuth
from ext import db, crossdomain
from models.user import User
from views.mock import mock
from views.gfjj import gfjj
# initialization
app = Flask(__name__)
app.config['SECRET_KEY'] = 'the quick brown fox jumps over the lazy dog'
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///db.sqlite'
app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True
# extensions
# db = SQLAlchemy(app)
db.app = app
db.init_app(app)
app.register_blueprint(mock)
app.register_blueprint(gfjj)
auth = HTTPBasicAuth()
app.config.from_object('config')
if __name__ == '__main__':
if not os.path.exists('test.sqlite'):
db.create_all()
app.run(host='0.0.0.0', port=8081, debug=True)
# -*- coding: utf-8 -*-
from flask import Flask
from views.index import vw_index
from views.book_view import vw_book
from ext import db as mysql_db
from utils.craw_ci import Ci
app = Flask(__name__)
app.config.from_object('config')
mysql_db.init_app(app)
with app.app_context():
# mysql_db.drop_all()
mysql_db.create_all()
@app.route('/')
def hello_world():
return 'Hello World!'
if __name__ == '__main__':
app.register_blueprint(vw_index)
app.register_blueprint(vw_book)
app.run(debug=True)
