Python SqlAlchemy Update Statement

Question

Could anyone help me out with this update statement? Just trying to save json value as str into a column in my database, but its not going through:

    new_bookmarks = {
        fitness_discipline: {effort: str([x for x in options if x['value'] in values]).replace("'", '"')}
    }

    session, engine = db_connect()
    athlete_bookmarks = session.query(athlete.peloton_auto_bookmark_ids).filter(
        athlete.athlete_id == 1).first().peloton_auto_bookmark_ids

    athlete_bookmarks_json = json.loads(athlete_bookmarks)
    athlete_bookmarks_json.update(new_bookmarks)

    athlete_bookmarks = json.dumps(athlete_bookmarks_json)

    session.commit()

    engine.dispose()
    session.close()

Ruben Helsloot · Accepted Answer · 2020-08-05 05:39:46Z

1

You're re-assigning the variable athlete_bookmarks, not setting the attribute peloton_auto_bookmark_ids on athlete:

new_bookmarks = {
    fitness_discipline: {effort: str([x for x in options if x['value'] in values]).replace("'", '"')}
}

session, engine = db_connect()
athlete = session.query(athlete).filter(athlete.athlete_id == 1).first()

athlete_bookmarks_json = json.loads(athlete_bookmarks.peloton_auto_bookmark_ids)
athlete_bookmarks_json.update(new_bookmarks)
athlete_bookmarks.peloton_auto_bookmark_ids = json.dumps(athlete_bookmarks_json)

session.commit()

answered Aug 5, 2020 at 5:39

Ruben Helsloot

13.2k6 gold badges33 silver badges56 bronze badges

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

Comments

Ethanopp · Accepted Answer · 2020-08-06 14:40:29Z

Got it with the following

    session, engine = db_connect()
    athlete_bookmarks = session.query(athlete.peloton_auto_bookmark_ids).filter(
        athlete.athlete_id == 1).first()

    # update peloton bookmark settings per the inputs
    athlete_bookmarks_json = json.loads(athlete_bookmarks.peloton_auto_bookmark_ids)

    # Check if fitness discipline exists
    if not athlete_bookmarks_json.get(fitness_discipline):
        athlete_bookmarks_json[fitness_discipline] = {}
    # Check if fitness discipline / effort exists
    if not athlete_bookmarks_json.get(fitness_discipline).get(effort):
        athlete_bookmarks_json[fitness_discipline][effort] = {}

    athlete_bookmarks_json[fitness_discipline][effort] = json.dumps([x for x in options if x['value'] in values])

    session.query(athlete.peloton_auto_bookmark_ids).filter(
        athlete.athlete_id == 1).update({athlete.peloton_auto_bookmark_ids: json.dumps(athlete_bookmarks_json)})

    # write back to database
    session.commit()

    engine.dispose()
    session.close()

Collectives™ on Stack Overflow

Python SqlAlchemy Update Statement

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related