func (d DAO) Insert(value interface{}) error {
if d.conn == nil {
return errors.New("no connection to mysql!")
}
sql := fmt.Sprintf("insert into %s values (", d.table)
struct_helper.ParseSimpleStruct(value, ToInsert, &sql, d.key)
sql += ")"
fmt.Println(sql)
_, err := d.conn.Exec(sql)
return err
}
func (d DAO) Update(key interface{}, value interface{}) error {
if d.conn == nil {
return errors.New("no connection to mysql!")
}
var sql string = fmt.Sprintf("update %s set ", d.table)
struct_helper.ParseSimpleStruct(value, ToUpdate, &sql, d.key)
sql = fmt.Sprintf("%s where %s = %d", sql, d.key, key)
fmt.Println(sql)
sql = fmt.Sprintf(sql)
_, err := d.conn.Exec(sql)
return err
}