incubator-stonehenge-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bende...@apache.org
Subject svn commit: r943791 - in /incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/DataLoad: createdbconfig.sql insertdbconfig.sql
Date Thu, 13 May 2010 04:13:23 GMT
Author: bendewey
Date: Thu May 13 04:13:23 2010
New Revision: 943791

URL: http://svn.apache.org/viewvc?rev=943791&view=rev
Log:
JIRA: STONEHENGE-125
Update DB Scripts for SQL Server, Thanks
Submitted by: Nicholas Hauenstein

Modified:
    incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/DataLoad/createdbconfig.sql
    incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/DataLoad/insertdbconfig.sql

Modified: incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/DataLoad/createdbconfig.sql
URL: http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/DataLoad/createdbconfig.sql?rev=943791&r1=943790&r2=943791&view=diff
==============================================================================
--- incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/DataLoad/createdbconfig.sql
(original)
+++ incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/DataLoad/createdbconfig.sql
Thu May 13 04:13:23 2010
@@ -16,6 +16,13 @@
  */
 SET ANSI_NULLS ON
 SET QUOTED_IDENTIFIER ON
+
+IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CONFIGSERVICE]')
AND type in (N'U'))
+	CREATE TABLE [dbo].[CONFIGSERVICE](
+		[NAME] [nvarchar](20) NULL,
+		[URL] [nvarchar](50) NULL
+	) ON [PRIMARY]
+
 IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DBCONFIG]')
AND type in (N'U'))
 	CREATE TABLE [dbo].[DBCONFIG](
 		[DBNAME][varchar](50) NOT NULL,

Modified: incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/DataLoad/insertdbconfig.sql
URL: http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/DataLoad/insertdbconfig.sql?rev=943791&r1=943790&r2=943791&view=diff
==============================================================================
--- incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/DataLoad/insertdbconfig.sql
(original)
+++ incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/DataLoad/insertdbconfig.sql
Thu May 13 04:13:23 2010
@@ -14,12 +14,14 @@
  * See the License for the specific language governing permissions and
  * limitations under the License.
  */
+INSERT INTO [StockTraderDB].[dbo].[CONFIGSERVICE]([NAME],[URL])
+     VALUES ('CONFIG_SERVICE','http://localhost:8080/config_service/ConfigService');
 INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL],[SEC])
-     VALUES ('WSAS_BS','http://localhost:9763/services/TradeServiceWsas', 'False');
+     VALUES ('WSAS_BS','http://localhost:9764/services/TradeServiceWsas', 'False');
 INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL],[SEC])
-     VALUES ('WSAS_OPS','http://localhost:9763/services/OrderProcessor', 'False');
+     VALUES ('WSAS_OPS','http://localhost:9764/services/OrderProcessor', 'False');
 INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL], [SEC])
-     VALUES ('WSAS_OPSSEC','http://localhost:9763/services/OrderProcessorMsec', 'True');
+     VALUES ('WSAS_OPSSEC','http://localhost:9764/services/OrderProcessorMsec', 'True');
 INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL], [SEC])
      VALUES ('PHP_BS','http://localhost:8080/php_stocktrader/business_service/business_svc.php',
'False');
 INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL], [SEC])
@@ -35,19 +37,17 @@ INSERT INTO [StockTraderDB].[dbo].[SERVI
 INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL], [SEC])
      VALUES ('DOTNET_OPSTSEC','https://localhost:8005/tradeorderprocessor', 'True');
 INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL], [SEC])
-     VALUES ('METRO_BS','http://localhost:8090/business_service/TradeServiceWsas', 'False');
+     VALUES ('METRO_BS','http://apps.stonehenge.dev:8080/business_service/TradeServiceWsas',
'False');
 INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL], [SEC])
-     VALUES ('METRO_OPS','http://localhost:8090/order_processor/OrderProcessor', 'False');
+     VALUES ('METRO_OPS','http://apps.stonehenge.dev:8080/order_processor/OrderProcessor',
'False');
 INSERT INTO [StockTraderDB].[dbo].[SERVICE]([SERVICENAME],[URL], [SEC])
-     VALUES ('METRO_OPSSEC','http://localhost:8090/order_processor/OrderProcessorSec', 'True');
+     VALUES ('METRO_OPSSEC','http://apps.stonehenge.dev:8080/order_processor/OrderProcessorSec',
'True');
 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 ('DOTNET_CLIENT','DOTNET_BS');
 INSERT INTO [StockTraderDB].[dbo].[CLIENTTOBS]([CLIENT],[BS])
      VALUES ('PHP_CLIENT','PHP_BS');
-INSERT INTO [StockTraderDB].[dbo].[CLIENTTOBS]([CLIENT],[BS])
-     VALUES ('METRO_CLIENT','METRO_BS');
 INSERT INTO [StockTraderDB].[dbo].[BSTOOPS]([BS],[OPS])
 	 VALUES ('DOTNET_BS', 'DOTNET_OPS');
 INSERT INTO [StockTraderDB].[dbo].[BSTOOPS]([BS],[OPS])



Mime
View raw message