case class CrmUserId(id:Int, crmId:String)
db.run(
quote(
liftQuery(list).foreach(e =>
// query[CrmUserId].insertValue(e).onConflictIgnore // does not work
sql"insert ignore into crm_user_id(id, crm_id) values (${e.id}, ${e.crmId})".as[Insert[CrmUserId]] // does not work
)
)
Version:
4.8.0
Module:quill-jdbc
Database:mysql
If there any way to write raw batch sql?