I'm somewhat familiar with the schema stuff. However, the .sql file is a file that's going to be provided to us and not a file that will be generated by cake. Our .sql file isn't just about the schema, it could be large amounts of data manipulation using sql. So unless the schema stuff will execute a .sql file (rather than just generate it). I don't think it will work for us. That's why I was trying to get the code above to work.
Any other thoughts? On Sep 23, 4:39 pm, Sam Sherlock <[email protected]> wrote: > I think you want to create a > schemahttp://book.cakephp.org/view/735/Generating-and-using-Schema-files > - S > > 2009/9/23 Stinkbug <[email protected]> > > > > > I'm trying to execute a bunch of sql from a .sql file from the > > console. I was trying to use the query method inside the Model class, > > but I keep getting the following error. > > > Error: Missing database table 'models' for model 'Model' > > > Below is my code: > > > <?php > > App::import('Core', array('Model')); > > class UpgradeShell extends Shell { > > var $uses = array(); > > > function main() { > > $filename = APP . 'config/sql/upgrade.sql'; > > if (file_exists($filename)) { > > $handle = fopen($filename, "r"); > > $sql = fread($handle, filesize($filename)); > > fclose($handle); > > echo $sql; > > if ($sql) { > > //Model::query($sql); > > $model = new Model(); > > //$model->query($sql); > > } > > } > > } > > > } > > ?> > > > When I try Model::query($sql); > > > I get the following error: > > Notice: Undefined property: UpgradeShell::$Model in C:\wamp\www\rx.com > > \app\vendors\shells\upgrade.php on line 13 > > > Fatal error: Call to a member function query() on a non-object in C: > > \wamp\www\rx.com\app\vendors\shells\upgrade.php on line 13 > > > I don't really need to specify models, I just want to execute the > > queries inside the .sql file. > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
