migr_IUSER_premigr_3.2.0.php File Reference

Go to the source code of this file.

Variables
global	$action
	$parent = null
	$dbaccess = $action->dbaccess
if($dbaccess=="")	$usage = new ApiUsage()
	$dryrun = $usage->addEmptyParameter('dry-run', 'Dry-run mode')
	$sqlList
	$childList = array()
	$q = sprintf("WITH RECURSIVE q AS ( SELECT id, fromid FROM docfam WHERE fromid = 128 UNION ALL SELECT docfam.id, docfam.fromid FROM docfam, q WHERE q.id = docfam.fromid ) SELECT id FROM q ORDER BY id")
	$childIdList = array()
foreach($childList as $child)	$resList = array()
	$warnNonEmpty = false
	$warnColumns = array()
foreach($resList as $attr) if(count($childIdList) > 0)	$sqlList [] = "DELETE FROM docattr WHERE docid = 128 AND type IN ('frame', 'array', 'tab') AND id NOT IN (SELECT DISTINCT dright.id FROM docattr AS dleft, docattr AS dright WHERE dleft.docid = 128 AND dleft.docid = dright.docid AND dleft.frameid = dright.id);"
	EOT
	$sql = join("\n", $sqlList)
	try

Variable Documentation

global $action

Definition at line 7 of file migr_IUSER_premigr_3.2.0.php.

$childIdList = array()

Definition at line 31 of file migr_IUSER_premigr_3.2.0.php.

$childList = array()

Definition at line 28 of file migr_IUSER_premigr_3.2.0.php.

$dbaccess = $action->dbaccess

Definition at line 14 of file migr_IUSER_premigr_3.2.0.php.

$dryrun = $usage->addEmptyParameter('dry-run', 'Dry-run mode')

Definition at line 21 of file migr_IUSER_premigr_3.2.0.php.

$parent = null

Definition at line 12 of file migr_IUSER_premigr_3.2.0.php.

$q = sprintf("WITH RECURSIVE q AS ( SELECT id, fromid FROM docfam WHERE fromid = 128 UNION ALL SELECT docfam.id, docfam.fromid FROM docfam, q WHERE q.id = docfam.fromid ) SELECT id FROM q ORDER BY id")

Definition at line 29 of file migr_IUSER_premigr_3.2.0.php.

foreach ($childList as $child) $resList = array()

Definition at line 38 of file migr_IUSER_premigr_3.2.0.php.

$sql = join("\n", $sqlList)

Definition at line 101 of file migr_IUSER_premigr_3.2.0.php.

$sqlList

Initial value:

= array(
    'BEGIN;'
)

Definition at line 24 of file migr_IUSER_premigr_3.2.0.php.

$sqlList[] = "DELETE FROM docattr WHERE docid = 128 AND type IN ('frame', 'array', 'tab') AND id NOT IN (SELECT DISTINCT dright.id FROM docattr AS dleft, docattr AS dright WHERE dleft.docid = 128 AND dleft.docid = dright.docid AND dleft.frameid = dright.id);"

Definition at line 78 of file migr_IUSER_premigr_3.2.0.php.

if ($dbaccess=="") $usage = new ApiUsage()

Definition at line 19 of file migr_IUSER_premigr_3.2.0.php.

$warnColumns = array()

Definition at line 42 of file migr_IUSER_premigr_3.2.0.php.

$warnNonEmpty = false

Definition at line 41 of file migr_IUSER_premigr_3.2.0.php.

EOT

Definition at line 97 of file migr_IUSER_premigr_3.2.0.php.

try

Definition at line 103 of file migr_IUSER_premigr_3.2.0.php.