resequence_author_table.php File Reference

Go to the source code of this file.

Functions
	ResequenceAuthorTablePKey ($dbManager, $authorColumn)
	Drop all sequence and constrains and resequence the author table and build them again. More...
	ResequenceCopyrightTablePKey ($dbManager, $copyrightColumn)
	Drop primary key constrains and resequence the copyright table and build them again. More...
	CleanAuthorTable ($dbManager, $authorColumn)
	Remove redundant entries from author table. More...
	CleanCopyrightTable ($dbManager, $copyrightColumn)
	Remove invalid entries from copyright table. More...

Variables
	$result

Detailed Description

Resequence the author and copyright table, remove duplicates in author table, remove dependency of author table on copyright sequence.

Definition in file resequence_author_table.php.

Function Documentation

CleanAuthorTable()

CleanAuthorTable	(		$dbManager,
			$authorColumn
	)

Remove redundant entries from author table.

Parameters

DbManager	$dbManager	DB Manager to be used
string	$authorColumn	Primary column name

Definition at line 115 of file resequence_author_table.php.

CleanCopyrightTable()

CleanCopyrightTable	(		$dbManager,
			$copyrightColumn
	)

Remove invalid entries from copyright table.

Parameters

DbManager	$dbManager	DB Manager to be used
string	$copyrightColumn	Primary column name

Definition at line 150 of file resequence_author_table.php.

ResequenceAuthorTablePKey()

ResequenceAuthorTablePKey	(		$dbManager,
			$authorColumn
	)

Drop all sequence and constrains and resequence the author table and build them again.

Parameters

DbManager	$dbManager	DB Manager to be used
string	$authorColumn	Primary column name

Definition at line 20 of file resequence_author_table.php.

ResequenceCopyrightTablePKey()

ResequenceCopyrightTablePKey	(		$dbManager,
			$copyrightColumn
	)

Drop primary key constrains and resequence the copyright table and build them again.

Parameters

DbManager	$dbManager	DB Manager to be used
string	$copyrightColumn	Primary column name

Definition at line 74 of file resequence_author_table.php.

Variable Documentation

$result

$result

Initial value:

= $dbManager->getSingleRow("SELECT count(*) FROM pg_class WHERE relname = 'author_pk_seq';",
  array(), 'checkAuthorCtPkSequence')

Definition at line 169 of file resequence_author_table.php.