020_sections 748 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
  1. #!/bin/sh
  2. echo "Creating default sections"
  3. set -e
  4. set -u
  5. SECTIONS="admin
  6. cli-mono
  7. comm
  8. database
  9. debian-installer
  10. debug
  11. devel
  12. doc
  13. editors
  14. education
  15. electronics
  16. embedded
  17. fonts
  18. games
  19. gnome
  20. gnu-r
  21. gnustep
  22. golang
  23. graphics
  24. hamradio
  25. haskell
  26. httpd
  27. interpreters
  28. introspection
  29. java
  30. javascript
  31. kde
  32. kernel
  33. libdevel
  34. libs
  35. lisp
  36. localization
  37. mail
  38. math
  39. metapackages
  40. misc
  41. net
  42. news
  43. ocaml
  44. oldlibs
  45. otherosfs
  46. perl
  47. php
  48. python
  49. raku
  50. ruby
  51. rust
  52. science
  53. shells
  54. sound
  55. tasks
  56. tex
  57. text
  58. utils
  59. vcs
  60. video
  61. web
  62. x11
  63. xfce
  64. zope"
  65. values=""
  66. for prefix in "" "contrib/" "non-free-firmware/" "non-free/"; do
  67. for section in ${SECTIONS}; do
  68. values="${values:+${values},} ('${prefix}${section}')"
  69. done
  70. done
  71. psql -c "INSERT INTO section (section) VALUES ${values}" >/dev/null