KeyError for the citext field

[farhatnawaz]

I wanted a citext field in my API, so I decided to use this package. But it raises an error saying that there is a keyError for the citext field. The code is like so:

class Book(Model):
    __tablename__ = 'books'
    id = db.Column(db.String(32), primary_key=True)
    book_code = db.Column(CIText())

    def __init__(self, bookcode):
        self.id = str(uuid.uuid4().hex)
        self.book_code = bookcode

Any idea what's wrong?

[omalbhagya]

I am facing the same issue. (https://stackoverflow.com/questions/46439816/how-to-add-citext-column-using-sqlalchemy)`

[hm43]

Same here !

[hm43]

@farhatnawaz @omalbhagya :
solution : from citext import CIText

@mahmoudimus you need to add that in the readme .

[mahmoudimus]

@hm43 would you make a PR? I am happy to add it this weekend if not.