def forge():
db.create_all()
name = "lv"
movies = [
{
'title': '杀破狼',
'year': '2003'
},
{
'title': '扫毒',
'year': '2018'
},
{
'title': '捉妖记',
'year': '2016'
},
{
'title': '囧妈',
'year': '2020'
},
{
'title': '葫芦娃',
'year': '1989'
},
{
'title': '杀破狼',
'year': '2003'
},
{
'title': '扫毒',
'year': '2018'
},
{
'title': '捉妖记',
'year': '2016'
},
{
'title': '囧妈',
'year': '2020'
},
{
'title': '葫芦娃',
'year': '1989'
},
]
user = User(name=name)
db.session.add(user)
for m in movies:
movie = Movie(title=m['title'], year=m['year'])
db.session.add(movie)
db.session.commit()
click.echo('数据导入完成')
def forge():
"""Generate fake data."""
db.create_all() # 创建数据表
# 虚拟电影条目数据
movies = [
{
'title': 'My Neighbor Totoro',
'year': '1988'
},
{
'title': 'Dead Poets Society',
'year': '1989'
},
{
'title': 'A Perfect World',
'year': '1993'
},
{
'title': 'Leon',
'year': '1994'
},
{
'title': 'Mahjong',
'year': '1996'
},
{
'title': 'Swallowtail Butterfly',
'year': '1996'
},
{
'title': 'King of Comedy',
'year': '1999'
},
{
'title': 'Devils on the Doorstep',
'year': '1999'
},
{
'title': 'WALL-E',
'year': '2008'
},
{
'title': 'The Pork of Music',
'year': '2012'
},
]
for m in movies:
movie = Movie(title=m['title'], year=m['year'])
db.session.add(movie)
db.session.commit() # 提交更改
click.echo('Generate fake data completed!')
def setUp(self):
app.config.update(TESTING=True,
SQLALCHEMY_DATABASE_URI='sqlite:///:memory:')
db.create_all()
user = User(name='Test', username='******')
user.set_password('123')
movie = Movie(title='Test Movie Title', year='2019')
db.session.add_all([user, movie])
db.session.commit()
self.client = app.test_client()
self.runner = app.test_cli_runner()
def admin(username, password):
"""Create user."""
db.create_all()
user = User.query.first()
if user is not None:
click.echo("Updating user ...")
user.username = username
user.set_password(password)
db.session.add(user)
db.session.commit()
click.echo("Done.")
def setUp(self):
app.config.update(TESTING=True,
SQLALCHEMY_DATABASE_URI='sqlite:///:memory:')
# 创建数据库
db.create_all()
# 创建测试数据， 一个用户, 一个电影条目
user = User(name='Test', username='******') # 新建用户
user.set_password('123') # 设置密码
movie = Movie(title='Test Movie Title', year='2020') # 创建一条电影记录
db.session.add_all([user, movie]) # add_all方法一次性传入多个模型类实例，以列表传入
db.session.commit()
self.client = app.test_client() # 创建测试客户端
self.runner = app.test_cli_runner()
def admin(username, password):
db.create_all()
user = User.query.first()
if user is not None:
click.echo('Updating user...')
user.username = username
user.set_password(password)
else:
click.echo('Creating user...')
user = User(name='Tom Li', username=username)
user.set_password(password)
db.session.add(user)
db.session.commit()
click.echo('Done.')
def comment():
db.create_all()
comments = [
{'name': 'James', 'content':'how are you?'},
{'name': 'Mike', 'content':'nice to see you'},
{'name': 'Alex', 'content':'see you around'},
]
for c in comments:
comment = Comment(name=c['name'], content=c['content'])
db.session.add(comment)
db.session.commit()
click.echo('Done')
def admin(username, password):
"""Create user."""
db.create_all()
user = User.query.filter_by(username=username).first()
if user is not None:
click.echo('Updating user...')
user.set_password(password)
else:
click.echo('Creating user...')
user = User(username=username, name='Admin')
user.set_password(password)
db.session.add(user)
db.session.commit()
click.echo('Done.')
def admin(username, password):
"""create user"""
db.create_all()
user = User.query.first()
if user is not None:
click.echo('Updating user...')
user.username = username
user.set_password(password) # 设置密码
else:
click.echo('Creating user')
user = User(username=username, name="Admin")
user.set_password(password)
db.session.add(user)
db.session.commit()
click.echo('Done')
def setUp(self):
# 更新配置
app.config.update(TESTING=True,
SQLALCHEMY_DATABASE_URI='sqlite:///:memory:')
# 创建数据库和表
db.create_all()
# 创建测试数据，一个用户，一个电影条目
user = User(name='Test', username='******')
user.set_password('123')
movie = Movie(title='Test Movie Title', year='2019')
# 使用 add_all() 方法一次添加多个模型类实例，传入列表
db.session.add_all([user, movie])
db.session.commit()
self.client = app.test_client() # 创建测试客户端
self.runner = app.test_cli_runner() # 创建测试命令运行器
def setUp(self):
"""
更新配置，设置为测试模式，数据库设为内存型数据库
"""
app.config.update(TESTING=True,
SQLALCHEMY_DATABASE_URI='sqlite:///:memory:')
#创建数据库和表
db.create_all()
user = User(name='Test', username='******')
user.set_password('123')
movie = Movie(title='Test Movie Title', year='2019')
db.session.add_all([user, movie])
db.session.commit()
self.client = app.test_client() #创建测试客户端,模拟客户端（浏览器）
self.runner = app.test_cli_runner() #创建测试命令运行器
def admin(username,password):
db.create_all()
user = User.query.first()
if user is not None:
click.echo('更新用户')
user.username = username
user.set_password(password)
else:
click.echo('创建用户')
user = User(username=username,name="Admin")
user.set_password(password)
db.session.add(user)
db.session.commit()
click.echo('创建管理员账号完成')
def forge():
db.create_all()
name = 'Grey Li'
movies = [
{
'title': 'My Neighbor Totoro',
'year': '1988'
},
{
'title': 'Dead Poets Society',
'year': '1989'
},
{
'title': 'A Perfect World',
'year': '1993'
},
{
'title': 'Leon',
'year': '1994'
},
{
'title': 'Mahjong',
'year': '1996'
},
{
'title': 'Swallowtail Butterfly',
'year': '1996'
},
{
'title': 'King of Comedy',
'year': '1999'
},
{
'title': 'Devils on the Doorstep',
'year': '1999'
},
{
'title': 'WALL-E',
'year': '2008'
},
]
user = User(name=name)
for m in movies:
movie = Movie(title=m['title'], year=m['year'])
db.session.add(movie)
db.session.add(user)
db.session.commit()
click.echo('Done')
def admin(username, password):
db.create_all()
user = User.query.first()
if user is not None:
click.echo('更新用户名...')
user.username = username
user.set_password(password)
else:
click.echo('创建新用户...')
user = User(username=username, name='Admin')
user.set_password(password)
db.session.add(user)
db.session.commit()
click.echo('Done.')
def admin(username, password):
db.create_all()
user = User.query.first()
if user is not None: # 用户存在，设置密码
click.echo('Updating user...')
user.user_name = username
user.set_password(password)
else: # 用户不存在，新建并设置密码
click.echo('Creating user...')
user = User(user_name=username, name='Admin')
user.set_password(password)
db.session.add(user)
db.session.commit() # 保存到数据库
click.echo('Done.')
def init(self, request):
app.config.update(TESTING=True,
SQLALCHEMY_DATABASE_URI='sqlite:///:memory:')
db.create_all()
user = User(name='TestName', username='******')
user.set_password('testpassword')
movie = Movie(title='Test Movie Title', year='2019')
db.session.add_all([user, movie])
db.session.commit()
def final():
db.session.remove()
db.drop_all()
request.addfinalizer(final)
def admin(username, password):
"""Create user."""
db.create_all()
user = User.query.first()
if user is not None: # 如果用户存在，则更新相关信息
click.echo('Updating user...')
user.username = username
user.set_password(password)
else: # 用户不存在，创建管理员
click.echo('Creating user...')
user = User(username=username, name='Admin')
user.set_password(password)
db.session.add(user)
db.session.commit()
click.echo('Done.')
def forge():
db.create_all()
name = "Bruce"
ariticles = [
{'title':'张恒家','author':'张恒','pubdate':'2020.03.01','content':'张恒牛皮'},
{'title':'2','author':'2','pubdate':'2','content':'2'},
{'title':'3','author':'3','pubdate':'3','content':'3'},
{'title':'4','author':'4','pubdate':'4','content':'4'},
{'title':'5','author':'5','pubdate':'5','content':'5'}
]
user = User(name=name)
db.session.add(user)
for m in ariticles:
ariticle = Ariticles(title=m['title'],author=m['author'],pubdate=m['pubdate'],content=m['content'])
db.session.add(ariticle)
db.session.commit()
click.echo('数据导入完成')
def forge():
"""Generate fake data."""
db.create_all()
courses = [{
'name': '程序设计基础',
'teacher': '谭光',
'time': '2017-2018学年 第1学期',
'info': 'xxx'
}]
for c in courses:
course = Courses(name=c['name'],
teacher=c['teacher'],
time=c['time'],
info=c['info'])
db.session.add(course)
db.session.commit()
def setUp(self):
"""更新配置"""
app.config.update(TESTING=True,
SQLALCHEMY_DATABASE_URI='sqlite:///:memory:')
db.create_all()
user = User()
user.name = "Test"
user.password = "******"
movie = Movie()
movie.title = "Test Movie"
movie.year = '1900'
db.session.add_all([user, movie])
db.session.commit()
self.client = app.test_client() # 创建测试客户端
self.ruuner = app.test_cli_runner() # 创建测试命令运行器
def admin(username, password):
"""create_user"""
db.create_all()
user = User.query.first()
if user is not None:
click.echo("updating user")
user.name = username
user.password = password
else:
click.echo("create user")
user = User()
user.name = username
user.password = password
db.session.add(user)
db.session.commit()
click.echo("Done.")
def setUp(self): #测试用例调用前执行
#更新配置
app.config.update(
TESTING=True, #开启测试模式
SQLALCHEMY_DATABASE_URI='sqlite:///:memory:' #使用SQLite的内存数据库
)
#创建数据库和表
db.create_all()
#创建测试数据
user = User(name='测试账号', username='******')
user.set_password('123')
movie = Movie(title='Test Movie Title', year='2020')
#使用add_all()方法一次添加多个model类实例，传入列表
db.session.add_all([user, movie])
db.session.commit()
self.client = app.test_client() #创建测试客户端
self.runner = app.test_cli_runner() #创建测试命令运行器
def setUp(self) -> None: # 固定函数，用于进行测试之前的设置
# 更新配置
app.config.update(
TESTING=True, # 打开测试模式
SQLALCHEMY_DATABASE_URI='sqlite:///:memory:' # 使用内存型数据库，不会干扰文件
)
# 创建测试数据库和表
db.create_all()
# 创建测试数据
user = User(name='Test', user_name='test')
user.set_password('123')
movie = Movie(title='Test Movie', year='2020')
db.session.add_all([user, movie])
db.session.commit()
self.client = app.test_client() # 得到一个模拟客户端对象用于测试
self.runner = app.test_cli_runner() # 得到一个命令运行器对象
def admin(username, password):
# Create user.
db.create_all()
user = User.query.first()
if user is not None:
click.echo('Updating user...')
user.username = username
user.set_password(password) # 设置密码
else:
click.echo('Creating user...')
user = User(username=username, name='Admin')
user.set_password(password) # 设置密码
db.session.add(user)
db.session.commit() # 提交数据库会话
click.echo('Done.')
def forge():
db.create_all()
name = 'ZhaoYuChen'
movies = [
{'title': 'My Neighbor Totoro','year': '1998'},
{'title': 'Dead Poets Society','year': '1989'},
{'title': 'Leon','year': '1994'},
{'title': 'A Perfect World','year': '1993'},
]
user = User(name=name)
db.session.add(user)
for m in movies:
movie = Movie(title=m['title'],year=m['year'])
db.session.add(movie)
db.session.commit()
click.echo('Done.')
def forge():
db.create_all()
name = "Bruce"
movies = [
{'title': '流浪地球','content':"小破球的流浪史" ,'author':'吴京','pubdate': '2019'},
{'title': '我和我的祖国','content':"开国大典升旗准战" ,'author':'吴京','pubdate': '2020'},
{'title': '杀破狼2','content':"弘扬正义警匪大战" ,'author':'吴京','pubdate': '2015'},
{'title': '战狼','content':"小人物拯救国家和民族命运" ,'author':'吴京','pubdate': '2015'},
]
user = User(name=name)
db.session.add(user)
for m in movies:
movie = Ariticles(title=m['title'], content=m['content'], author=m['author'],pubdate=m['pubdate'])
db.session.add(movie)
db.session.commit()
click.echo('数据导入完成')
def setUp(self):
#更新配置 在开发和测试时候通常配置不一样
app.config.update(
TESTING=True, #开启测试模式 出错时候不会输出多余消息
SQLALCHEMY_DATABASE_URI='sqlite:///:memory:' #SQLite内存型数据库，不会
)
#创建数据库和表
db.create_all()
#创建测试数据，一个用户，一个电影信息
user = User(name='Test', username='******')
user.set_password('123456')
movie = Movie(title='测试电影名称', year='2020')
db.session.add_all([user, movie])
db.session.commit()
self.client = app.test_client() #创建测试客户端（模拟客户端请求）
self.runner = app.test_cli_runner() #创建测试命令运行期（触发自定义命令）
def forgecat(count):
"""Generate fake messages."""
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 gen_db_data():
db.drop_all()
db.create_all()
users = []
movies = []
for i in range(10):
item = {}
item["title"] = fake.name()
item["year"] = fake.year()
movies.append(item)
for i in range(1):
item = {}
item["name"] = fake.name()
users.append(item)
db.session.bulk_insert_mappings(User, users) # 批量插入数据
db.session.bulk_insert_mappings(Movie, movies)
db.session.commit()
click.echo("data generated!")
def setUp(self):
# 更新配置 在开发和配置的时候通常配置不一样
app.config.update(
TESTING=True, # 开启测试模式 出错的时候不会输出多余信息
SQLALCHEMY_DATABASE_URI=
'sqlite:///:memory:' # SQLite内存性数据库，不会干扰开发时使用的数据库文件
)
# 创建数据库和表
db.create_all()
# 创建测试数据，一个用户，一个电影信息
user = User(name='Test', username='******')
user.set_password('123456')
movie = Ariticles(title='请问', content='请问')
db.session.add_all([user, movie])
db.session.commit()
self.client = app.test_client() # 创建测试客户端（模拟客户端请求）
self.runner = app.test_cli_runner() # 创建测试命令运行器（触发自定义命令）
