How to support FileField with SQLModel?

[fqzhang42]

How to support FileField with SQLModel? I'm aware of sqlalchemy-file, which is for sqlalchemy to handle file field. Can we still use it with SQLModel?

[brunolnetto]

Does this answer resolve your question?

from sqlalchemy import Column, String
from sqlalchemy_file import FileField, FileConverter

from sqlmodel import SQLModel, create_engine, Session

class MyModel(SQLModel):
    __tablename__ = "my_table"

    id = Column(Integer, primary_key=True)
    name = Column(String)
    file = Column(FileField(converter=FileConverter(url="uploads/")))  # Define file field and converter

engine = create_engine("sqlite:///my_database.db")
SQLModel.metadata.create_all(engine)

session = Session(engine)

# Example usage
new_model = MyModel(name="My File", file="path/to/your/file.txt")
session.add(new_model)
session.commit()

session.close()

[gioscarda]

The FileConverter import fails :/

[Victoradukwu]

The FileConverter import fails :/

@gioscarda, it is a separate package to be installed with: pip install sqlalchemy-file

[goodm2ice]

@Victoradukwu ImportError: cannot import name 'FileConverter' from 'sqlalchemy_file'