Ejemplo n.º 1
0
// Update updates a entry with ID id in the associated table.
func (self *Mod) Update(id int, item interface{}) error {
	entries, err := encoding.Encode(item)
	if err != nil {
		return err
	}

	vals := make([]interface{}, len(entries))
	sql := "UPDATE " + self.table + " SET "

	// prepare arguments
	for i := 0; i < len(entries); i++ {
		sql += entries[i].Column + " = ?,"
		vals[i] = entries[i].Value
	}
	// remove last comma
	sql = sql[:len(sql)-1]

	sql += " WHERE ID = ?"

	vals = append(vals, id)

	_, err = self.db.Execute(sql, vals...)
	if err != nil {
		return err
	}

	return nil
}
Ejemplo n.º 2
0
// Insert adds a new row the associated table from the given struct. If ignore
// is true it ignores duplication conflicts.
func (self *Mod) insert(item interface{}, ignore bool) (sql.Result, error) {
	entries, err := encoding.Encode(item)
	if err != nil {
		return nil, err
	}

	var sql, cols, qmarks string
	vals := make([]interface{}, len(entries))

	// prepare arguments
	for i := 0; i < len(entries); i++ {
		cols += entries[i].Column + ","
		vals[i] = entries[i].Value
		qmarks += "?,"
	}
	// remove last comma
	cols = cols[:len(cols)-1]
	qmarks = qmarks[:len(qmarks)-1]

	if ignore {
		sql = "INSERT OR IGNORE INTO " +
			self.table + "(" + cols + ") VALUES(" + qmarks + ")"
	} else {
		sql = "INSERT INTO " + self.table +
			"(" + cols + ") VALUES(" + qmarks + ")"
	}

	res, err := self.db.Execute(sql, vals...)
	if err != nil {
		return nil, err
	}

	return res, nil
}