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)