semvec/pypi-packages huggingface dataset:
pooledMySQL 4.0.2
A simple way to have MySQL connection pool which auto-scales infinitely as required. This would help remove problems caused by multithreading, also removed user hassle of manually creating and deleting connections manually.
Requires Python: >=3.6
Keywords: mysql, pool, threadedmysql, pooledmysql, multithreaded, thread, database, sql

# pooledMySQL v4.0.2

```pip install pooledMySQL --upgrade```

###### <br>A well maintained program to have MySQL connection pool which auto-scales infinitely as required. This would help remove problems caused by multithreading, also removed user hassle of manually creating and deleting connections manually.


<br>To install: 
```
pip install pooledMySQL --upgrade
pip3 install pooledMySQL --upgrade
python -m pip install pooledMySQL --upgrade
python3 -m pip install pooledMySQL --upgrade
```


#### <br><br>Using this program is as simple as:
```
from pooledMySQL import Manager as MySQLManager

executorMySQL = MySQLManager("SomeUsername", "SomePassword", "DatabaseName")

listOfDict = executorMySQL.execute("SELECT * from someTable where someColumn = ?", ["someValue"])

for individualDict in listOfDict:
    print(individualDict)
```


### <br>Future implementations:
* Classes for individual tables to make reading and writing of rows way easier for the user
* Table and database creation syntaxes

###### <br>This project is always open to suggestions and feature requests.
totindex 1.0.3
TOT指数衡量了政策文本在主题全局性、目标贯通性和工具多样性三方面的表现。较高的得分表明该政策文本在内容设计上更具全面性、协调性和丰富性；较低的得分反映了政策文本可能聚焦于特定目标或优先事项，但并不意味着政策本身存在缺陷，而是文本内容设计的取向不同。政策主题X反映了主题格局的全局性水平，得分越高表示政策对于核心主题的涵盖更加完整、全局性水平更高，反之，则更聚焦于局部核心主题。政策目标Y反映了目标优序的贯通程度，得分越高表明数量、质量、生态三个目标递进更深入、贯通性更强；反之，则表明目标贯通性相对不足。政策工具Z反映了工具结构的多样化程度，得分越高表示工具组合更具多样性；反之，则表示相对单一。TOT指数的计算原理基于模糊集赋值原则，旨在科学、合理地量化政策文本内容
Requires Python: >=3.6

# TOTIndex

TOT指数衡量了政策文本在主题全局性、目标贯通性和工具多样性三方面的表现。较高的得分表明该政策文本在内容设计上更具全面性、协调性和丰富性；较低的得分反映了政策文本可能聚焦于特定目标或优先事项，但并不意味着政策本身存在缺陷，而是文本内容设计的取向不同。政策主题X反映了主题格局的全局性水平，得分越高表示政策对于核心主题的涵盖更加完整、全局性水平更高，反之，则更聚焦于局部核心主题。政策目标Y反映了目标优序的贯通程度，得分越高表明数量、质量、生态三个目标递进更深入、贯通性更强；反之，则表明目标贯通性相对不足。政策工具Z反映了工具结构的多样化程度，得分越高表示工具组合更具多样性；反之，则表示相对单一。TOT指数的计算原理基于模糊集赋值原则，旨在科学、合理地量化政策文本内容。

## Installation

```bash
pip install totindex

## 使用实验数据文件

本包包含一个默认的实验数据文件 `TOT实验数据.xlsx`，可以通过以下方法访问文件路径：

```python
import totindex

file_path = totindex.get_data_file()
print(f"实验数据文件路径: {file_path}")

## Usage
1.在终端输入：totindex
or
2.新建python文件，输入如下命令：
import totindex

if __name__ == "__main__":
    totindex.main()
tugpgp 0.1.3a2
Tugpgp desktop application for OpenPGP keys.

## tugpgp

An utility to create and upload OpenPGP keys to Yubikey. The tool will not write the generated key on disk unless specifically asked.

Under active development.


### LICENSE: GPL-3.0-or-later


### Next create the virtualenv

```
python3 -m venv .venv 
source .venv/bin/activate
python3 -m pip install wheel
python3 -m pip install -U pip
python3 -m pip install -r requirements.txt
```

We need [johnnycanencrypt](https://github.com/kushaldas/johnnycanencrypt) version 0.13.1 or above.

### How to use the tool?


```
briefcase dev
```

![](./images/tugpgp_final_screen.png)
libre-finance 0.1.0
This tool helps financial consumers freely utilize financial services by interest calculating.
Requires Python: >=3.10

# LibreFinance

LibreFinance is a combination of the words "libre" and "finance". 

This tool helps financial consumers freely utilize financial services by interest calculating.

##  Important Notice

> In South Korea, the general interest income tax rate is 15.4% (14% interest income tax + 1.4% local tax). Please be aware of this when using the tool.

## Usage

1. Install the library using `pip install libre-finance`.
2. Import the library with `from libre_finance import LibreFinance`.

## Example

```python
from libre_finance import LibreFinance

# deposit example
lf = LibreFinance(amount=12000000, currency='KRW')
print(lf.calculate_deposit(month=6, annual_interest_rate=3.5))
print(f"amount: {lf.amount}")

# deposit example with non-taxable interest
lf = LibreFinance(amount=12000000, currency='KRW')
print(lf.calculate_deposit(month=6, annual_interest_rate=3.5, is_tax=False))
print(f"amount: {lf.amount}")

# savings example
lf = LibreFinance(amount=0, currency='KRW')
print(lf.calculate_savings(month=6, monthly_deposit=1000000, annual_interest_rate=3.5))
print(f"amount: {lf.amount}")

# savings example with non-taxable interest
lf = LibreFinance(amount=0, currency='KRW')
print(lf.calculate_savings(month=6, monthly_deposit=1000000, is_tax=False, annual_interest_rate=3.5))
print(f"amount: {lf.amount}")
```

## Features

- Deposit interest (taxable/non-taxable)
- Savings interest (taxable/non-taxable)


- sql query

if you want to use sql feature, you can install the library with the following command.

```bash
pip install libre-finance[sql]
```

```python
from libre_finance.database import MariaDBTable

t = MariaDBTable(db_name='db', user='user', passwd='passwd', host='127.0.0.1', port=3306)
```

and you can use the sql command as follows.

```sql
SELECT *
FROM `finance`
where product = "deposit" and month = 6
order by total_interest desc
limit 5;
```

## ToDo List

- Bond interest
- RP interest

## License

MIT
HaulEncryptor 0.1
A Python-based file encryption and decryption toolkit.
Requires Python: >=3.6

# Haul - File Encryption Toolkit 🔐

<p>Haul is a Python-based file encryption and decryption toolkit designed to secure your sensitive files. It uses strong AES encryption in CBC mode along with PBKDF2 for key derivation. The toolkit is simple to use and provides a command-line interface (CLI) to encrypt and decrypt files or directories.</p>

### With Haul, you can:

<ul>
	<li>Encrypt and decrypt files or entire directories with ease.</li>
	<li>Initialize a key file and password protection for encryption and decryption.</li>
	<li>Work with AES-256 encryption and secure password hashing.</li>
</ul>

## Features:-

<ul>
	<li><b>Encrypt files:</b> Secure sensitive data by encrypting files using AES-256.</li>
	<li><b>Decrypt files:</b> Decrypt encrypted files with the correct password.</li>
	<li><b>Key management:</b> Generate and store encryption keys securely.</li>
	<li><b>Directory-based operations:</b> Encrypt and decrypt multiple files within a directory.</li>
	<li><b>Easy-to-use CLI:</b> Simple commands to perform actions like initializing, encrypting, and decrypting.</li>
</ul>

## Installation:-

To install Haul, you can either clone the repository or install it directly using pip from PyPI. 

```
pip install haul
```

## Use Case Example

### 1. Initializing the Key

Run the following command to initialize the key:

```bash
haul --action init
```

*Initializing with a specified directory:*

```bash
haul --action init --directory /usr/local/bin
```

**🗒️ Note:** Initialization will make changes only within user-privileged directories. It will initialize in every privileged directory and create a `key.key` file in the specified location.

#### Additional Tips:
- Ensure you have the necessary permissions for the target directory.
- Keep the generated `key.key` file secure, as it is critical for encryption and decryption processes.

---

### 2. Encryption

Encrypt files securely using the following command:

```bash
haul --action encrypt
```

*Encryption with a specified directory:*

```bash
haul --action encrypt --directory /usr/local/bin
```
jinja2sql 0.8.0
Jinja Templates to SQL
Requires Python: ~=3.9
Keywords: database, db, jinja, queries, query, sql, template

# Jinja2SQL (Jinja To SQL)

`Jinja2SQL` is a simple and efficient library for generating SQL queries from [Jinja2](https://jinja.palletsprojects.com/en/3.1.x/) templates. It is type-friendly and offers `async` support, drawing significant inspiration from the excellent library at [jinjasql](https://github.com/sripathikrishnan/jinjasql).

[![CI](https://github.com/antonrh/jinja2sql/actions/workflows/ci.yml/badge.svg)](https://github.com/antonrh/jinja2sql/actions/workflows/ci.yml)
[![codecov](https://codecov.io/gh/antonrh/jinja2sql/branch/main/graph/badge.svg?token=67CLD19I0C)](https://codecov.io/gh/antonrh/jinja2sql)
[![Documentation Status](https://readthedocs.org/projects/jinja2sql/badge/?version=latest)](https://jinja2sql.readthedocs.io/en/latest/?badge=latest)
[![Code style: black](https://img.shields.io/badge/code%20style-black-000000.svg)](https://github.com/psf/black)

---
Documentation

http://jinja2sql.readthedocs.io/

---

## Requirements

`Python 3.9+` and `Jinja2 3.1.2+`.

## Installation

Install using `pip`:

```shell
pip install jinja2sql
```

or using `poetry`:

```shell
poetry add jinja2sql
```

## Quick Example

```python
from jinja2sql import Jinja2SQL


j2sql = Jinja2SQL(param_style="named")  # default param style is "named"

query, params = j2sql.from_string(
    "SELECT * FROM {{ table | identifier }} WHERE email = {{ email }}",
    context={"table": "users", "email": "user@mail.com"},
)

# using with your favorite database driver connection

conn.execute(query, params)
```

### Param Styles

`Jinja2SQL` supports different param styles depending on the database driver you are using.

You can choose between the following supported param styles:

```python
from jinja2sql import Jinja2SQL


j2sql = Jinja2SQL(param_style="named")  # default

query, params = j2sql.from_string(
    "SELECT * FROM table WHERE param = {{ param }}",
    context={"param": ...},
    param_style="named",  # or "qmark", "numeric", "format", "pyformat", "asyncpg"
)
```

| param_style   | Example     |
| ------------- | ----------- |
| `named`       | `:param`    |
| `qmark`       | `?`         |
| `numeric`     | `:1`        |
| `format`      | `%s`        |
| `pyformat`    | `%(param)s` |
| `asyncpg`     | `$1`        |


or you can provide a custom function to format your database specific param style:


```python
from jinja2sql import Jinja2SQL


j2sql = Jinja2SQL()

query, params = j2sql.from_string(
    "SELECT * FROM table WHERE column = {{ param }}",
    context={"param": ...},
    param_style=lambda key, _: f"{{{key}}}",
)

assert query == "SELECT * FROM table WHERE column = {email}"
```