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)
 
(20 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`;
  
−
ALTER TABLE `labs` ADD PRIMARY KEY ( `id` ) ;
  
   
  +
===Test suite before deploying new code===
−
CREATE TABLE `mills_classes` SELECT * FROM `sagmilli_agd`.`mills_classes`;
  
  +
On the development server
−
ALTER TABLE `mills_classes` ADD PRIMARY KEY ( `id` ) ;
  
  +
# create a new project
  +
## 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 `project` SELECT * FROM `sagmilli_agd`.`project` WHERE `id`=1;
  
−
INSERT INTO `project` (`id`, `name`, `folder`) VALUES (0, '_Listing of default mills', 'bond') ;
  
−
ALTER TABLE `project` ADD PRIMARY KEY ( `id` ) ;
  
   
  +
Compare the '''Example''' project on development server versus main server
−
CREATE TABLE `ai` SELECT * FROM `sagmilli_agd`.`ai` WHERE `ProjNum`=1;
  
  +
# View model output table of a circuit
−
ALTER TABLE `ai` ADD PRIMARY KEY ( `id` ) ;
  
  +
## Pull up some summary charts
−
ALTER TABLE `ai` ADD INDEX `ProjNum` ( `ProjNum` , `Sample` ) ;
  
  +
## Check some SAG-limited samples
−  
  +
## Check some ball-limited samples
−
CREATE TABLE `dwt` SELECT * FROM `sagmilli_agd`.`dwt` WHERE `ProjNum`=1;
  
  +
## Run the PDF report, confirm percentile samples against the HTML list.
−
ALTER TABLE `dwt` ADD PRIMARY KEY ( `id` ) ;
  
  +
# Check the result table totals are the same
−
ALTER TABLE `dwt` ADD INDEX `ProjNum` ( `ProjNum` , `Sample` ) ;
  
  +
# Edit a SAG mill; change the model on a SAG mill
−  
  +
## check a tent diagram
−
CREATE TABLE `geotech` SELECT * FROM `sagmilli_agd`.`geotech` WHERE `ProjNum`=1;
  
  +
## change speed or filling on tent diagram
−
ALTER TABLE `geotech` ADD PRIMARY KEY ( `id` ) ;
  
  +
# Edit a ball mill; change the model on a ball mill
−
ALTER TABLE `geotech` ADD INDEX `ProjNum` ( `ProjNum` ) ;
  
  +
## check a tent diagram
−  
  +
## change speed or filling on tent diagram
−
CREATE TABLE `litho` SELECT * FROM `sagmilli_agd`.`litho` WHERE `ProjNum`=1;
  
  +
# Manually override the test results and the F80, P80 sizes (use the data entry fields on the flowsheet page)
−
ALTER TABLE `litho` ADD PRIMARY KEY ( `id` ) ;
  
  +
# Edit a crusher
−
ALTER TABLE `litho` ADD INDEX `ProjNum` ( `ProjNum`,`Sample` ) ;
  
−  
−
CREATE TABLE `pli` SELECT * FROM `sagmilli_agd`.`pli` WHERE `ProjNum`=1;
  
−
ALTER TABLE `pli` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `pli` ADD INDEX `ProjNum` ( `ProjNum`,`Sample` ) ;
  
−  
−
CREATE TABLE `project__circuits` SELECT * FROM `sagmilli_agd`.`project__circuits` WHERE `ProjNum`=1;
  
−
ALTER TABLE `project__circuits` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `project__circuits` ADD INDEX `ProjNum` ( `ProjNum` ) ;
  
−  
−
CREATE TABLE `spi` SELECT * FROM `sagmilli_agd`.`spi` WHERE `ProjNum`=1;
  
−
ALTER TABLE `spi` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `spi` ADD INDEX `ProjNum` ( `ProjNum`,`Sample` ) ;
  
−  
−
CREATE TABLE `ucs` SELECT * FROM `sagmilli_agd`.`ucs` WHERE `ProjNum`=1;
  
−
ALTER TABLE `ucs` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `ucs` ADD INDEX `ProjNum` ( `ProjNum`,`Sample` ) ;
  
−  
−
CREATE TABLE `wibm` SELECT * FROM `sagmilli_agd`.`wibm` WHERE `ProjNum`=1;
  
−
ALTER TABLE `wibm` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `wibm` ADD INDEX `ProjNum` ( `ProjNum`,`Sample` ) ;
  
−  
−
CREATE TABLE `wirm` SELECT * FROM `sagmilli_agd`.`wirm` WHERE `ProjNum`=1;
  
−
ALTER TABLE `wirm` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `wirm` ADD INDEX `ProjNum` ( `ProjNum`,`Sample` ) ;
  
−  
−
CREATE TABLE `wic` SELECT * FROM `sagmilli_agd`.`wic` WHERE `ProjNum`=1;
  
−
ALTER TABLE `wic` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `wic` ADD INDEX `ProjNum` ( `ProjNum`,`Sample` ) ;
  
−  
−
CREATE TABLE `mills` SELECT * FROM `sagmilli_agd`.`mills` WHERE `ProjNum`=0 OR `ProjNum`=1;
  
−
ALTER TABLE `mills` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `mills` ADD INDEX `ProjNum` ( `ProjNum` ) ;
  
−  
−
</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"