You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This would allow for more quickly knowing how many rows have been entered from your dataframe
Expected Output
Something like inserted = 2 if 2 rows have been added. Even better would be inserted = [24, 25] where inserted is now a list of the inserted primary keys
The text was updated successfully, but these errors were encountered:
Would seem like we could return the sqlalchemy ResultProxy - answers those type of questions
fromsqlalchemyimportcreate_engineeng=create_engine('sqlite://')
eng.execute("CREATE TABLE data (t TEXT)")
r=eng.execute("INSERT INTO data VALUES ('jane'), ('jon'), ('jack');")
r# Out[72]: <sqlalchemy.engine.result.ResultProxy at 0x15a83128>r.rowcount# Out[73]: 3
Potential feature, could
df.to_sql()
return the indexes of the inserted rows? Something like knex.js Query BuilderProblem description
This would allow for more quickly knowing how many rows have been entered from your dataframe
Expected Output
Something like
inserted = 2
if 2 rows have been added. Even better would beinserted = [24, 25]
where inserted is now a list of the inserted primary keysThe text was updated successfully, but these errors were encountered: