aboutsummaryrefslogtreecommitdiffstats
path: root/src/sql/generateData.sh
diff options
context:
space:
mode:
authorslomo <steve.harrison@gmx.net>2011-01-12 20:37:16 +0100
committerslomo <steve.harrison@gmx.net>2011-01-12 20:37:16 +0100
commit2cb5dd752037ff81329578d1514dac7de0e3ee16 (patch)
tree58c043051b7f9e49c54db57ab65dec097281a0cc /src/sql/generateData.sh
parent8758b959552cc282b2d9b72055130958a8f9101b (diff)
downloadosm-xapi-2cb5dd752037ff81329578d1514dac7de0e3ee16.tar.gz
osm-xapi-2cb5dd752037ff81329578d1514dac7de0e3ee16.tar.xz
osm-xapi-2cb5dd752037ff81329578d1514dac7de0e3ee16.zip
merged code from old repo
Diffstat (limited to 'src/sql/generateData.sh')
-rwxr-xr-xsrc/sql/generateData.sh18
1 files changed, 18 insertions, 0 deletions
diff --git a/src/sql/generateData.sh b/src/sql/generateData.sh
new file mode 100755
index 0000000..7c4276e
--- /dev/null
+++ b/src/sql/generateData.sh
@@ -0,0 +1,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