def init(): session = DBSession() t1 = Template(name=u'新闻模板', index_file='news_index.html',\ list_file='news_list.html', display_file='news_display.html') t2 = Template(name=u'职位模板', index_file='job_index.html',\ list_file='job_list.html', display_file='job_display.html') session.add(t1) session.add(t2) session.commit()
def init(): session = DBSession() admin = User(username='******', email='*****@*****.**') admin.set_password('123456') admin.is_active=True admin.is_superuser=True ahao = User(username='******', email='*****@*****.**') ahao.set_password('123456') session.add(admin) session.add(ahao) session.commit()
def init(): session = DBSession() #m1 = session.query(Model).get(1) #m2 = session.query(Model).get(2) c1 = Category(name=u'新闻', slug='news') #c1.model = m2 c2 = Category(name=u'国内新闻', slug='natnews') c2.parent = c1 #c2.model = m2 c3 = Category(name=u'猎头职位', slug='medicine_jobs') #c3.model = m1 session.add(c1) session.add(c2) session.add(c3) session.commit()
def init(): session = DBSession() t1 = session.query(Template).filter_by(name=u'新闻模板').first() t2 = session.query(Template).filter_by(name=u'职位模板').first() job = Model(name='job', title=u'职位') job.template = t2 #title = Field(name='title', title=u'名称', type='string', length=32, required=True) point = Field(name='point', title=u'点击数', type='integer') content1 = Field(name='content', title=u'内容', type='text') #session.add(title) session.add(point) session.add(content1) #job.fields.append(title) job.fields.append(point) job.fields.append(content1) #r1 = Relation(name='user', title=u'创建者', type='many-to-one', target='User', backref='jobs') #r2 = Relation(name='categories', title=u'栏目', type='many-to-many', target='Category', backref='jobs') #session.add(r1) #session.add(r2) #job.relations.append(r1) #job.relations.append(r2) session.add(job) news = Model(name='news', title=u'新闻') news.template = t1 #title = Field(name='title', title=u'标题', type='string', length=32, required=True) keywords = Field(name='keywords', title=u'关键词', type='string', length=64) summary = Field(name='summary', title=u'摘要', type='string', length=255) content2 = Field(name='content', title=u'内容', type='text') #session.add(title) session.add(keywords) session.add(summary) session.add(content2) #news.fields.append(title) news.fields.append(keywords) news.fields.append(summary) news.fields.append(content2) #r3 = Relation(name='user', title=u'创建者', type='many-to-one', target='User', backref='news') #r4 = Relation(name='categories', title=u'栏目', type='many-to-many', target='Category', backref='news') #session.add(r3) #session.add(r4) #news.relations.append(r3) #news.relations.append(r4) session.add(news) session.commit()
def create(): session = DBSession() model = session.query(Model).get(1) model_cls = build_model(model) create_table(model_cls)
def drop(): session = DBSession() model = session.query(Model).get(1) model_cls = build_model(model) drop_table(model_cls)
def init(): session = DBSession() p1=Permission(u'内容', 'content') p2=Permission(u'用户', 'user') #p11=Permission(u'内容管理', 'content_admin') #p11.parent=p1 p111=Permission(u'实体管理', 'entity_index') p111.parent=p1 p112=Permission(u'栏目管理', 'category_index') p112.parent=p1 p113=Permission(u'模型管理', 'model_index') p113.parent=p1 p114=Permission(u'模板管理', 'template_index') p114.parent=p1 p115=Permission(u'发布管理', 'publish_index') p115.parent=p1 #p21=Permission(u'用户管理', 'user_admin') #p21.parent=p2 p211=Permission(u'用户管理', 'user_index') p211.parent=p2 p212=Permission(u'组管理', 'group_index') p212.parent=p2 session.add(p1) session.add(p2) #session.add(p11) session.add(p111) session.add(p112) session.add(p113) session.add(p114) session.add(p115) #session.add(p21) session.add(p211) session.add(p212) session.commit()