Hi,
Your latest plugin looks great and I am eager to learn more about it.
However, I got some errors when I installed web2py.app.PowerGrid.w2p
and tried to run it:
Traceback (most recent call last):
File "/home/xa21/workspace/web2py/gluon/restricted.py", line 192, in
restricted
exec ccode in environment
File "/home/xa21/workspace/web2py/applications/pgrid/controllers/
default.py", line 982, in <module>
File "/home/xa21/workspace/web2py/gluon/globals.py", line 137, in
<lambda>
self._caller = lambda f: f()
File "/home/xa21/workspace/web2py/applications/pgrid/controllers/
default.py", line 18, in index
if auth.has_membership('admin'):
File "/home/xa21/workspace/web2py/gluon/tools.py", line 2627, in
has_membership
group_id = self.id_group(group_id) # interpret group_id as a role
File "/home/xa21/workspace/web2py/gluon/tools.py", line 2603, in
id_group
rows = self.db(self.settings.table_group.role == role).select()
File "/home/xa21/workspace/web2py/gluon/dal.py", line 5394, in
select
return self.db._adapter.select(self.query,fields,attributes)
File "/home/xa21/workspace/web2py/gluon/dal.py", line 1176, in
select
rows = response(sql)
File "/home/xa21/workspace/web2py/gluon/dal.py", line 1166, in
response
self.execute(sql)
File "/home/xa21/workspace/web2py/gluon/dal.py", line 1251, in
execute
return self.log_execute(*a, **b)
File "/home/xa21/workspace/web2py/gluon/dal.py", line 1246, in
log_execute
ret = self.cursor.execute(*a,**b)
DatabaseError: malformed database schema (comments) - near "by":
syntax error
I'm running web2py Version 1.97.1 (2011-06-26 19:25:44) and Python
2.5.2: /usr/bin/python
- Any suggestions?
Thanks, - Tom
On Jul 22, 4:35 pm, Bruno Rocha <rochacbr...@gmail.com> wrote:
> Hi,
>
> I present you PowerGrid Plugin (now in beta 0.1)
> [http://labs.blouweb.com/PowerGrid/]
>
> What is it?
>
> A plugin to show, manage and paginate data
> It works with paginated JSON callbacks, you can use web2py DAL's Query or
> Table, or you can create your own callback returning the desired JSON or
> JSONP
>
> What is has in special?
> - Based on Jquery templates
> - Server side pagination loads records on demand
> - Ajax Caching option
> - Programable in pure Python & web2py
> - You can pass JS callbacks to the event handlers
> - Can show images with Virtual Fields
> - has button system
> - totally integrated with CRUD
> - Easy to integrate with Auth
> - Can be used to manage a site content (a CMS admin page)
> - can be used to create any kind of paginated data view
>
> Changelog:
> - Some issues solved
> - Tested in Windows, Linux, I.E, Opera, Chrome, FF
> - Better default layout
>
> Beta:
> - Needs tests with different datasources
> - Need to be tested on GAE
> - Need to test multiple on the same page
> - Need to test wotking with another UI libs
>
> EXAMPLES:
> images -http://labs.blouweb.com/PowerGrid/default/withimages
> dataGRid -http://labs.blouweb.com/PowerGrid/default/onlydata
> Buttons -http://labs.blouweb.com/PowerGrid/default/buttons
> Scrolling -http://labs.blouweb.com/PowerGrid/default/scroll
> Customization:http://labs.blouweb.com/PowerGrid/default/nocontrol/http://labs.blouweb.com/PowerGrid/default/noadd/http://labs.blouweb.com/PowerGrid/default/nosearch
> Default search
> system:http://labs.blouweb.com/PowerGrid/default/defaultsearch?what=Ferrari&;...
> SubGrids:http://labs.blouweb.com/PowerGrid/default/gridinpopup
> JavaScript callbacks:http://labs.blouweb.com/PowerGrid/default/jscallbacks
> Custom templates:http://labs.blouweb.com/PowerGrid/default/blog(a blog
> created with it)
>
> DOCUMENTATION:
> Is being writen in home pagehttp://labs.blouweb.com/PowerGrid/default/index(in
> the grid)
> source example app is well commented with options.
>
> IT USES:http://labs.blouweb.com/PowerGrid/default/about
>
> Comments:http://labs.blouweb.com/PowerGrid/default/support
>
> Get it:http://labs.blouweb.com/PowerGrid/default/get
>
> !!! BETA VERSION, SOME THINGS CAN CRASH, THE SERVER IS A BIT SLOW, IT WILL
> BE VERY MORE QUICKLY IN A GOOD SERVER OR GAE !!!
>
> Thanks if you can test and report on BitBucker or omments page.
>
> Bruno Rocha
> [ About me:http://zerp.ly/rochacbruno]
> [ Aprenda a programar:http://CursoDePython.com.br]
> [ O seu aliado nos cuidados com os animais:http://AnimalSystem.com.br]
> [ Consultoria em desenvolvimento web:http://www.blouweb.com]
