/**
* Tests to get collation definition for different collations.
*/
public function testGetDefinition()
{
// Get definition for utf8_unicode_ci
$defCi = Collation::getDefinition('utf8_unicode_ci');
$defCs = Collation::getDefinition('utf8_unicode_cs');
$def = Collation::getDefinition('utf8_unicode');
// Check type
$this->assertType('string', $defCi);
$this->assertType('string', $defCs);
$this->assertType('string', $def);
// Check case sensitivity
$this->assertContains('(' . Yii::t('collation', 'ci') . ')', $defCi);
$this->assertContains('(' . Yii::t('collation', 'cs') . ')', $defCs);
$this->assertNotContains('(' . Yii::t('collation', 'ci') . ')', $def);
$this->assertNotContains('(' . Yii::t('collation', 'cs') . ')', $def);
}
';
var row = $('#' + idPrefix).closest("tr").prev();
row.attr('id', 'columns_<?php
echo $column->COLUMN_NAME;
?>
');
row.children('td:eq(1)').html('<?php
echo $column->COLUMN_NAME;
?>
');
row.children('td:eq(2)').html(<?php
echo CJSON::encode($column->COLUMN_TYPE);
?>
);
row.children('td:eq(3)').html('<?php
echo $column->COLLATION_NAME ? '<dfn class="collation" title="' . Collation::getDefinition($column->COLLATION_NAME) . '">' . $column->COLLATION_NAME . '</dfn>' : '';
?>
');
row.children('td:eq(4)').html('<?php
echo Yii::t('core', $column->isNullable ? 'yes' : 'no');
?>
');
row.children('td:eq(5)').html(<?php
echo !is_null($column->COLUMN_DEFAULT) ? CJSON::encode($column->COLUMN_DEFAULT) : ($column->isNullable ? CJSON::encode('<span class="null">NULL</span>') : '\'\'');
?>
);
row.children('td:eq(6)').html('<?php
echo $column->EXTRA;
?>
');
$('#' + idPrefix).parent().slideUp(500, function() {
}
?>
</td>
<td>
<?php
echo $table->getRowCount();
?>
</td>
<td>
<?php
echo $table->ENGINE;
?>
</td>
<td>
<dfn title="<?php
echo Collation::getDefinition($table->TABLE_COLLATION);
?>
"><?php
echo $table->TABLE_COLLATION;
?>
</dfn>
</td>
<td style="text-align: right">
<?php
echo Formatter::fileSize($table->DATA_LENGTH + $table->INDEX_LENGTH);
?>
</td>
<td style="text-align: right">
<?php
echo Formatter::fileSize($table->DATA_FREE);
?>
<td>
<?php
echo $column->COLUMN_NAME;
?>
</td>
<td>
<?php
echo $column->COLUMN_TYPE;
?>
</td>
<td>
<?php
if (!is_null($column->COLLATION_NAME)) {
?>
<dfn class="collation" title="<?php
echo Collation::getDefinition($column->COLLATION_NAME);
?>
">
<?php
echo $column->COLLATION_NAME;
?>
</dfn>
<?php
}
?>
</td>
<td>
<?php
echo Yii::t('core', strtolower($column->IS_NULLABLE));
?>
</td>
?>
" />
</td>
<td>
<?php
echo CHtml::link(CHtml::encode($model->SCHEMA_NAME), Yii::app()->createUrl('schema/' . urlencode($model->SCHEMA_NAME)));
?>
</td>
<td class="count">
<?php
echo $model->tableCount;
?>
</td>
<td>
<dfn class="collation" title="<?php
echo Collation::getDefinition($model->DEFAULT_COLLATION_NAME);
?>
">
<?php
echo $model->DEFAULT_COLLATION_NAME;
?>
</dfn>
</td>
<td>
<?php
echo Html::icon('privileges', 16, true, 'core.privileges');
?>
</td>
<td>
<?php
if (Yii::app()->user->privileges->checkSchema($model->SCHEMA_NAME, 'ALTER')) {
echo $charset['Description'];
?>
</th>
</tr>
</thead>
<tbody>
<?php
foreach ($charset['collations'] as $collation) {
?>
<tr>
<td><?php
echo $collation['Collation'];
?>
</td>
<td><?php
echo Collation::getDefinition($collation['Collation'], false);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<?php
}
?>
<script type="text/javascript">
breadCrumb.set([
<?php
CHtml::generateRandomIdPrefix();
if (!$schema->isNewRecord && $isSubmitted) {
?>
<script type="text/javascript">
var idPrefix = '<?php
echo CHtml::$idPrefix;
?>
';
var row = $('#' + idPrefix).closest("tr").prev();
row.find("td dfn.collation").html("<?php
echo $schema->DEFAULT_COLLATION_NAME;
?>
").attr("title", "<?php
echo Collation::getDefinition($schema->DEFAULT_COLLATION_NAME);
?>
");
$('#' + idPrefix).parent().slideUp(500, function() {
$('#' + idPrefix).parents("tr").remove();
});
Notification.add('success', '<?php
echo Yii::t('core', 'successEditSchema', array('{schema}' => $schema->SCHEMA_NAME));
?>
', null, <?php
echo CJSON::encode($sql);
?>
);
</script>
<?php
}
