mayim
mayim copied to clipboard
ahopkins
The *NOT* ORM hydrator
## Summary For one-off commands (i.e. no app is running), one would expect that the connection is released when an error occurs. MySQL and Postgresql pools relies on context managers...
```python DATABASE_PATH = os.path.abspath("./data/database.db") # not work DATABASE_PATH = "./data/database.db" mayim = Mayim( db_path=DATABASE_PATH, ) ``` ``` Traceback (most recent call last): File "D:\workspace\repo\automate\qt-client\gl_ui\main_loop.py", line 72, in run File "D:\Program\Python3.10\lib\asyncio\runners.py",...
Can I set default schema for my queries if i want to work only with 1 database schema and want to avoid duplicate code?
Hi, How can I add multiple sql statement with one endpoint (sqlite)? queries/mayim_mockup_origin.sql: ``` DROP TABLE IF EXISTS origin; CREATE TABLE origin ( id INTEGER PRIMARY KEY AUTOINCREMENT, hostname VARCHAR,...
Hi, My application is running `CockroachDB v22.2`. Below files are fine. (I did a small test using `psycopg3` raw inside the same project) - `ca.crt` - `client.root.crt` - `client.root.key` I'm...
It'd be great if something like this worked: ``` class User: name: str email: str class UserExecutor(...): @query(""" INSERT INTO user (name, email) VALUES ($user.name, $user.email); """) async def mayim_insert_user(user:...
Hi, I would love to use Mayim with SQL Server, so I added an SQL-Server-Executor. It uses pyODBC, which could be used for other databases as well, so a more...
https://python-driver.docs.scylladb.com/stable/getting_started.html#executing-queries https://twitter.com/IsraelFruchter/status/1536770327090536451?s=20&t=tN5y1X8JbwdZC_owknhwFg
