def wikipage_add(self):
form = self.wiki_form.render()
if 'submit' in self.request.params:
controls = self.request.POST.items()
try:
appstruct = self.wiki_form.validate(controls)
except deform.ValidationFailure as e:
# Form is NOT valid
return dict(form=e.render())
# Add a new page to the database
new_title = appstruct['title']
new_body = appstruct['body']
DBSession.add(Page(title=new_title, body=new_body))
# Get the new ID and redirect
page = DBSession.query(Page).filter_by(title=new_title).one()
new_uid = page.uid
# Now visit new page
url = self.request.route_url('wikipage_view', uid=new_uid)
return HTTPFound(url)
return dict(form=form)
def _initTestingDB():
from sqlalchemy import create_engine
from tutorial.models import (DBSession, Page, Base)
engine = create_engine('sqlite://')
Base.metadata.create_all(engine)
DBSession.configure(bind=engine)
with transaction.manager:
model = Page('FrontPage', 'This is the front page')
DBSession.add(model)
return DBSession
def add_article(self, item):
a = Article()
a.name = item['name']
a.href = item['link']
a.title = item['title']
session = DBSession()
session.add(a)
session.commit()
session.close()
def _initTestingDB():
from sqlalchemy import create_engine
from tutorial.models import DBSession, Page, Base
engine = create_engine("sqlite://")
Base.metadata.create_all(engine)
DBSession.configure(bind=engine)
with transaction.manager:
model = Page("FrontPage", "This is the front page")
DBSession.add(model)
return DBSession
def add_page(request):
name = request.matchdict['pagename']
if 'form.submitted' in request.params:
session = DBSession()
body = request.params['body']
page = Page(name, body)
session.add(page)
return HTTPFound(location = route_url('view_page', request,
pagename=name))
save_url = route_url('add_page', request, pagename=name)
page = Page('', '')
return dict(page=page, save_url=save_url)
def add_page(request):
name = request.matchdict['pagename']
if 'form.submitted' in request.params:
session = DBSession()
body = request.params['body']
page = Page(name, body)
session.add(page)
return HTTPFound(
location=route_url('view_page', request, pagename=name))
save_url = route_url('add_page', request, pagename=name)
page = Page('', '')
return dict(page=page, save_url=save_url)
def edit_page(request):
name = request.matchdict['pagename']
session = DBSession()
page = session.query(Page).filter_by(name=name).one()
if 'form.submitted' in request.params:
page.data = request.params['body']
session.add(page)
return HTTPFound(location = route_url('view_page', request,
pagename=name))
return dict(
page=page,
save_url = route_url('edit_page', request, pagename=name),
)
def edit_page(request):
name = request.matchdict['pagename']
session = DBSession()
page = session.query(Page).filter_by(name=name).one()
if 'form.submitted' in request.params:
page.data = request.params['body']
session.add(page)
return HTTPFound(
location=route_url('view_page', request, pagename=name))
return dict(
page=page,
save_url=route_url('edit_page', request, pagename=name),
)
def _initTestingDB():
from sqlalchemy import create_engine
from tutorial.models import (
DBSession,
Page,
Base
)
engine = create_engine('sqlite://')
Base.metadata.create_all(engine)
DBSession.configure(bind=engine)
with transaction.manager:
model = Page(name='FrontPage', data='This is the front page')
DBSession.add(model)
return DBSession
def main(argv=sys.argv):
if len(argv) != 2:
usage(argv)
config_uri = argv[1]
setup_logging(config_uri)
settings = get_appsettings(config_uri)
engine = engine_from_config(settings, 'sqlalchemy.')
DBSession.configure(bind=engine)
Base.metadata.create_all(engine)
with transaction.manager:
user=User(name='mohsen',lname='jahndideho',tel='0937239304',email='*****@*****.**',username='******',password='******',semat='test')
nameh=Nameh(nnameh='اداری',mnameh='مرخصی',chnameh='درخواست مرخصی از ریاست',manameh='اابباتاا',recive='jh',ersal="jahandide",tarikher="jun",mohlat="feb",jahat="eghdam",peyvast="no",vaseiyat="T")
p=Paygham(mpayam="hello",ersal="jahandide",img="tutorial\images\jahandide.jpg")
pa=payam(mapyam="hello",mopyam="jkjkjk",ersal='jahandide',recive='jahandideh')
g=groups(usr="******")
e=etela(minfo="hihjgkdsfukfspffsdtffdkjlkl")
erj=moerjah(mer="edgsaaffuuygff'isfdjdf")
DBSession.add(pa)
DBSession.add(g)
DBSession.add(e)
DBSession.add(erj)
DBSession.add(p)
DBSession.add(user)
DBSession.add(nameh)
