FastData replacement

View: New views
14 Messages — Rating Filter:   Alert me  

FastData replacement

by SRA :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

What's the best widget to use to replace FastData with SA (SQLAlchemy) and Kid (if any)?
I'm searching for a widget which supports localization and field ordering.

The project http://svn.turbogears.org/projects/FastData2 seems dead.
Which widget will be included in TG 1.1?

I'm tried to use dbsprockets.primitives and Genshi but the previous issues aren't resolved (localization and field ordering).

Thanks,
Stéphane


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: FastData replacement

by Lukasz Szybalski :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Tue, Jun 17, 2008 at 4:38 AM, Stéphane Raimbault
<stephane.raimbault@...> wrote:

> Hi,
>
> What's the best widget to use to replace FastData with SA (SQLAlchemy) and
> Kid (if any)?
> I'm searching for a widget which supports localization and field ordering.
>
> The project http://svn.turbogears.org/projects/FastData2 seems dead.
> Which widget will be included in TG 1.1?
>
> I'm tried to use dbsprockets.primitives and Genshi but the previous issues
> aren't resolved (localization and field ordering).
>

try paginate, but you will need to create a widget do.

http://docs.turbogears.org/1.0/PaginateDecorator
http://lucasmanual.com/mywiki/TurboGears#head-6246bb14d7d099b71b68760735be7252686c8cae




--
Where was my car manufactured?
http://cars.lucasmanual.com/vin
TurboGears Manual-Howto
http://lucasmanual.com/pdf/TurboGears-Manual-Howto.pdf

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: FastData replacement

by SRA :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

2008/6/17 Lukasz Szybalski <szybalski@...>:
On Tue, Jun 17, 2008 at 4:38 AM, Stéphane Raimbault
<stephane.raimbault@...> wrote:
> Hi,
>
> What's the best widget to use to replace FastData with SA (SQLAlchemy) and
> Kid (if any)?
> I'm searching for a widget which supports localization and field ordering.
>
> The project http://svn.turbogears.org/projects/FastData2 seems dead.
> Which widget will be included in TG 1.1?
>
> I'm tried to use dbsprockets.primitives and Genshi but the previous issues
> aren't resolved (localization and field ordering).
>

try paginate, but you will need to create a widget do.

http://docs.turbogears.org/1.0/PaginateDecorator
http://lucasmanual.com/mywiki/TurboGears#head-6246bb14d7d099b71b68760735be7252686c8cae


I try to use paginate so I reused the code from
http://docs.turbogears.org/1.0/PaginateDecorator?action=AttachFile&do=get&target=pagedemo1.tar.gz

with the following changes
http://paste.turbogears.org/paste/2885

The example is dead simple but doesn't work with SA, the links are present and a new URL is generated at each click but without any effects on the ordering.

Do you have any idea?

Stéphane

PS : persons = session.query(Person).all()


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: FastData replacement

by Lukasz Szybalski :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Tue, Jun 17, 2008 at 3:57 PM, Stéphane Raimbault
<stephane.raimbault@...> wrote:

> 2008/6/17 Lukasz Szybalski <szybalski@...>:
>>
>> On Tue, Jun 17, 2008 at 4:38 AM, Stéphane Raimbault
>> <stephane.raimbault@...> wrote:
>> > Hi,
>> >
>> > What's the best widget to use to replace FastData with SA (SQLAlchemy)
>> > and
>> > Kid (if any)?
>> > I'm searching for a widget which supports localization and field
>> > ordering.
>> >
>> > The project http://svn.turbogears.org/projects/FastData2 seems dead.
>> > Which widget will be included in TG 1.1?
>> >
>> > I'm tried to use dbsprockets.primitives and Genshi but the previous
>> > issues
>> > aren't resolved (localization and field ordering).
>> >
>>
>> try paginate, but you will need to create a widget do.
>>
>> http://docs.turbogears.org/1.0/PaginateDecorator
>>
>> http://lucasmanual.com/mywiki/TurboGears#head-6246bb14d7d099b71b68760735be7252686c8cae
>>
>
> I try to use paginate so I reused the code from
> http://docs.turbogears.org/1.0/PaginateDecorator?action=AttachFile&do=get&target=pagedemo1.tar.gz
>
> with the following changes
> http://paste.turbogears.org/paste/2885
>
> The example is dead simple but doesn't work with SA, the links are present
> and a new URL is generated at each click but without any effects on the
> ordering.

http://groups.google.com/group/turbogears/browse_thread/thread/6ff1686afae966ee

able_grid = PaginateDataGrid(name='my big results',
    fields=[
        PaginateDataGrid.Column('ID', 'id', 'columnHeaderToDisplay',
options=dict(sortable=True)),
        PaginateDataGrid.Column('Groupname', 'group_name',
'columnHeaderToDisplay', options=dict(sortable=True)),
        PaginateDataGrid.Column('Last Name', 'last_name',
'columnHeaderToDisplay', options=dict(sortable=True)),
        PaginateDataGrid.Column('Members', 'num_members',
'columnHeaderToDisplay', options=dict(sortable=True))
])

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: FastData replacement

by Paul Johnston :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


Hi,

> What's the best widget to use to replace FastData with SA (SQLAlchemy)
> and Kid (if any)?
> I'm searching for a widget which supports localization and field ordering.

There isn't a good replacement at the moment. ToscaWidgets include
fieldfactory, which does some of FastData for SQLAlchemy, but not all.
There's also dbsprockets, which I have been meaning to look at for ages,
but haven't as yet.

This is a known development area for TG.

Paul


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: FastData replacement

by SRA :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

2008/6/17 Lukasz Szybalski <szybalski@...>:

http://groups.google.com/group/turbogears/browse_thread/thread/6ff1686afae966ee

able_grid = PaginateDataGrid(name='my big results',
   fields=[
       PaginateDataGrid.Column('ID', 'id', 'columnHeaderToDisplay',
options=dict(sortable=True)),
       PaginateDataGrid.Column('Groupname', 'group_name',
'columnHeaderToDisplay', options=dict(sortable=True)),
       PaginateDataGrid.Column('Last Name', 'last_name',
'columnHeaderToDisplay', options=dict(sortable=True)),
       PaginateDataGrid.Column('Members', 'num_members',
'columnHeaderToDisplay', options=dict(sortable=True))
])

Lukasz,

Do you see any difference with my test code?

 sortable_person_list = PaginateDataGrid(
            fields=[
                PaginateDataGrid.Column('name', 'name', 'Name',
                                        options=dict(sortable=True)),
                PaginateDataGrid.Column('age', 'age', 'Age',
                                        options=dict(sortable=True)),
                ])




--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: FastData replacement

by SRA :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

2008/6/18 Stéphane Raimbault <stephane.raimbault@...>:
2008/6/17 Lukasz Szybalski <szybalski@...>:

http://groups.google.com/group/turbogears/browse_thread/thread/6ff1686afae966ee

able_grid = PaginateDataGrid(name='my big results',
   fields=[
       PaginateDataGrid.Column('ID', 'id', 'columnHeaderToDisplay',
options=dict(sortable=True)),
       PaginateDataGrid.Column('Groupname', 'group_name',
'columnHeaderToDisplay', options=dict(sortable=True)),
       PaginateDataGrid.Column('Last Name', 'last_name',
'columnHeaderToDisplay', options=dict(sortable=True)),
       PaginateDataGrid.Column('Members', 'num_members',
'columnHeaderToDisplay', options=dict(sortable=True))
])

Lukasz,

Do you see any difference with my test code?

 sortable_person_list = PaginateDataGrid(
            fields=[
                PaginateDataGrid.Column('name', 'name', 'Name',
                                        options=dict(sortable=True)),
                PaginateDataGrid.Column('age', 'age', 'Age',
                                        options=dict(sortable=True)),
                ])

As previously said, this code works for me with SQLObject but not with SQLAlchemy.

Stéphane


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: FastData replacement

by Christoph Zwerschke :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


Stéphane Raimbault schrieb:
>      sortable_person_list = PaginateDataGrid(
> ...
> As previously said, this code works for me with SQLObject but not with
> SQLAlchemy.

Did you test with the SVN head of the TG 1.0 branch or with the last
release? paginate has been much improved, particularly SQLAlchemy
support, after 1.0.4.4. This will be available in 1.0.4.5 coming soon.

-- Christoph

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: FastData replacement

by SRA :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

2008/6/18 Christoph Zwerschke <cito@...>:

Stéphane Raimbault schrieb:
>      sortable_person_list = PaginateDataGrid(
> ...
> As previously said, this code works for me with SQLObject but not with
> SQLAlchemy.

Did you test with the SVN head of the TG 1.0 branch or with the last
release? paginate has been much improved, particularly SQLAlchemy
support, after 1.0.4.4. This will be available in 1.0.4.5 coming soon.

-- Christoph

The new release (1.0.5) fixes the bug. Awesome !
Thank you.

Stéphane
 


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: FastData replacement

by Florent Aide :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On Wed, Jul 2, 2008 at 12:08 PM, Stéphane Raimbault
<stephane.raimbault@...> wrote:

> 2008/6/18 Christoph Zwerschke <cito@...>:
>>
>> Did you test with the SVN head of the TG 1.0 branch or with the last
>> release? paginate has been much improved, particularly SQLAlchemy
>> support, after 1.0.4.4. This will be available in 1.0.4.5 coming soon.
>>
>> -- Christoph
>
> The new release (1.0.5) fixes the bug. Awesome !
> Thank you.

At your service :)

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: FastData replacement

by percious :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


Please let me know if you are interested in pursuing dbsprockets in
this respect.  The DBMechanic has a nice paginated grid, which allows
you to edit fields on a record-by-record basis.  Also, it handles one-
many relationships, and many-many relationships automagically.

My plan is to eventually integrate dojo's editable grid to
dbsprockets, but we are still polishing the framework pieces before we
get into the glitsy stuff.  (Make it work first please).  Here is some
more information on dbmechanic and it's capabilities:
http://code.google.com/p/dbsprockets/wiki/DBMechanic

cheers.
-chris

On Jul 2, 6:55 am, "Florent Aide" <florent.a...@...> wrote:

> On Wed, Jul 2, 2008 at 12:08 PM, Stéphane Raimbault
>
> <stephane.raimba...@...> wrote:
> > 2008/6/18 Christoph Zwerschke <c...@...>:
>
> >> Did you test with the SVN head of the TG 1.0 branch or with the last
> >> release? paginate has been much improved, particularly SQLAlchemy
> >> support, after 1.0.4.4. This will be available in 1.0.4.5 coming soon.
>
> >> -- Christoph
>
> > The new release (1.0.5) fixes the bug. Awesome !
> > Thank you.
>
> At your service :)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: FastData replacement

by Lukasz Szybalski :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On Wed, Jul 2, 2008 at 3:17 PM, percious <chris@...> wrote:

>
> Please let me know if you are interested in pursuing dbsprockets in
> this respect.  The DBMechanic has a nice paginated grid, which allows
> you to edit fields on a record-by-record basis.  Also, it handles one-
> many relationships, and many-many relationships automagically.
>
> My plan is to eventually integrate dojo's editable grid to
> dbsprockets, but we are still polishing the framework pieces before we
> get into the glitsy stuff.  (Make it work first please).  Here is some
> more information on dbmechanic and it's capabilities:
> http://code.google.com/p/dbsprockets/wiki/DBMechanic
>

I wonder if anybody though of implementing xform into tg style widget.
aka. Build a Xform in openoffice, save it as xml file and tell
turbogears to use it as one of the form widgets.


http://marketing.openoffice.org/ooocon2004/presentations/friday/vogelheim_XForms.pdf
http://opendocument.xml.org/files/xforms_ooo_06_10_25.pdf


So just to summarize how many widget choices we have now?

kid:
datagrid
fastdatagrid
paginatedatagrid

genshi:
Toscawidgets

and
DBMechanic is doing widgets as well?

Would be nice if all these were under one package.
Thanks,
Lucas

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: FastData replacement

by percious :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


Dbsprockets is auto-generating TW based on SA schema.  It utilizes
mostly genshi, but may switch over to mako for speed in the near
future.

Right now the widgets are simple html, but they will be using JS/Ajaj
technologies in the future.

Hope that clears things up.

-chris

On Jul 2, 2:35 pm, "Lukasz Szybalski" <szybal...@...> wrote:

> On Wed, Jul 2, 2008 at 3:17 PM, percious <ch...@...> wrote:
>
> > Please let me know if you are interested in pursuing dbsprockets in
> > this respect.  The DBMechanic has a nice paginated grid, which allows
> > you to edit fields on a record-by-record basis.  Also, it handles one-
> > many relationships, and many-many relationships automagically.
>
> > My plan is to eventually integrate dojo's editable grid to
> > dbsprockets, but we are still polishing the framework pieces before we
> > get into the glitsy stuff.  (Make it work first please).  Here is some
> > more information on dbmechanic and it's capabilities:
> >http://code.google.com/p/dbsprockets/wiki/DBMechanic
>
> I wonder if anybody though of implementing xform into tg style widget.
> aka. Build a Xform in openoffice, save it as xml file and tell
> turbogears to use it as one of the form widgets.
>
> http://marketing.openoffice.org/ooocon2004/presentations/friday/vogel...http://opendocument.xml.org/files/xforms_ooo_06_10_25.pdf
>
> So just to summarize how many widget choices we have now?
>
> kid:
> datagrid
> fastdatagrid
> paginatedatagrid
>
> genshi:
> Toscawidgets
>
> and
> DBMechanic is doing widgets as well?
>
> Would be nice if all these were under one package.
> Thanks,
> Lucas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: FastData replacement

by Lukasz Szybalski :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On Wed, Jul 2, 2008 at 3:50 PM, percious <chris@...> wrote:
>
> Dbsprockets is auto-generating TW based on SA schema.

So if I have 100 tables in my db, using dbsp I can generate tw widgets
that would allow me to enter data into any table?

Lucas

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---