func getRecord(byFild, value string) (Record, error) {
var isVisibleInt int
record := Record{}
sql := "SELECT `id`, `datestamp`, `identifier`, `repository`, `is_visible` FROM `repository_resource` WHERE " + byFild + " = ?"
query, err := database.Connection.Prepare(sql)
if err != nil {
return record, err
}
query.QueryRow(value).Scan(&record.ID, &record.Timestamp, &record.Identifier, &record.Repository, &isVisibleInt)
record.IsVisible = database.GetBoolFromInt(isVisibleInt)
sql2 := "SELECT `resource_key`, `value` FROM `resource_key` WHERE `resource`=? "
rows2, keyErr := database.Connection.Query(sql2, record.Identifier)
if keyErr != nil {
return record, keyErr
}
keys := &RecordKeys{}
for rows2.Next() {
var name, value string
rows2.Scan(&name, &value)
keys.Add(name, value)
}
record.Keys = keys
return record, nil
}
// GetRecords returns all the records
func GetRecords(repositoryID int, options database.SQLOptions) []*Record {
start := time.Now()
var list []*Record
var (
rows *sql.Rows
err error
)
fieldList := "record.`identifier`, record.`id`, record.`datestamp`, record.`repository`, record.`is_visible`"
// If no collection has been chosen
if options.Where["collection"] == "" {
sql := "SELECT " + fieldList + " FROM `repository_resource` AS record WHERE record.`repository`=? ORDER BY record.id DESC " + options.GetLimit()
rows, err = database.Connection.Query(sql, repositoryID)
} else {
sql := "SELECT DISTINCT `identifier_set`.`identifier`, 0, 0, 0, 0 FROM `identifier_set` WHERE `identifier_set`.`set_spec` = ? ORDER BY identifier DESC " + options.GetLimit()
rows, err = database.Connection.Query(sql, options.Where["collection"])
}
if err != nil {
fmt.Println("Error #1 with Wisply repository records")
fmt.Println(err)
}
counter := 0
for rows.Next() {
var isVisibleInt int
counter++
record := &Record{}
rows.Scan(&record.Identifier, &record.ID, &record.Timestamp, &record.Repository, &isVisibleInt)
record.IsVisible = database.GetBoolFromInt(isVisibleInt)
if record.ID == 0 {
sql := "SELECT `id`, `datestamp`, `repository`, `is_visible` FROM `repository_resource` WHERE identifier = ?"
query, err := database.Connection.Prepare(sql)
if err != nil {
fmt.Println(err)
}
fmt.Println(record.Identifier)
err = query.QueryRow(record.Identifier).Scan(&record.ID, &record.Timestamp, &record.Repository, &isVisibleInt)
record.IsVisible = database.GetBoolFromInt(isVisibleInt)
fmt.Println(err)
}
sql2 := "SELECT `resource_key`, `value` FROM `resource_key` WHERE `resource`=? "
rows2, _ := database.Connection.Query(sql2, record.Identifier)
keys := &RecordKeys{}
for rows2.Next() {
var name, value string
rows2.Scan(&name, &value)
keys.Add(name, value)
}
record.Keys = keys
list = append(list, record)
}
elapsed := time.Since(start)
log.Printf("Has taken %s", elapsed)
return list
}