File: gen-employee-sql

package info (click to toggle)
firebird4.0 4.0.6.3221.ds6-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 41,964 kB
  • sloc: ansic: 393,248; cpp: 356,542; sql: 15,263; yacc: 8,713; fortran: 5,645; sh: 5,184; pascal: 3,328; makefile: 1,342; asm: 271; perl: 194; xml: 55; csh: 15; awk: 1
file content (19 lines) | stat: -rwxr-xr-x 520 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
#!/bin/sh
set -u
set -e

echo "-- This is a generated file"
echo "set sql dialect 3;"
echo "create database 'employee.fdb';"
cat "examples/empbuild/empddl.sql"
cat "examples/empbuild/indexoff.sql"
cat "examples/empbuild/empdml.sql"
cat "examples/empbuild/indexon.sql"

debian/emp_data.pl --table job --key job_code,job_grade,job_country \
    --blob-col job_requirement \
    < "examples/empbuild/job.inp"

debian/emp_data.pl --table project --key proj_id \
    --blob-col proj_desc \
    < "examples/empbuild/proj.inp"