Sorry, I didn't get that you need to run an actual app too on the same project. Well, then yes, it's the case you need two databases, to keep data clean too. You could use some kind of flag to differentiate real data from the demo stuff, but it would be not to best thing to do...
With symfony you can easily use two different connections on an app- basis. Check the gentle introduction to see how this is done. On Sep 9, 1:25 pm, Paul Burdon <p...@clearintent.co.uk> wrote: > Hi Davide, > > Thanks for replying. > > This is the issue, if I truncate the database and the demo data is in the > same db as client data I would also dump all the actual client data. > > Hence the question about 2 databases. > > If I have demo site accessing demoDB and client stuff clientDB then that > makes more sense to me (easy to do what you suggest) but I wondered if I can > use the same symfony app to access the different databases maybe depending > on url or something? > > Hence the question, what do you think? > > OR do I just need to run 2 sites/apps which seems like a pain in the head to > maintain to me. > > Cheers, > > Paul > > On 9 September 2010 12:04, Davide Borsatto <lloy...@gmail.com> wrote: > > > I guess this has nothing to do with symfony. Just run a SQL file that > > truncates the tables and inserts the demo content using cron. > > > On Sep 9, 11:46 am, Tofuwarrior <p...@clearintent.co.uk> wrote: > > > Hi, > > > > I want to do a demo of our site and to reset the database every 30 > > > minutes. > > > > Would it be better to run the demo using a different database > > > connection and a separate database or can anyone think of a way to do > > > it within the same DB as the rest of the site. > > > > I am guessing separate but does anyone know how best to do this? Can > > > we do it through the same symfony install and set it by using a > > > different controller or something? > > > We are running propel 1.5 Symfony 1.4.5 > > > > I don't really want to have to duplicate the site completely if I can > > > help it > > > > Paul > > > -- > > If you want to report a vulnerability issue on symfony, please send it to > > security at symfony-project.com > > > You received this message because you are subscribed to the Google > > Groups "symfony users" group. > > To post to this group, send email to symfony-users@googlegroups.com > > To unsubscribe from this group, send email to > > symfony-users+unsubscr...@googlegroups.com<symfony-users%2bunsubscr...@googlegroups.com> > > For more options, visit this group at > >http://groups.google.com/group/symfony-users?hl=en -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
