You are viewing a plain text version of this content. The canonical link for it is here.
Posted to stonehenge-commits@incubator.apache.org by sh...@apache.org on 2009/04/23 06:54:57 UTC
svn commit: r767820 - in
/incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts:
InsertScript.sql Table Creation.sql mssql/ mssql/InsertScript.sql
mssql/Table Creation.sql
Author: shankar
Date: Thu Apr 23 06:54:57 2009
New Revision: 767820
URL: http://svn.apache.org/viewvc?rev=767820&view=rev
Log:
moving mssql scripts inside mssql folder
Added:
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/InsertScript.sql
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/Table Creation.sql (with props)
Removed:
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/InsertScript.sql
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/Table Creation.sql
Added: incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/InsertScript.sql
URL: http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/InsertScript.sql?rev=767820&view=auto
==============================================================================
--- incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/InsertScript.sql (added)
+++ incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/InsertScript.sql Thu Apr 23 06:54:57 2009
@@ -0,0 +1,55 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+ VALUES ('JAVA_BS','http://localhost:9763/services/TradeServiceWsas');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+ VALUES ('JAVA_OPS','http://localhost:9763/services/OrderProcessor');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+ VALUES ('JAVA_OPSSEC','http://localhost:9763/services/OrderProcessorMsec');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+ VALUES ('PHP_BS','http://localhost:8080/php_stocktrader/business_service/business_svc.php');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+ VALUES ('PHP_OPS','http://localhost:8080/php_stocktrader/order_processor/order_processor_svc.php');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+ VALUES ('PHP_OPSSEC','http://localhost:8080/php_stocktrader/order_processor/order_processor_svc_msec.php');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+ VALUES ('SPRING_BS','http://localhost:8070/StockTrader/services/TradeService');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+ VALUES ('SPRING_OPS','http://localhost:8060/StockTrader/services/OrderService');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+ VALUES ('SPRING_OPSSEC','http://localhost:8060/StockTrader/services/OrderServiceMsec');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+ VALUES ('RUBY_OPS','http://localhost:3005/OrderService');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+ VALUES ('RUBY_OPSSEC','http://localhost:3005/OrderServiceMsec');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+ VALUES ('DOTNET_BS','http://localhost:9000/TradeBusinessService');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+ VALUES ('DOTNET_OPS','http://localhost:8000/TradeOrderProcessor');
+INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL])
+ VALUES ('DOTNET_OPSSEC','http://localhost:8000/TradeOrderProcessor/msec');
+INSERT INTO [StockTraderDB].[dbo].[DBCONFIG]([DBNAME],[HOSTNAME],[PORT],[ACTIVE])
+ VALUES ('MSSQL', '127.0.0.1', 1433, 'Y');
+INSERT INTO [StockTraderDB].[dbo].[CLIENTTOBS]([CLIENT],[BS])
+ VALUES ('PHP_CLIENT','PHP_BS');
+INSERT INTO [StockTraderDB].[dbo].[BSTOOPS]([BS],[OPS])
+ VALUES ('PHP_BS', 'PHP_OPS');
+INSERT INTO [StockTraderDB].[dbo].[BSTOOPS]([BS],[OPS])
+ VALUES ('JAVA_BS', 'JAVA_OPS');
+
+
+
Added: incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/Table Creation.sql
URL: http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/Table%20Creation.sql?rev=767820&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mssql/Table Creation.sql
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream