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/21 09:16:44 UTC

svn commit: r767081 - in /incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql: ./ DBCreate.sql InsertScript.sql TableCreate.sql

Author: shankar
Date: Tue Apr 21 09:16:43 2009
New Revision: 767081

URL: http://svn.apache.org/viewvc?rev=767081&view=rev
Log:
mysql scripts

Added:
    incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/
    incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/DBCreate.sql
    incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/InsertScript.sql
    incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/TableCreate.sql

Added: incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/DBCreate.sql
URL: http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/DBCreate.sql?rev=767081&view=auto
==============================================================================
--- incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/DBCreate.sql (added)
+++ incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/DBCreate.sql Tue Apr 21 09:16:43 2009
@@ -0,0 +1,20 @@
+/*
+ * 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.
+ */
+grant all on *.* to 'trade'@'localhost' identified by 'trade';
+create database StockTraderDB;
+
+

Added: 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=767081&view=auto
==============================================================================
--- incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/InsertScript.sql (added)
+++ incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/InsertScript.sql Tue Apr 21 09:16:43 2009
@@ -0,0 +1,78 @@
+/*
+ * 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 SERVICE(SERVICENAME,URL)
+     VALUES ('JAVA_BS','http://localhost:9763/services/TradeServiceWsas');
+INSERT INTO SERVICE(SERVICENAME,URL)
+     VALUES ('JAVA_OPS','http://localhost:9763/services/OrderProcessor');
+INSERT INTO SERVICE(SERVICENAME,URL)
+     VALUES ('JAVA_OPSSEC','http://localhost:9763/services/OrderProcessorMsec');
+INSERT INTO SERVICE(SERVICENAME,URL)
+     VALUES ('PHP_BS','http://localhost:8080/php_stocktrader/business_service/business_svc.php');
+INSERT INTO SERVICE(SERVICENAME,URL)
+     VALUES ('PHP_OPS','http://localhost:8080/php_stocktrader/order_processor/order_processor_svc.php');
+INSERT INTO SERVICE(SERVICENAME,URL)
+     VALUES ('PHP_OPSSEC','http://localhost:8080/php_stocktrader/order_processor/order_processor_svc_msec.php');
+INSERT INTO SERVICE(SERVICENAME,URL)
+     VALUES ('SPRING_BS','http://localhost:8070/StockTrader/services/TradeService');
+INSERT INTO SERVICE(SERVICENAME,URL)
+     VALUES ('SPRING_OPS','http://localhost:8060/StockTrader/services/OrderService');
+INSERT INTO SERVICE(SERVICENAME,URL)
+     VALUES ('SPRING_OPSSEC','http://localhost:8060/StockTrader/services/OrderServiceMsec');
+INSERT INTO SERVICE(SERVICENAME,URL)
+     VALUES ('RUBY_OPS','http://localhost:3005/OrderService');
+INSERT INTO SERVICE(SERVICENAME,URL)
+     VALUES ('RUBY_OPSSEC','http://localhost:3005/OrderServiceMsec');
+INSERT INTO DBCONFIG(DBNAME,HOSTNAME,PORT,ACTIVE)
+     VALUES ('MSSQL', '127.0.0.1', 1433, 'Y');
+INSERT INTO CLIENTTOBS(CLIENT,BS)
+     VALUES ('PHP_CLIENT','PHP_BS');
+INSERT INTO BSTOOPS(BS,OPS)
+	 VALUES ('PHP_BS', 'PHP_OPS');
+
+
+
+
+INSERT INTO ACCOUNT(CREATIONDATE, OPENBALANCE, LOGOUTCOUNT, BALANCE, LASTLOGIN, LOGINCOUNT, PROFILE_USERID)
+	VALUES ('2008-01-01 00:00:00', 10000, 1, 10000, '2008-01-01 00:00:00', 1, 'uid:0');
+INSERT INTO ACCOUNTPROFILE(ADDRESS,PASSWORD,USERID,EMAIL,CREDITCARD,FULLNAME)
+     VALUES ('111 First Street, Redmond, WA33', 'xxx', 'uid:0', 'user0@company.com', '469023-0320', 'Full Name 0');
+
+INSERT INTO QUOTE (LOW,OPEN1,VOLUME,PRICE,HIGH,COMPANYNAME,SYMBOL,CHANGE1)
+     VALUES (100, 100, 1000, 100, 100, 'S0 Incorp', 's:0', 0);
+INSERT INTO QUOTE (LOW,OPEN1,VOLUME,PRICE,HIGH,COMPANYNAME,SYMBOL,CHANGE1)
+     VALUES (100, 100, 1000, 100, 100, 'S1 Incorp', 's:1', 0);
+INSERT INTO QUOTE (LOW,OPEN1,VOLUME,PRICE,HIGH,COMPANYNAME,SYMBOL,CHANGE1)
+     VALUES (100, 100, 1000, 100, 100, 'S2 Incorp', 's:2', 0);
+INSERT INTO QUOTE (LOW,OPEN1,VOLUME,PRICE,HIGH,COMPANYNAME,SYMBOL,CHANGE1)
+     VALUES (100, 100, 1000, 100, 100, 'S3 Incorp', 's:3', 0);
+INSERT INTO QUOTE (LOW,OPEN1,VOLUME,PRICE,HIGH,COMPANYNAME,SYMBOL,CHANGE1)
+     VALUES (100, 100, 1000, 100, 100, 'S4 Incorp', 's:4', 0);
+INSERT INTO QUOTE (LOW,OPEN1,VOLUME,PRICE,HIGH,COMPANYNAME,SYMBOL,CHANGE1)
+     VALUES (100, 100, 1000, 100, 100, 'S5 Incorp', 's:5', 0);
+INSERT INTO QUOTE (LOW,OPEN1,VOLUME,PRICE,HIGH,COMPANYNAME,SYMBOL,CHANGE1)
+     VALUES (100, 100, 1000, 100, 100, 'S6 Incorp', 's:6', 0);
+INSERT INTO QUOTE (LOW,OPEN1,VOLUME,PRICE,HIGH,COMPANYNAME,SYMBOL,CHANGE1)
+     VALUES (100, 100, 1000, 100, 100, 'S7 Incorp', 's:7', 0);
+INSERT INTO QUOTE (LOW,OPEN1,VOLUME,PRICE,HIGH,COMPANYNAME,SYMBOL,CHANGE1)
+     VALUES (100, 100, 1000, 100, 100, 'S8 Incorp', 's:8', 0);
+INSERT INTO QUOTE (LOW,OPEN1,VOLUME,PRICE,HIGH,COMPANYNAME,SYMBOL,CHANGE1)
+     VALUES (100, 100, 1000, 100, 100, 'S9 Incorp', 's:9', 0);
+
+
+
+
+

Added: 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=767081&view=auto
==============================================================================
--- incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/TableCreate.sql (added)
+++ incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/mysql/TableCreate.sql Tue Apr 21 09:16:43 2009
@@ -0,0 +1,93 @@
+/*
+ * 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.
+ */
+CREATE TABLE IF NOT EXISTS ACCOUNT(
+			CREATIONDATE datetime NULL,
+			OPENBALANCE decimal(12, 2) NULL,
+			LOGOUTCOUNT integer NOT NULL,
+			BALANCE decimal(12, 2) NULL,
+			ACCOUNTID integer AUTO_INCREMENT NOT NULL,
+			LASTLOGIN datetime NULL,
+			LOGINCOUNT integer NOT NULL,
+			PROFILE_USERID varchar(250) NULL,
+			PRIMARY KEY (ACCOUNTID));
+
+CREATE TABLE IF NOT EXISTS ACCOUNTPROFILE(
+			ADDRESS varchar(250) NULL,
+			PASSWORD varchar(250) NULL,
+			USERID varchar(250) NOT NULL,
+			EMAIL varchar(250) NULL,
+			CREDITCARD varchar(250) NULL,
+			FULLNAME varchar(250) NULL,
+			PRIMARY KEY (USERID));
+
+CREATE TABLE IF NOT EXISTS QUOTE(
+			LOW decimal(12, 2) NULL,
+			OPEN1 decimal(12, 2) NULL,
+			VOLUME float NOT NULL,
+			PRICE decimal(12, 2) NULL,
+			HIGH decimal(12, 2) NULL,
+			COMPANYNAME varchar(250) NULL,
+			SYMBOL varchar(250) NOT NULL,
+			CHANGE1 float NOT NULL,		
+			PRIMARY KEY (SYMBOL));
+
+CREATE TABLE IF NOT EXISTS HOLDING(
+			PURCHASEPRICE decimal(12, 2) NULL,
+			HOLDINGID integer AUTO_INCREMENT NOT NULL,
+			QUANTITY float NOT NULL,
+			PURCHASEDATE datetime NULL,
+			ACCOUNT_ACCOUNTID int NULL,
+			QUOTE_SYMBOL varchar(250) NULL,
+			PRIMARY KEY (HOLDINGID));
+
+CREATE TABLE IF NOT EXISTS ORDERS(
+			ORDERFEE decimal(12, 2) NULL,
+			COMPLETIONDATE datetime NULL,
+			ORDERTYPE varchar(250) NULL,
+			ORDERSTATUS varchar(250) NULL,
+			PRICE decimal(12, 2) NULL,
+			QUANTITY float NOT NULL,
+			OPENDATE datetime NULL,
+			ORDERID integer AUTO_INCREMENT NOT NULL,
+			ACCOUNT_ACCOUNTID integer NULL,
+			QUOTE_SYMBOL varchar(250) NULL,
+			HOLDING_HOLDINGID integer NULL,
+			PRIMARY KEY (ORDERID));
+
+CREATE TABLE IF NOT EXISTS DBCONFIG(
+			DBNAME varchar(50) NOT NULL,
+			HOSTNAME varchar(50) NOT NULL,
+			PORT integer NOT NULL,
+			ACTIVE varchar(1) NOT NULL,
+			PRIMARY KEY (DBNAME));
+
+CREATE TABLE IF NOT EXISTS SERVICE(
+			SERVICENAME varchar(50) NOT NULL,
+			URL varchar(500) NOT NULL,
+			PRIMARY KEY (SERVICENAME));
+
+CREATE TABLE IF NOT EXISTS CLIENTTOBS(
+			CLIENT varchar(50) NOT NULL,
+			BS varchar(50) NOT NULL,
+			PRIMARY KEY (CLIENT));
+
+CREATE TABLE IF NOT EXISTS BSTOOPS(
+			BS varchar(50) NOT NULL,
+			OPS varchar(50) NOT NULL,
+			PRIMARY KEY (BS));
+
+