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])
