Author: shankar
Date: Wed Apr 22 03:54:23 2009
New Revision: 767359
URL: http://svn.apache.org/viewvc?rev=767359&view=rev
Log:
Added .NET Service endpoints to services table.
Modified:
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/InsertScript.sql
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/InsertScript.sql
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/TableCreate.sql
Modified:
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/InsertScript.sql
URL:
http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/InsertScript.sql?rev=767359&r1=767358&r2=767359&view=diff
==============================================================================
---
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/InsertScript.sql
(original)
+++
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/InsertScript.sql
Wed Apr 22 03:54:23 2009
@@ -36,6 +36,12 @@
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])
Modified:
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/InsertScript.sql
URL:
http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/InsertScript.sql?rev=767359&r1=767358&r2=767359&view=diff
==============================================================================
---
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/InsertScript.sql
(original)
+++
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/InsertScript.sql
Wed Apr 22 03:54:23 2009
@@ -36,6 +36,12 @@
VALUES ('RUBY_OPS','http://localhost:3005/OrderService');
INSERT INTO SERVICE(SERVICENAME,URL)
VALUES ('RUBY_OPSSEC','http://localhost:3005/OrderServiceMsec');
+INSERT INTO SERVICE(SERVICENAME,URL)
+ VALUES ('DOTNET_BS','http://localhost:9000/TradeBusinessService');
+INSERT INTO SERVICE(SERVICENAME,URL)
+ VALUES ('DOTNET_OPS','http://localhost:8000/TradeOrderProcessor');
+INSERT INTO SERVICE(SERVICENAME,URL)
+ VALUES ('DOTNET_OPSSEC','http://localhost:8000/TradeOrderProcessor/msec');
INSERT INTO DBCONFIG(DBNAME,HOSTNAME,PORT,ACTIVE)
VALUES ('MSSQL', '127.0.0.1', 1433, 'Y');
INSERT INTO CLIENTTOBS(CLIENT,BS)
Modified:
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/TableCreate.sql
URL:
http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/TableCreate.sql?rev=767359&r1=767358&r2=767359&view=diff
==============================================================================
---
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/TableCreate.sql
(original)
+++
incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/TableCreate.sql
Wed Apr 22 03:54:23 2009
@@ -1,4 +1,4 @@
-/*
+/*
* 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.
@@ -14,6 +14,7 @@
* See the License for the specific language governing permissions and
* limitations under the License.
*/
+
CREATE TABLE IF NOT EXISTS ACCOUNT(
CREATIONDATE datetime NULL,
OPENBALANCE decimal(12, 2) NULL,
@@ -34,7 +35,7 @@
FULLNAME varchar(250) NULL,
PRIMARY KEY (USERID));
-CREATE TABLE IF NOT EXISTS QUOTE(
+CREATE TABLE IF NOT EXISTS stocktraderdb.QUOTE(
LOW decimal(12, 2) NULL,
OPEN1 decimal(12, 2) NULL,
VOLUME float NOT NULL,
@@ -42,7 +43,7 @@
HIGH decimal(12, 2) NULL,
COMPANYNAME varchar(250) NULL,
SYMBOL varchar(250) NOT NULL,
- CHANGE1 float NOT NULL,
+ CHANGE1 float NOT NULL,
PRIMARY KEY (SYMBOL));
CREATE TABLE IF NOT EXISTS HOLDING(
@@ -90,4 +91,3 @@
OPS varchar(50) NOT NULL,
PRIMARY KEY (BS));
-
