Attention, le tuto n'est pas à jour avec Symfony. Le fichier généré est lib.model.schema.sql dans <SF_ROOT_DIR>/data/sql
Nautile On 18 avr, 11:15, jason <[EMAIL PROTECTED]> wrote: > bonjour, > j'ai un petit soucis avec le tuto > askeet.http://www.symfony-project.com/askeet/en/2 > > tout fonctionne bien jusqu'a l'insertion du shema en BDD > en fait c'est a l'étape juste avant que ça coince, tout semble > fonctionner mais je n'ai pas de fichier data/sql/schema.sql de créé. > j'ai tout copié collé, si quelqu'un a une idée... > > [EMAIL PROTECTED] ~ $ symfony init-project jazz > >> dir+ /home/jazz/batch > >> dir+ /home/jazz/test > >> dir+ /home/jazz/test/unit > >> dir+ /home/jazz/test/functional > >> dir+ /home/jazz/test/bootstrap > >> file+ /home/jazz/test/bootstrap/unit.php > >> file+ /home/jazz/test/bootstrap/functional.php > >> dir+ /home/jazz/log > >> dir+ /home/jazz/web > >> dir+ /home/jazz/web/images > >> dir+ /home/jazz/web/js > >> file+ /home/jazz/web/.htaccess > >> file+ /home/jazz/web/robots.txt > >> dir+ /home/jazz/web/uploads > >> dir+ /home/jazz/web/uploads/assets > >> dir+ /home/jazz/web/css > >> file+ /home/jazz/web/css/main.css > >> dir+ /home/jazz/plugins > >> dir+ /home/jazz/config > >> file+ /home/jazz/config/propel.ini > >> file+ /home/jazz/config/schema.yml > >> file+ /home/jazz/config/databases.yml > >> file+ /home/jazz/config/properties.ini > >> file+ /home/jazz/config/rsync_exclude.txt > >> file+ /home/jazz/config/config.php > >> dir+ /home/jazz/cache > >> dir+ /home/jazz/data > >> dir+ /home/jazz/data/model > >> dir+ /home/jazz/data/sql > >> dir+ /home/jazz/doc > >> dir+ /home/jazz/lib > >> dir+ /home/jazz/lib/model > >> dir+ /home/jazz/apps > >> file+ /home/jazz/symfony > >> tokens /home/jazz/config/propel.ini > >> tokens /home/jazz/config/properties.ini > >> tokens /home/jazz/config/propel.ini > >> tokens /home/jazz/config/config.php > >> chmod 777 /home/jazz/cache > >> chmod 777 /home/jazz/log > >> chmod 777 /home/jazz/web/uploads > >> chmod 777 /home/jazz/symfony > >> chmod 777 web/uploads/assets > [EMAIL PROTECTED] ~ $ symfony init-app frontend > >> dir+ /home/jazz/apps/frontend/config > >> file+ /home/jazz/apps/frontend/config/view.yml > >> file+ /home/jazz/apps/frontend/config/security.yml > >> file+ /home/jazz/apps/frontend/config/app.yml > >> file+ /home/jazz/apps/frontend/config/cache.yml > >> file+ /home/jazz/apps/frontend/config/i18n.yml > >> file+ /home/jazz/apps/frontend/config/factories.yml > >> file+ /home/jazz/apps/frontend/config/routing.yml > >> file+ /home/jazz/apps/frontend/config/config.php > >> file+ /home/jazz/apps/frontend/config/settings.yml > >> file+ /home/jazz/apps/frontend/config/logging.yml > >> file+ /home/jazz/apps/frontend/config/filters.yml > >> dir+ /home/jazz/apps/frontend/i18n > >> dir+ /home/jazz/apps/frontend/lib > >> file+ /home/jazz/apps/frontend/lib/myUser.class.php > >> dir+ /home/jazz/apps/frontend/templates > >> file+ /home/jazz/apps/frontend/templates/layout.php > >> dir+ /home/jazz/apps/frontend/modules > >> tokens /home/jazz/apps/frontend/config/settings.yml > >> file+ /home/jazz/web/index.php > >> file+ /home/jazz/web/frontend_dev.php > >> tokens /home/jazz/web/index.php > >> tokens /home/jazz/web/frontend_dev.php > >> chmod 777 /home/jazz/cache > >> chmod 777 /home/jazz/log > >> chmod 777 /home/jazz/web/uploads > >> chmod 777 /home/jazz/symfony > >> chmod 777 web/uploads/assets > >> dir+ /home/jazz/test/functional/frontend > [EMAIL PROTECTED] ~ $ > > je cree le fichier config/schema.xml et je verifie que je ne me suis pas > trrompé ds le nom de fichier : > [EMAIL PROTECTED] ~ $ cat config/schema.xml > <?xml version="1.0" encoding="UTF-8"?> > <database name="propel" defaultIdMethod="native" noxsd="true"> > <table name="ask_question" phpName="Question"> > <column name="id" type="integer" required="true" primaryKey="true" > autoIncrement="true" /> > <column name="user_id" type="integer" /> > <foreign-key foreignTable="ask_user"> > <reference local="user_id" foreign="id"/> > </foreign-key> > <column name="title" type="longvarchar" /> > <column name="body" type="longvarchar" /> > <column name="created_at" type="timestamp" /> > <column name="updated_at" type="timestamp" /> > </table> > > <table name="ask_answer" phpName="Answer"> > <column name="id" type="integer" required="true" primaryKey="true" > autoIncrement="true" /> > <column name="question_id" type="integer" /> > <foreign-key foreignTable="ask_question"> > <reference local="question_id" foreign="id"/> > </foreign-key> > <column name="user_id" type="integer" /> > <foreign-key foreignTable="ask_user"> > <reference local="user_id" foreign="id"/> > </foreign-key> > <column name="body" type="longvarchar" /> > <column name="created_at" type="timestamp" /> > </table> > > <table name="ask_user" phpName="User"> > <column name="id" type="integer" required="true" primaryKey="true" > autoIncrement="true" /> > <column name="nickname" type="varchar" size="50" /> > <column name="first_name" type="varchar" size="100" /> > <column name="last_name" type="varchar" size="100" /> > <column name="created_at" type="timestamp" /> > </table> > > <table name="ask_interest" phpName="Interest"> > <column name="question_id" type="integer" primaryKey="true" /> > <foreign-key foreignTable="ask_question"> > <reference local="question_id" foreign="id"/> > </foreign-key> > <column name="user_id" type="integer" primaryKey="true" /> > <foreign-key foreignTable="ask_user"> > <reference local="user_id" foreign="id"/> > </foreign-key> > <column name="created_at" type="timestamp" /> > </table> > > <table name="ask_relevancy" phpName="Relevancy"> > <column name="answer_id" type="integer" primaryKey="true" /> > <foreign-key foreignTable="ask_answer"> > <reference local="answer_id" foreign="id"/> > </foreign-key> > <column name="user_id" type="integer" primaryKey="true" /> > <foreign-key foreignTable="ask_user"> > <reference local="user_id" foreign="id"/> > </foreign-key> > <column name="score" type="integer" /> > <column name="created_at" type="timestamp" /> > </table> > > </database>[EMAIL PROTECTED] ~ $ > > [EMAIL PROTECTED] ~ $ symfony propel-build-schema > Buildfile: /usr/share/php/symfony/vendor/propel-generator/build.xml > [resolvepath] Resolved /home/jazz/config to /home/jazz/config > > propel-project-builder > check-project-or-dir-set: > > propel-project-builder > check-project-set: > > propel-project-builder > set-project-dir: > > propel-project-builder > check-buildprops-exists: > > propel-project-builder > check-buildprops-for-propel-gen: > > propel-project-builder > check-buildprops: > > propel-project-builder > configure: > [echo] Loading project-specific props from /home/jazz/config/propel.ini > [property] Loading /home/jazz/config/propel.ini > > propel-project-builder > creole: > [phing] Calling Buildfile > '/usr/share/php/symfony/vendor/propel-generator/build-propel.xml' with > target 'creole' > [property] Loading > /usr/share/php/symfony/vendor/propel-generator/./default.properties > > propel > creole: > [echo] +-----------------------------------------------+ > [echo] | | > [echo] | Generating XML from Creole connection ! | > [echo] | | > [echo] +-----------------------------------------------+ > [propel-creole-transform] Propel - CreoleToXMLSchema starting > [propel-creole-transform] Your DB settings are: > [propel-creole-transform] driver : (default) > [propel-creole-transform] URL : mysql://localhost/jazz > [propel-creole-transform] There was an error building XML from metadata: > connect failed [Native Error: Access denied for user > \'root\'@\'localhost\' (using password: NO)] [User Info: Array] > [propel-creole-transform] Propel - CreoleToXMLSchema finished > > BUILD FINISHED > > Total time: 0.4005 seconds > >> schema putting /home/jazz/config/schema.yml > >> file- /home/jazz/config/schema.xml > [EMAIL PROTECTED] ~ $ symfony propel-build-schema > Buildfile: /usr/share/php/symfony/vendor/propel-generator/build.xml > [resolvepath] Resolved /home/jazz/config to /home/jazz/config > > propel-project-builder > check-project-or-dir-set: > > propel-project-builder > check-project-set: > > propel-project-builder > set-project-dir: > > propel-project-builder > check-buildprops-exists: > > propel-project-builder > check-buildprops-for-propel-gen: > > propel-project-builder > check-buildprops: > > propel-project-builder > configure: > [echo] Loading project-specific props from /home/jazz/config/propel.ini > [property] Loading /home/jazz/config/propel.ini > > propel-project-builder > creole: > [phing] Calling Buildfile > '/usr/share/php/symfony/vendor/propel-generator/build-propel.xml' with > target 'creole' > [property] Loading > /usr/share/php/symfony/vendor/propel-generator/./default.properties > > propel > creole: > [echo] +-----------------------------------------------+ > [echo] | | > [echo] | Generating XML from Creole connection ! | > [echo] | | > [echo] +-----------------------------------------------+ > [propel-creole-transform] Propel - CreoleToXMLSchema starting > [propel-creole-transform] Your DB settings are: > [propel-creole-transform] driver : (default) > [propel-creole-transform] URL : mysql://localhost/jazz > [propel-creole-transform] There was an error building XML from metadata: > connect failed [Native Error: Access denied for user > \'root\'@\'localhost\' (using password: NO)] [User Info: Array] > [propel-creole-transform] Propel - CreoleToXMLSchema finished > > BUILD FINISHED > > Total time: 0.4009 seconds > > [EMAIL PROTECTED] ~ $ symfony propel-build-model > >> schema converting "/home/jazz/config/schema.yml" to XML > >> schema putting /home/jazz/config/generated-schema.xml > Buildfile: /usr/share/php/symfony/vendor/propel-generator/build.xml > [resolvepath] Resolved /home/jazz/config to /home/jazz/config > > propel-project-builder > check-project-or-dir-set: > > propel-project-builder > check-project-set: > > propel-project-builder > set-project-dir: > > propel-project-builder > check-buildprops-exists: > > propel-project-builder > check-buildprops-for-propel-gen: > > propel-project-builder > check-buildprops: > > propel-project-builder > configure: > [echo] Loading project-specific props from /home/jazz/config/propel.ini > [property] Loading /home/jazz/config/propel.ini > > propel-project-builder > om: > [phing] Calling Buildfile > '/usr/share/php/symfony/vendor/propel-generator/build-propel.xml' with > target 'om' > [property] Loading > /usr/share/php/symfony/vendor/propel-generator/./default.properties > > propel > check-run-only-on-schema-change: > > propel > om-check: > > propel > om: > [echo] +------------------------------------------+ > [echo] | | > [echo] | Generating Peer-based Object Model for | > [echo] | YOUR Propel project! (NEW OM BUILDERS)! | > [echo] | | > [echo] +------------------------------------------+ > [phingcall] Calling Buildfile > '/usr/share/php/symfony/vendor/propel-generator/build-propel.xml' with > target 'om-template' > [property] Loading > /usr/share/php/symfony/vendor/propel-generator/./default.properties > > propel > om-template: > [propel-om] Target database type: mysql > [propel-om] Target package: lib.model > [propel-om] Using template path: > /usr/share/php/symfony/vendor/propel-generator/templates > [propel-om] Output directory: /home/jazz > [propel-om] Processing: generated-schema.xml > [propel-om] Processing Datamodel : JoinedDataModel > [propel-om] - processing database : propel > [propel-om] + ask_question > [propel-om] -> BaseQuestionPeer [builder: SfPeerBuilder] > [propel-om] -> BaseQuestion [builder: SfObjectBuilder] > [propel-om] -> QuestionMapBuilder [builder: SfMapBuilderBuilder] > [propel-om] -> QuestionPeer [builder: SfExtensionPeerBuilder] > [propel-om] -> Question [builder: SfExtensionObjectBuilder] > [propel-om] + ask_answer > [propel-om] -> BaseAnswerPeer [builder: SfPeerBuilder] > [propel-om] -> BaseAnswer [builder: SfObjectBuilder] > [propel-om] -> AnswerMapBuilder [builder: SfMapBuilderBuilder] > [propel-om] -> AnswerPeer [builder: SfExtensionPeerBuilder] > [propel-om] -> Answer [builder: SfExtensionObjectBuilder] > [propel-om] + ask_user > [propel-om] -> BaseUserPeer [builder: SfPeerBuilder] > [propel-om] -> BaseUser [builder: SfObjectBuilder] > [propel-om] -> UserMapBuilder [builder: SfMapBuilderBuilder] > [propel-om] -> UserPeer [builder: SfExtensionPeerBuilder] > [propel-om] -> User [builder: SfExtensionObjectBuilder] > [propel-om] + ask_interest > [propel-om] -> BaseInterestPeer [builder: SfPeerBuilder] > [propel-om] -> BaseInterest [builder: SfObjectBuilder] > [propel-om] -> InterestMapBuilder [builder: SfMapBuilderBuilder] > [propel-om] -> InterestPeer [builder: SfExtensionPeerBuilder] > [propel-om] -> Interest [builder: SfExtensionObjectBuilder] > [propel-om] + ask_relevancy > [propel-om] -> BaseRelevancyPeer [builder: SfPeerBuilder] > [propel-om] -> BaseRelevancy [builder: SfObjectBuilder] > [propel-om] -> RelevancyMapBuilder [builder: > SfMapBuilderBuilder] > [propel-om] -> RelevancyPeer [builder: SfExtensionPeerBuilder] > [propel-om] -> Relevancy [builder: SfExtensionObjectBuilder] > > BUILD FINISHED > > Total time: 0.8680 seconds > >> file- /home/jazz/config/generated-schema.xml > [EMAIL PROTECTED] ~ $ > > =>Pas de fichier data/sql/schema.sql de créé : > > [EMAIL PROTECTED] ~ $ cat data/sql/schema.sql > cat: data/sql/schema.sql: Aucun fichier ou répertoire de ce type > [EMAIL PROTECTED] ~ $ > > la je coince, quelqu'un a déjà eu le cas ? --~--~---------~--~----~------------~-------~--~----~ Vous avez reçu ce message, car vous êtes abonné au groupe Groupe "Symfony-fr" de Google Groupes. Pour transmettre des messages à ce groupe, envoyez un e-mail à l'adresse [email protected] Pour résilier votre abonnement à ce groupe, envoyez un e-mail à l'adresse [EMAIL PROTECTED] Pour afficher d'autres options, visitez ce groupe à l'adresse http://groups.google.com/group/symfony-fr?hl=fr -~----------~----~----~----~------~----~------~--~---
