func (s *SQLEngine) consumeCreation(tx *sql.Tx, i gregor.Item) error {
md := i.Metadata()
qb := s.newQueryBuilder()
qb.Build("INSERT INTO gregor_items(uid, msgid, category, body, dtime) VALUES(?,?,?,?,",
hexEnc(md.UID()),
hexEnc(md.MsgID()),
i.Category().String(),
i.Body().Bytes(),
)
qb.TimeOrOffset(i.DTime())
qb.Build(")")
err := qb.Exec(tx)
if err != nil {
return err
}
for i, t := range i.RemindTimes() {
if t == nil {
continue
}
nqb := s.newQueryBuilder()
nqb.Build("INSERT INTO gregor_reminders(uid, msgid, seqno, rtime) VALUES(?,?,?,", hexEnc(md.UID()), hexEnc(md.MsgID()), i)
nqb.TimeOrOffset(t)
nqb.Build(")")
err = nqb.Exec(tx)
if err != nil {
return err
}
}
return nil
}
