Gecko [ paroquia-rio-de-mouro.pt ]

Linux anchor 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64
Apache/2.4.18 (Ubuntu)
Server IP : 10.10.100.4 & Your IP : 216.73.217.150
Domains : Cant Read [ /etc/named.conf ]
User : www-data

Name	Size	Permission	Date
Version20170101010100.php	21.05 KB	-rw-r--r--	2018-04-19 18:15
Version20170101215145.php	4.5 KB	-rw-r--r--	2018-04-19 18:15
Version20170111103310.php	4.2 KB	-rw-r--r--	2018-04-19 18:15
Version20170213215145.php	532 B	-rw-r--r--	2018-04-19 18:15
Version20170214112458.php	1.46 KB	-rw-r--r--	2018-04-19 18:15
Version20170221114437.php	953 B	-rw-r--r--	2018-04-19 18:15
Version20170221121536.php	1.7 KB	-rw-r--r--	2018-04-19 18:15
Version20170315173825.php	3.53 KB	-rw-r--r--	2018-04-19 18:15
Version20170320173955.php	1.21 KB	-rw-r--r--	2018-04-19 18:15
Version20170418154659.php	1.32 KB	-rw-r--r--	2018-04-19 18:15
Version20170516100103.php	2.17 KB	-rw-r--r--	2018-04-19 18:15
Version20170526104128.php	1.57 KB	-rw-r--r--	2018-04-19 18:15
Version20170605143658.php	745 B	-rw-r--r--	2018-04-19 18:15
Version20170711191432.php	673 B	-rw-r--r--	2018-04-19 18:15
Version20170804201253.php	1.07 KB	-rw-r--r--	2018-04-19 18:15
Version20170928120000.php	628 B	-rw-r--r--	2018-04-19 18:15
Version20171026130750.php	787 B	-rw-r--r--	2018-04-19 18:15
Version20180123131835.php	880 B	-rw-r--r--	2018-04-19 18:15
Version20180319102121.php	543 B	-rw-r--r--	2018-04-19 18:15

Rename

<?php
namespace OC\Migrations;

use Doctrine\DBAL\Schema\Schema;
use OC\DB\QueryBuilder\Literal;
use OCP\IDBConnection;
use OCP\Migration\ISchemaMigration;

/**
 * Update term column length to ensure index creation works on all db setups
 */
class Version20170526104128 implements ISchemaMigration {

public function changeSchema(Schema $schema, array $options) {
		// Get the table
		$prefix = $options['tablePrefix'];
		$table = $schema->getTable("{$prefix}account_terms");

// Check column length
		if($table->getColumn('term')->getLength() === 191) {
			// we don't need to adjust it
			return;
		}

// Need to shorten the column by one character
		// Check if we have any terms taking up 192 or more chars (unlikely)

/** @var IDBConnection $db */
		$db = \OC::$server->getDatabaseConnection();

$qb = $db->getQueryBuilder();
		$qb->select(['id', 'term'])
			->from('account_terms')
			->where($qb->expr()->gte($qb->expr()->length('term'), new Literal(192)));
		$results = $qb->execute();

// Now shorten these terms
		$db->beginTransaction();
		while($longTerm = $results->fetch()) {
			$qb->update('account_terms')
				->where($qb->expr()->eq('id', $qb->createNamedParameter($longTerm['id'])))
				->set('term', $qb->createNamedParameter($this->trimTerm($longTerm['term'])))
				->execute();
		}
		$db->commit();

// Now update the column length
		$table->getColumn('term')->setLength(191);
    }

/**
	 * @param $longTerm
	 * @return string the shortened string ready for the new db column
	 */
    public function trimTerm($longTerm) {
		return (string) substr($longTerm, 0, 191);
	}
}