package webutility

import "database/sql"

type SelectConfig struct {
	ListObjType string `json:"listObjectType"`
	ObjType     string `json:"objectType"`
	Type        string `json:"type"`
	IdField     string `json:"idField"`
	LabelField  string `json:"labelField"`
	ValueField  string `json:"valueField"`
}

// GetSelectConfig returns select configuration slice for the given object type.
func GetSelectConfig(db *sql.DB, otype string) ([]SelectConfig, error) {
	resp := make([]SelectConfig, 0)
	rows, err := db.Query(`SELECT
		a.LIST_OBJECT_TYPE,
		a.OBJECT_TYPE,
		a.ID_FIELD,
		a.LABEL_FIELD,
		a.TYPE,
		b.FIELD
		FROM LIST_SELECT_CONFIG a, LIST_VALUE_FIELD b
		WHERE a.LIST_OBJECT_TYPE` + otype + `
		AND b.LIST_TYPE = a.LIST_OBJECT_TYPE
		AND b.OBJECT_TYPE = a.OBJECT_TYPE`)
	if err != nil {
		return nil, err
	}
	defer rows.Close()

	var sc SelectConfig
	for rows.Next() {
		rows.Scan(&sc.ListObjType, &sc.ObjType, &sc.IdField, &sc.LabelField, &sc.Type, &sc.ValueField)
		resp = append(resp, sc)
	}
	if rows.Err() != nil {
		return nil, rows.Err()
	}

	return resp, nil
}