semvec/pypi-packages huggingface dataset:
sdi-utils 0.0.1
Mocking SAP Data Intelligence api for local testing
Keywords: SAP Data Intelligence,local development,mocking api

# Mock SAP Data Intelligence api

This small package can be used to mock the api-package of SAP Data Intelligence in order to develop an operator locally. 
It is assumed that the working directory has the SAP Data Intelligence vflow-structure (github-pull) and the 
Python-operator has been created previously with the 'Create Operator'-wizzard of the modeler. For details a blog
 will be published on SAP Community in May 2021. 
 
To use the this add at the beginning of your script the following codelines: 

```
try:
    api
except NameError:
    from utils.di_local_test import *
```

The following api attributes will be mocked: 

* **config**: with the attributes read from the operators.json-file
* **Message**: creating a Message with attributes and body as attributes
* **send**: prints the content of the message that is send to the port. Only the message data types `string' and 'message' are 
currently supported.
sqlite3-crud-2021 0.0.2
An simple and easy CRUD to SQLITE3
Requires Python: >=3.6

# SQLITE3 CRUD

### 1 - Import file

from sqlite3_crud import Db

### 2 - <i>Db([local database])</i>

db = Db('database.db')

### 3 - <i>db.create_database([database])</i>

db.create_database(db)

### 4 - <i>db.create_table([table],[columns type parameters])</i>

db.create_table('tb_test', 'id integer primary key autoincrement, name text, status integer')

### 5 - <i>db.truncate_table([table])</i>

db.truncate_table('tb_test')

### 6 - <i>db.drop_table([table])</i>

db.drop_table('tb_test')

### 7 - <i>db.insert([table],[columns],[values])</i>

db.insert('tb_test', 'name,status', '"Joe Climb",0')

### 8 - <i>db.update([table],[set],[where])</i>

db.update('tb_test', 'name = "Joe Caruzo", status = 0', 'status = 1')

### 9 - <i>db.delete([table],[where])</i>

db.delete('tb_test','id = 1, status = 0')

### 10 - <i>db.select([table],[columns],[where],[groupby],[orderby])</i>

print(db.select('tb_test','name,count(*)','id > 0, status != 0', 'name', 'name asc'))

### 11 - <i>db.sql([query])</i>

print(db.sql('select * from tb_test '))