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: https://stackoverflow.com/a/6104825/208880 and https://stackoverflow.com/a/36136344/208880. — Ethan Furman, Feb 04 '20 at 20:06
I wish they solved my problem @EthanFurman – sadly, am still getting the error. — Yaakov Bressler, Feb 04 '20 at 20:08

score 7 · Answer 1 · answered Feb 05 '20 at 19:00

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 05 '20 at 19:00

LNF

644
8
8

Access Enum Value from a Database Record in Python / Sqlalchemy

1 Answers1