fredjuvaux/silex-orm-skeleton

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

dev-master / 1.1.x-dev 2015-08-18 17:34 UTC

Requires

• php: >=5.3.3
• fredjuvaux/doctrine-orm-provider: 1.0.*@dev
• fredjuvaux/silex-less-provider: dev-master
• silex/silex: ~1.0
• silex/web-profiler: ~1.0
• symfony/browser-kit: ~2.3
• symfony/class-loader: ~2.3
• symfony/config: ~2.3
• symfony/console: ~2.3
• symfony/css-selector: ~2.3
• symfony/debug: ~2.3
• symfony/finder: ~2.3
• symfony/form: 2.5.2
• symfony/monolog-bridge: ~2.3
• symfony/process: ~2.3
• symfony/security: ~2.3
• symfony/translation: ~2.3
• symfony/twig-bridge: ~2.3
• symfony/validator: 2.5.2

MIT

• Fred Juvaux

• silex
• database
• orm
• bootstrap
• doctrine
• extension
• provider
• Skeleton

README

Silex skeleton with doctrine ORM, bootstrap and CRUD example.

For doctrine documentation see symfony and doctrine docs.

Install:

cd /path/to/your_project
git clone [e-mail]:fredjuvaux/silex-orm-skeleton.git

Install composer:

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

More information on Composer can be found on getcomposer.org.

And install your dependencies:

php composer.phar install

Set your database information in src/app.php:

$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):

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

Commands available:

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:

php bin/console orm:generate-entities src

Acme CRUD demo routes:

/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}