databases

databases copied to clipboard

Support fetch_coloumn like fetch_val but for multiple records

MAKMED1337

I was trying to do something like this where the table name is part of the values in execute_many but it doesn't work... ```py queries = [] for name in...

justinrest

where in clause for sqlite

5

Awesome project! I want to use something like `select * from tables where col in ('dog', 'cat')` in sqlite3 but I don't know how to use it in raw query...

allanwakes

asyncpg version: 0.25.0 PostgreSQL version: 12.11 We have been frequently receiving this Timeout Error ``` asyncio.exceptions.TimeoutError [View similar errors](https://link.datadoghq.com/apm/error-tracking?issueId=...471-da7ad0900002) Traceback (most recent call last): File /usr/local/lib/python3.9/site-packages/ddtrace/contrib/asyncpg/patch.py, line 89, in _traced_query...

jageshmaharjan

Hi, I'm using raw queries like that: ```python record = await db.fetch_one( query='select * from table_a where id = :id', values={ # "id": 0 }) ``` If I don't provide...

conservative-dude

Without it tests fail at least on FreeBSD

mekanix

Caching disabled in sqlalchemy queries

1

There is a significant regression in speed and it's probably due to cache not being used. In [ormar PR switching to SQLAlchemy2](https://github.com/collerek/ormar/pull/1269) there is a noticeable degradation in speed, and...

mekanix

typing: fetch_one: Value of type "Optional[Mapping[Any, Any]]" is not indexable

1

Running mypy on the tests shows: > Value of type "Optional[Mapping[Any, Any]]" is not indexable with https://github.com/encode/databases/blob/88b381ae33bcb417b76b8df9149742cbbcc253b5/tests/test_databases.py#L146 This means the typing annotations should be fixed and that mypy should also...

blueyed

execute_many insert sql do not have high preformance?

1

```python async def execute_many(self, queries: typing.List[ClauseElement]) -> None: assert self._connection is not None, "Connection is not acquired" cursor = await self._connection.cursor() try: for single_query in queries: single_query, args, context =...

ShichaoMa

Bumps [black](https://github.com/psf/black) from 22.6.0 to 24.3.0. Release notes Sourced from black's releases. 24.3.0 Highlights This release is a milestone: it fixes Black's first CVE security vulnerability. If you run Black...

dependabot[bot]