Method GetIdToObjectWithTransaction

server/resource/dbmethods.go:2347–2416

(typeName string, id int64, transaction *sqlx.Tx)

}

func (dbResource *DbResource) GetIdToObjectWithTransaction(typeName string, id int64, transaction *sqlx.Tx) (map[string]interface{}, error) {
	key := fmt.Sprintf("ito-%v-%v", typeName, id)
	if OlricCache != nil {
		val, err := OlricCache.Get(context.Background(), key)
		if err == nil && val != nil {
			var res map[string]interface{}
			err = val.Scan(res)
			return res, err
		}
	}
	s, q, err := statementbuilder.Squirrel.Select(goqu.C("*")).Prepared(true).From(typeName).Where(goqu.Ex{"id": id}).ToSQL()
	if err != nil {
		return nil, err
	}

	stmt1, err := transaction.Preparex(s)

	if err != nil {
		log.Errorf("[1146] 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 = row.Close()
	if err != nil {
		log.Errorf("[1064] failed to close result after value scan in defer")
		return nil, err
	}
	err = stmt1.Close()
	if err != nil {
		log.Errorf("failed to close prepared statement: %v", err)
		return nil, err
	}
	m, _, err := dbResource.ResultToArrayOfMapWithTransaction(responseArray, dbResource.Cruds[typeName].model.GetColumnMap(), nil, transaction)
	if err != nil {
		return nil, err
	}
	duration := time.Since(start)
	log.Tracef("[TIMING] GetIdToObject ResultToArray: %v", duration)