Metadata-Version: 1.1
Name: ddlgenerator
Version: 0.1.0
Summary: Generates SQL DDL that will accept Python data
Home-page: https://github.com/catherinedevlin/ddlgenerator
Author: Catherine Devlin
Author-email: catherine.devlin@gmail.com
License: MIT
Description: =============
        DDL Generator
        =============
        
        Infers SQL DDL (Data Definition Language) from table data.
        
        Use at command line::
        
            $ ddlgenerator -i postgresql '{"Name": "Alfred", "species": "wart hog", "kg": 22}'
        
            DROP TABLE generated_table;
            CREATE TABLE generated_table (
        	    name VARCHAR(6) NOT NULL, 
        	    kg INTEGER NOT NULL, 
        	    species VARCHAR(8) NOT NULL 
            )
            ;
            INSERT INTO generated_table (kg, Name, species) VALUES (22, 'Alfred', 'wart hog');
            
        Accepts file paths::
        
            $ ddlgenerator postgresql mydata.yaml > mytable.sql
        
        Enables one-line creation of tables with their data
        
            $ ddlgenerator --inserts postgresql mydata.json | psql 
        
        With ``-i``/``--inserts`` flag, insert statements are included.
        
        or use in Python::
        
            >>> from ddlgenerator.ddlgenerator import Table
            >>> table = Table({"Name": "Alfred", "species": "wart hog", "kg": 22})
            >>> sql = table.sql('postgresql', inserts=True)
        
        * Free software: MIT license
        
        Supported data formats
        ----------------------
        
        - Pure Python
        - YAML
        - JSON
        - CSV
        
        Features
        --------
        
        - Supports all SQL dialects supported by SQLAlchemy
        - Coerces data into numeric or date form if possible
        - Takes table name from file name
        - Guesses format of input data if unspecified
        - with ``-u``/``--uniques`` flag, surmises UNIQUE constraints from data
        - Chokes demurely on nested data
        
        Installing
        ----------
        
        ::
        
            git clone git clone https://github.com/catherinedevlin/ddl-generator.git
            cd ddl-generator
            python setup.py install
        
        Credits
        -------
        
        - Mike Bayer for sqlalchemy
        - coldfix and Mark Ransom for their StackOverflow answers
        - Audrey Roy for cookiecutter
        
        
        
        
        
        
        History
        -------
        
        0.1.0 (2014-03-22)
        ++++++++++++++++++
        
        * First release on PyPI.
Keywords: ddlgenerator
Platform: UNKNOWN
Classifier: Development Status :: 2 - Pre-Alpha
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: BSD License
Classifier: Natural Language :: English
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
