how to generate models using Doctrine help :(

[sasori]

hi, can you guys tell me or type here howto generate models from an existing db using the doctrine 1.2 ?

currently, what I did was, I placed the Doctrine folder + Doctrine.php in a directory named e.g test, then in the test directory, I created a file named test1.php , and I added this code

 

include_once('Doctrine.php');
spl_autoload_register(array('Doctrine','autoload'));

$manager = Doctrine_Manager::getInstance();

$conn = Doctrine_Manager::connection('mysql://username:password@localhost/dbname','doctrine');

Doctrine::generateModelsFromDb('/test',
    array('doctrine'),
    array('classPrefix'=>'Square_Model_')
);

 

then I ran it via shell using "php -f test1.php" ,

and boom!, nothing happened.

actually this  code snippet is from a book, I dunno why it's not working 

[trq]

Doctrine has its own command line interface, take a look at the help for...

 

doctrine generate-models-db

[sasori]

I was able to generate models using this script, slightly modified the one i posted above

include_once 'doctrine1/lib/Doctrine.php';
spl_autoload_register(array('Doctrine', 'autoload'));

$manager = Doctrine_Manager::getInstance();

$conn = Doctrine_Manager::connection('mysql://root:pass@localhost/dbname','doctrine');

Doctrine::generateModelsFromDb('/a/models',
    array('doctrine'),
    array('classPrefix' => 'Square_Model_')
);

 

but I got this error at the cmd , i dunno what it means

 

 

I deleted the generated models and repeated the same procedure and it doesn't work anymore

btw, I placed the Doctrine folder inside the PEAR folder of my PHP installation

[sasori]

problem solved after several trial and errors...the generated models went to the c:\  ,