def _initTestingDB():
from tutorial.models import DBSession
from tutorial.models import Base
from sqlalchemy import create_engine
engine = create_engine('sqlite://')
DBSession.configure(bind=engine)
Base.metadata.bind = engine
Base.metadata.create_all(engine)
return DBSession
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 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 test_it(self):
from sqlalchemy import create_engine
engine = create_engine('sqlite:///:memory:')
self._callFUT(engine)
from tutorial.models import DBSession, Page
self.assertEqual(DBSession.query(Page).one().data,
'This is the front page')
def view_page(request):
matchdict = request.matchdict
session = DBSession()
page = session.query(Page).filter_by(name=matchdict['pagename']).one()
def check(match):
word = match.group(1)
exists = session.query(Page).filter_by(name=word).all()
if exists:
view_url = route_url('view_page', request, pagename=word)
return '<a href="%s">%s</a>' % (view_url, word)
else:
add_url = route_url('add_page', request, pagename=word)
return '<a href="%s">%s</a>' % (add_url, word)
content = publish_parts(page.data, writer_name='html')['html_body']
content = wikiwords.sub(check, content)
edit_url = route_url('edit_page', request,
pagename=matchdict['pagename'])
return dict(page=page, content=content, edit_url=edit_url)
def view_page(request):
pagename = request.matchdict['pagename']
session = DBSession()
page = session.query(Page).filter_by(name=pagename).first()
if page is None:
return HTTPNotFound('No such page')
def check(match):
word = match.group(1)
exists = session.query(Page).filter_by(name=word).all()
if exists:
view_url = route_url('view_page', request, pagename=word)
return '<a href="%s">%s</a>' % (view_url, word)
else:
add_url = route_url('add_page', request, pagename=word)
return '<a href="%s">%s</a>' % (add_url, word)
content = publish_parts(page.data, writer_name='html')['html_body']
content = wikiwords.sub(check, content)
edit_url = route_url('edit_page', request, pagename=pagename)
logged_in = authenticated_userid(request)
return dict(page=page, content=content, edit_url=edit_url,
logged_in=logged_in)
def test_it(self):
self._callFUT({'sqlalchemy.url':'sqlite://'})
from tutorial.models import DBSession, Page
self.assertEqual(DBSession.query(Page).one().data,
'This is the front page')
def tearDown(self):
from tutorial.models import DBSession
DBSession.remove()
def setUp(self):
from tutorial.models import DBSession
DBSession.remove()
def tearDown(self):
del self.testapp
from tutorial.models import DBSession
DBSession.remove()
def my_view(request):
dbsession = DBSession()
root = dbsession.query(MyModel).filter(MyModel.name==u'root').first()
return {'root':root, 'project':'tutorial'}
def wiki_view(self):
pages = DBSession.query(Page).order_by(Page.title)
return dict(title='Wiki View', pages=pages)
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)
def tearDown(self):
del self.testapp
from tutorial.models import DBSession
DBSession.remove()
