Can't seem to supply my own id for idtables

[AllanWang]

Exposed 0.11.2

It seems like creating a new "entity" and supplying the id results in a failure that no key was generated.

table:

object PrinterGroupTable : IdTable<String>("printer_group") {
    override val id = varchar("id", ID_SIZE).entityId()
    val name = varchar("name", NAME_SIZE).uniqueIndex()
    val loadBalancer = varchar("load_balancer", FLAG_SIZE)
}

execution:

 protected fun transactionInsert(body: T.(InsertStatement<EntityID<K>>) -> Unit): M? = transaction {
    try {
        val id = table.insertAndGetId(body)
        commit()
        getById(id.value)
    } catch (e: Exception) {
        null
    }
}

// Id and Name are type aliases for String
override fun create(id: Id, name: Name, group: PrinterGroup): Printer? = transactionInsert {
    it[table.id] = EntityID(id, table)
    it[table.name] = name
    it[table.group] = group.id
}

output when calling create:

20:17:53.249 [main] DEBUG Exposed - INSERT INTO printer_group (id, load_balancer, name) VALUES ('testGroupId0', 'testQueueManager0', 'testGroupName0')
Exception java.lang.IllegalStateException: No key generated

[AllanWang]

To add more details, this works:

protected fun transactionInsert(id: K, body: T.(InsertStatement<Number>) -> Unit): M? = transaction {
    try {
        table.insert {
            body(it)
            it[table.id] = EntityID(id, table)
        }
        getById(id)
    } catch (e: Exception) {
        null
    }
}

but this does not:

protected fun transactionInsert(id: K, body: T.(InsertStatement<Number>) -> Unit): M? = transaction {
    try {
        val insertId = table.insert {
            body(it)
            it[table.id] = EntityID(id, table)
        } get table.id
        getById(insertId!!.value)
    } catch (e: Exception) {
        null
    }
}

Ideally, I'd like to remove the id parameter from my method, as it will either be passed through the body or generated with client defaults. With the current implementation, I also have to make sure that my caller does not pass an id, or there will be an exception caused by duplicate sets

---

Snapshot of my project, available for testing:

https://github.com/AllanWang/Prim/blob/0a14e38f00fc1b45563d1dd7f2196eebfca770b7/printer-sql/src/main/kotlin/ca/allanwang/prim/printer/sql/PrinterSql.kt#L63