noccylabs/data-explorer-bundle

$ git tag


$ git branch
* master

DataExplorer Bundle

This bundle lets you explore your data.

Features

Upcoming

Usage

On the CLI

$ app/console data-explorer:shell
...
[@1]data:DQL> .help

Result history cache

The @1 indicates that the result of this query if successful will be stored in history cache slot 1. Once you have done something like select x from VendorMyBundle:Entity x and the prompt reads anything above 1, you can do @@ to dump the last results, and @1 to dump the results from the first query entered.

All commands start with . while @ refrences the history cache.

Contexts

When you first open the shell, you are in the DQL context. This context doesn't really do anything too exciting (most of that stuff is in the Global context), but you can change into a new context by enterin a valid entity name. Once you are in a context, you will see [~1] in the prompt, indicating that you have one parent context. Enter . to list the active contexts or .. to change to the parent context.

The commands that are available varies with the context, so use the .help command to learn more.

Aliases

You can alias tables and entities and anything else that points to a valid context. This is done using the .alias command. For convenience you can create commonly used aliases in a file named .datashellrc in the project root containing something like:

# Set up useful aliases
.alias VendorFooBundle:Foo foo
.alias VendorFooBundle:Bar bar

Settings

You can access the settings using .set. Just calling .set will dump all the available settings. Calling .set prop-name will show the current setting of prop-name, and .set prop-name value will set the value of prop-name to value.

Saving and Loading buffers

> .save foo.de
> .load foo.de

Loading will replace your entire result cache.

Filtering buffers

> @@ "user.name='bob'"

Yes, you need to double-quote.