Realtor Preference

realtor.go

package preference
 
import (
    "circlepix/pkg/database"
    "strings"
)
 
func ReadByID(Id int64) (*Preference, error) {
    p := Preference{}
    err := database.Get(&p, "SELECT * FROM Preference WHERE PrefId = ?", Id)
    if err != nil {
        return nil, err
    }
    return &p, nil
}
 
func GetPreferences(prefType string, prefTypeId int64) ([]*Preference, error) {
    p := []*Preference{}
    prefType = strings.ToLower(prefType)
    err := database.Get(&p, "SELECT * FROM Preference WHERE PREFtype = ? AND PREFtypeId = ? ", prefType, prefTypeId)
    if err != nil {
        return nil, err
    }
 
    return p, nil
}