bump up. I am still stuck with the problem. any solutions?
On Feb 2, 6:27 pm, alind sharma <[email protected]> wrote: > I am getting this error while using dojo for move demo > > TypeError: Sorry, your collection type is not supported by the paginate > module. You can provide a list, a tuple, a SQLAlchemy " "select object or a > SQLAlchemy ORM-query object. > > =========Here is the model===== > > # -*- coding: utf-8 -*- > """Sample model module.""" > > from sqlalchemy import * > from sqlalchemy.orm import mapper, relation > from sqlalchemy import Table, ForeignKey, Column > from sqlalchemy.types import Integer, Unicode > #from sqlalchemy.orm import relation, backref > from moviedemo.model import DeclarativeBase, metadata, DBSession > from sqlalchemy.orm import relation > > from moviedemo.model import DeclarativeBase, metadata > > class Movie(DeclarativeBase): > __tablename__ = "movies" > movie_id = Column(Integer, primary_key=True) > #title = Column(String(100), nullable=False) > description = Column(Text, nullable=True) > #release_date = Column(Date, nullable=True) > > === HEre is thecontroller ==== > > # -*- coding: utf-8 -*- > """Main Controller""" > > from formencode.validators import Int, NotEmpty, DateConverter, > DateValidator > from moviedemo import model > from moviedemo.controllers.error import ErrorController > from moviedemo.controllers.secure import SecureController > from moviedemo.lib.base import BaseController > from moviedemo.model import DBSession, Movie > from moviedemo.model import DBSession, metadata > from repoze.what import predicates > > from sprox.dojo.fillerbase import DojoTableFiller as TableFiller > #from sprox.fillerbase import TableFiller > > from sprox.dojo.tablebase import DojoTableBase as TableBase > #from sprox.tablebase import TableBase > > #from sprox.fillerbase import EditFormFiller > > from sprox.dojo.formbase import DojoAddRecordForm as AddRecordForm > #from sprox.formbase import AddRecordForm > > from sprox.dojo.formbase import DojoEditableForm as EditableForm > #from sprox.formbase import EditableForm > > from tg import expose, flash, require, url, request, redirect, validate > from tg import tmpl_context, request > from tg.i18n import ugettext as _, lazy_ugettext as l_ > from tgext.admin.controller import AdminController > from tgext.admin.tgadminconfig import TGAdminConfig > from tgext.crud import CrudRestController > from tw.core import WidgetsList > from tw.forms import TableForm, TextField, CalendarDatePicker, > SingleSelectField, TextArea > __all__ = ['RootController'] > > class DeclarativeMovieController(CrudRestController): > model = Movie > > # class new_form_type(AddRecordForm): > # __model__ = Movie > # __omit_fields__ = ['genre_id', 'movie_id'] > # > # class edit_form_type(EditableForm): > # __model__ = Movie > # __omit_fields__ = ['genre_id', 'movie_id'] > # > # class edit_filler_type(EditFormFiller): > # __model__ = Movie > > class table_type(TableBase): > __model__ = Movie > __omit_fields__ = ['genre_id', 'movie_id'] > > class table_filler_type(TableFiller): > __model__ = Movie > > class RootController(BaseController): > """ > The root controller for the moviedemo application. > > All the other controllers and WSGI applications should be mounted on > this > controller. For example:: > > panel = ControlPanelController() > another_app = AnotherWSGIApplication() > > Keep in mind that WSGI applications shouldn't be mounted directly: They > must be wrapped around with :class:`tg.controllers.WSGIAppController`. > > """ > secc = SecureController() > admin = AdminController(model, DBSession, config_type=TGAdminConfig) > > error = ErrorController() > movie = DeclarativeMovieController(DBSession) > > @expose('moviedemo.templates.index') > def index(self): > """Handle the front-page.""" > return dict(page='index') > > @expose('moviedemo.templates.about') > def about(self): > """Handle the 'about' page.""" > return dict(page='about') > > @expose('moviedemo.templates.environ') > def environ(self): > """This method showcases TG's access to the wsgi environment.""" > return dict(environment=request.environ) > > @expose('moviedemo.templates.data') > @expose('json') > def data(self, **kw): > """This method showcases how you can use the same controller for a > data page and a display page""" > return dict(params=kw) > @expose('moviedemo.templates.authentication') > def auth(self): > """Display some information about auth* on this application.""" > return dict(page='auth') > > @expose('moviedemo.templates.index') > @require(predicates.has_permission('manage', msg=l_('Only for > managers'))) > def manage_permission_only(self, **kw): > """Illustrate how a page for managers only works.""" > return dict(page='managers stuff') > > @expose('moviedemo.templates.index') > @require(predicates.is_user('editor', msg=l_('Only for the editor'))) > def editor_user_only(self, **kw): > """Illustrate how a page exclusive for the editor works.""" > return dict(page='editor stuff') > > @expose('moviedemo.templates.login') > def login(self, came_from=url('/')): > """Start the user login.""" > login_counter = request.environ['repoze.who.logins'] > if login_counter > 0: > flash(_('Wrong credentials'), 'warning') > return dict(page='login', login_counter=str(login_counter), > came_from=came_from) > > @expose() > def post_login(self, came_from='/'): > """ > Redirect the user to the initially requested page on successful > authentication or redirect her back to the login page if login > failed. > > """ > if not request.identity: > login_counter = request.environ['repoze.who.logins'] + 1 > redirect('/login', > params=dict(came_from=came_from, __logins=login_counter)) > userid = request.identity['repoze.who.userid'] > flash(_('Welcome back, %s!') % userid) > redirect(came_from) > > @expose() > def post_logout(self, came_from=url('/')): > """ > Redirect the user to the initially requested page on logout and say > goodbye as well. > > """ > flash(_('We hope to see you soon!')) > redirect(came_from) > > ==== > Thanks and Regards, > > |== Alind Sharma ==| -- You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/turbogears?hl=en.
