Download the PHP package studiomado/query-bundle without Composer

QueryBundle

latest stable version

2.4 (master)	2.3	2.2

Run tests

• ./runtests.sh run all unit tests
• ./agile.sh generate testdox documentation
• ./coverage.sh generate and open html coverage

Plain symfony project for query-bundle

The purpose of this project is to see how studiomado/query-bundle works and can be installed in a plain symfony project.

• database configuration
• install query-bundle
• create at least one entity

Database configuration

Remember to update parameter.yml file, parameter.yml.dist and config.yml file. In config.yml file also remember that the drive MUST be changed in pdo_sqlite to enable doctrine to work with this database.

This is just an example: for this example we use sqlite but in production you can use mysql or postgres or any other database supported by doctrine.

prompt> ./bin/console doctrine:database:create
Created database /path/to/project/var/data/data.sqlite for connection named default

Install query-bundle

prompt> composer require studiomado/query-bundle

Create at least one entity

Create at least one entity ...

prompt> ./bin/console doctrine:generate:entity

In this example I created an entity Task following command steps.

created ./src/AppBundle/Entity/
created ./src/AppBundle/Entity/Task.php
> Generating entity class src/AppBundle/Entity/Task.php: OK!
> > Generating repository class src/AppBundle/Repository/TaskRepository.php: OK!

... and update the schema ...

    prompt> ./bin/console doctrine:schema:update
    ATTENTION: This operation should not be executed in a production environment.
                         Use the incremental update to detect changes during development and use
                         the SQL DDL provided to manually update your database in production.

    The Schema-Tool would execute "1" queries to update the database.
    Please run the operation by passing one - or both - of the following options:
            doctrine:schema:update --force to execute the command
            doctrine:schema:update --dump-sql to dump the SQL statements to the screen

The schema update works only with force option

prompt> ./bin/console doctrine:schema:update --force
Updating database schema...
Database schema updated successfully! "1" query was executed

Just take a look of the database content (that now is simply empty).

prompt> ./bin/console doctrine:query:dql "select t from AppBundle:Task t"

The query will return an empty array of result

 array (size=0)
   empty

Just add first task ...

prompt> ./bin/console doctrine:query:sql "insert into task values (null, 'complete this guide', 'todo') "

and take a look of the content

prompt> ./bin/console doctrine:query:dql "select t from AppBundle:Task t"

array (size=1)
  0 =>
    object(stdClass)[507]
      public '__CLASS__' => string 'AppBundle\Entity\Task' (length=21)
      public 'id' => int 1
      public 'description' => string 'complete this guide' (length=19)
      public 'status' => string 'todo' (length=4)

Complete installation

First of all install vendors

prompt> composer require jms/serializer-bundle
prompt> composer require willdurand/hateoas-bundle
prompt> composer require white-october/pagerfanta-bundle
prompt> composer require friendsofsymfony/rest-bundle

and then, … add vendors in your app/AppKernel

new FOS\RestBundle\FOSRestBundle(),
new JMS\SerializerBundle\JMSSerializerBundle(),
new Bazinga\Bundle\HateoasBundle\BazingaHateoasBundle(),

Complete configuration and use the bundle

Once everything is done, you can add new endpoints using the query-bundle to query the database.

Configure your entity repository

Now be sure that your repository extends the right BaseRepository.

Customize entity serialization

Now if you want to customize responses add

use JMS\Serializer\Annotation as JMS;

On top of your entities and complete your JMS configurations. See JMS documentation to get all the complete documentation.

Here some examples:

• http://127.0.0.1:8000/?filtering[status]=todo
• http://127.0.0.1:8000/?filtering[status|contains]=od
• http://127.0.0.1:8000/?filtering[status|endswith]=gress

Find All No Paginated

Added a new method in BaseRepository
When you need results applying filter and sort without pagination

This feature was needed to create an Excel Report, injecting results into the Excel Report

Example without pagination

In Controller:

Example with pagination

In Controller:

Queries

AND Conditions

If you want to create an AND condition with this library you can create it from the client for example with a simple GET request like this:

This request will produce a query like this:

OR Conditions

If you want to create an OR condition with this library you can create it from the client for example with a simple GET request like this:

This request will produce a query like this:

Instead, if you want to have more OR conditions separated you can do something like this:

This request will produce a query like this:

This can be done by using a counter after the operator separated by

Search into relations

If you want to search inside an entity where a condition is inside another entity you can do this:

This request will produce a query like this:

To do this you need to add inside the user entity some Hateoas annotations like this:

If you add Hateoas annotations correctly, you can search deeper than only "one level". Here an example:

In this example you search all users that have a profile with a country location name: Italy.
Profile, location and country are entities and name is the field.

You can use _embedded filter also into filtering_or conditions.