semvec/pypi-packages huggingface dataset:
Sqlcarve 0.4.31
Sql Parser and Validator
Requires Python: >=3.6

# sqlcarve
[![PyPI](https://img.shields.io/pypi/v/sqlcarve)](https://pypi.org/project/Sqlcarve/)
[![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](https://opensource.org/licenses/)

SQL Parser for Teachers


# SQL Validation and execution

__fichier.sql__ est le fichier à valider.
__ref_stmnt__ est la requête de référence pour la validation sémantique.
__referencefile.json__ est le modèle de commentaire pour la validation des commentaires.
    

__Exemple de referencefile.json__
```json
{
  "profcomments": {
    "auteur": "",
    "objectif": "",
    "documentation": ""
  },
  "studentcomments": {
    "author": "",
    "cip": "",
    "objectif": ""
  }
}
```


__Exemple d'utilisation__
```python
from src.sqlcarve.validator.validator import *

valid = Validator()
report = {}
with open("fichier.sql", "r") as f_content:
    statement_list = Preprocessor.extract_stmnts(f_content)

    for stmnt in statement_list:
        report = valid.validate(statement=stmnt, ref_statement=ref_stmnt, ref_comments="referencefile.json", type="all")

print(report)
```

__Résultat__

```
    {'commentaires': [], 'syntax': 'Validation syntaxique réussie', 'semantique': 'Validation sémantique réussie'}
```

<a href="https://www.usherbrooke.ca/">
  <img src="src/resources/developed-by-usherbrooke.svg">
</a>
save-mongopy 1.0.1
This is a module for importing dictionary or list data into mongodb database. Before importing, it will check for duplication. If it exists, it will not be imported. If it does not exist, it will be imported. The standard for checking whether there is duplication is a relatively unique key.

# Description
>This is a module for importing dictionary or list data into mongodb database. Before importing, it will check for duplication. If it exists, it will not be imported. If it does not exist, it will be imported. The standard for checking whether there is duplication is a relatively unique key