aboutsummaryrefslogtreecommitdiffstats
path: root/src/sql/generateData.sh
blob: 7c4276ed7affdb6763c0348eb66b07a929052b5a (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
#! /bin/bash
rm -f insert.sql
touch insert.sql

for i in `seq 1 100`; do 
    echo "INSERT INTO \"anamnity#pub\" VALUES
        ( $i , $i.5 , $i.7, 'pub nr $i'); " >> insert.sql
done

for i in `seq 1 100`; do 
    echo "INSERT INTO \"highway#tohell\" VALUES
        ( $i , $i.5 , $i.7, 'highway nr $i'); " >> insert.sql
done

for i in `seq 1 100`; do 
    echo "INSERT INTO \"anamnity#resturant\" VALUES
        ( $i , $i.5 , $i.7, 'restuarant nr $i'); " >> insert.sql
done