I am trying to connect to our remote sql server db via Jupyter Labs using the SQL magics. I can connect with a traditional connection string, but the SQL magics doesnt seem to work (which means I a...

I want to use multiprocessing module with sqlAlchemy in my custom class. Here is the code: from sqlalchemy import create_engine engine = create_engine(f'mysql+pymysql://a:b@localhost:3306/', serv...

im very new to sqlite, im using macbook m1, im try to use jupyter notebook to do sql here is my code %load_ext sql import csv, sqlite3 con = sqlite3.connect("socioeconomic.db") cur = co...

After installing pyodbc in a docker container I'm receiving the error: File "/root/.local/lib/python3.10/site-packages/sqlalchemy/connectors/pyodbc.py", line 43, in dbapi return __impor...

I'm trying to connect the alembic library to the databases and sqlalchemy libraries. As a guide, I use this example link My projects file: db.py from databases import Database from sqlalchemy impor...

I am attempting to execute a raw sql insert statement in Sqlalchemy, SQL Alchemy throws no errors when the constructed insert statement is executed but the lines do not appear in the database. As f...

How to convert string to model type in FastAPI? If I have Student model and want to convert string student to type model. How to convert it? engine = create_engine(SQLALCHAMY_DATABASE_URL,pool_pre_...

Suppose I have the following (in Python 3 and SQLAlchemy): class Book(Base): id = Column(Integer, primary_key=True) chapters = relationship("Chapter", backref="book") class Chapter(Base): id =...

Suppose I have an engine pointing at MySQL database: engine = create_engine('mysql://arthurdent:answer42@localhost/dtdb', echo=True) I can populate dtdb with tables, FKs, etc by: metadata.creat...

I would like to use autoload to use an existings database. I know how to do it without declarative syntax (model/_init_.py): def init_model(engine): """Call me before using any of the tables or c...

I have a very simple SqlAlchemy model class User(Base): """ The SQLAlchemy declarative model class for a User object. """ __tablename__ = 'users' id = Column(Integer, primary_key=True) phone =...

I'm trying to use alembic with a MySQL engine to perform online migrations. I've found that when an operation in my onupgrade() method fails my database gets stuck in an inconsistent state and i ca...

I'm trying to implement dynamic filtering using SQLAlchemy ORM. I was looking through StackOverflow and found very similar question:SQLALchemy dynamic filter_by It's useful for me, but not enough...

I am trying to insert some data in a table I have created. I have a data frame that looks like this: I created a table: create table online.ds_attribution_probabilities ( attribution_type text,...

I'm trying to programmatically build a search query, and to do so, I'm joining a table. class User(db.Model): id = db.Column(db.Integer(), primary_key=True) class Tag(db.Model): id = db.Column(...

I wrote a Flask-SQLAlchemy model class that looks like this (from this reference): from flask import Flask from flask_sqlalchemy import SQLAlchemy app = Flask(__name__) db = SQLAlchemy(app) class...

I have a table that already exists: USERS_TABLE = Table("users", META_DATA, Column("id", Integer, Sequence("user_id_seq"), primary_key=True), Column("first_name", String(255)), Column("last_nam...

Assuming the following models, how exactly would one go about loading the shipment associated with the order via a subqueryload, filtered by the status of is_refunded? class Order(db.Model): id =...

I've been trying to figure out this for a while but a lot of answers I can find now are out-dated (posts from > 6 years ago), or less related. The question is really how to deal with database se...

I'm trying to do some operations after an insert occurs on a particular table. user = ModelFactory.create_user(username, email, password) db.session.add(user) db.session.commit() So I have creat...

I am going through a flask/sqlalchemy tutorial https://pythonhosted.org/Flask-SQLAlchemy/quickstart.html#a-minimal-application and I configured my database url to be: postgres://username:password@...

I am using alembic to manage my database changes. Other people may also add changes to this database. Everything is set up correctly and this is currebtly working fine. However, because we are many...

I'm following this tutorial to adapt it to my needs, in this case, to perform a sql module where I need to record the data collected by a webhook from the gitlab issues. For the database module I'm...

I wrote a module which is to create an empty database file def create_database(): engine = create_engine("sqlite:///myexample.db", echo=True) metadata = MetaData(engine) metadata.create_all() ...

I have data for a particular entity partitioned across multiple identical tables, often separated chronologically or by numeric range. For instance, I may have a table called mytable for current da...