Why Gemfury? Push, build, and install  RubyGems npm packages Python packages Maven artifacts PHP packages Go Modules Debian packages RPM packages NuGet packages

Repository URL to install this package:

Details    
Size: Mime:
Metadata-Version: 1.1
Name: sqlparse
Version: 0.2.3
Summary: Non-validating SQL parser
Home-page: https://github.com/andialbrecht/sqlparse
Author: Andi Albrecht
Author-email: albrecht.andi@gmail.com
License: BSD
Description: 
        ``sqlparse`` is a non-validating SQL parser module.
        It provides support for parsing, splitting and formatting SQL statements.
        
        Visit the `project page <https://github.com/andialbrecht/sqlparse>`_ for
        additional information and documentation.
        
        **Example Usage**
        
        
        Splitting SQL statements::
        
           >>> import sqlparse
           >>> sqlparse.split('select * from foo; select * from bar;')
           [u'select * from foo; ', u'select * from bar;']
        
        
        Formatting statemtents::
        
           >>> sql = 'select * from foo where id in (select id from bar);'
           >>> print sqlparse.format(sql, reindent=True, keyword_case='upper')
           SELECT *
           FROM foo
           WHERE id IN
             (SELECT id
              FROM bar);
        
        
        Parsing::
        
           >>> sql = 'select * from someschema.mytable where id = 1'
           >>> res = sqlparse.parse(sql)
           >>> res
           (<Statement 'select...' at 0x9ad08ec>,)
           >>> stmt = res[0]
           >>> str(stmt)  # converting it back to unicode
           'select * from someschema.mytable where id = 1'
           >>> # This is how the internal representation looks like:
           >>> stmt.tokens
           (<DML 'select' at 0x9b63c34>,
            <Whitespace ' ' at 0x9b63e8c>,
            <Operator '*' at 0x9b63e64>,
            <Whitespace ' ' at 0x9b63c5c>,
            <Keyword 'from' at 0x9b63c84>,
            <Whitespace ' ' at 0x9b63cd4>,
            <Identifier 'somes...' at 0x9b5c62c>,
            <Whitespace ' ' at 0x9b63f04>,
            <Where 'where ...' at 0x9b5caac>)
        
        
Platform: UNKNOWN
Classifier: Development Status :: 4 - Beta
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: BSD License
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 2
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.3
Classifier: Programming Language :: Python :: 3.4
Classifier: Programming Language :: Python :: 3.5
Classifier: Programming Language :: Python :: 3.6
Classifier: Topic :: Database
Classifier: Topic :: Software Development