[Dancer-users] SimpleCRUD and multiple tables

[Christopher Taranto]

On Fri, May 25, 2012 at 12:56 PM, Puneet Kishor <punk.kish at gmail.com> wrote:

> On May 25, 2012, at 12:52 PM, <gizmomathboy at gmail.com> wrote:
> > On May 25, 2012 11:10 AM, Puneet Kishor <punk.kish at gmail.com> wrote:
> > On May 25, 2012, at 10:02 AM, <gizmomathboy at gmail.com> wrote:
>
> > > Is there a way to access multiple tables using SimpleCRUD without
> using foreign keys?
> > > I have a relatively small database with a 3 tables or so but I don't
> have foreign keys between the tables.
> > Using Dancer::Plugin::SimpleCRUD there doesn't seem to be a way (from
> reading the documentation or search around for examples) to access more
> than 1 table in the simple_crud() call. It does look like you can use FKs
> to pull them into that 1 table.
>

What about using an SQL view to create a single virtual table to use with
SimpleCRUD?

http://www.w3schools.com/sql/sql_view.asp

Chris
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.backup-manager.org/pipermail/dancer-users/attachments/20120525/fef5d993/attachment.htm>