__author__ = 'xieshaoxin'
from models import User, Blog, Comment
from transwrap import db
db.create_engine(user='******', passwd='root', database='blog')
u = User(name='Test', email='*****@*****.**', passwd='1234567890', image='about:blank')
u.insert()
print 'new user id:', u.id
u1 = User.find_first('where email=?', '*****@*****.**')
print 'find user\'s name:', u1.name
u1.delete()
u2 = User.find_first('where email=?', '*****@*****.**')
print 'find user:', u2
from models import User, Blog, Comment
from transwrap import db
db.create_engine(user='******',password='******',database='awesome',host='192.168.166.30',port=3359)
u = User(name='Test',email='*****@*****.**',password='******',image='blank')
u.insert()
print 'new user id:',u.id
u1 = User.find_first('where email=?','*****@*****.**')
print u1
content = TextField()
created_at = FloatField(updatable=False, default=time.time)
class Comment(Model):
__table__ = 'comments'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
blog_id = StringField(updatable=False, ddl='varchar(50)')
user_id = StringField(updatable=False, ddl='varchar(50)')
user_name = StringField(ddl='varchar(50)')
user_image = StringField(ddl='varchar(500)')
content = TextField()
created_at = FloatField(updatable=False, default=time.time)
if __name__ == '__main__':
from transwrap.db import create_engine, select_one, select
create_engine('root', 'zhengyi', 'awesome')
import hashlib
useradmin = User(name = 'zhengyiadmin',
email='*****@*****.**',
password=hashlib.md5('zhengyiadmin').hexdigest(),
admin=True)
useradmin.insert()
# 1、修改数据库不完整关系；
'''
1、删除comments里blog_id指向为空的comments：
delete from comments where comments.blog_id not in
(select id from blogs);
2、删除comments里user_id指向为空的：
delete from comments where comments.user_id not in
(select id from users);
template_engine.add_filter('datetime', datetime_filter)
wsgi.template_engine = template_engine
import urls
#wsgi.add_interceptor(urls.user_interceptor)
#wsgi.add_interceptor(urls.manage_interceptor)
wsgi.add_module(urls)
if __name__ == "__main__":
# init db:
db.create_engine(**configs['db'])
wsgi.run()
else:
import sae
import sae.const
import os
import sys
root = os.path.dirname(__file__)
# 两者取其一
sys.path.insert(0, os.path.join(root, 'site-packages'))
db.create_engine(user=sae.const.MYSQL_USER, passwd=sae.const.MYSQL_PASS, database=sae.const.MYSQL_DB, port=int(sae.const.MYSQL_PORT), host=sae.const.MYSQL_HOST)
application = sae.create_wsgi_app(wsgi.get_wsgi_application())
template_engine = Jinja2TemplateEngine(
os.path.join(os.path.dirname(os.path.abspath(__file__)), 'templates'))
template_engine.add_filter('datetime', datetime_filter)
wsgi.template_engine = template_engine
import urls
#wsgi.add_interceptor(urls.user_interceptor)
#wsgi.add_interceptor(urls.manage_interceptor)
wsgi.add_module(urls)
if __name__ == "__main__":
# init db:
db.create_engine(**configs['db'])
wsgi.run()
else:
import sae
import sae.const
import os
import sys
root = os.path.dirname(__file__)
# 两者取其一
sys.path.insert(0, os.path.join(root, 'site-packages'))
db.create_engine(user=sae.const.MYSQL_USER,
passwd=sae.const.MYSQL_PASS,
database=sae.const.MYSQL_DB,
port=int(sae.const.MYSQL_PORT),
__author__ = 'Excelle'
from model import User, Blog, Comment
from transwrap import db
from config import config
db.create_engine(config.mysql_username, config.mysql_password, config.mysql_database)
u = User(id='test', email='*****@*****.**', password='******', image='about:blank', name='Wajueji')
u.insert()
print('New UID:'+u.id)
u1 = User.find_first('where email=?', '*****@*****.**')
print 'find user\'s name:', u1.name
u1.delete()
u2 = User.find_first('where email=?', '*****@*****.**')
print 'find user:', u2
def datetime_filter(t):
delta = int(time.time() - t)
if delta < 60:
return u'1分钟前'
if delta < 3600:
return u'%s分钟前' % (delta // 60)
if delta < 86400:
return u'%s小时前' % (delta // 3600)
if delta < 604800:
return u'%s天前' % (delta // 86400)
dt = datetime.fromtimestamp(t)
return u'%s年%s月%s日' % (dt.year, dt.month, dt.day)
# init db:
db.create_engine(**configs.db)
# init wsgi app:
wsgi = WSGIApplication(os.path.dirname(os.path.abspath(__file__)))
template_engine = Jinja2TemplateEngine(os.path.join(os.path.dirname(os.path.abspath(__file__)), 'templates'))
template_engine.add_filter('datetime', datetime_filter)
wsgi.template_engine = template_engine
import urls
wsgi.add_interceptor(urls.user_interceptor)
wsgi.add_interceptor(urls.manage_interceptor)
wsgi.add_module(urls)
#test_db.py
__author__='Tony Xu'
from models import User,Blog,Comment
from transwrap import db
db.create_engine(user='******',password='******',database='awesome')
u = User(name='Test',email='*****@*****.**',password='******',image='about:blank')
u.insert()
print 'new user id:',u.id
u1 = User.find_first('where email=?','*****@*****.**')
print 'find user\'s name:' ,u1.name
u1.delete()
u2=User.find_first('where email=?','*****@*****.**')
print 'find user:',u2
