How to insert data to postgresql database with flask - sqlalchemy.exc.ProgrammingError?

Question

I would like to insert data to postgresql database with flask.

This is a model class code that I wrote.

class Bet365(db.Model):
    __tablename__ = "bet365s"
    id = db.Column(db.Integer, primary_key=True)
    sports = db.Column(db.Float)
    casino = db.Column(db.Float)
    poker = db.Column(db.Float)
    games_bingo = db.Column(db.Float)
    total = db.Column(db.Float)
    withdrawal = db.Column(db.Float)
    balance = db.Column(db.Float)

    def __init__(self, sports, casino, poker, games_bingo, total, withdrawal, balance):
        self.id = id
        self.sports = sports
        self.casino = casino
        self.poker = poker
        self.games_bingo = games_bingo
        self.total = total
        self.withdrawal = withdrawal
        self.balance = balance

This is the snippet code which is responsible for inserting data.

@app.route('/testing/')
def testing():
    data_bet365 = bet365_scrapping()

    sports = float(data_bet365[0])
    casino = float(data_bet365[1])
    poker = float(data_bet365[2])
    games_bingo = float(data_bet365[3])
    total = float(data_bet365[4])
    withdrawal = float(data_bet365[5])
    balance = float(data_bet365[6])

    result_bet365 = Bet365(sports, casino, poker, games_bingo, total, withdrawal, balance)
    db.session.add(result_bet365)
    db.session.commit()
    return (jsonify(data_bet365))

When I run this script, I get an error like this.

sqlalchemy.exc.ProgrammingError

sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) can't adapt type 'builtin_function_or_method'
[SQL: 'INSERT INTO bet365s (id, sports, casino, poker, games_bingo, total, withdrawal, balance) VALUES (%(id)s, %(sports)s, %(casino)s, %(poker)s, %(games_bingo)s, %(total)s, %(withdrawal)s, %(balance)s)']
[parameters: {'withdrawal': 0.0, 'id': <built-in function id>, 'sports': -29.94, 'total': 593.75, 'casino': 464.22, 'poker': 14.29, 'games_bingo': 145.17, 'balance': 593.75}]

I can't find a solution. Please help me.

Cory Madden · Accepted Answer · 2017-07-17 17:42:34Z

1

It looks like the problem is with your column types. You're trying to insert a float into an Integer column.

answered Jul 17, 2017 at 17:42

Cory Madden

5,23326 silver badges37 bronze badges

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

2 Comments

Kyan Heuvel Over a year ago

Thanks for your response. Please have a look again. I've updated my question. Sorry for bothering you.

Cory Madden Over a year ago

Ah, it looks like you're trying to insert a null value into the ID column. Which should be an autogenerated field.

D.Shawley · Accepted Answer · 2017-07-17 17:56:09Z

0

I wouldn't use id as a class attribute name. You are assigning the id global function to self.id in the initializer which is the cause of the traceback.

edited Jul 17, 2017 at 17:56

answered Jul 17, 2017 at 17:47

D.Shawley

59.9k10 gold badges105 silver badges116 bronze badges

Collectives™ on Stack Overflow

How to insert data to postgresql database with flask - sqlalchemy.exc.ProgrammingError?

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related