Query OrientDB via IPython
Project description
Package Description
IOrient is an IPython extension for running queries against an OrientDB graph database within IPython using OrientDB’s SQL dialect and Gremlin.
Installation
The package may be installed as follows:
pip install iorient
After installation, the extension may be loaded within an IPython session with
%load_ext iorient
Usage Examples
Set user name, password, server host, and database name:
%orient user:passwd@localhost/dbname
Same as above, but also specify the port:
%orient user:passwd@localhost:2424/dbname
Multiple connections to different databases may be opened. Once a connection has been established, it can be used by specifying its user and database name:
%%orient user@dbname SELECT * FROM V
One can also execute Gremlin queries using the -g option:
%orient -g g.V[0]
Once at least one connection has been opened, specifying a query without a connection string will use the last used connection:
%orient SELECT * FROM V
Query results may be displayed in tabular format using the oview magic command; to display results using Python’s pprint module (which is useful for examining JSON data structures), use the -j option:
r = %orient SELECT * FROM V %oview -j r
Development
The latest release of the package may be obtained from GitHub.
License
This software is licensed under the BSD License. See the included LICENSE.rst file for more information.
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.