Metadata-Version: 2.1
Name: odbcdol
Version: 0.0.3
Summary: odbc (through pyodbc) with a simple (dict-like or list-like) interface
Home-page: https://github.com/i2mint/odbcdol
Author: OtoSense
License: apache-2.0
Platform: any
Description-Content-Type: text/markdown
Requires-Dist: dol
Requires-Dist: pyodbc


# odbcdol
odbc (through pyodbc) with a simple (dict-like or list-like) interface


To install:	```pip install odbcdol```

Here's how it looks:

```python
from odbcdol import SQLServerPersister

sql_server_persister = SQLServerPersister()

print("Fetching a Record")
print(sql_server_persister[1])
print(sql_server_persister[3])
print("=========================")

print("Adding a Record")
sql_server_persister[3] = {"id": "3", "name": "new name"}
sql_server_persister[4] = {"id": "4", "name": "Hamid NEW"}
sql_server_persister[5] = {"id": "5", "name": "Hamid NEW AGAIN"}

print(sql_server_persister[3])
print(sql_server_persister[4])
print(sql_server_persister[5])
print("======================")

print("Deleting a Record")
del sql_server_persister[3]
del sql_server_persister[4]
del sql_server_persister[5]
print(sql_server_persister[3])
print("=====================")

print("Iterating over the records")
for record in sql_server_persister:
    print(record)
print("=========================")

print("Getting the length")
print(len(sql_server_persister))

```


