Metadata-Version: 2.1
Name: sql-smith
Version: 1.0.0
Summary: sql-smith is an SQL query builder with zero dependencies and a fluent interface.
Home-page: https://github.com/fbraem/sql-smith
Author: Franky Braem
Author-email: franky.braem@gmail.com
Maintainer: 
Maintainer-email: 
License: MIT
Description: =========
        sql-smith
        =========
        
        **sql-smith** is an SQL query builder with zero dependencies and a fluent interface.
        
            The sentence above is, beside the name, a copy from the website of the PHP library
            Latitude_, for the simple reason that this Python module is a port of Latitude.
        
        Installation
        ************
        
        .. code-block:: sh
        
            $ pip install sql-smith
        
        Quick Start
        ***********
        
        QueryFactory is a factory to create a **SELECT**, **INSERT**, **UPDATE** or **DELETE** query.
        Use the fluent interface of the queries to complete the query.
        
        .. code-block:: python
        
            from sql_smith import QueryFactory
            from sql_smith.engine import CommonEngine
            from sql_smith.functions import field
            
            factory = QueryFactory(CommonEngine())
            query = factory \
                .select('id', 'username') \
                .from_('users') \
                .where(field('id').eq(5)) \
                .compile()
            
            print(query.sql)  # SELECT "id", "username" FROM "users" WHERE "id" = ?
            print(query.params)  # (5)
        
        When the query is ready, compile it. The return value of compile is a Query class instance
        with two properties: sql and params. Use these properties to pass the query to a database.
        
        .. code-block:: python
        
            import sqlite3
            
            db = sqlite3.connect('test.db')
            cur = db.cursor()
        
            for row in cur.execute(query.sql, query.params):
                print(row)
        
        .. _Latitude: https://latitude.shadowhand.com/
        
Keywords: sql-smith query builder querybuilder sql mysql sqlite postgres sqlserver database
Platform: UNKNOWN
Classifier: License :: OSI Approved :: MIT License
Classifier: Development Status :: 5 - Production/Stable
Classifier: Intended Audience :: Developers
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.5
Classifier: Programming Language :: Python :: 3.6
Classifier: Programming Language :: Python :: 3.7
Classifier: Programming Language :: Python :: 3.8
Classifier: Programming Language :: Python :: 3.9
Classifier: Programming Language :: Python :: 3.10
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Classifier: Operating System :: OS Independent
Description-Content-Type: text/x-rst
