Update of /cvsroot/monetdb/sql/src/test/Skyserver
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv21705/src/test/Skyserver
Modified Files:
run.all
Log Message:
propagated changes of Sunday Jan 24 2010 - Tuesday Jan 26 2010
from the Feb2010 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/01/24 - nielsnes: src/test/Skyserver/run.all,1.14.2.1
make manual testing a bit easier
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/01/24 - nielsnes: src/test/Skyserver/run.all,1.14.2.2
skyserver test run longer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: run.all
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/run.all,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -d -r1.14 -r1.15
--- run.all 7 Jan 2010 15:24:33 -0000 1.14
+++ run.all 26 Jan 2010 13:26:08 -0000 1.15
@@ -19,7 +19,6 @@
PWD=`pwd`
SQL='mclient -lsql'
-SQL1='mclient -lsql'
if [ $# -eq 1 ]; then
SQL=$1
fi
@@ -28,31 +27,53 @@
#Bulk-Load into SQL server...
-#echo Create User
-#$SQL < create_user.sql
+cat << EOF > .monetdb
+user=monetdb
+password=monetdb
+EOF
+
+echo Create User
+$SQL < create_user.sql
+
+cat << EOF > .monetdb
+user=skyserver
+password=skyserver
+EOF
+
+$SQL < ../../sql/math.sql
+$SQL < ../../sql/cache.sql
+$SQL < ../../sql/skyserver.sql
echo tables
-$SQL1 < Skyserver_tables.sql
-$SQL1 < Skyserver_constraints.sql
+$SQL < Skyserver_tables.sql
+
+echo loading
+cat Skyserver_import.sql | sed -e "s|DATA|$PWD/microsky|g" | $SQL
+
+echo Constraints
+$SQL < Skyserver_constraints.sql
echo views
-$SQL1 < Skyserver_views.sql
+$SQL < Skyserver_views.sql
echo functions
-$SQL1 < ../../sql/math.sql
-$SQL1 < ../../sql/cache.sql
-$SQL1 < ../../sql/skyserver.sql
-$SQL1 < Skyserver_functions.sql
+$SQL < Skyserver_functions.sql
-exit
echo Cleanup
-$SQL1 < Skyserver_dropFunctions.sql
-$SQL1 < Skyserver_dropMs_functions.sql
-$SQL1 < Skyserver_dropMath.sql
-$SQL1 < Skyserver_dropCache.sql
-$SQL1 < Skyserver_dropViews.sql
-$SQL1 < Skyserver_dropConstraints.sql
-$SQL1 < Skyserver_dropTables.sql
+$SQL < Skyserver_dropFunctions.sql
+$SQL < Skyserver_dropMs_functions.sql
+$SQL < Skyserver_dropMath.sql
+$SQL < Skyserver_dropCache.sql
+$SQL < Skyserver_dropViews.sql
+$SQL < Skyserver_dropConstraints.sql
+$SQL < Skyserver_dropTables.sql
+
+cat << EOF > .monetdb
+user=monetdb
+password=monetdb
+EOF
echo Remove User
$SQL < drop_user.sql
+
+rm -f .monetdb
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
