Understanding Numeric Datatype in SqlAlchemy

Question

I have a class

class vw_invoice_header(db.Model):

    __tablename__ = "vw_invoice_header"
    tax_amount = db.column(db.Numeric)
    total_price = db.column(db.Numeric)
    invc_number = db.Column(db.String(40))
    term_code = db.Column(db.String(20))
    order_date = db.Column(db.Date)
    airway_bill = db.Column(db.String(40))
    inh_auto_key = db.Column(db.Integer,primary_key=True)

Now I get a result from an oracle db as below

invc = vw_invoice_header.query.filter_by(inh_auto_key=20643519).first()

I'm trying to use the value below to get a nicely formatted price in my jinja2 template

"{:8,.2f}".format(invc.total_price)

This throws an error, AttributeError: type object 'Numeric' has no attribute 'lower' I have no idea how to just print out this numeric :/ Im a newb to python been using it for a week.

Thanks Cameron

Are the db.column's in your code not supposed to be db.Column? — Suever
– Suever, Commented Jul 22, 2016 at 12:52

Suever · Accepted Answer · 2016-07-22 12:55:25Z

2

Your first two fields should be db.Column not db.column (note the capitalization). db.column creates a sqlalchemy.sql.elements.ColumnClause object whereas db.Column creates a sqlalchemy.sql.schema.Column object like you want.

class vw_invoice_header(db.Model):

    __tablename__ = "vw_invoice_header"
    tax_amount = db.Column(db.Numeric)
    total_price = db.Column(db.Numeric)
    invc_number = db.Column(db.String(40))
    term_code = db.Column(db.String(20))
    order_date = db.Column(db.Date)
    airway_bill = db.Column(db.String(40))
    inh_auto_key = db.Column(db.Integer,primary_key=True)

Once you correct this, the Numeric datatype will behave just as you expect.

answered Jul 22, 2016 at 12:55

Suever

65.6k14 gold badges91 silver badges104 bronze badges

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

1 Comment

Cameron Over a year ago

Thank you! - Always ends up being something simple

Collectives™ on Stack Overflow

Understanding Numeric Datatype in SqlAlchemy

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related