postgresql – 如何插入UUID的值?
我在播放框架2.3支持
postgresql 9.4中使用anorm 2.4
给这样的模型: case class EmailQueue(id:UUID,send_from:String,send_to:String,subject:String,body:String,created_date:Date,is_sent:Boolean,email_template:String) 这是我的解析器: val parser: RowParser[EmailQueue] = { get[UUID]("id") ~ get[String]("send_from") ~ get[String]("send_to") ~ get[String]("subject") ~ get[String]("body") ~ get[Date]("created_date") ~ get[Boolean]("is_sent") ~ get[String]("email_template") map { case id ~ send_from ~ send_to ~ subject ~ body ~ created_date ~ is_sent ~ email_template=> EmailQueue(id,send_from,send_to,subject,body,created_date,is_sent,email_template) } } 这是我的插入声明: def insert(email:EmailQueue): Unit ={ DB.withTransaction { implicit c => SQL(s""" INSERT INTO "email_queue" ( "body","created_date","id","is_sent","send_from","send_to","subject","email_template") VALUES ( {body},{created_date},{id},{is_sent},{send_from},{send_to},{subject},{email_template} ); """).on( "body" -> email.body,"created_date" -> email.created_date,"id" -> email.id,"is_sent" -> email.is_sent,"send_from" -> email.send_from,"send_to" -> email.send_to,"subject" -> email.subject,"email_template" -> email.email_template ).executeInsert() } } 插入时收到以下错误:
数据库表由此查询创建: CREATE TABLE email_queue ( id UUID PRIMARY KEY,send_from VARCHAR(255) NOT NULL,send_to VARCHAR(255) NOT NULL,subject VARCHAR(2000) NOT NULL,body text NOT NULL,created_date timestamp without time zone DEFAULT now(),is_sent BOOLEAN NOT NULL DEFAULT FALSE,email_template VARCHAR(2000) NOT NULL ); 解决方法
Anorm与DB无关,因为JDBC,默认情况下不支持特定于供应商的数据类型.
您可以在语句中使用{id} :: uuid,以便在JDBC参数中作为String传递的java.util.UUID然后从传递的VARCHAR转换为特定的PostgreSQL uuid.
def insert(email:EmailQueue): Unit = DB.withTransaction { implicit c => SQL""" INSERT INTO "email_queue" ( "body","email_template") VALUES ( ${email.body},${email.created_date},${email.id}::uuid,${email.is_sent},${email.send_from},${email.send_to},${email.subject},${email.email_template} ) """).executeInsert() }
(编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |