semvec/pypi-packages huggingface dataset:
coplin-db2 2.4
Um módulo de conveniência para manipulação de bancos de dados IBM DB2 em Python.
License: MIT
Requires Python: <3.12,>=3.8

# coplin-db2

A biblioteca coplin-db2 é um módulo de conveniência para acessar bancos de dados do tipo IBM DB2, desenvolvido pela 
Coordenadoria de Planejamento Informacional da UFSM (COPLIN).

Com esta biblioteca, é possível definir um arquivo com credenciais de acesso ao banco de dados, no formato `json`, que 
podem ser utilizadas posteriormente:

Arquivo `credentials.json`:

```json
{
  "user": "nome_de_usuário",
  "password": "sua_senha_aqui",
  "host": "URL_do_host",
  "port": 50000,
  "database": "nome_do_banco"
}
```

Arquivo `db2_schema.sql`:

```sql
CREATE TABLE USERS_TEST_IBMDB2(
    ID INTEGER NOT NULL PRIMARY KEY,
    NAME VARCHAR(10) NOT NULL,
    AGE INTEGER NOT NULL
);

INSERT INTO USERS_TEST_IBMDB2(ID, NAME, AGE) VALUES (1, 'HENRY', 32);
INSERT INTO USERS_TEST_IBMDB2(ID, NAME, AGE) VALUES (2, 'JOHN', 20);

```

Arquivo `main.py`:

```python
import os
from db2 import DB2Connection

# arquivo JSON com credenciais de login para o banco de dados
credentials = 'credentials.json'

with DB2Connection(credentials) as db2_conn:
    db2_conn.create_tables('db2_schema.sql')
    query_str = '''
        SELECT * 
        FROM USERS_TEST_IBMDB2;
     ''' 
    df = db2_conn.query_to_dataframe(query_str)
    
    print(df)
    
    # deleta a tabela
    # db2_conn.modify('''DROP TABLE USERS_TEST_IBMDB2;''', suppress=False)
```

A saída esperada deve ser:

```bash
   ID   NAME  AGE
0   1  HENRY   32
1   2   JOHN   20
```

## Instalação

Para instalar o pacote pelo pip, digite o seguinte comando:

```bash
pip install coplin-db2
```

## Documentação

A documentação está disponível em https://coplin-ufsm.github.io/db2

## Desenvolvimento

Para instruções de desenvolvimento do pacote, consulte [este arquivo](https://github.com/COPLIN-UFSM/db2/blob/main/DEVELOPMENT.md).

## Contato

Biblioteca desenvolvida originalmente por Henry Cagnini: [henry.cagnini@ufsm.br]()

Caso encontre algum problema no uso, abra um issue no [repositório da biblioteca](https://github.com/COPLIN-UFSM/db2).

Pull requests são bem-vindos!
EstateEdgePy 0.7.2
EstateEdgePy is a powerful and user-friendly asynchronous Python package designed to enhance data analysis of property data.
License: MIT
Requires Python: <4.0,>=3.10
Keywords: EstateEdgePy, DataDock-AI, python, Real Estate

# EstateEdgePy Library  

-----

![Python Versions](https://img.shields.io/badge/python-3.12|3.13|3.14-blue) 
![Latest Release](https://img.shields.io/badge/Release-v0.1.0-blue.svg)


## Introduction

`EstateEdgePy` is a powerful and user-friendly asynchronous Python package designed to enhance data analysis.


## Get Started on Windows/MacOS/Linux Terminal

-------

You can use `Poetry` or any dependency manager or use the general `pip install` command to install `datadock`.

### Using pip command to install `EstateEdgePy`

```commandline
pip install EstateEdgePy
```

### Using Poetry to install `EstateEdgePy`


1. Open your terminal and install poetry _[if you do not have poetry]_ using `pip`.
    
    ```commandline
   pip install poetry
   ```
   or Install poetry using `pipx`.
    
    ```commandline 
   pipx install poetry
    ```
   or Install using `curl`

   ```commandline
   curl -sSL https://install.python-poetry.org | python3 -
   ```

2. Create a project using poetry command. This will create a `pyproject.TOML` in your project.
Follow the instructions to finish creating your project

    ```commandline
    poetry new project_name
    ```

3. Change directory to your project

   ```commandline
   cd project_name
   ```

4. Run the poetry command to add `EstateEdgePy`: 

    ```commandline
   poetry add EstateEdgePy
   ```


## Use EstateEdgePy with Jupyter

----------

1. Open notebook in your project and install `datadock` using `pip` command.
    
    ```bash
   !pip install EstateEdgePy
   ```

----------------------------------


## How to use the latest version of `EstateEdgePy` in your terminal.

   ```commandline
   pip install --upgrade EstateEdgePy
   ```

or

   ```commandline
   pip install EstateEdgePy==<latest version number here>   
   ```