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)
 
(19 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">
  
   
  +
===Test suite before deploying new code===
−
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  
  +
On the development server
−
CREATE TABLE `labs` LIKE `sagmilli_agd`.`labs`;
  
  +
# create a new project
−
INSERT INTO `labs` SELECT * FROM `sagmilli_agd`.`labs`;
  
  +
## add a user to this new project
  +
# create a new test result
  +
## Add the 3 work index values
  +
## check these appear in the Testwork Summary listing
  +
## check these appear in the testwork comparison charts
  +
# delete a test result. delete a whole sample.
  +
# create a new optimized Bond SABC circuit
  +
## create new mill for the new circuit from templates or from blanks
  +
## check tent diagram
  +
## change to raw Bond circuit
  +
# create a new SSBM circuit
  +
## create new mill for the new circuit from templates or from blanks
  +
# create a new SSSAG circuit
  +
## create new mill for the new circuit from templates or from blanks
  +
# create a new template mill for a SAG mill, a pebble crusher and a ball mill.
   
−
CREATE TABLE `mills_classes` LIKE `sagmilli_agd`.`mills_classes`;
  
−
INSERT INTO `mills_classes` SELECT * FROM `sagmilli_agd`.`mills_classes`;
  
   
  +
Compare the '''Example''' project on development server versus main server
−
CREATE TABLE `project` LIKE `sagmilli_agd`.`project`;
  
  +
# View model output table of a circuit
−
INSERT INTO `project` SELECT * FROM `sagmilli_agd`.`project` WHERE `id`<=1;
  
  +
## Pull up some summary charts
−  
  +
## Check some SAG-limited samples
−
CREATE TABLE `ai` LIKE `sagmilli_agd`.`ai`;
  
  +
## Check some ball-limited samples
−
INSERT INTO `ai` SELECT * FROM `sagmilli_agd`.`ai` WHERE `ProjNum`=1;
  
  +
## Run the PDF report, confirm percentile samples against the HTML list.
−  
  +
# Check the result table totals are the same
−
CREATE TABLE `dwt` LIKE `sagmilli_agd`.`dwt`;
  
  +
# Edit a SAG mill; change the model on a SAG mill
−
INSERT INTO `dwt` SELECT * FROM `sagmilli_agd`.`dwt` WHERE `ProjNum`=1;
  
  +
## check a tent diagram
−  
  +
## change speed or filling on tent diagram
−
CREATE TABLE `geotech` LIKE `sagmilli_agd`.`geotech`;
  
  +
# Edit a ball mill; change the model on a ball mill
−
INSERT INTO `geotech` SELECT * FROM `sagmilli_agd`.`geotech` WHERE `ProjNum`=1;
  
  +
## check a tent diagram
−  
  +
## change speed or filling on tent diagram
−
CREATE TABLE `litho` LIKE `sagmilli_agd`.`litho`;
  
  +
# Manually override the test results and the F80, P80 sizes (use the data entry fields on the flowsheet page)
−
INSERT INTO `litho` SELECT * FROM `sagmilli_agd`.`litho` WHERE `ProjNum`=1;
  
  +
# Edit a crusher
−  
−
CREATE TABLE `pli` LIKE `sagmilli_agd`.`pli`;
  
−
INSERT INTO `pli` SELECT * FROM `sagmilli_agd`.`pli` WHERE `ProjNum`=1;
  
−  
−
CREATE TABLE `project__circuits` LIKE `sagmilli_agd`.`project__circuits`;
  
−
INSERT INTO `project_circuits` SELECT * FROM `sagmilli_agd`.`project__circuits` WHERE `ProjNum`=1;
  
−  
−
CREATE TABLE `spi` LIKE `sagmilli_agd`.`spi`;
  
−
INSERT INTO `spi` SELECT * FROM `sagmilli_agd`.`spi` WHERE `ProjNum`=1;
  
−  
−
CREATE TABLE `ucs` LIKE `sagmilli_agd`.`ucs`;
  
−
INSERT INTO `ucs` SELECT * FROM `sagmilli_agd`.`ucs` WHERE `ProjNum`=1;
  
−  
−
CREATE TABLE `wibm` LIKE `sagmilli_agd`.`wibm`;
  
−
INSERT INTO `wibm` SELECT * FROM `sagmilli_agd`.`wibm` WHERE `ProjNum`=1;
  
−  
−
CREATE TABLE `wirm` LIKE `sagmilli_agd`.`wirm`;
  
−
INSERT INTO `wirm` SELECT * FROM `sagmilli_agd`.`wirm` WHERE `ProjNum`=1;
  
−  
−
CREATE TABLE `wic` LIKE `sagmilli_agd`.`wic`;
  
−
INSERT INTO `wic` SELECT * FROM `sagmilli_agd`.`wic` WHERE `ProjNum`=1;
  
−  
−
CREATE TABLE `mills` LIKE `sagmilli_agd`.`mills`;
  
−
INSERT INTO `mills` SELECT * FROM `sagmilli_agd`.`mills` WHERE `ProjNum`=0 OR `ProjNum`=1;
  
−  
−
</syntaxhighlight>
  
−
</div>
  

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"