Hi Harold, Yes! Definitely use trunk for EVERYTHING unless directed otherwise. If Sun contributes code to Stonehenge it goes to contrib initially and is moved to truck when we actually use it in the project. My guess contrib is really there to maintain history for blocks of contributed code. This does not include changes made to code that already exist in trunk. --Please correct me if I am wrong.
The dotnet Readme will be updated to point to trunk very soon. Drew -----Original Message----- From: harold.c...@sun.com [mailto:harold.c...@sun.com] Sent: Wednesday, April 01, 2009 9:14 AM To: stonehenge-dev@incubator.apache.org Subject: Re: How to create and populate DB Hello Drew, Thanks for the instructions. The interns will try them out and ask questions here if they have problems. QUESTION: you point to .../stonehenge/trunk --- should we ignore dotnet code in the contrib branch and always refer to the trunk for dotnet? Thanks, Harold Drew Baird (Volt) wrote: > Hi Harold, > One way to do this is use the "setupActions" [1], a C# program from the > dotnet tree that will setup run the scripts in the correct order to create > the database. Then all you need to do is run the two scripts in the > phpStockTrader to create the additional config system. This is in described > in the file [2]. There is document will be improved soon. One edit between > the * * that I intend to add in the next few days. > > > Seed the database and create accounts > a. In the directory: C:\StockTraderDemo\Setup\SetupActions \bin\debug > b. Edit the SetupActions.exe.config file to set the right "dbPassword" > for the sa account. > c. dbserver is set to ".\MSQLServer " If you use SQLExpress or *another > MSSQL Instance* it will be different. > d. From a console run SetupActions.exe (with elevated privilege - i.e. > run as admin) > > > > Hope this helps > Drew > [1] > http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/SetupActions/ > [2] > http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/dotnet/ReadMe.mht?view=markup > > > > -----Original Message----- > From: harold.c...@sun.com [mailto:harold.c...@sun.com] > Sent: Wednesday, April 01, 2009 8:00 AM > To: stonehenge-dev@incubator.apache.org > Subject: How to create and populate DB > > Hello all, > > The Metro interns' current plan is: > > 1. create and populate tables in MSSQL > (independent of any .NET, PHP or Java StockTrader versions) > > 2. OPTIONAL: Install and run Java/PHP versions > (this depends on if there is a detailed and known accurate guide) > > 3. OPTIONAL: Install and run .NET version > (this depends on a detailed and accurate guide) > > 4. Create Metro-based stocktrader from existing WSDLs > > --------- > > We need help on #1 since neither the interns nor myself know SQL (or > MSSQL in particular). > > It seems that we first need to create the DB tables by running: > > contrib/stocktrader/dotnet/Setup/DataLoad/createdb.sql > > Followed up with populating those tables by running: > > contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLAccountProc.sql > ... > > which uses initial data from: > > contrib/stocktrader/dotnet/Setup/StockTraderDB/Account.xml ... > > Could someone let us know how to do this, either from the command line > (preferred) or a GUI tool? > > In particular, it's not clear how the connection is made between > DataLoad/CreateInsertXML*.sql and the corresponding data files > StockTraderDB/*.xml > > Thanks, > Harold >
