[Dbix-class] Fw: Dynamism in a static model

[Ido Perelmutter]

Hi there.

This is a forward of a question I posted to the Catalyst developer's mailing list. If anyone can help me, I'd be much obliged.

Thanks,
Ido Perelmutter.

--- On Wed, 4/29/09, Ido Perelmutter <ido50 at yahoo.com> wrote:

> From: Ido Perelmutter <ido50 at yahoo.com>
> Subject: Dynamism in a static model
> To: catalyst-dev at lists.scsys.co.uk
> Date: Wednesday, April 29, 2009, 6:33 PM
> Hi everyone.
> 
> I am working on a Catalyst application that allows the
> end-user to add their own tables to the database (for the
> matter it is a CMS). The application creates the tables by
> using $c->model('DB')->storage->sth($sql)
> which is easy.
> 
> After creating tables, my application needs to recognize
> their existence and allow the end-user to populate them.
> While I could use Catalyst::Helper or manually create a
> (DBIx::Class) schema for every table created, these new
> schemas would not be recognized until the application is
> restarted.
> 
> This is bad, it makes my application useless. So my
> question is, is there a way for me to load the schemas I
> create while the application is running, instead of having
> to restart it, such that I can immediately start using them?
> 
> Thanks,
> Ido Perelmutter.