Method GetObjectByWhereClause

server/resource/dbmethods.go:2181–2230

(typeName string, column string, val interface{}, transaction *sqlx.Tx)

}

func (dbResource *DbResource) GetObjectByWhereClause(typeName string, column string, val interface{}, transaction *sqlx.Tx) (map[string]interface{}, error) {
	s, q, err := statementbuilder.Squirrel.Select("*").
		Prepared(true).From(typeName).Where(goqu.Ex{column: val}).ToSQL()
	if err != nil {
		return nil, err
	}

	stmt1, err := transaction.Preparex(s)

	if err != nil {
		log.Errorf("[1106] failed to prepare statment - [%v]: %v", s, err)
		return nil, err
	}

	defer func(stmt1 *sqlx.Stmt) {
		err := stmt1.Close()
		if err != nil {
			log.Errorf("failed to close prepared statement: %v", err)
		}
	}(stmt1)

	row, err := stmt1.Queryx(q...)

	if err != nil {
		return nil, err
	}

	defer func(row *sqlx.Rows) {
		err := row.Close()
		if err != nil {
			log.Errorf("[1029] failed to close result after value scan in defer")
		}
	}(row)

	start := time.Now()
	responseArray, err := RowsToMap(row, dbResource.model.GetName())
	err = stmt1.Close()
	err = row.Close()

	m, _, err := dbResource.ResultToArrayOfMapWithTransaction(responseArray, dbResource.Cruds[typeName].model.GetColumnMap(), nil, transaction)
	duration := time.Since(start)
	log.Tracef("[TIMING] GetObjectByWhere ResultToArray [1946]: %v", duration)

	if len(m) == 0 {
		log.Printf("[1976] No result found for [%v] [%v][%v]", typeName, column, val)
		return nil, errors.New(fmt.Sprintf("no [%v=%v] object found", column, val))
	}

	return m[0], err
}

func (dbResource *DbResource) GetObjectByWhereClauseWithTransaction(
	typeName string, column string, val interface{}, transaction *sqlx.Tx) (map[string]interface{}, error) {