Metadata-Version: 1.1
Name: dql
Version: 0.5.12
Summary: DynamoDB Query Language
Home-page: http://github.com/mathcamp/dql
Author: Steven Arcangeli
Author-email: stevearc@stevearc.com
License: MIT
Description: DQL
        ===
        :Build: |build|_ |coverage|_
        :Documentation: http://dql.readthedocs.org/
        :Downloads: http://pypi.python.org/pypi/dql
        :Source: https://github.com/mathcamp/dql
        
        .. |build| image:: https://travis-ci.org/mathcamp/dql.png?branch=master
        .. _build: https://travis-ci.org/mathcamp/dql
        .. |coverage| image:: https://coveralls.io/repos/mathcamp/dql/badge.png?branch=master
        .. _coverage: https://coveralls.io/r/mathcamp/dql?branch=master
        
        A simple, SQL-ish language for DynamoDB
        
        Getting Started
        ===============
        Install with pip::
        
            pip install dql
        
        Here are some basic DQL examples to get you going:
        
        Start the REPL::
        
            $ dql
            us-west-1>
        
        Creating a table::
        
            us-west-1> CREATE TABLE forum_threads (name STRING HASH KEY,
                     >                             subject STRING RANGE KEY,
                     >                             THROUGHPUT (4, 2));
        
        Inserting data::
        
            us-west-1> INSERT INTO forum_threads (name, subject, views, replies)
                     > VALUES ('Self Defense', 'Defense from Banana', 67, 4),
                     > ('Self Defense', 'Defense from Strawberry', 10, 0),
                     > ('Cheese Shop', 'Anyone seen the camembert?', 16, 1);
        
        Queries::
        
            us-west-1> SCAN * FROM forum_threads;
            us-west-1> SELECT count(*) FROM forum_threads WHERE name = 'Self Defense';
            us-west-1> SELECT * FROM forum_threads WHERE name = 'Self Defense';
        
        Mutations::
        
            us-west-1> UPDATE forum_threads ADD views 1 WHERE
                     > name = 'Self Defense' AND subject = 'Defense from Banana';
            us-west-1> DELETE FROM forum_threads WHERE name = 'Cheese Shop';
        
        Changing tables::
        
            us-west-1> ALTER TABLE forum_threads SET THROUGHPUT (8, 4);
            us-west-1> DROP TABLE forum_threads;
        
        And don't forget to use ``help``!
        
        
        Changelog
        =========
        
        0.5.12
        ------
        * Differentiate LIMIT and SCAN LIMIT
        * Options and query syntax for ``throttling`` the consumed throughput
        * Crash fixes and other small robustness improvements
        
        0.5.11
        ------
        * SELECT <attributes> can now use full expressions
        
        0.5.10
        ------
        * LOAD command to insert records from a file created with ``SELECT ... SAVE``
        * Default SAVE format is pickle
        * SAVE command can gzip the file
        
        0.5.9
        -----
        * Don't print results to console when saving to a file
        * 'auto' pagesize to adapt to terminal height
        * When selecting specific attributes with KEYS IN only those attributes are fetched
        * ORDER BY queries spanning multiple pages no longer stuck on first page
        * Column formatter fits column widths more intelligently
        * Smart formatter is smarter about switching to Expanded mode
        
        0.5.8
        -----
        * Tab completion for Mac OS X
        
        0.5.7
        -----
        * ``run_dql.py`` locks in a version
        * Display output auto-detects terminal width
        
        0.5.6
        -----
        * Format option saves properly
        * WHERE expressions can compare fields to fields (e.g. ``WHERE foo > bar``)
        * Always perform batch_get after querying/scanning an index that doesn't project all attributes
        
        0.5.5
        -----
        * General bug fixes
        * Self contained ``run_dql.py`` script
        
        0.5.4
        -----
        * Fixes for ``watch`` display
        * SELECT can save the results to a file
        
        0.5.3
        -----
        * ALTER commands can specify IF (NOT) EXISTS
        * New ``watch`` command to monitor table consumed capacities
        * SELECT can fetch attributes that aren't projected onto the queried index
        * SELECT can ORDER BY non-range-key attributes
        
        0.5.2
        -----
        * EXPLAIN <query> will print out the DynamoDB calls that will be made when you run the query
        * ANALYZE <query> will run the query and print out consumed capacity information
        
        0.5.1
        -----
        * Pretty-format non-item query return values (such as count)
        * Disable passing AWS credentials on the command line
        
        0.5.0
        -----
        * **Breakage**: New syntax for SELECT, SCAN, UPDATE, DELETE
        * **Breakage**: Removed COUNT query (now ``SELECT count(*)``)
        * **Breakage**: Removed the ability to embed python in queries
        * New alternative syntax for INSERT
        * ALTER can create and drop global indexes
        * Queries and updates now use the most recent DynamoDB expressions API
        * Unified options in CLI under the ``opt`` command
        
        0.4.1
        -----
        * Update to maintain compatibility with new versions of botocore and dynamo3
        * Improving CloudWatch support (which is used to get consumed table capacity)
        
        0.4.0
        -----
        * **Breakage**: Dropping support for python 3.2 due to lack of botocore support
        * Feature: Support for JSON data types
        
        0.3.2
        -----
        * Bug fix: Allow '.' in table names of DUMP SCHEMA command
        * Bug fix: Passing a port argument to local connection doesn't crash
        * Bug fix: Prompt says 'localhost' when connected to DynamoDB local
        
        0.3.1
        -----
        * Bug fix: Allow '.' in table names
        
        0.3.0
        -----
        * Feature: SELECT and COUNT can have FILTER clause
        * Feature: FILTER clause may OR constraints together
        
        0.2.1
        -----
        * Bug fix: Crash when printing 'COUNT' queries
        
        0.2.0
        -----
        * Feature: Python 3 support
        
        0.1.0
        -----
        * First public release
        
Keywords: aws dynamo dynamodb sql
Platform: any
Classifier: Development Status :: 4 - Beta
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 2
Classifier: Programming Language :: Python :: 2.6
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.3
Classifier: Programming Language :: Python :: 3.4
