fredjuvaux/silex-orm-skeleton

A pre-configured skeleton for the Silex microframework with doctrine ORM and bootstrap config.

silex-orm-skeleton

Silex skeleton with doctrine ORM, bootstrap and CRUD example., _(*1)

For doctrine documentation see symfony and doctrine docs., _(*2)

Install:, _(*3)

cd /path/to/your_project
git clone git@github.com:fredjuvaux/silex-orm-skeleton.git

Install composer:, _(*4)

curl -s https://getcomposer.org/installer | php

More information on Composer can be found on getcomposer.org., _(*5)

And install your dependencies:, _(*6)

php composer.phar install

Set your database information in src/app.php:, _(*7)

$app->register(new DoctrineServiceProvider(), array(
    'db.options' => array(
        'driver'        => 'pdo_mysql',
        'host'          => 'localhost',
        'dbname'        => 'xxx',
        'user'          => 'xxx',
        'password'      => 'xxx',
    ),
));

Create database, then generate tables with CLI tool (for acme demo by example):, _(*8)

php bin/console orm:schema-tool:update --force

Commands available:, _(*9)

php bin/console --info

Available commands:
  help                             Displays help for a command
  list                             Lists commands
dbal
  dbal:import                      Import SQL file(s) directly to Database.
  dbal:reserved-words              Checks if the current database contains identifiers that are reserved.
  dbal:run-sql                     Executes arbitrary SQL directly from the command line.
orm
  orm:clear-cache:metadata         Clear all metadata cache of the various cache drivers.
  orm:clear-cache:query            Clear all query cache of the various cache drivers.
  orm:clear-cache:result           Clear result cache of the various cache drivers.
  orm:convert-d1-schema            Converts Doctrine 1.X schema into a Doctrine 2.X schema.
  orm:convert-mapping              Convert mapping information between supported formats.
  orm:ensure-production-settings   Verify that Doctrine is properly configured for a production environment.
  orm:generate-entities            Generate entity classes and method stubs from your mapping information.
  orm:generate-proxies             Generates proxy classes for entity classes.
  orm:generate-repositories        Generate repository classes from your mapping information.
  orm:info                         Show basic information about all mapped entities
  orm:run-dql                      Executes arbitrary DQL directly from the command line.
  orm:schema-tool:create           Processes the schema and either create it directly on EntityManager Storage Connection or generate the SQL output.
  orm:schema-tool:drop             Drop the complete database schema of EntityManager Storage Connection or generate the corresponding SQL output.
  orm:schema-tool:update           Executes (or dumps) the SQL needed to update the database schema to match the current mapping metadata.
  orm:validate-schema              Validate that the mapping files.

Example:, _(*10)

php bin/console orm:generate-entities src

Acme CRUD demo routes:, _(*11)

/path/to/your_project/acme/
/path/to/your_project/acme/create
/path/to/your_project/acme/show/{id}
/path/to/your_project/acme/update/{id}
/path/to/your_project/acme/delete/{id}