#!/bin/sh

# search for a package in the database

# shellcheck disable=SC2119,SC2120

# shellcheck source=../lib/load-configuration
. "${0%/*}/../lib/load-configuration"

# shellcheck disable=SC2016
{
  printf 'SELECT'
  printf ' CONCAT('
    printf '`architectures`.`name`,"/",'
    printf '`binary_packages`.`pkgname`,": ",'
    printf 'GROUP_CONCAT('
      printf 'CONCAT('
      printf '`r_a`.`name`,"/",'
      printf '`repositories`.`name`," (",'
      printf 'IF('
        printf '`binary_packages`.`epoch`=0,'
        printf '"",'
        printf 'CONCAT(`binary_packages`.`epoch`,":")'
      printf '),'
      printf '`binary_packages`.`pkgver`,"-",'
      printf '`binary_packages`.`pkgrel`,'
      printf 'IF('
        printf 'NOT `binary_packages`.`sub_pkgrel_omitted`,'
        printf 'CONCAT(".",`binary_packages`.`sub_pkgrel`),'
        printf '""),'
      printf '")"'
      printf ')'
      printf ' ORDER BY `repositories`.`stability`'
      printf ' SEPARATOR ", "'
    printf ')'
  printf ')'
  printf ' FROM `binary_packages`'
  mysql_join_binary_packages_architectures
  mysql_join_binary_packages_binary_packages_in_repositories
  mysql_join_binary_packages_in_repositories_repositories
  mysql_join_repositories_architectures '' 'r_a'
  printf ' WHERE `binary_packages`.`pkgname` LIKE from_base64("'
  printf '%s' "$*" | \
    base64 -w0
  printf '") AND `repositories`.`is_on_master_mirror`'
  printf ' GROUP BY CONCAT(`binary_packages`.`pkgname`,"-",`architectures`.`name`)'
  printf ' ORDER BY `binary_packages`.`pkgname`,`architectures`.`name`'
  printf ';\n'
} | \
  mysql_run_query