Hello all:

Question: Is it possible to create and populate all the tables of
the stocktrader demo without running any of the Java, PHP or .NET code?

If so, then please supply step-by-step instructions.

The following is what we have guessed so far by looking at the code and docs.

There are 5 tables with specific fields as documented in:
  contrib/stocktrader/documents/BusinessServiceFunctionality.doc

The script:
  contrib/stocktrader/dotnet/Setup/DataLoad/createdb.sql
seems to create those 5 tables.

The scripts:
  contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLAccountProc.sql
  
contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLAccountProfileProc.sql
  contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLHoldingProc.sql
  contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLOrdersProc.sql
  contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLQuoteProc.sql
and the data files:
  contrib/stocktrader/dotnet/Setup/StockTraderDB/Account.xml
  contrib/stocktrader/dotnet/Setup/StockTraderDB/AccountProfile.xml
  contrib/stocktrader/dotnet/Setup/StockTraderDB/Holding.xml
  contrib/stocktrader/dotnet/Setup/StockTraderDB/Orders.xml
  contrib/stocktrader/dotnet/Setup/StockTraderDB/Quote.xml
seem to initialize the tables with pseudo data.

Is that correct?

Is it possible to run the above independent of the services?

Is the above all that is necessary to start running the WSAS and PHP
versions as shown in:

http://cwiki.apache.org/confluence/display/STONEHENGE/Stonehenge+PHP+and+WSAS+Stocktrader+Installation+Guide


What is the purpose of:

contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLConfigurationKeysProc.sql
contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLConnectedConfigServicesProc.sql
contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLConnectedServicesProc.sql
contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLHostedServicesProc.sql
contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLServiceHostsProc.sql
contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLUserProc.sql

Can we safely ignore them if we are not running the .NET version?

We want to get the database tables created and populated and them build
a Metro-based services and clients (and perhaps install/run the WSAS/PHP
versions).  But there just isn't enough documentation to understand how
to proceed.

Thanks,
Harold

Reply via email to