README

What is it?

This package contains SQL logging for GraphQL queries and mutations.
You will get all executed queries at response.

Installation

Require the package through composer.

$ composer require marqant-lab/graphql-sql-log

Example

Example of response data:

{
    "data": {
        ...
    },
    "extensions": [
        {
            "sqlInfo": {
                "executed_queries_count": 7,
                "executed_queries": [
                    ...
                    {
                        "query": "select * from `users` where `users`.`id` = ? limit 1",
                        "bindings": [
                            2
                        ],
                        "time": 3.48
                    }
                    ...
                ]
            }
        }
    ]
}

Tests

To run tests, you first need to set up a sqlite database that we use to get snapshots of the database state. Run the following command from within your project root to create the sqlite database.

$ touch database/database.sqlite

If you want to execute package tests add this to the phpunit.xml

        <testsuite name="GraphQLSQLLog">
            <directory suffix="Test.php">./vendor/marqant-lab/graphql-sql-log/tests</directory>
        </testsuite>

And after you can check it by executing:

$ php artisan test --group=GraphQLSQLLog
or
$ phpunit --group=GraphQLSQLLog