Access Enum Value from a Database Record in Python / Sqlalchemy

Question

I have a class as such:

class VoteEnum(enum.Enum):
    like = "LIKE"
    dislike = "DISLIKE"
    abstain =  "ABSTAIN"

I have a database which stores these votes as such:

class MyVotes(db.Model):
    __tablename__ = "my_votes"
    id = db.Column(db.String, primary_key=True, default=lambda: str(uuid4()))
    item = db.Column(db.String,  nullable=False),
    vote = db.Column(db.Enum(VoteEnum))

    def __str__(self):
        return json.dumps({
            "id":self.id,
            "item":self.item,
            # I want to print the value of vote?
    )}

When retrieving values from sqlalchemy (in flask) and printing, I get the following error:

TypeError: Object of type MyVotes is not JSON serializable

Perhaps there a way to call in my sqlalchemy request? Maybe the class method? I appreciate any help folks can provide.

Possible answers: stackoverflow.com/a/6104825/208880 and stackoverflow.com/a/36136344/208880. — Ethan Furman
– Ethan Furman, Commented Feb 4, 2020 at 20:06
I wish they solved my problem @EthanFurman – sadly, am still getting the error. — Yaakov Bressler
– Yaakov Bressler, Commented Feb 4, 2020 at 20:08

LNF · Accepted Answer · 2020-02-05 19:00:17Z

7

I have a similar situation. Here is how you should do it. Enums have name and value.

def __str__(self):
    return json.dumps({
        'id': self.id,
        'item': self.item,
        'vote': self.vote.name
    })

answered Feb 5, 2020 at 19:00

LNF

7098 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

Access Enum Value from a Database Record in Python / Sqlalchemy

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related