get last_insert_rowid

[QuickBrownFoxy]

I can seem to find any method returns last_insert_rowid(), do I need to get it with raw query?

I need to use "last_insert_rowid" because i am trying to populate database at first run from a text file and there is ID relation of items

Thanks

[satyan]

Yes, there's no specific function right now to give you the last insert row_id.. You could try with raw query.
If you're inserting via Sugar, each insert returns the id of the corresponding record. That way you could also find out the id of the last record inserted.

Hope it helps. Let me know if you need more details.

[QuickBrownFoxy]

Is it the .save() function returning I'd? Sorry away from pc can't check atm

[satyan]

Yes.

[QuickBrownFoxy]

.save() returns void
but I can use getId() after save

[satyan]

Yeah. My bad. It doesn't return the id, it sets the id field in the object. As you mentioned, you could use getId() after that.

You could modify the save method to return the id if you need that too..

Hope it helps.