def testdb(loop):
'test class User - add a new user'
print('Create db pool...')
r = yield from orm.create_pool(loop=loop,
host='127.0.0.1',
port=3306,
user='******',
password='******',
db='awesome')
print('r : %s' % r)
# 以下为测试:
print('Create a new user...')
"create a user with fixed <id> and <created_at>"
#u = User(email='*****@*****.**', passwd='password', admin=True, name='testname2', image='blank', id='testid2',created_at='1.0')
"create a user with fixed auto-generated <id> and <created_at>"
u = User(email='*****@*****.**',
passwd='password',
admin=True,
name='testname3',
image='blank',
id=None,
created_at=None) #
print('Save the new user into database...')
r = yield from u.save()
print('r : %s' % r)
def test(loop):
yield from create_pool(loop=loop, user='******', password='******', db='test')
u = User(name='aaa', email='*****@*****.**', passwd='aaa', image='about:blank')
yield from u.save()
# r = yield from u.findAll()
# print(r)
yield from destory_pool()
def test(loop):
#创建连接池
yield from orm.create_pool(loop,user='******',password='******',database='awesome')
#创建对象
u=User(name='Test231',email='test123@wxample',passwd='123456',image='about:blank')
#调用保存方法
yield from u.save()
def init(loop):
yield from orm.create_pool(loop=loop, **configs.db)
app = web.Application(loop=loop, middlewares=[response_factory])
# app.router.add_route()
add_routes(app, 'handlers')
srv = yield from loop.create_server(app.make_handler(), '127.0.0.1', 9000)
logging.info('server started at http://127.0.0.1:9000...')
return srv
def test(loop):
yield from orm.create_pool(loop=loop,
user='******',
password='******',
database='awesome')
u = User(name='Yao',
email='*****@*****.**',
passwd="sas",
image='about:blank')
yield from u.save()
def test(loop):
yield from orm.create_pool(loop=loop,
user='******',
password='******',
db='awesome')
u = User(name='test77',
email='*****@*****.**',
passwd='test',
image='about:blank')
yield from u.save()
def find_test(loop):
yield from orm.create_pool(loop=loop,
host='123.206.178.243',
user='******',
password='******',
db='awesome')
u = yield from User().find(
'001502421565775576b9c8a80e847e3b6ca4f45e5573712000')
print(u)
def init(loop):
yield from orm.create_pool(loop=loop, **configs.db)
app = web.Application(loop=loop, middlewares=[
logger_factory, auth_factory, response_factory
])
init_jinja2(app, filters=dict(datetime=datetime_filter))
add_routes(app, 'handlers')
add_static(app)
srv = yield from loop.create_server(app.make_handler(), '127.0.0.1', 9000)
logging.info('server started at http://127.0.0.1:9000...')
return srv
def test():
yield from orm.create_pool(user='******',
password='******',
database='awesome')
u = User(name='Test',
email='[email protected]',
passwd='123456',
image='about-blank')
yield from u.save()
def testSave():
yield from orm.create_pool(loop,
user='******',
password='******',
db='awesome')
u = User(name='awsome_admin',
email='*****@*****.**',
passwd='1234567890',
image='about:blank',
admin=True)
yield from u.save()
def test():
yield from orm.create_pool(user='******',
password='******',
database='awesome')
u = User(name='Test',
email='*****@*****.**',
passwd='1234567890',
image='about:blank')
yield from u.save()
def init(loop):
yield from orm.create_pool(loop=loop, **configs.db)
app = web.Application(loop=loop, middlewares=[
logger_factory, auth_factory, response_factory
])
init_jinja2(app, filters=dict(datetime=datetime_filter))
add_routes(app, 'handlers')
add_static(app)
srv = yield from loop.create_server(app.make_handler(), '127.0.0.1', 8050)
logging.info('server started at http://127.0.0.1:8050...')
return srv
def test(loop):
db_dict = {'user': '******', 'password': '******', 'db': 'awesome'}
yield from orm.create_pool(loop=loop, **db_dict)
# yield from orm.create_pool(user='******', password='******', database='awesome')
u = User(name='Test',
email='*****@*****.**',
passwd='1234567890',
image='about:blank')
yield from u.save()
yield from orm.destory_pool()
def test(loop):
yield from create_pool(loop=loop,
host='localhost',
port=3306,
user='******',
password='******',
db='awesome')
# user = User(id=1, name='ding')
# yield from user.save()
r = yield from User.find('1')
print(r)
yield from destory_pool()
def save_test(loop):
yield from orm.create_pool(loop=loop,
host='123.206.178.243',
user='******',
password='******',
db='awesome')
u = User(name='sanji',
email='*****@*****.**',
passwd='123123',
image='about:blank')
yield from u.save()
def test(loop):
yield from orm.create_pool(loop=loop,
user='******',
password='******',
database='awesome')
u = User(admin=True,
name='kHRYSTAL',
email='*****@*****.**',
passwd=hashlib.sha1(
('%s:%s' %
(next_id(), 'yyg1990918')).encode('utf-8')).hexdigest(),
image='about:blank')
yield from u.save()
def test(loop):
yield from orm.create_pool(loop=loop,
host='127.0.0.1',
port=3306,
user='******',
password='******',
db='awesome')
user = User(name='Test',
email='*****@*****.**',
passwd='123456',
image='ablout:blank')
print('-------create finish-----------')
user.show()
yield from user.save()
yield from orm.destory_pool()
def init(loop):
# 创建数据库连接池，db参数传配置文件里边的db
yield from orm.create_pool(loop=loop, **configs.db)
# middlewares 设置两个中间处理函数
# middlewares 中的每个factory接收两个参数，app和handler，即middlewares中下一个handler
# middlewares 的最后一个元素的 handler会通过routes查找到相应的 routes注册的handler
app = web.Application(loop=loop, middlewares=[logger_factory, auth_factory, response_factory])
# 初始化 jinja2模板
init_jinja2(app, filters=dict(datetime=datetime_filter))
# 添加请求的 handlers，即各个请求相对应的处理函数
add_routes(app, 'handlers')
# 添加静态文件所在地址
add_static(app)
# 启动服务器
srv = yield from loop.create_server(app.make_handler(), '127.0.0.1', 9000)
logging.info('server started at http://127.0.0.1:9000...')
return srv
def test(loop, **kw):
yield from orm.create_pool(loop=loop,
user='******',
password='******',
db='awesome')
u = User(name=kw.get('name'),
email=kw.get('email'),
passwd=kw.get('passwd'),
image=kw.get('image'))
yield from u.save()
yield from orm.destory_pool()
# data=dict(name='gaf', email='*****@*****.**', passwd='1312345', image='about:blank')
# loop=asyncio.get_event_loop()
# loop.run_until_complete(test(loop,**data))
# loop.close()
def create_server(loop, config_mod_name):
config = __import__(config_mod_name, fromlist=["config", "config_default"])
#print(config.config_default.configs["db"])
yield from orm.create_pool(loop=loop,
**config.config_default.configs["db"])
app = web.Application(loop=loop,
middlewares=[
logger_factory, auth_factory, data_factory,
response_factory
])
init_jinja2(app, filters=dict(datetime=datetime_filter))
add_routs(app, "handlers")
add_routs(app, "apis")
add_static(app)
srv = yield from loop.create_server(app.make_handler(), '127.0.0.1', 9000)
logging.info('server started at http://127.0.0.1:9000...')
return srv
def init(loop):
yield from orm.create_pool(loop=loop,
host='127.0.0.1',
port=3306,
user='******',
password='******',
db='awesome')
app = web.Application(
loop=loop,
middlewares=[logger_factory, auth_factory, response_factory])
init_jinja2(app, filters=dict(datetime=datetime_filter))
add_routes(app, 'handlers')
add_static(app)
srv = yield from loop.create_server(app.make_handler(), '127.0.0.1', 9000)
logging.info('server started at http://127.0.0.1:9000...')
return srv
def testdb():
'test orm and database connection'
# 以下为测试:
loop = asyncio.get_event_loop()
loop.run_until_complete(
orm.create_pool(loop=loop,
host='127.0.0.1',
port=3306,
user='******',
password='******',
db='awesome'))
#rs = loop.run_until_complete(orm.select('select `id` from users', None))
args = [
'*****@*****.**', 'password', True, 'testname', 'blank', '1.0', 'testid'
]
rs = loop.run_until_complete(
orm.execute(
'insert into `users` (`email`,`passwd`,`admin`,`name`,`image`,`created_at`, `id`) values (?,?,?,?,?,?,?)',
args))
# 获取到了数据库返回的数据
print("rs:%s" % rs)
pass
def init(loop):
# yield from www.orm.create_pool(loop=loop,host='127.0.0.1',port =3306,user='******',password='******',db='awesome')
yield from orm.create_pool(loop=loop, **configs.db)
# handlers: url对应的内容 middlewares：根据内容的类型决定具体返回的形式
app = web.Application(
loop=loop,
middlewares=[
# logger_factory, response_factory
logger_factory,
auth_factory,
response_factory
])
# jinja2的filter（过滤器）
init_jinja2(app, filters=dict(datetime=datetime_filter))
add_routes(app, 'handlers') # 与handlers.py 文件名一致
add_static(app)
srv = yield from loop.create_server(app.make_handler(), '127.0.0.1', 9090)
logging.info('server started at http://127.0.0.1:9090...')
return srv
def test(loop, x):
yield from orm.create_pool(user='******', password='', database='awesome', loop=loop)
u = User(name='Test%d' % x, email='*****@*****.**' % x, passwd='123456', image='about:blank')
yield from u.save()
def test():
yield from orm.create_pool(host=DB_HOST, user=DB_USER, password=DB_PASSWORD, port=DB_PORT, db=DB_NAME)
for x in range(10):
u = model.User(name='Test%s' % x, email='*****@*****.**' % x, passwd='1234567890', image='about:blank')
yield from u.save()
def test():
yield from orm.create_pool(user='******', password='******', database='awesome')
u = user(name='test', email='*****@*****.**', passwd='test', image='about:blank')
yield from u.save()
def create_pool(loop):
yield from orm.create_pool(loop=loop,
host='123.206.178.243',
user='******',
password='******',
db='awesome')
async def testDelete(uid):
u = await User.find(uid)
await Blog.deleteAll(user_id=uid)
blogs = await u.getBlogs()
print(blogs)
async def creCom(uid):
blogs = await Blog.findAll(user_id=uid)
for b in blogs:
await b.comments_random()
co = await b.getCommentsWrapped()
print(co)
async def initialize():
await init()
u = User.user_random()
await u.save()
print(u.id)
await loadBlogs(u.id)
loop = asyncio.get_event_loop()
loop.run_until_complete(
create_pool(user=config['user'],
password=config['password'],
db=config['db'],
loop=loop))
loop.run_until_complete(initialize())
def test(loop):
yield from orm.create_pool(loop=loop, user='******', password='******', database='awesome')
u=User(name='Yao', email='*****@*****.**', passwd="sas", image='about:blank')
yield from u.save()
def test(loop):
yield from orm.create_pool(loop=loop, user='******', password='******', db='awesome')
u = User(name='Won', email='*****@*****.**', passwd='1234567890', image='about:blank')
yield from u.save()
def test(loop):
yield from orm.create_pool(loop=loop, user='******', password='******', database='awesome')
u=User(admin=True, name='kHRYSTAL', email='*****@*****.**', passwd=hashlib.sha1(('%s:%s' % (next_id(), 'yyg1990918')).encode('utf-8')).hexdigest(), image='about:blank')
yield from u.save()
def test(loop):
yield from orm.create_pool(loop, user='******', password='******', database='awesome_study')
u = User(name='Test', email='*****@*****.**', passwd='1234567890', image='about:blank')
yield from u.save()