Tag: sqlalchemy

SQLAlchemy engine.connect() fails for Snowflake using keypair authentication

pandas python snowflake-cloud-data-platform sqlalchemy

My goal is to be able to write a pandas dataframe to Snowflake using the to_sql() function. I am able to successfuly query from Snowflake using read_sql() with no problems. It appears that to_sql() requires a slightly different configuration I can’t figure out. I’ve tried two different approaches that I’ve outlined below. I’m guessing, but could be wrong that the

I want to add data to my table using ORM in python

orm python sqlalchemy

I want to add data in my database using ORM, and i am new to ORM in python. I am confused in SQLAlchemy and Flask-SQLAlchemy.”I tried this but don’t know how to proceed further Answer Flask-SqlAlchemy is commonly used for flask applications, otherwise just plain SqlAlchemy would should be enough. Flask-SqlAlchemy is a wrapper over SqlAlchemy and gives you following

sqlalchemy foreign key could not find table

database flask-sqlalchemy python sqlalchemy sqlite

I’m making a database using sqlalchemy which consists of three classes, User, Meeting, MeetingRoom I want to create a foreign key in Meeting for the Meeting room, but for some reason it gives the following error sqlalchemy.exc.NoReferencedTableError: Foreign key associated with column ‘meeting.mrid’ could not find table ‘meetingroom’ with which to generate a foreign key to target column ‘mrid’ When

How to access “count” value as dict/property in sqlalchemy with group_by?

python sqlalchemy

I am making a very simple query using ORM SQLAlchemy, in which I expect to get a column (type) as well as its occurences for each value (count with group by). I can access the type column by accessing the type property on the server object (as shown in the code provided). I can also access the count column by

how flask-sqlalchemy turn off returning id while insert data

flask-sqlalchemy python sqlalchemy

I’m trying to insert data to PostgreSQL 8.3.23 by Flask-SQLAlchemy==2.3.2, the errors show that INSERT statement is not supported in this version of Greenplum Database. so how can I turn off returning id in (flask-)sqlalchemy while insert. Thanks in advance Answer You need to set the implicit_returning create_engine parameter to False. When True, a RETURNING- compatible construct, if available, will

Connecting to Cloud SQL from Google Cloud Function using Python and SQLAlchemy

google-cloud-functions google-cloud-platform google-cloud-sql python sqlalchemy

I read all documentation related to connecting to MysQL hosted in Cloud SQL from GCF and still can’t connect. Also, tried all hints in documentation of SQLAlchemy related to this. I am using the following connection The error I got was: (pymysql.err.OperationalError) (2003, “Can’t connect to MySQL server on ‘localhost’ ([Errno 111] Connection refused)”) (Background on this error at: http://sqlalche.me/e/e3q8)

Specifying pyODBC options (fast_executemany = True in particular) using SQLAlchemy

pyodbc python sqlalchemy

I would like to switch on the fast_executemany option for the pyODBC driver while using SQLAlchemy to insert rows to a table. By default it is of and the code runs really slow… Could anyone suggest how to do this? Edits: I am using pyODBC 4.0.21 and SQLAlchemy 1.1.13 and a simplified sample of the code I am using are

How can I set model defaults based on a SqlAlchemy relationship?

python sqlalchemy

Let’s say I have the following models: I would like to be able to default the Shipment.ship_date to be the day before the Treatment.treatment_date. In other words, I want to do the following: How do I set defaults based on relationships when they’re set dynamically by methods like append? For clarification, this is a question about SqlAlchemy and when relationships

Building a connection URL for mssql+pyodbc with sqlalchemy.engine.url.URL

connection-string pyodbc python sql-server sqlalchemy

The problem… I am trying to connect to a MSSql server via SQLAlchemy. Here is my code with fake credentials (not my real credentials obviously). The code… And this is the .pyodbc error that I am getting. Additional Details But, here is what is weird… I if make a pyodbc connection and use Pandas.read_sql, then I can get data without

SQLAlchemy nested model creation one-liner

nested python sqlalchemy

I’m looking to create a new object from q2, which fails because the Question class is expecting options to be a dictionary of Options, and it’s receiving a dict of dicts instead. So, unpacking obviously fails with a nested model. What is the best approach to handle this? Is there something that’s equivalent to the elegance of the **dict for