85 lines
2.4 KiB
Text
85 lines
2.4 KiB
Text
Metadata-Version: 2.1
|
|
Name: harlequin-odbc
|
|
Version: 0.3.1
|
|
Summary: A Harlequin adapter for ODBC drivers.
|
|
License: MIT
|
|
Author: Ted Conbeer
|
|
Author-email: tconbeer@users.noreply.github.com
|
|
Requires-Python: >=3.9,<3.14
|
|
Classifier: License :: OSI Approved :: MIT License
|
|
Classifier: Programming Language :: Python :: 3
|
|
Classifier: Programming Language :: Python :: 3.9
|
|
Classifier: Programming Language :: Python :: 3.10
|
|
Classifier: Programming Language :: Python :: 3.11
|
|
Requires-Dist: harlequin (>=1.25,<3)
|
|
Requires-Dist: pyodbc (>=5.0,<6.0)
|
|
Description-Content-Type: text/markdown
|
|
|
|
# harlequin-odbc
|
|
|
|
This repo provides the ODBC adapter for Harlequin.
|
|
|
|
## Installation
|
|
|
|
`harlequin-odbc` depends on `harlequin`, so installing this package will also install Harlequin.
|
|
|
|
### Pre-requisites
|
|
|
|
You will need an ODBC driver manager installed on your OS. Windows has one built-in, but for Unix-based OSes, you will need to download and install one before installing `harlequin-odbc`. You can install unixODBC with `brew install unixodbc` or `sudo apt install unixodbc`. See the [pyodbc docs](https://github.com/mkleehammer/pyodbc/wiki/Install) for more info.
|
|
|
|
Additionally, you will need to install the ODBC driver for your specific database (e.g., `ODBC Driver 18 for SQL Server` for MS SQL Server). For more information, see the docs for your specific database.
|
|
|
|
### Using pip
|
|
|
|
To install this adapter into an activated virtual environment:
|
|
```bash
|
|
pip install harlequin-odbc
|
|
```
|
|
|
|
### Using poetry
|
|
|
|
```bash
|
|
poetry add harlequin-odbc
|
|
```
|
|
|
|
### Using pipx
|
|
|
|
If you do not already have Harlequin installed:
|
|
|
|
```bash
|
|
pip install harlequin-odbc
|
|
```
|
|
|
|
If you would like to add the ODBC adapter to an existing Harlequin installation:
|
|
|
|
```bash
|
|
pipx inject harlequin harlequin-odbc
|
|
```
|
|
|
|
### As an Extra
|
|
Alternatively, you can install Harlequin with the `odbc` extra:
|
|
|
|
```bash
|
|
pip install harlequin[odbc]
|
|
```
|
|
|
|
```bash
|
|
poetry add harlequin[odbc]
|
|
```
|
|
|
|
```bash
|
|
pipx install harlequin[odbc]
|
|
```
|
|
|
|
## Usage and Configuration
|
|
|
|
You can open Harlequin with the ODBC adapter by selecting it with the `-a` option and passing an ODBC connection string:
|
|
|
|
```bash
|
|
harlequin -a odbc 'Driver={ODBC Driver 18 for SQL Server};Server=tcp:harlequin-example.database.windows.net,1433;Database=dev;Uid=harlequin;Pwd=my_secret;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;'
|
|
```
|
|
|
|
The ODBC adapter does not accept other options.
|
|
|
|
For more information, see the [Harlequin Docs](https://harlequin.sh/docs/odbc/index).
|
|
|