Patch method unreliable?

[tjbanks]

Patch method unreliable?

[thomaxxl]

Hi,

This shouldn't happen and I haven't encountered this problem before.
Can you provide more details so I can reproduce this?
I guess you're using postgres? Can you switch to sqlite to check if the problem still appears?

[tjbanks]

That seems to work well - maybe it's a postgres specific issue? Some work and some don't - below, the first model works in postgres/safrs but the second doesn't. And the only difference being the second uses a text type in a tsvector. I'll investigate that route and close the issue - thanks for your suggestion!

class AcademicFunder(BaseModelTS):

    __tablename__ = 'academic_funder'

    id = db.Column(db.Integer(),primary_key=True)
    name = db.Column(db.String(),nullable=False)
    doi = db.Column(db.String(),nullable=False,unique=True)
    alt_names = db.Column(db.String(),nullable=True)
    location_name = db.Column(db.String(),nullable=True)
    
    search_vector = db.Column(TSVectorType('name','doi','alt_names','location_name'))

class AcademicWork(BaseModelTS):
    """Academic work model generalized

    """
    __tablename__ = 'academic_work'

    id = db.Column(db.BigInteger(), primary_key=True)
    doi = db.Column(db.String(),nullable=True)
    title = db.Column(db.String(),nullable=True)
    first_author_name = db.Column(db.String(),nullable=True)
    abstract = db.Column(db.String(),nullable=True)
    abstract_en = db.Column(db.String(),nullable=True)
    full_text = db.Column(db.Text(),nullable=True)
    full_text_en = db.Column(db.Text(),nullable=True)
    published = db.Column(db.DateTime(), nullable=True)
    source = db.Column(db.String(),nullable=True)
    score = db.Column(db.Float(),nullable=True)
    work_type = db.Column(db.String(),nullable=True)
    container_title = db.Column(db.String(),nullable=True)
    subjects = db.Column(db.String(),nullable=True)    

    urls = db.relationship('Url',
                secondary='academic_work_url',
                backref=db.backref('academic_work', lazy='dynamic'))

    funders = db.relationship('AcademicFunder',
                secondary='academic_work_funder',
                backref=db.backref('academic_work', lazy='dynamic'))


    authors = db.relationship('Entity',
                secondary='academic_work_author',
                backref=db.backref('academic_work', lazy='dynamic'))


    search_vector = db.Column(TSVectorType('title','title_en','abstract','abstract_en','full_text','full_text_en','container_title','subjects'))