Metadata-Version: 2.1
Name: simplysql
Version: 0.1.2
Summary: Simplified editing of SQL databases (sqlite3) without having to deal with queries!
Home-page: https://github.com/Luanee/simplysql
Author: Pit Nahrstedt
Author-email: luanee@web.de
License: MIT
Download-URL: https://github.com/Luanee/SimplySQL/archive/v0.1.0.tar.gz
Description: # SimplySQL - The easiest way to edit SQL databases!
        
        With SimplySQL you can edit SQL databases without having to have a great understanding of SQL queries. Creating, reading or editing a database is made possible by simple python commands without the need for many lines of code.
        
        ## Overview
        
        The following features are included:
        * Open or create databases
        * Open or create tables
        * Run through all rows or columns, create them or delete them
        
        *At this stage only the following databases are supported: SQLite.*
        
        ## Installation
        
        The installation is possible in two ways: either fork this github repo or use Pypi via pip.
        
        ```
        $ pip install simplysql
        ```
        
        ## Usage
        
        Because SimplySQL should work without queries, it is only necessary to import DataBase from SimplySQL
        ```python
        from simplysql import DataBase
        ```
        From this moment the fun can begin. The next step is the assignment of the database. Two methods can be used for this. The first method is a direct assignment (whereby this must be closed again at the end of processing):
        
        ```python
        DB = DataBase("tests/Test.db")
        ...
        DB.close()
        ```
        Or you can choose the with-assignment:
        ```python
        with DataBase("tests/Test.db") as DB:
        ...
        ```
        Grab a table and iterate over all rows:
        ```python
        DBtable = DB.table(0)
        
        for row in DBTable.rows():
            print(row.as_dict())
            
            # first row would be like:: {'name': 'Karl', 'age': 29, 'gender': 'female'}
        ```
        Each entry in a row can be reached by several ways where the assignment via a name depends on the name of the table columns:
        * ```row.name```, ```row["name"]```, ```row.get("name")``` or ```row[0]```
        
        To display the all content of a row you can use this functions and methods:
        * ```row.attribute()```, ```row.data```, ```row.as_list()```, ```row.as_dict()``` or ```row.as_tuple()```
        
        For a complete overview of all functions have a look at the manual and the examples. _>>> coming soon_
        
Keywords: sql,easy,queries,databases,sqlite3
Platform: UNKNOWN
Classifier: Development Status :: 3 - Alpha
Classifier: Intended Audience :: Developers
Classifier: Topic :: Software Development :: Build Tools
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 3.7
Requires-Python: >=3.7
Description-Content-Type: text/markdown
