The title says it all. Here is the code snippet. async with EngineContext(uri=URI) as engine: session = async_sessionmaker(bind=engine, expire_on_commit=True)() async with session.begin(): stmt: Select = select(User).order_by(_GenerativeSelect__first=User.login_date.desc()).limit(limit=10) result = await session.execute(statement=stmt) Equivalent to the very simple query, SELECT * FROM User…
I'm having difficulty getting Saxon configured to use MySQL, in oXygen and in eXist-db. Here is my attempt in eXist-db xquery. There are no errors, I do get a connection object (so the fields extracted from my.cnf do appear to…
I have an odd question. I have three tables all with different information but a few common columns. I want to get a sum from the tables, but I also want to know which table the data came from. I…
I have a table called cc_index and the table has among others the following columns: length, date, url, [other_colums]. The same url may appear in multiple rows. For each url, I only want to retain a single row (but all…
SHA() method giving different result for same value of binary with different sizes. Created a table, columns with X1 binary(1), X2 binary(10) size. CREATE TABLE TEST_binary10_2 ( PK bigint NOT NULL, VERSION int NOT NULL, X1 binary(1) DEFAULT NULL, X2…
I have a table named "article" containing 1,145,141 records with various fields including "id," "uiqPID," "tenant," "status," "title," "body," "user_id," "category_id," "created_at," and "updated_at." The "status" column can have one of three values: 'PUBLISHED,' 'DRAFT,' or 'ARCHIVED,' with the following…
I have faced this scenario in one of my interview. There will one table with millions of records and the table is going to have only two columns id which is primary key and time_stamp which is of type date…
I'm a bit stuck writing something that should be pretty simple, so I need your help. I have one main table "posts", and two other related tables "categories" and "sectors". I'm making the filter route, and the logic should be…
I would like to modify a function in my schema. When it calculates the other_leave_count_per_staff, it's getting the data from leave_type_table. In the table, i have a column calculate_efte, true or false (1 and 0). But in my function, i…
I have two tables with same structure. One table contains old value and another table contains new value of all columns. I want to get out out as columns as 1 column and old and new value row wise with…