File: ListTables

package info (click to toggle)
ctn 3.2.0~dfsg-8
  • links: PTS, VCS
  • area: main
  • in suites: sid, trixie
  • size: 16,924 kB
  • sloc: ansic: 179,652; makefile: 7,006; java: 1,863; csh: 1,067; yacc: 523; sh: 424; cpp: 394; sql: 389; lex: 170
file content (33 lines) | stat: -rw-r--r-- 751 bytes parent folder | download | duplicates (7)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
#!/bin/bash
#
# ListTables
#
if [ -z $1 -o -z $2 ]; then
  echo " "
  echo Usage: "$0 <DIM|Control> <Database Name>"
  echo " "
  exit
fi
#
#
if [ "$1" = "Control" ]; then
mysqlshow -pctn -uctn $2 ApplicationEntity
mysqlshow -pctn -uctn $2 GroupNames
mysqlshow -pctn -uctn $2 StorageAccess
mysqlshow -pctn -uctn $2 StorageControl
mysqlshow -pctn -uctn $2 InstanceTable
mysqlshow -pctn -uctn $2 FISAccess
mysqlshow -pctn -uctn $2 PrintServerCFG
mysqlshow -pctn -uctn $2 VideoImageDest
fi
#
#
#
if [ "$1" = "DIM" ]; then
mysqlshow -pctn -uctn $2 ApplicationEntity
mysqlshow -pctn -uctn $2 PatientLevel
mysqlshow -pctn -uctn $2 StudyLevel
mysqlshow -pctn -uctn $2 SeriesLevel
mysqlshow -pctn -uctn $2 ImageLevel
mysqlshow -pctn -uctn $2 InstanceTable
fi