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 }