semvec/pypi-packages huggingface dataset:
minusSQL 0.0.3
easy sql: decorator with sql
License: Apache License 2.0

# minusSQL User Guide

------

Talk is cheap. Show me the code

```python
"""
sqlite example

 --------------------
丨     person        丨
 --------------------
丨 id        int     丨
丨 name      string  丨
 --------------------
"""
from minusSQL.db.sqlite import Sqlite
from typing import List

db = Sqlite(":memory:")


class Person:
    def __init__(self):
        self.id = None
        self.name = None
        
@db.sql("""
    create table if not exists person(
        id      integer not null primary key,
        name    varchar(127)
    )
""")
def create_person_table():
    pass



@db.sql("insert into person(name) values ({name})")
def insert(name) -> int:
    pass


@db.sql("select * from person where id={id}", model=Person)
def find(id) -> List[Person]:
    pass


@db.sql("update person set name={name} where id={id}")
def update_name(id: int, name: str) -> int:
    pass


@db.sql("delete from person where name={name}")
def delete(name: str) -> int:
    pass


if __name__ == '__main__':
    create_person_table()  # create person table
    id = insert("name001")  # id=1
    persons = find(id)  # persons=[person(id=1, name=name001)]
    rowcount = update_name(1, "name002")  # rowcount=1
    persons = find(id)  # persons=[person(id=1, name=name002)]
    rowcount = delete("name002")  # rowcount=1
    persons = find(id)  # persons=[]
```
b-aws-dynamodb-backup 1.1.1
DynamoDB.
License: Apache License 2.0
Keywords: DynamoDB

# B.AwsDynamoDbBackup

A python based package that allows you to back up, restore, and seed dynamodb database tables.

### Description

Sometimes you want to make a small modification to your dynamodb table, however it usually requires
destruction of the table itself. This library allows you to do those small modifications without 
any headache. You can easily backup all your data to your local computer, delete the table, create
a new one with desired modifications, and then simply restore it!

### Remarks

[Biomapas](https://biomapas.com) aims to modernise life-science 
industry by sharing its IT knowledge with other companies and 
the community. This is an open source library intended to be used 
by anyone. Improvements and pull requests are welcome.

### Related technology

- Python 3
- DynamoDB
- Boto3

### Assumptions

The project assumes the following:

- You have basic knowledge in python programming.
- You have basic knowledge in DynamoDB.

### Useful sources

- Read more DynamoDB:<br>
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Programming.SDKOverview.html

### Install

The project is built and uploaded to PyPi. Install it by using pip.

```
pip install b_aws_dynamodb_backup
```

Or directly install it through source.

```
pip install .
```

### Usage & Examples

The library uses boto3 AWS SDK for interacting with AWS environment. Hence,
environmental credentials (such as `aws_access_key_id`, `aws_secret_access_key`, and `region_name`)
are required.

The library exposes cli commands. Read more about them down below.

##### dyseed

Seeds your table with random data.

```shell
> dyseed TableName
```

##### dyback

Backups your whole table(s).

```shell
# Single table.
> dyback TableName

# All tables.
> dyback 
```

##### dyrest

Restores your whole table(s).

```shell
# Single table.
> dyrest TableName

# All tables.
> dyrest
```

### Testing

This project currently has no tests.

### Contribution

Found a bug? Want to add or suggest a new feature?<br>
Contributions of any kind are gladly welcome. You may contact us 
directly, create a pull-request or an issue in github platform.
Lets modernize the world together.


# Release history

### 1.1.1
* Fix DynamoDB backup chunks all being written in the same file.

### 1.1.0
* Handle byte types.

### 1.0.0
* Allow to back up all tables.
* Allow to restore all tables.

### 0.0.2
* Cleanup.

### 0.0.1
* Initial build.