LimeSurvey API - Master branch

Update_605 extends DatabaseUpdateBase

This update adds two new indexes to the quota and quota_members table to speed up quota usage. In certain situations, this can speed up the quota usage by a factor of 100.

This fix will also be included in the update dbversion 496 for version 5.x. That is why it may fail if the index already exists, but that is not a problem, because we catch the exception.

Table of Contents

Properties

$db  : CDbConnection
$newVersion  : int
$options  : string

Methods

__construct()  : mixed
getVersion()  : int
Get db version number based on class name, e.g. 123 for Update_123
safeUp()  : void
Runs up() wrapped in a transaction.
up()  : mixed
This is the function that must be implemented by the child classes.
updateVersion()  : mixed
Sets DBVersion in settings global to $this->newVersion Last thing that happens before transaction commit in every update.

Properties

Methods

__construct()

public __construct(CDbConnection $connection, string $options) : mixed
Parameters
$connection : CDbConnection
$options : string

Specific database options like ENGINE=INNODB etc

getVersion()

Get db version number based on class name, e.g. 123 for Update_123

public getVersion() : int
Return values
int

safeUp()

Runs up() wrapped in a transaction.

public safeUp() : void

Will rollback transaction and re-throw exception at failure.

Tags
throws
Throwable

up()

This is the function that must be implemented by the child classes.

public up() : mixed
Tags
inheritDoc

updateVersion()

Sets DBVersion in settings global to $this->newVersion Last thing that happens before transaction commit in every update.

private updateVersion() : mixed

        
On this page

Search results