Jay Marcyes
Jay Marcyes
[via](https://dba.stackexchange.com/questions/22362/list-all-columns-for-a-specified-table) ```sql SELECT column_name FROM information_schema.columns where table_name = '' ``` This seems way better than the horrible query I'm using right now ### Search * postgres 12.8 get fields...
These were the links I had open while researching supporting this in a similar manner as Postgres * [is there UID datatype in SQLITE if Yes then how to generate...
This might simplify some things ``` "SELECT * FROM foo WHERE id IN %s", [10, 20, 30] "SELECT * FROM foo WHERE id = ANY(%s)", [10, 20, 30] ``` [via](https://www.psycopg.org/psycopg3/docs/basic/from_pg2.html)...
I'm starting to standardize on: * `eq_*(value)` - takes one value and compares it against something internal * `is_*()` - True if some internal condition is True * `in_*(*values) -...
Right now there are three different list actions: * "store_list" - set to have a value like `1,2,3` be blown up to `['1', '2', '3']` * "append" - if multiple...
I've extended `call.Param` in another project and I made my new class have an async `handle` method, but that meant I needed to override `decorators.call.param.handle_param` to use `await`. If `Param.handle`...
Using [jsonapi](https://jsonapi.org/format/#errors) for a project and I'm realizing I'm not taking full advantage of the detail an exception can provide. For example, it would be great to have a ParamError...
Inspired by [jsonapi](https://jsonapi.org/format/#errors): > When a server encounters multiple problems for a single request, the most generally applicable HTTP error code SHOULD be used in the response. For instance, 400...
There could be a `Router.create_controller` method that gets called from `BaseApplication.create_controller` and then Router can internalize all the controller info stuff. A pro would be all that stuff is in...
Rename them to Request.ip_address and Request.ip_addresses