Metadata-Version: 2.4
Name: pysqlconnector
Version: 0.2.0
Summary: dbms experiments just impp extensions for dbms
Author: Do_brx
License: MIT
Requires-Python: >=3.9
Description-Content-Type: text/markdown

# pysqlconnector

dbms experiments just impp extensions for dbms

## Install
```
pip install pysqlconnector
```

## Use
```python
import pysqlconnector

pysqlconnector.gm8lqsa.print()            # print every file of experiment 8a
pysqlconnector.gm8lqsa.print("queries")   # print only 02_queries.js (any part of a file name works)
pysqlconnector.gm8lqsa.save()             # save all files into a folder named gm8lqsa
pysqlconnector.gm8lqsa.save("exp8a")      # or into a folder you name
pysqlconnector.gm8lqsa.files()            # list the files in run order
pysqlconnector.gm8lqsa.get("queries")     # file text as a string
```

MongoDB files (experiments 7, 8, 9A, 9B) are plain shell queries, one block per question:
`use <db>` first, then `// Q1 ...`, `// Q2 ...`. Copy-paste them straight into the Compass `>_ MONGOSH` shell.

Experiments 1 to 6 (SQL) are named `lqs<no>mg<slip>`, experiments 7 to 9 (MongoDB and others) are named `gm<no>lqs<slip>`.

## Experiments
| Exp | Module |
|---|---|
| 1a | `lqs1mga` |
| 1b | `lqs1mgb` |
| 1c | `lqs1mgc` |
| 2a | `lqs2mga` |
| 2b | `lqs2mgb` |
| 2c | `lqs2mgc` |
| 3a | `lqs3mga` |
| 3b | `lqs3mgb` |
| 3c | `lqs3mgc` |
| 4a | `lqs4mga` |
| 4b | `lqs4mgb` |
| 4c | `lqs4mgc` |
| 5a | `lqs5mga` |
| 5b | `lqs5mgb` |
| 5c | `lqs5mgc` |
| 6a | `lqs6mga` |
| 6b | `lqs6mgb` |
| 6c | `lqs6mgc` |
| 7a | `gm7lqsa` |
| 7b | `gm7lqsb` |
| 7c | `gm7lqsc` |
| 8a | `gm8lqsa` |
| 8b | `gm8lqsb` |
| 8c | `gm8lqsc` |
| 9a | `gm9lqsa` |
| 9b | `gm9lqsb` |
| 9c | `gm9lqsc` |
