databases
databases copied to clipboard
encode
Async database support for Python. 🗄
Hello! When i select a bit column from a mysql table (with a raw query), the value for `1` looks like b'\x01'. In mysqlclient package i can adjust the mapping...
I've noticed that if one of my tests fails, every next test will fail with error from `async with database` claiming that connection is still on. Upon closer look I've...
Hi, I am exploring the databases module and found this issue. Following examples how to update record using 'bindparam' on sqlalchemy.org website [[here](https://docs.sqlalchemy.org/en/13/core/tutorial.html#inserts-updates-and-deletes)] and found this message UPDATE users SET...
aiosqlite and sqlite3 have this function too, in their case you would do something like: ```py async with aiofiles.open("path/to/file.sql", "r") as f: await cxn.executescript(await f.read()) ``` it could be like...
Hi, I'm currently using Python 3.6+, and I've installed databases along with the necessary "Mysql" dependencies for creating a FASTAPI based API server, but facing the issue " No Module...
A simple `COUNT(*)` works using `sqlalchemy.Engine.execute()`, but fails using `databases.Database.fetch_all()`, raising an `IndeterminateDatatypeError` exception. ```python import asyncio import databases import sqlalchemy from sqlalchemy import Column, MetaData, Text, Table, select, func...
Whenever I have SQLAlchemy table column with a default value (e.g. `Column("verified", Boolean(), default=False)`), the resulting insert statement generated by `databases` sets a `null` value for the column when that...
`databases==0.4.1` `asyncpg==0.21.0` `SQLAlchemy==1.3.20` When using SQLAlchemy's `literal` with a `date` object, it raises an exception. **Demo** ``` import asyncio from datetime import date from databases import Database from sqlalchemy import...
Step to reproduce: Python 3.7.7 ```python3 import asyncio from databases import Database url = "postgresql+aiopg://localhost:5432" async def generate_series(db, *args): async with db.connection() as conn: async for row in conn.iterate( #...
