[sqlalchemy] SQLAlchemy Filter Table using Model Methods

Hi , I want to filter my table using Model methods . So I have a method called get_gen_name() that gives me the actual item name from a combination of values in the tables & I want to search that . Any idea how do I achieve that ? I’m understand that there are hybrid properties / column expres

[sqlalchemy] postgresql geometry types

We are beginning to use the PostgreSQL (12) geometric types (initially the 'point' datatype) in our SA model, and was disappointed to find that the sqlalchemy postgresql dialect modules appear not to have these. So I wrote a function using schema.CreateColumn to generate the postgresql DDL acc

Re: [sqlalchemy] Encrypt/Decrypt specific column(s)

I had just created all-new revised encryption examples on the wiki and apparently I forgot to link them from the index, fixed. Here's two examples showing the general idea of how this can be done: https://github.com/sqlalchemy/sqlalchemy/wiki/SymmetricEncryptionClientSide https://github.com/sql

[sqlalchemy] Encrypt/Decrypt specific column(s)

Hi All, In one or two database tables I need to encrypt/decrypt a couple of columns. These tables/columns already exist in the DB and they already have data in them. What is the best way using SQL Alchemy to add encryption to these tables/columns? It needs to be efficient and the columns need

Re: [sqlalchemy] convert subset to dictionary

Thanks, yes, this well help a lot. On Wednesday, 8 July 2020 at 11:33:31 UTC+2 Simon King wrote: > You should start by enabling SQLAlchemy logging to see the actual > queries that are being run. The easiest way is to pass "echo=True" to > your create_engine call. (You could also try echo="debug",

Re: [sqlalchemy] convert subset to dictionary

You should start by enabling SQLAlchemy logging to see the actual queries that are being run. The easiest way is to pass "echo=True" to your create_engine call. (You could also try echo="debug", but since you've got hundreds of thousands of rows you'll be swamped) Verify that the queries look corr

Re: [sqlalchemy] convert subset to dictionary

I'd like to redesign the DB but that's not on the cards at the moment (or ever hehe). Thanks for the feedback, I appreciate all the help, I really do. What puzzles me now is, why would the looping through each student (using with_entities) and getting the subjects (using with_entities) for each