SQLAlchemy script works fine with sqlite3 but raises errors when used with MYSQL

Question

SQLAlchemy script works fine with sqlite3 but when connected to MYSQL database it gives different errors like:

AttributeError: '_NoResultMetaData' object has no attribute '_indexes_for_keys'
sqlalchemy.exc.NoSuchColumnError: Could not locate column in row for column 'filters.id'
KeyError: Column('id', Integer(), table=, primary_key=True, nullable=False)

The functions works fine when running separately but when used with flask they raise above errors.

My DB models:

from sqlalchemy import Column, Integer, String, MetaData, Boolean, DateTime
from sqlalchemy.ext.declarative import declarative_base

import datetime


Base = declarative_base()


class ProfileData(Base):
    __tablename__ = 'profile_data'

    id = Column(Integer, primary_key=True)
    user_id = Column("user_id", Integer)
    user_profile_link = Column(String(100))
    username = Column(String(100))
    name = Column(String(100))
    is_verified = Column(Boolean)
    website = Column(String(100))
    bio = Column(String(1000))
    location = Column(String(100))
    created_at = Column(DateTime)
    followers = Column(Integer)
    following = Column(Integer)
    _datetime = Column(DateTime, default=datetime.datetime.utcnow)

Thanks in advance.

Ahmed K Madani · Accepted Answer · 2022-02-08 20:46:01Z

1

I would suggest to do this and this how usually do my setup

first init db object from SQLAlchemy

db = SQLAlchemy()

then declare the model using db.model

class ProfileData(db.Model):

    __tablename__ = 'profile_data'

    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column("user_id", db.Integer)
    user_profile_link = db.Column(db.String(100))
    username = db.Column(db.String(100))

hope this fix your issue

answered Feb 8, 2022 at 20:46

Ahmed K Madani

1161 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Huzaifa Farooq Over a year ago

Thanks. It worked.

Ahmed K Madani Over a year ago

always welcome glad it did work :D @HuzaifaFarooq

Collectives™ on Stack Overflow

SQLAlchemy script works fine with sqlite3 but raises errors when used with MYSQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related