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',
'us...@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));
+
+
