<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<body bgcolor="#ffffff" text="#000000">
Peter Karman wrote:
<blockquote cite="mid473CF478.email@example.com" type="cite">
Andrew Peebles wrote on 11/15/07 7:16 PM:
<pre wrap="">I've been searching and experimenting and have not found a solution ...
I have multiple instances of a database (each in a separate sqlite db
file), same schema, different data. Each represents a snapshot of
something at a particular time. During a session, user wants switch
among these databases. I am trying to add a method to my Model
(Catalyst::Model::DBIC::Schema) that takes a new connection string, and
switches to that database ... all things otherwise remaining the same.
Seems relatively simple, but I just ain't getting it. Lots of hints on
the list, but nothing I can find that's helping.
why not have a different Model class for each db?
There could be an arbitrary number of them, databases are added over
time. They are identical; same schema, tables, et. al (same model).<br>