| Project | Status | |
|---|---|---|
| CI/CD |    |
|
| Quality |      |
|
| Package |    |
|
| Community |       |
|
| Meta |       |
A barebones Oracle Database plugin for Litestar. This plugin is useful for when you plan to use no ORM or need to manage the Oracle connection separately.
Usage
Installation
pip install litestar-oracledb
Example
Here is a basic application that demonstrates how to use the plugin.
from __future__ import annotations
from typing import TYPE_CHECKING
from litestar import Controller, Litestar, Request, get
from litestar_oracledb import AsyncDatabaseConfig, AsyncPoolConfig, OracleDatabasePlugin
if TYPE_CHECKING:
from oracledb import AsyncConnection
class SampleController(Controller):
@get(path="/")
async def sample_route(self, request: Request, db_connection: AsyncConnection) -> dict[str, str]:
"""Check database available and returns app config info."""
with db_connection.cursor() as cursor:
await cursor.execute("select 'a database value' a_column from dual")
result = await cursor.fetchone()
request.logger.info(result[0])
if result:
return {"a_column": result[0]}
return {"a_column": "dunno"}
oracledb = OracleDatabasePlugin(
config=AsyncDatabaseConfig(
pool_config=AsyncPoolConfig(user="system", password="super-secret", dsn="localhost:1513/FREEPDB1") # noqa: S106
)
)
app = Litestar(plugins=[oracledb], route_handlers=[SampleController])
1 maintainer
Release files for litestar-oracledb 0.2.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| litestar_oracledb-0.2.0.tar.gz | 70.4 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| litestar_oracledb-0.2.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 85.2 kB
Release files / litestar_oracledb-0.2.0.tar.gz
| Download URL | litestar_oracledb-0.2.0.tar.gz |
|---|---|
| Size | 70.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
44323e8715e45d244342ca5e68cb8c0f9e1a50d142b8dc9a2a453038c8371e89
|
|
BLAKE2b-256 checksum How to use checksums |
3bb4b3818ecaab4dd7ca33d99d94962b92930d2c43e2c9ac0b7584909145df64
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/5.1.1 CPython/3.12.5
|
Release files / litestar_oracledb-0.2.0-py3-none-any.whl
| Download URL | litestar_oracledb-0.2.0-py3-none-any.whl |
|---|---|
| Size | 14.8 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
e8de5c5cba016b609b792b7c161e6f829f9039a7ba87d7a37ca0366750708915
|
|
BLAKE2b-256 checksum How to use checksums |
c0f9fd1fb1c3440d69d294047308fd3cf8cf5333d46be2f73efd109bddcdd772
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/5.1.1 CPython/3.12.5
|
