noccylabs/data-explorer-bundle $ git tag $ git branch * master
This bundle lets you explore your data.
- Bundle and Binary/Commands
- Doctrine integration
- mysql, sqlite, etc. direct
- web ui
On the CLI
$ app/console data-explorer:shell ... [@1]data:DQL> .help
Result history cache
@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
@ refrences the history cache.
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.
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
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.
> @@ "user.name='bob'"
Yes, you need to double-quote.