Sorry to bump this, guys, but it's holding up my development. Can anyone even just confirm or deny whether it's possible to reconnect to a Doctrine database during the middle of a script. If it's impossible, I'll just use a native mysql connection for this part.
Thanks, Tom On Mon, Sep 28, 2009 at 8:59 AM, Tom Haskins-Vaughan <[email protected]> wrote: > > OK, so assuming I have in fact lost a connection during a script due > to inactivity, is there a way to open a doctrine connection in the > middle of a script, or is that just all taken care of at > initialization? > > TIA, > > Tom > > On Sep 24, 8:58 am, Tom Haskins-Vaughan <[email protected]> > wrote: >> I'm running the script as a task with a cron job. I'm not generating the >> file, the files are held in a remote ftp directory, posted by a real >> estate listing service. They're basically a pipe delimited files of new >> and modified properties for sale. >> >> So my flow is: >> >> 1. download file, creating log as I go >> 2. unzip file if download was completed >> 3. process file and insert data into property table >> >> As I say, I use the log to keep track of the status of each file. >> >> Jeremy Thomerson wrote: >> > Are you generating this file during an HTTP request that is also >> > downloading it? >> >> > Although I still don't understand what you're doing, try changing it to >> > a command line task rather than something that is triggered by HTTP. >> > Then execute it from the shell or cron. Then you can just rsync the files. >> >> > Jeremy >> >> > On Thu, Sep 24, 2009 at 7:39 AM, Tom Haskins-Vaughan >> > <[email protected] <mailto:[email protected]>> wrote: >> >> > Well, basically, I have to download loads of file, unzip them and >> > process the content. But I only get 15 minutes of execution time with >> > my >> > current host, so I have a log table which tells me where I am and where >> > to pick up from the next time the script runs (every 20 minutes). I >> > need >> > to know that the filehasdownloaded correctly before I unzip it so >> > after it's downloaded I put the enter the download_completed_at field. >> > Then I know that I can unzip it the next time around. >> >> > The problem is, I'm losing the connection during the time it takes to >> > download the file. >> >> > Eno wrote: >> > > On Wed, 23 Sep 2009, Tom Haskins-Vaughan wrote: >> >> > >> But the problem is, by the time I've downloaded the file, I've >> > lost the >> > >> connection (SQLSTATE[HY000]: General error: 2006 MySQLserver >> > hasgone away) >> >> > >> Is there any way to reconnect the database? >> >> > > What does a file download have to do with your database? > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
