Difference between revisions of "User:Alex Doll"

From SAGMILLING.COM
Jump to: navigation, search
(→‎Setting up a new project)
(→‎Test suite before deploying new code)
 
(21 intermediate revisions by the same user not shown)
Line 3: Line 3:
   
 
===Setting up a new project===
  
===Setting up a new project===
  +
# Click the Administration button
−
# Create a new database & dbuser.
  
−
# Create a new folder in circuitmodels/.
 +
# Create a new Client
  +
## Assign the new administrator
−
# Copy the base PHP files into the new folder.
  
  +
## The database structure, including default data, will populate.
−
# Tweak the configuration file to point to the new database.
  
  +
## Check that indexing of table index fields is active
−
# fill in the database structure, including default data.
  
  +
# Switch to the new Client and check that the database is populated correctly
−
<div style='background-color: #F9F9F9; border: dashed thin blue; padding:0.5em;'>
  
  +
# Email the new administrator with credentials and URL.
−
<syntaxhighlight lang="mysql">
  
  +
−
CREATE TABLE `labs` SELECT * FROM `sagmilli_agd`.`labs`;
  
  +
===Test suite before deploying new code===
−
CREATE TABLE `mills_classes` SELECT * FROM `sagmilli_agd`.`mills_classes`;
  
  +
On the development server
−
CREATE TABLE `project` SELECT * FROM `sagmilli_agd`.`project` WHERE `id`=1;
  
  +
# create a new project
−
ALTER TABLE `project` AUTO_INCREMENT=2 ;
  
  +
## add a user to this new project
−
CREATE TABLE `ai` SELECT * FROM `sagmilli_agd`.`ai` WHERE `ProjNum`=1;
  
  +
# create a new test result
−
CREATE TABLE `dwt` SELECT * FROM `sagmilli_agd`.`dwt` WHERE `ProjNum`=1;
  
  +
## Add the 3 work index values
−
CREATE TABLE `geotech` SELECT * FROM `sagmilli_agd`.`geotech` WHERE `ProjNum`=1;
  
  +
## check these appear in the Testwork Summary listing
−
CREATE TABLE `litho` SELECT * FROM `sagmilli_agd`.`litho` WHERE `ProjNum`=1;
  
  +
## check these appear in the testwork comparison charts
−
CREATE TABLE `pli` SELECT * FROM `sagmilli_agd`.`pli` WHERE `ProjNum`=1;
  
  +
# delete a test result. delete a whole sample.
−
CREATE TABLE `project__circuits` SELECT * FROM `sagmilli_agd`.`project__circuits` WHERE `ProjNum`=1;
  
  +
# create a new optimized Bond SABC circuit
−
CREATE TABLE `spi` SELECT * FROM `sagmilli_agd`.`spi` WHERE `ProjNum`=1;
  
  +
## create new mill for the new circuit from templates or from blanks
−
CREATE TABLE `ucs` SELECT * FROM `sagmilli_agd`.`ucs` WHERE `ProjNum`=1;
  
  +
## check tent diagram
−
CREATE TABLE `wibm` SELECT * FROM `sagmilli_agd`.`wibm` WHERE `ProjNum`=1;
  
  +
## change to raw Bond circuit
−
CREATE TABLE `wirm` SELECT * FROM `sagmilli_agd`.`wirm` WHERE `ProjNum`=1;
  
  +
# create a new SSBM circuit
−
CREATE TABLE `wic` SELECT * FROM `sagmilli_agd`.`wic` WHERE `ProjNum`=1;
  
  +
## create new mill for the new circuit from templates or from blanks
−
CREATE TABLE `mills` SELECT * FROM `sagmilli_agd`.`mills` WHERE `ProjNum`=0 OR `ProjNum`=1;
  
  +
# create a new SSSAG circuit
−
</syntaxhighlight>
  
  +
## create new mill for the new circuit from templates or from blanks
−
</div>
  
  +
# create a new template mill for a SAG mill, a pebble crusher and a ball mill.
  +
  +
  +
Compare the '''Example''' project on development server versus main server
  +
# View model output table of a circuit
  +
## Pull up some summary charts
  +
## Check some SAG-limited samples
  +
## Check some ball-limited samples
  +
## Run the PDF report, confirm percentile samples against the HTML list.
  +
# Check the result table totals are the same
  +
# Edit a SAG mill; change the model on a SAG mill
  +
## check a tent diagram
  +
## change speed or filling on tent diagram
  +
# Edit a ball mill; change the model on a ball mill
  +
## check a tent diagram
  +
## change speed or filling on tent diagram
  +
# Manually override the test results and the F80, P80 sizes (use the data entry fields on the flowsheet page)
  +
# Edit a crusher

Latest revision as of 17:01, 24 June 2020

Alex's to-do lists

Stuff that Alex needs to not forget.

Setting up a new project

  1. Click the Administration button
  2. Create a new Client
    1. Assign the new administrator
    2. The database structure, including default data, will populate.
    3. Check that indexing of table index fields is active
  3. Switch to the new Client and check that the database is populated correctly
  4. Email the new administrator with credentials and URL.

Test suite before deploying new code

On the development server

  1. create a new project
    1. add a user to this new project
  2. create a new test result
    1. Add the 3 work index values
    2. check these appear in the Testwork Summary listing
    3. check these appear in the testwork comparison charts
  3. delete a test result. delete a whole sample.
  4. create a new optimized Bond SABC circuit
    1. create new mill for the new circuit from templates or from blanks
    2. check tent diagram
    3. change to raw Bond circuit
  5. create a new SSBM circuit
    1. create new mill for the new circuit from templates or from blanks
  6. create a new SSSAG circuit
    1. create new mill for the new circuit from templates or from blanks
  7. create a new template mill for a SAG mill, a pebble crusher and a ball mill.


Compare the Example project on development server versus main server

  1. View model output table of a circuit
    1. Pull up some summary charts
    2. Check some SAG-limited samples
    3. Check some ball-limited samples
    4. Run the PDF report, confirm percentile samples against the HTML list.
  2. Check the result table totals are the same
  3. Edit a SAG mill; change the model on a SAG mill
    1. check a tent diagram
    2. change speed or filling on tent diagram
  4. Edit a ball mill; change the model on a ball mill
    1. check a tent diagram
    2. change speed or filling on tent diagram
  5. Manually override the test results and the F80, P80 sizes (use the data entry fields on the flowsheet page)
  6. Edit a crusher
Retrieved from "https://wiki.sagmilling.com/index.php?title=User:Alex_Doll&oldid=1278"