Skip to content

Instantly share code, notes, and snippets.

@ryansgot
Last active June 8, 2018 01:40
Show Gist options
  • Save ryansgot/57035025e0d41f2273489f710a1c4ad4 to your computer and use it in GitHub Desktop.
Save ryansgot/57035025e0d41f2273489f710a1c4ad4 to your computer and use it in GitHub Desktop.
ForSure DB CRUD For the Impatient (Kotlin)
val uuid = UUID.randomUUID().toString()
// create (upsert)
ForSure.employeesTable()
.set().firstName("Some").lastName("Name").uuid(uuid)
.save()
//retrieve
val api = ForSure.employeesTable().api
val retriever = ForSure.employeesTable().get()
if (retriever.moveToFirst()) {
do {
var retrievedUUID = api.uuid(retriever)
var firstName = api.firstName(retriever)
var lastName = api.lastName(retriever)
} while(retriever.moveToNext())
}
retriever.close()
// update (upsert)
ForSure.employeesTable()
.find().byUuid(uuid)
.then().set().firstName("First").lastName("Last")
.save()
// delete
ForSure.employeesTable()
.find().byFirstName("First")
.then().set().hardDelete()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment