semvec/pypi-packages huggingface dataset:
dmSQLAlchemy 1.1.10
SQLAlchemy dialect for DM
Keywords: DM SQLAlchemy

dmSQLAlchemy
====================================

此包为Python的SQLAlchemy包链接达梦数据库的适配框架，当前版本为 ``1.1.10`` ，API详见安装目录下的 ``《DM8_dmPython使用手册》`` ，目前用于适配1.1及以上，1.4以下版本的SQLAlchemy。

ChangeLogs
====================================

 dmSQLAlchemy v1.1.10(2024.10.31)

- 修复了部分类型无法对应到 ``SQLAlchemy`` 支持类型的问题，当前类型支持详见 ``《DM8_dmPython使用手册》`` 第5.3节类型映射

- 修复了自增列自增值设置报错问题

- 修复了列类型为 ``Enum`` 时访问该列时报错的问题

- 修复了向blob数据执行插入操作，插入 ``NONE`` 时实际插入 `` `NONE` `` 的问题

 dmSQLAlchemy v1.1.9(2024.08.27)

- 修复了单条语句执行市场最大为30秒的问题，现执行语句默认将不再限制执行时长

- 增加了对于SQLAlchemy的 ``array`` 类型的支持

 dmSQLAlchemy v1.1.8(2023.01.06)

- 修复了主键为自增列的情况下执行插入操作报错的问题

LICENSE
====================================

The MIT License (MIT)

Copyright (c) 2017 Dameng

Permission is hereby granted, free of charge, to any person obtaining a copy of
this software and associated documentation files (the "Software"), to deal in
the Software without restriction, including without limitation the rights to
use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of
the Software, and to permit persons to whom the Software is furnished to do so,
subject to the following conditions:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS
FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR
COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER
IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN
CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
hiedwinlan 0.1.0
A simple SDK that returns Hello World
Requires Python: >=3.8

# Hiedwinlan SDK

一个简单的Python SDK，提供了返回"Hello World"的功能。这是一个示例项目，展示了如何创建和打包一个基本的Python SDK。

## 系统要求

- Python 3.8 或更高版本
- pip 21.0 或更高版本

## 开发环境设置 (Mac)

1. 安装 Python 3.8:

## 功能特点

- 简单易用的API
- 完整的文档说明
- 支持Python 3.6+
- 遵循PEP8编码规范

## 安装

你可以通过pip安装此SDK：
sqlalchemy-dm 1.1.10
SQLAlchemy dialect for DM
Keywords: DM SQLAlchemy

dmSQLAlchemy
====================================

此包为Python的SQLAlchemy包链接达梦数据库的适配框架，当前版本为 ``1.1.10`` ，API详见安装目录下的 ``《DM8_dmPython使用手册》`` ，目前用于适配1.1及以上，1.4以下版本的SQLAlchemy。

ChangeLogs
====================================

 dmSQLAlchemy v1.1.10(2024.10.31)

- 修复了部分类型无法对应到 ``SQLAlchemy`` 支持类型的问题，当前类型支持详见 ``《DM8_dmPython使用手册》`` 第5.3节类型映射

- 修复了自增列自增值设置报错问题

- 修复了列类型为 ``Enum`` 时访问该列时报错的问题

- 修复了向blob数据执行插入操作，插入 ``NONE`` 时实际插入 `` `NONE` `` 的问题

 dmSQLAlchemy v1.1.9(2024.08.27)

- 修复了单条语句执行市场最大为30秒的问题，现执行语句默认将不再限制执行时长

- 增加了对于SQLAlchemy的 ``array`` 类型的支持

 dmSQLAlchemy v1.1.8(2023.01.06)

- 修复了主键为自增列的情况下执行插入操作报错的问题

LICENSE
====================================

The MIT License (MIT)

Copyright (c) 2017 Dameng

Permission is hereby granted, free of charge, to any person obtaining a copy of
this software and associated documentation files (the "Software"), to deal in
the Software without restriction, including without limitation the rights to
use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of
the Software, and to permit persons to whom the Software is furnished to do so,
subject to the following conditions:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS
FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR
COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER
IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN
CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
dmDjango 3.0.3
Dameng database backend for Django

dmDjango
====================================

Django是基于Python的Web应用程序框架，dmDjango是DM提供的Django连接达梦数据库的驱动，当前版本为 ``3.0.3`` ，API详见安装目录下的 ``《DM8_dmPython使用手册》`` ，目前用于适配3.0以上版本的Django。

ChangeLogs
====================================

 dmDjango v3.0.3(2024.08.09)

- 整理代码格式，去除冗余代码

 dmDjango v3.0.2(2024.04.10)

- 增加了对于 ``Django 5.0`` 新版本的支持，修复了新版本下部分函数报错问题

- 修复了使用Django新创建用户无法使用的问题，新创建用户将默认获得 ``SOI角色`` 的权限

 dmDjango v3.0.1(2023.03.15)

- 增加了对于 ``Django 4.1`` 新版本的支持，修复了新版本下部分函数报错问题

 dmDjango v3.0.0(2023.02.28)

- 创建框架适配包，用于兼容 ``3.0`` 以上版本的Django框架


LICENSE
====================================

Copyright (c) dmDjango Software Foundation and individual contributors.
All rights reserved.

Redistribution and use in source and binary forms, with or without modification,
are permitted provided that the following conditions are met:

    1. Redistributions of source code must retain the above copyright notice,
       this list of conditions and the following disclaimer.

    2. Redistributions in binary form must reproduce the above copyright
       notice, this list of conditions and the following disclaimer in the
       documentation and/or other materials provided with the distribution.

    3. Neither the name of dmDjango nor the names of its contributors may be used
       to endorse or promote products derived from this software without
       specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR
ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
(INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
postgreasy 1.1.1
A simple package for interacting with a Postgres Database.
Requires Python: >=3.10

# Postgreasy

This package contains some simple helper functions to interact with a postgress database. Makes use of a `.env` file to make the connection with the database. It's basically a simple wrapper around the `psycopg2` library.

Fill in the following 4 parameters in the `.env` file in the root folder like so:

```lua
postgres_host = ...
postgres_username = ...
postgres_database = ...
postgres_password = ...
```

## Methods

### Create a database

```py
import postgreasy

postgreasy.create_database(database_name='example_db')
```

### Create a schema

```py
import postgreasy

postgreasy.create_schema(database_name='example_db')
```

### Create a table

```py
import postgreasy
from psycopg2 import sql

postgreasy.create_table('example_schema', 'example_table', sql.SQL('id serial, temperature int, name text'))
```

### Execute a query

```py
import postgreasy
from psycopg2 import sql

postgreasy.execute(sql.SQL('...'))
```

### Fetch with a query (Execute a query and get the results)

```py
import postgreasy
from psycopg2 import sql

x = postgreasy.execute(sql.SQL('select 1'))
```

### Insert a Pandas DataFrame

```py
import postgreasy
import pandas as pd

df = pd.DataFrame({'x': [1, 2, 3], 'y': [5, 28, 8]})
postgreasy.insert_df(df, 'example_schema', 'example_table')
```

## Connection

Normally when you execute one of the postgreasy methods, a connection is automatically established and closed. For example:

```py
import postgreasy
from psycopg2 import sql

postgreasy.execute_query_on_db(sql.SQL('select 1'))
```

To create a connection without the .env or if you want to execute multiple queries and not create a connection for each separate query there are 2 ways to go about it. Either use the `get_connection()` method or use the `with ...` structure with a `PostgresConnection()` object. The latter is the preferred option as it requires less steps that can be forgotten.

### `get_connection()`

This way you create a connection object which you supply to the other postgreasy methods. Here you have to remember to manually close the connection with the `.close()` function.

**Example:**

```py
import postgreasy
from psycopg2 import sql

conn = postgreasy.get_connection(host='...', database='...', username='...', password='...')
postgreasy.execute_query_on_db(sql.SQL('select 1'), conn )
conn.close()

```

### `PostgresConnection()`

In this case the connection is automatically opened, you also don't have to supply the connection paramter to the postgreasy methods.

**Example:**

```py
import postgreasy
from psycopg2 import sql

with PostgresConnection(host='...', database='...', username='...', password='...') as conn:
    conn.execute_query_on_db(sql.SQL('select 1') )
```

## Contact

Go to the GitHub page if you hav any issues.