Get row id for inserted row in sqldelight

Question

I'm trying to use sqldelight to insert an item, but to also return the id of the item after it's inserted. There doesn't seem to be a way to do this in sqldelight.

I can call something like SELECT last_insert_rowid(); after I do the insert, but is this the best way to move forward?

If my answer helped you, could you mark it as accepted? Thanks. — snitsaruk, Oct 14 '21 at 10:09

score 12 · Accepted Answer · answered May 06 '19 at 12:56

12

You can add this command to your .sq file:

lastInsertRowId:
SELECT last_insert_rowid()
;

And it will return you an id of last inserted row.

Please refer to this issue on Github for more info.

answered May 06 '19 at 12:56

snitsaruk

422
6
13

Thanks for this answer, I was looking for a bit. – Booger Apr 21 '22 at 18:31

Get row id for inserted row in sqldelight

1 Answers1