semvec/pypi-packages huggingface dataset:
u-msgpack-python 2.8.0
A portable, lightweight MessagePack serializer and deserializer written in pure Python.
License: MIT
Keywords: msgpack serialization deserialization

u-msgpack-python is a lightweight `MessagePack <http://msgpack.org/>`_ serializer and deserializer module written in pure Python, compatible with both Python 2 and Python 3, as well as CPython and PyPy implementations of Python. u-msgpack-python is fully compliant with the latest `MessagePack specification <https://github.com/msgpack/msgpack/blob/master/spec.md>`_. In particular, it supports the new binary, UTF-8 string, and application-defined ext types. See https://github.com/vsergeev/u-msgpack-python for more information.
sql-pylib 0.14
Custom Python library for standard SQL tasks
License: MIT
Requires Python: >=3.6
Keywords: sql python

# sql_pylib

<!-- #region -->

## Install docquity_pylib package

`pip install sql_pylib`

### Create a text file containing credentials for RedShift
* Create a `creds.txt` file
* Copy paste your credentials in this format:

```
NAME_DB=sample-redshift
HOST_DB=sample-redshift-prod.....ap-southeast-1.redshift.amazonaws.com
PORT_DB=5XXX
USER_DB=XXXX
PASSWORD_DB=XXXX
```

* Note that you must copy the credentials as-is. Do not add quotation marks

## Compatibility
Right now, this works on Redshift Postgresql, and may work on MySQL (not tested)

## Sample usage
More examples how to use can be found in [Sample Usage](https://github.com/PrinceJavier/sql_pylib/blob/main/docs/01_sql_builder_functions.ipynb)

### Import and define SQLBuilder
```python
from sql_pylib.sql_builder import SQLBuilder 
DOTENV_FILE = "./creds.txt"
sql = SQLBuilder(credentials=DOTENV_FILE, sql_type='postgresql') # or sql_type='mysql'
```

### Show table in database
```python
q = sql.get_table_names(schema="schema_name")
df = sql.download(q)
```

### Show columns in a table
```python
q = sql.get_column_names(table_name="table_name", schema="schema_name")
df = sql.download(q)
```

### Run any Query/Instruction on Redshift Cluster (without needing to download)
```python
q = "SELECT 123"
sql.run_query(q)
```

#### Download Query as Pandas DataFrame
```python
q = """SELECT 123 AS test_col """
df = sql.download_query(q)
```

### Quickly download from a table (automatically gets all columns)
#### Get all columns if columns not specified
```python
q = sql.make_query(schema='schema_name',
                   table_name='table_name', 
                   filters="id BETWEEN 0 AND 5000",
                   limit=5)
df = sql.download(q.query)
```

#### Select only certain columns
```python
q = sql.make_query(schema='schema_name',
                   table_name='table_name',
                   cols=['id AS user_id', 'user_name'])
q = q.limit(5) # limit can also be defined here
df = sql.download(q.query)
```

### Building queries using SQL Builder
##### Query with conditions
```python
cols = "col1, col2, col1 + col2 AS col3"
cols = ['col1', 'col2', 'col1 + col2 AS col3']

table1 = "user_table"
table2 = "item_table"
conditions = "col1 > col2 AND col1 > 0"

q = (SQLBuilder()
     .select(cols)
     .from_table(table1)
     .where(conditions))

# print corresponding SQL query
print(q.query)
```
<!-- #endregion -->
lazy-alchemy 1.0.3
Lazy-Alchemy is a Python package that loads the DB models lazily.
License: MIT
Requires Python: >=3.6
Keywords: sqlalchemy,alchemy,mysql,postgres,mssql,sql,sqlite,lazy,performance,orm,mapper,performance,database,lazy,relational,classes,oops,metaclass

# 🅛🅐🅩🅨-🅐🅛🅒🅗🅔🅜🅨

*Lazy-Alchemy* is a Python package that loads the database models lazily. It's a wrapper on top of sqlalchemy, so the Lazy-Alchemy can be used with any framework or project that use sqlalchemy.

Sqlalchemy loads the entire metadata of all models during the application startup, thus increases the app start up time significantly. In projects where there are 100s of database models, the start up time can be in minutes due to loading of models metadata.

Lazy-Alchemy is an attempt to solve the above mentioned problem. Lazy-Alchemy significantly boosts the start up time from minutes to seconds. It also saves memory by only loading the models "on-demand", and not loading every model.



[![Pypi tag](https://img.shields.io/pypi/v/lazy_alchemy.svg?style=flat-square&label=version)](https://pypi.org/project/lazy_alchemy/) [![build](https://github.com/joke2k/faker/workflows/Python%20Tests/badge.svg?branch=master&event=push)](https://github.com/satyamsoni2211/lazy_alchemy/actions) [![Licence](https://img.shields.io/badge/license-MIT-blue.svg?style=flat-square)](https://github.com/satyamsoni2211/lazy_alchemy/blob/master/LICENSE)
![PyPI - Python Version](https://img.shields.io/pypi/pyversions/lazy_alchemy)
![GitHub repo size](https://img.shields.io/github/repo-size/satyamsoni2211/lazy_alchemy)
![Codecov](https://img.shields.io/codecov/c/github/satyamsoni2211/lazy_alchemy)
[![CodeFactor](https://www.codefactor.io/repository/github/satyamsoni2211/lazy_alchemy/badge)](https://www.codefactor.io/repository/github/satyamsoni2211/lazy_alchemy)
[![Scrutinizer Code Quality](https://scrutinizer-ci.com/g/satyamsoni2211/lazy_alchemy/badges/quality-score.png?b=master)](https://scrutinizer-ci.com/g/satyamsoni2211/lazy_alchemy/?branch=master)
[![Code Intelligence Status](https://scrutinizer-ci.com/g/satyamsoni2211/lazy_alchemy/badges/code-intelligence.svg?b=master)](https://scrutinizer-ci.com/code-intelligence)
----

### Compatibility


This package is compatible with Python >= 3.6

### Basic Usage


Install with pip:

```bash
    pip install lazy-alchemy
```


```python
    from lazy_alchemy import get_lazy_class
    from sqlalchemy import create_engine

    db_engine = create_engine(DB_CONNECT_STRING)
    lazy_db = get_lazy_class(db_engine)
```

```python
    # SqlAlchemy DB Queries
    db_model = lazy_db.my_db_table_foo

    query = session.query(db_model).filter(db_model.foo == "bar").all()
```

Tests
-----

Run tests:

```bash
    pytest
```


License
-------

Lazy-Alchemy is released under the MIT License. See the bundled [`LICENSE`](https://github.com/satyamsoni2211/lazy_alchemy/blob/master/LICENSE) file
for details.
longpython 0.1.1
CLI tool to print long python
License: MIT
Requires Python: >=3.9,<4.0

# longpython

[![PyPI](https://img.shields.io/pypi/v/longpython?color=blue)](https://pypi.org/project/longpython/)

_looooooooooooooooooooong python!_

## Usage

```shellsession
$ longpython
  _
(" ヽ
   \ \
   / /
   \ \ _ ,
    \___/

$ longpython -h
usage: longpython [-h] [-l INT]

CLI tool to print long python

optional arguments:
  -h, --help            show this help message and exit
  -l INT, --length INT  length of python (default: 1)
```

## Installation

longpython requires python 3.9 or later.

### Via pipx (recommended)

I recommend using [pipx](https://github.com/pypa/pipx) to install this project.

```sh
pipx install longpython
```

### Via pip

```sh
pip install longpython
```

### Download Single File

The project does not have any dependencies, you can download
[this file](./longpython/main.py) and use as soon as.

## Derived Projects

- [syumai/longify](https://github.com/syumai/longify): A command to output
  longified any ascii art
- [arrow2nd/longdeno](https://github.com/arrow2nd/longdeno):
  Looooooooooooooooooooooooooooooooooooooooooooooong [Deno](https://deno.land)
- [ikanago/longferris](https://github.com/ikanago/longferris): Long
  [Ferris](https://github.com/ciusji/ferris) written in Rust
- [sheepla/longgopher](https://github.com/sheepla/longgopher): ʕ◉ϖ◉ʔ
  loooooooooooooooooooooong gopher

## License

MIT
tkinter-bounce-game 0.2.1
Simple bounce game with Python and tkinter
License: MIT
Requires Python: >=3.10,<4.0

# tkinter-bounce-game

[![PyPI](https://img.shields.io/pypi/v/tkinter-bounce-game?color=blue)](https://pypi.org/project/tkinter-bounce-game/)

Simple bounce game with Python and tkinter

## Usage

```sh
python -m tkinter_bounce_game
```

Press `<Space>` to start and press `<Left>`/`<Right>` to move paddle.

## Installation

tkinter-bounce-game requires Python 3.10 or later with `tkinter` module.

```sh
pip install tkinter-bounce-game
```