dbmigrate_3.7-3.8.php File Reference

Migrate DB from release 3.7.0 to 3.8.0. More...

Go to the source code of this file.

Functions
	calculateNumberOfRecordsToRecode ($dbManager)
	updateRecodedValues ($dbManager, $table, $rows)
	recodeContents (&$rows, $MODDIR)
	startRecodingTables ($dbManager, $MODDIR)
	getDbEncoding ($dbManager)
	updateDbEncoding ($dbManager)
	checkMigrate3738Required ($dbManager)
	recodeTables ($dbManager, $MODDIR, $force=false)
	Migrate_37_38 ($dbManager, $MODDIR)

Variables
const	MAX_ROW_SIZE = 100
const	ENCODE_TABLES

Detailed Description

Migrate DB from release 3.7.0 to 3.8.0.

Definition in file dbmigrate_3.7-3.8.php.

Function Documentation

calculateNumberOfRecordsToRecode

(

$dbManager

)

Calculate the total number of records in concerned tables

Parameters

DbManager

$dbManager

Definition at line 47 of file dbmigrate_3.7-3.8.php.

checkMigrate3738Required

(

$dbManager

)

Check if migration is required.

Parameters

DbManager

$dbManager

Returns

boolean True if migration is required, false otherwise

Definition at line 243 of file dbmigrate_3.7-3.8.php.

getDbEncoding

(

$dbManager

)

Get fossology DB's encoding

Parameters

DbManager

$dbManager

Returns

string Encoding of current DB

Definition at line 213 of file dbmigrate_3.7-3.8.php.

Migrate_37_38	(		$dbManager,
			$MODDIR
	)

Migration from FOSSology 3.7.0 to 3.8.0

Parameters

DbManager

$dbManager

Definition at line 328 of file dbmigrate_3.7-3.8.php.

recodeContents	(	&	$rows,
			$MODDIR
	)

Use the recoder tool to remove non UTF-8 characters from text

Parameters

[in,out]	array	$rows	Rows with ID and content. Function will replace the content with recoded values and remove the rows which are unchanged.
	string	$MODDIR	Location of fossology mods

Exceptions

Definition at line 100 of file dbmigrate_3.7-3.8.php.

recodeTables	(		$dbManager,
			$MODDIR,
			$force = false
	)

Start the recoding process

Parameters

DbManager	$dbManager
string	$MODDIR	Location of LIB
boolean	$force	True to force the process

Returns

number Return code

Definition at line 274 of file dbmigrate_3.7-3.8.php.

startRecodingTables	(		$dbManager,
			$MODDIR
	)

Fetch the data from tables and update the recoded values

Parameters

DbManager

$dbManager

Definition at line 158 of file dbmigrate_3.7-3.8.php.

updateDbEncoding

(

$dbManager

)

Check if the DB encoding is SQL_ASCII, change it to UTF-8

Parameters

DbManager

$dbManager

Definition at line 226 of file dbmigrate_3.7-3.8.php.

updateRecodedValues	(		$dbManager,
			$table,
			$rows
	)

Update the recoded values back into DB

Parameters

DbManager	$dbManager
string	$table	Table to be updated
array	$rows	Rows with ID and recoded values

Returns

int Count of updated rows

Definition at line 66 of file dbmigrate_3.7-3.8.php.

Variable Documentation

array ENCODE_TABLES

Initial value:

= array(
  "copyright",
  "ecc",
  "keyword"
)

Tables which needs to be recoded

Definition at line 37 of file dbmigrate_3.7-3.8.php.

integer MAX_ROW_SIZE = 100

Maximum rows to process at once

Definition at line 31 of file dbmigrate_3.7-3.8.php.