python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - sqlalchemy

Converting raw sql query to SQL Alchemy ORM

I'm currently executing this query in one process: SELECT DISTINCT ON (c.api_key, worker_id) worker_id, c.api_key, a.updated_at, b.user_id, a.country FROM TABLE_A a INNER JOI...
test-img

Enrique Ortiz Casillas

python

sqlalchemy

Votes: 0

Answers: 1

Latest Answer

Yes, it's possible. But the exact way to do it will depend on your SQLAlchmey version and how you've setup your SQLAlchemy project and models. You may want to check out the SQLAlchemy ORM querying gui...
test-img

Elias Dorneles

SQLAlchemy fails to insert decimal only on temp table

Trying to insert into temp tables with SQLAlchemy (plugged into PYODBC/sql server) and inserting more than one row with decimal values and fast_executemany=True throws: ProgrammingError("(pyodbc...
test-img

manoftheyear

python

sql-server

sqlalchemy

pyodbc

Votes: 0

Answers: 1

Latest Answer

fast_executemany=True asks the ODBC driver what the column types are, and the default mechanism used by Microsoft's ODBC drivers for SQL Server is to call a system stored procedure named sp_describe_u...
test-img

Gord Thompson

Creation timestamp of a row in SQLAlchemy

Using SQLAlchemy ORM, what is a good way to record the creation time of a record, without overwriting the creation time on subsequent updates? Here's a sample table definition: class Car: model = ...
test-img

John Gordon

python

sqlalchemy

insert

Votes: 0

Answers: 1

Latest Answer

Try: from sqlalchemy.sql import func class Car: model = Column(String, primary_key=True) latest_model_year = Column(Integer) created = Column(DateTime, default=func.now()) # <- HERE ...
test-img

Corralien

Does SQLAlchemy close sessions after commit()?

So this question is a little like Does SQLAlchemy reset the database session between SQLAlchemy Sessions from the same connection? I have a Flask/SQLAlchemy/Postgres app, which intermittently seems to...
test-img

Nick M

python

postgresql

sqlalchemy

Votes: 0

Answers: 1

Latest Answer

So the answer in here seems to be that commit() does perform a checkin with this pattern: https://github.com/sqlalchemy/sqlalchemy/issues/4925 if Session is what you're working with then yes, the Ses...
test-img

Nick M

Posts

Questions

Blogs

Jobs