[Dbix-class] Reconnecting Behavior

[Matt S Trout]

On Mon, Jul 30, 2007 at 11:03:44AM -0400, Adam Herzog wrote:
> On Jul 26, 2007, at 2:17 PM, Adam Herzog wrote:
> >On Jul 26, 2007, at 12:19 PM, Brandon Black wrote:
> >>As I understand the code, it *should* be attempting reconnection.   
> >>Any
> >>chance you can make a test file that reproduces the behavior?
> >
> >I've added a test to 33storage_reconnect.t; attached is the output  
> >of an svn diff against trunk.
> >
> >Essentially, there was already a test to make sure that it would  
> >reconnect if it lost its connection. I had to make that  
> >reconnection fail, so I rename the sqlite file, try to fetch some  
> >data, rename the file back, and then try to fetch some data again.  
> >The last fetch fails, when it should succeed.
> 
> After trying to look into the problem, I discovered that my test is  
> never going to work. After moving the db file and trying to  
> reconnect, SQLite just creates a new file, so it IS connected to a db  
> and so it doesn't try to reconnect again.

How about if you write "THIS DATABASE IS FULL OF FAIL\n" to the original
location of the file and -then- try to reconnect?

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director    Want a managed development or deployment platform?
 Shadowcat Systems Ltd.  Contact mst (at) shadowcatsystems.co.uk for a quote
http://chainsawblues.vox.com/                    http://www.shadowcat.co.uk/