Wednesday, 17 August 2022

(sqlite3.OperationalError) unknown database "seller"

I'm trying to use a testdb(sqlite) to make my tests, but when i use Base.metadata.createall() to create the same tables of the production database, i got this error: (sqlite3.OperationalError) unknown database "seller".

Conftest.py:

DATABASE_URL = 'sqlite:///testedb.sqlite'

@pytest.fixture(scope="function")
def client() -> Generator:
    config_database(DATABASE_URL)
    with TestClient(app) as c:
        yield c

Database.py:

Base = declarative_base()

def config_database(database_url):
    engine = create_engine(database_url)
    Base.metadata.create_all(bind=engine)

Example of model there i'm using:

class Seller(Base):

__table__ = Table(
    "seller",
    Base.metadata,
    Column(
        "seller_id",
        Integer,
        primary_key=True,
        index=True,
        nullable=False),
    Column("cnpj", String, nullable=True),
    Column("nickname", String, nullable=False),
    schema="seller")


from (sqlite3.OperationalError) unknown database "seller"

No comments:

Post a Comment