Metadata-Version: 2.1
Name: anysql
Version: 0.0.1
Summary: Lightweight, Thread-Safe, Version-Agnostic, SQL Client Implementation
Home-page: https://github.com/imgurbot12/anysql
Author: Andrew Scott
Author-email: imgurbot12@gmail.com
License: MIT
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.7
Description-Content-Type: text/markdown
Provides-Extra: mysql
Provides-Extra: postgresql
License-File: LICENSE

AnySQL
-------
Lightweight, Thread-Safe, Version-Agnostic, SQL Client Implementation 
inspired by [Databases](https://github.com/encode/databases)

### Example

```python
# Create a database instance, and connect to it.
from anysql import Database
database = Database('sqlite://:memory:')
database.connect()

# Create a table.
query = """CREATE TABLE HighScores (id INTEGER PRIMARY KEY, name VARCHAR(100), score INTEGER)"""
database.execute(query=query)

# Insert some data.
query = "INSERT INTO HighScores(name, score) VALUES (:name, :score)"
values = [
    {"name": "Daisy", "score": 92},
    {"name": "Neil", "score": 87},
    {"name": "Carol", "score": 43},
]
database.execute_many(query=query, values=values)

# Run a database query.
query = "SELECT * FROM HighScores"
rows = database.fetch_all(query=query)
print('High Scores:', rows)
```
