use column_property in sqlalchemy including integer column

Question

I want to use column_property to get a full address including street and house number in one column. The problem is that I want to combine two columns which are of different types. House number is of type Integer and street is of nummber string that's why I get following error:

sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) operator     
does not exist: text + integer
LINE 1: SELECT (address.road || ' ') + address.housenumber AS anon...

Well it works if I turn housenumber to a String column but that wouldn't be a clean way I guess.

Is there a way to cast the housenumber to a string when combining it with a column of type string into column_property?

Here is my code:

class Address(CommonColumns):
    __tablename__ = 'address'
    street = db.Column(db.String(80), nullable=False)
    housenumber = db.Column(db.Integer, nullable=False)
    fulladdress = db.column_property(street + " " + housenumber)

mbijou · Accepted Answer · 2017-11-19 17:52:06Z

4

You need to do a cast:

fulladdress = db.column_property(street + " " + db.cast(housenumber, db.String))

edited Nov 19, 2017 at 17:52

mbijou

871 gold badge2 silver badges12 bronze badges

answered Jul 28, 2017 at 23:33

univerio

20.7k3 gold badges73 silver badges73 bronze badges

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

1 Comment

mbijou Over a year ago

Perfect, worked for me. Thanks! In my case the codesnippet was as following: fulladdress = db.column_property(street + " " + db.cast(housenumber, db.String))

Collectives™ on Stack Overflow

use column_property in sqlalchemy including integer column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related