modeanalytics / public-python / python / sdist / mode-sqlparse-0.2.2.tar.gz
Download

mode-sqlparse-0.2.2.tar.gz

STEP 1: Have you installed this repository?

If not, run this installation script command:

curl -s https://packagecloud.io/install/repositories/modeanalytics/public-python/script.python.sh | bash
copy 
curl -s https://packagecloud.io/install/repositories/modeanalytics/public-python/script.python.sh | bash



    

    
  


            

    
STEP 2: Install the package

      
sudo pip install mode-sqlparse==0.2.2

  


        

      

            
Temproray Fork of Andis Non-validating SQL parser

  
Full 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>)


        
          

            
Checksums

            

  
    

      
        MD5
      
      
        efcc73e2fc2127757fb5c8d76879c274
      
    

    

      
        SHA1
      
      
        d8904d22a9ea2318ba54dc154b4e493b22967cd1
      
    

    

      
        SHA256
      
      
        bf8adf9f03091e8b53812982dc16bea957330deaf4ebad2afb044d3bd9695108
      
    

    

      
        SHA512
      
      
        c6b4782f64bd17255c348443042b1534ec7d989d5388fb95f765318645fbfe77d249ee36b0c6815d28caa02918ca978b31d4f7572ae7b4d18cf20f894bfe5549
      
    

  



          

        


              

  
Files

  
    
      
  • mode-sqlparse-0.2.2/tox.ini
    • 
      
  • mode-sqlparse-0.2.2/TODO
    • 
      
  • mode-sqlparse-0.2.2/tests/test_tokenize.py
    • 
      
  • mode-sqlparse-0.2.2/tests/test_split.py
    • 
      
  • mode-sqlparse-0.2.2/tests/test_regressions.py
    • 
      
  • mode-sqlparse-0.2.2/tests/test_parse.py
    • 
      
  • mode-sqlparse-0.2.2/tests/test_grouping.py
    • 
      
  • mode-sqlparse-0.2.2/tests/test_format.py
    • 
      
  • mode-sqlparse-0.2.2/tests/test_cli.py
    • 
      
  • mode-sqlparse-0.2.2/tests/files/test_cp1251.sql
    • 
      
  • mode-sqlparse-0.2.2/tests/files/stream.sql
    • 
      
  • mode-sqlparse-0.2.2/tests/files/huge_select.sql
    • 
      
  • mode-sqlparse-0.2.2/tests/files/function.sql
    • 
      
  • mode-sqlparse-0.2.2/tests/files/function_psql4.sql
    • 
      
  • mode-sqlparse-0.2.2/tests/files/function_psql3.sql
    • 
      
  • mode-sqlparse-0.2.2/tests/files/function_psql2.sql
    • 
      
  • mode-sqlparse-0.2.2/tests/files/function_psql.sql
    • 
      
  • mode-sqlparse-0.2.2/tests/files/dashcomment.sql
    • 
      
  • mode-sqlparse-0.2.2/tests/files/begintag.sql
    • 
      
  • mode-sqlparse-0.2.2/tests/files/begintag_2.sql
    • 
      
  • mode-sqlparse-0.2.2/tests/files/_Make_DirEntry.sql
    • 
      
  • mode-sqlparse-0.2.2/tests/conftest.py
    • 
      
  • mode-sqlparse-0.2.2/tests/__init__.py
    • 
      
  • mode-sqlparse-0.2.2/sqlparse/utils.py
    • 
      
  • mode-sqlparse-0.2.2/sqlparse/tokens.py
    • 
      
  • mode-sqlparse-0.2.2/sqlparse/sql.py
    • 
      
  • mode-sqlparse-0.2.2/sqlparse/lexer.py
    • 
      
  • mode-sqlparse-0.2.2/sqlparse/keywords.py
    • 
      
  • mode-sqlparse-0.2.2/sqlparse/formatter.py
    • 
      
  • mode-sqlparse-0.2.2/sqlparse/filters/tokens.py
    • 
  








        

      

      

          

  
Uploaded

  over 7 years ago




  

    
Package Size

    51.7 KB
  




          
          

  
Downloads

  

    

      
82

    

    
  




          

  
wget

  
wget --content-disposition "https://packagecloud.io/modeanalytics/public-python/packages/python/mode-sqlparse-0.2.2.tar.gz/download?distro_version_id=166"




          
            

    
Homepage

    
      https://github.com/mode/sqlparse
  


          
          

    

      
License

        BSD