semvec/pypi-packages huggingface dataset:
sqlalchemy-migration-maker 0.4
SQLAlachemy migration maker.Generate SQL command to auto migrate
Requires Python: >=3.6
Keywords: sqlalchemy migration database db postgres python python3

# SQLAlchemy Migration Maker
[SQLalchemy](https://github.com/zzzeek/sqlalchemy) 是個 Python 的 Database Library，可以與 Postgres、MySQL 與其他 Database 連結，但是卻缺少了更新 Database 的功能。 <br>
受到 [Django](https://github.com/django/django) Database 的啟發，我寫了這套件使更新更輕鬆，把 Database 結構化成特別的 Id，並存到資料庫，透過比較結構來決定需要下哪些 SQL 指令。<br>
**此套件需要自行設定**

[SQLalchemy](https://github.com/zzzeek/sqlalchemy) is a  python library that deal with database. Can be used to connect with Postgres, MySQL, etc. But it lack of builtin migrate functionality. <br>
Inspire by django db manager, I write this package to migrate db more easily. <br>
It turn Database structure into special id then store in database. <br>
When there's new version structure, it compares two version then decide what SQL command need to be executed. <br>
**This package need to setup yourself**

## Intall
`pip install sqlalchemy-migration-maker`

## Requiremnt
- sqlalchemy

## Testing
#### Require psycopg2
In my testing, I use postgres database to execute sql language

### Tested Envirment
- MacOSX
- Python3

### Tested Database
- Postgres

## Example
model.py

```python
from sqlalchemy import Column
from sqlalchemy.types import Integer
from sqlalchemy.ext.declarative import declarative_base


Base = declarative_base()


class User(Base):
    __tablename__ = "user"

    id = Column(Integer, primary_key=True, autoincrement=True)

    def __repr__(self):
        return f"<User {self.id} {self.create_at}>"

```

migrate.py

```python
from .model import Base
from migrationmaker import VersionControl

version_ctl = VersionCtrol("{DB_URI}")

# 檢查版本控制是否存在於 DB
# Check version ctrl exist in DB
version_ctl.check_version_ctl_exist()

# 取回舊版本
# Retrieve old version
self.version_ctl.get_latest_version(is_old_metadata=True)

# 指定新版本
# Assign new version
self.version_ctl.new_version(Base.metadata)

if not self.version_ctl.check_same():
    self.version_ctl.migrate()

```
uipath-api 0.1.2
A wrapper for UiPath's Cloud/Local APIs
Requires Python: >=3.5

# UiPath-API

Local and Cloud UiPath API functions

I'm starting with what I already know, which was the local and cloud authentication API process.
The local process is rather simple.
But at the time, the cloud was rather complex, and the documentation was hard to follow.

The cloud process has simplified a bit, but there's still room for improvement.
I'm likely reinventing the wheel a bit with this package, but it's also for learning purposes. 
A personal goal is to maintain compatibility with the most recent supported Python versions. 
As of 3/2/2020, uipath-api is compatible with Python 3.5+.

This is my first module, and I'm by no means a python expert. 
Feel free to contribute, and constructive criticism is always welcome.

The future goal is to incorporate more of the UiPath API commands, 
and if possible, make the calls easier to work with or simplify their usage.


Updated to the latest UiPath Cloud and Local authentication API version (as of 3/1/2020).