I generally do that sort of thing directly in the DB interpreter (psql/mysql) but you could also write a shell that does the inserts. Or even use Perl or Python, for that matter.
If you don't have shell access to the server, there's always PhpPgAdmin/PhpMyAdmin. Or, as you suggested, you can create a controller to do the same. Obviously, you'd want to remove that from the server afterwards. I think the determining factors really are what's available to you and what you're comfortable with. 2009/4/19 イタリア人 <[email protected]>: > > Hi Group, > > I've created a cake application and now I want to populate the > databases with external data sources. > My first approach would have been to write a script to INSERT queries > directed to MySQL, but I feel this to be very little "caki" approach. > > My second approach would be to write a controller with various actions > to import from different sources and then use > http://book.cakephp.org/view/75/Saving-Your-Data > hints to put data. > > What do you think ? Have you experinces differnt approaces already ? > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
