snower / TorMySQL

The highest performance asynchronous MySQL driver by PyMySQL
MIT License
308 stars 63 forks source link

Get last insert id #16

Closed mlmarius closed 7 years ago

mlmarius commented 7 years ago

Hi. How do i get the last insert id ? It seems that cursor.lastrowid or connection.insert_id() are not available:

                if data is None:
                    query = 'INSERT INTO solutions(origintime, lat, lon, elev, region) VALUES(%s, %s, %s, %s, %s)'
                    qparams = (dt_formated, lat, lon, elev, region)
                    try:
                        with conn.cursor() as cursor:
                            yield cursor.execute(query, qparams)
                    except Exception as e:
                        yield conn.rollback()
                        logging.error(e, exc_info=True)
                    else:
                        yield conn.commit()
                    # quake_id = conn.insert_id()
                    quake_id = cursor.lastrowid
                else:
                    quake_id = data[0]
                    crt_report_path = data[1]
mlmarius commented 7 years ago

Sorry, i think my insert statement was failing.