Difference between revisions of "TableEdit Loader"

Latest revision as of 18:12, 9 October 2012

Author : Daniel Renfro

Objective

Introduced in version 0.8, the loader class houses methods to load data into tables in the wiki.

Location

Reading the page on Using Subversion with the wikis is a good reference, you'll need some background in SVN.

The loader currently resides in the SVN repository at svn://tetramer.tamu.edu/wiki-extensions/trunk/TableEdit/

Execution Syntax/ Usage

The loader is a PHP class which must be instantiated to use.

See the Example script below.

The loader has a few options that can be set in the instantiation code.

Options

Public Methods/Properties

Example

TableEdit ships with a sample script, but I'll add it here, too. This is a basic script which will:

1. set up the wiki to be used ( by setting the variable $wikidir)
2. include the loader class ( by giving the right path to the loader class in the require_once())
3. make an object from the loader class
4. set up some options for the object (verbosity, etc)
5. load info into the tables in the wiki ( by calling the method loadFromFile())

<?php
/* 
	Example loader script for TableEdit.
*/
 
// Setup to use the wiki from the command line
$options = getopt('w:');
if(isset($options['w'])){
	if( is_file($options['w'] . "/AdminSettings.php") ){
		require_once($options['w'] . "/maintenance/commandLine.inc");
	} else {
		die("Cannot find AdminSettings.php in {$options['w']}. Please check the paths.\n");
	}
} else {
	die("Please use the -w flag to set a path to the wiki.\n");
}
 
// Instantiate the object
	$loader = new TableEdit_Loader;
 
// set some options
	$loader->setVerbose();
	$loader->setUser()
	$loader->printInfo();
 
 
// load pretty much anything into tables from either an *.ifalt file.
	$loader->loadFromFile(array_pop($argv));
 
?>

running the script (loading information into the wiki)

Once you have a script like above, with the right variables and paths, you can then run that script to do the loading. In a command-line window, browse to the path where your script lives, and run it using the command

php5 loader.sample.php /path/to/input_file

If you want to save the output into a file for later viewing, you can pipe the output like so:

php5 loader.sample.php >& output.txt

You can also separate the output based on STDOUT and STDERR with this type of command:

(php5 loader.sample.php > load.out) >& load.err

I/O

It takes a path to a formatted input file, and has a few options.

Input

The loader currently will accept one type of input:

1. Ifalt format

Output

On the commandline the loader will tell you what page it's working on. It will print any error messages to STDERR.

Notes

logic cases

There is a key method in the loader class which compares two rows. There are four return values:

1. exact : the two rows match data regardless of whitespace
2. disjoint : the two rows are totally different
3. subset : the old row is a subset of the new row
4. different : they could have some common elements, but are regarded as different

old = a | b | c | d | e
new = a | b | c | d | e

old = a | b |   |   | e
new = a | b | c | d | e

new = a | b | c | d | e
old = z | y | w | v | u

new = a | b |   | k | e
old = a | g | h |   | e

How it works

1. constructor sets up variables to use later
2. options are set
3. grabs a line from ifalt, parses it into data-structure
4. creates object for page
   • if the page doesn't exist, check if the gene name redirects to another article, and use this one (follow the redirect)
5. get content from the page
6. create object for page template, get content
7. get content from table template
8. get the box_uid from the database using the page_uid
   • if that fails, try getting the box_uid from the database using the page_name
   • if that fails, then try and grab the box out of the wikitext of the page
   • if that fails, forget it--throw an error
9. make a box object from the table info, make sure we've got the wikitext equivalent
10. check what type of action we are doing (append, merge, clear)
    • if append:
      • append rows and save metadata
    • if merge:
      • compare new row to every row in the existing box
      • we can do a plethora of things here, see above
    • if clear, clear old rows from table
11. save the box object to the database
12. replace the any old wikitext with the new wikitext and save the page
13. unset the box object to keep from messing up next iteration

Code Examples

do_misc_features

public function do_misc_features( $array ){
	foreach ($array as $name => $feature) {
 
		// Here is where you can add code to define what to do for things in the 7th column. 	
		if ($name == 'row_style')	$this->new_row->row_style = trim($feature);
 
		print "added row style";
		return true;
	}
}

appendRow

public function appendRow($new_row_obj){
	$this->box_obj->rows[] = $new_row_obj;
	if ($this->verbose) print "\tappended row, \n";		
	return;
}

mergeRows

public function mergeRows($new_row_obj){	
	// compare the new row to each of the existing rows
	$results = array();
	foreach ($this->box_obj->rows as $old_row) {
		$results[] = $this->compareRows($old_row, $new_row_obj);
	}
	if (in_array('exact', $results)) {
		// skip, this row is already in the box
		return;
	} elseif (in_array('subset', $results)) {
		for($i=0, $c=count($results); $i<$c; $i++){
			if($results[$i] == 'subset'){
				foreach($this->box_obj->rows[$i]->row_metadata as $old_row_metadata_obj){
					$new_row_obj->metadata[] = $old_row_metadata_obj;
				}
				$this->box_obj->delete_row($i);
			}
		}
		$this->box_obj->rows[] = $new_row_obj;
		return;
	} else {
		$this->appendRow($new_row_obj);
	}
}

clearOldRows

function clearOldRows($box, $time){
	// compare timestamps and delete row if older
	if(!$this->debug){
		foreach($box->rows as $row){
			if($time > $row->timestamp){
				$row->delete_row();
			}
		}
	}
	return;
}