php - I'm having trouble with installing Propel, sql:build does not work -
i following official propel tutorial: propel chapter 2: build time
but when execute vendor/bin/propel sql:build script, nothing happens!
i created composer.json file , installed composer, explained. files succesfully downloaded.
i go project: /media/sf_sandbox/test/temp/propel/bookstore
i used example schema.xml file:
<?xml version="1.0" encoding="utf-8"?> <database name="bookstore" defaultidmethod="native"> <table name="book" phpname="book"> <column name="id" type="integer" required="true" primarykey="true" autoincrement="true"/> <column name="title" type="varchar" size="255" required="true" /> <column name="isbn" type="varchar" size="24" required="true" phpname="isbn"/> <column name="publisher_id" type="integer" required="true"/> <column name="author_id" type="integer" required="true"/> <foreign-key foreigntable="publisher" phpname="publisher" refphpname="book"> <reference local="publisher_id" foreign="id"/> </foreign-key> <foreign-key foreigntable="author"> <reference local="author_id" foreign="id"/> </foreign-key> </table> <table name="author" phpname="author"> <column name="id" type="integer" required="true" primarykey="true" autoincrement="true"/> <column name="first_name" type="varchar" size="128" required="true"/> <column name="last_name" type="varchar" size="128" required="true"/> </table> <table name="publisher" phpname="publisher"> <column name="id" type="integer" required="true" primarykey="true" autoincrement="true" /> <column name="name" type="varchar" size="128" required="true" /> </table> </database>
i used propel.php example username , password, kept rest unchanged:
<?php return [ 'propel' => [ 'database' => [ 'connections' => [ 'bookstore' => [ 'adapter' => 'mysql', 'classname' => 'propel\runtime\connection\connectionwrapper', 'dsn' => 'mysql:host=localhost;dbname=my_db_name', 'user' => 'myusername', 'password' => 'mypassword', 'attributes' => [] ] ] ], 'runtime' => [ 'defaultconnection' => 'bookstore', 'connections' => ['bookstore'] ], 'generator' => [ 'defaultconnection' => 'bookstore', 'connections' => ['bookstore'] ] ] ];
but when execute script: vendor/bin/propel sql:build
but nothing happens, no new database, no error, repeats line:
/media/sf_sandbox/test/temp/propel/bookstore /media/sf_sandbox/test/temp/propel/bookstore
the path project, can't head around this...
Comments
Post a Comment