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 }