/**
* 分类
*/
private function categorySitemap()
{
$criteria = new CDbCriteria();
$criteria->condition = 'classify=:category';
$criteria->params = array(':category' => $this->classify);
$criteria->limit = $this->limitPerPage;
$criteria->offset = $this->pageStart;
$result = Column::model()->findAll($criteria);
foreach ($result as $k => $v) {
$this->categoryItems[] = array('url' => $this->webSiteTitle . '/posts/col-' . $v->id . '.html', 'date' => date(DATE_W3C, time()));
}
}
/**
* Loads the current table.
*
* @return Table
*/
public function loadTable()
{
if (is_null($this->_table)) {
$pk = array('TABLE_SCHEMA' => $this->schema, 'TABLE_NAME' => $this->table);
$this->_table = Table::model()->findByPk($pk);
$this->_table->columns = Column::model()->findAllByAttributes($pk);
if (is_null($this->_table)) {
throw new CHttpException(500, 'The requested table does not exist.');
}
}
return $this->_table;
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model=Column::model()->findByPk((int)$id);
if($model===null)
throw new CHttpException(404,'The requested page does not exist.');
return $model;
}
/**
* Exports all rows of the given array and writes the dump to the output buffer.
*
* @param array array with identifiers of rows
*/
private function exportRowData()
{
$db = Yii::app()->db;
$pdo = $db->getPdoInstance();
// Columns
$cols = Column::model()->findAllByAttributes(array('TABLE_NAME' => $this->table, 'TABLE_SCHEMA' => $this->schema));
$blobCols = array();
// Create insert statement
if ($this->settings['completeInserts']) {
$columns = array();
$i = 0;
foreach ($cols as $col) {
$columns[] = $db->quoteColumnName($col->COLUMN_NAME);
if (in_array(DataType::getBaseType($col->DATA_TYPE), array('smallblob', 'blob', 'mediumblob', 'longblob'))) {
$blobCols[] = $i;
}
$i++;
}
$columns = ' (' . implode(', ', $columns) . ')';
} else {
$columns = '';
}
$insert = $this->settings['insertCommand'] . ($this->settings['delayedInserts'] ? ' DELAYED' : '') . ($this->settings['ignoreInserts'] ? ' IGNORE' : '') . ' INTO ' . $db->quoteTableName($this->table) . $columns . ' VALUES';
// Find all rows
$rowCount = count($this->rows);
// Settings
$hexBlobs = $this->settings['hexBlobs'];
$rowsPerInsert = (int) $this->settings['rowsPerInsert'];
// Cycle rows
$i = 0;
$k = 1;
foreach ($this->rows as $row) {
// Add comment
if ($i == 0) {
$this->comment('Data for table ' . $db->quoteTableName($this->table));
echo "\n\n";
echo $insert;
}
$attributes = $row->getAttributes();
SqlUtil::FixRow($attributes);
// Escape all contents
foreach ($attributes as $key => $value) {
if ($value === null) {
$attributes[$key] = 'NULL';
} elseif ($hexBlobs && in_array($key, $blobCols) && $value) {
$attributes[$key] = '0x' . bin2hex($value);
} else {
$attributes[$key] = $pdo->quote($value);
}
}
// Add this row
echo "\n (", implode(', ', $attributes), ')';
if ($i == $rowCount - 1) {
echo ";\n\n";
} elseif ($k == $rowsPerInsert) {
echo ";\n\n", $insert;
$k = 0;
} else {
echo ',';
}
$i++;
$k++;
}
}
/**
* Loads the current view.
*
* @return View
*/
public function loadView()
{
if (is_null($this->_view)) {
$pk = array('TABLE_SCHEMA' => $this->schema, 'TABLE_NAME' => $this->view);
$this->_view = View::model()->findByPk($pk);
$this->_view->columns = Column::model()->findAllByAttributes($pk);
if (is_null($this->_view)) {
throw new CHttpException(500, 'The requested view does not exist.');
}
}
return $this->_view;
}
/**
* Exports all rows of the given array and writes the dump to the output buffer.
*
* @param array array with identifiers of rows
*/
private function exportRowData()
{
$db = Yii::app()->db;
$pdo = $db->getPdoInstance();
// Columns
$cols = Column::model()->findAllByAttributes(array('TABLE_NAME' => $this->table, 'TABLE_SCHEMA' => $this->schema));
$blobCols = array();
$columns = array();
$i = 0;
foreach ($cols as $col) {
$columns[] = $db->quoteColumnName($col->COLUMN_NAME);
if (in_array(DataType::getBaseType($col->DATA_TYPE), array('smallblob', 'blob', 'mediumblob', 'longblob'))) {
$blobCols[] = $i;
}
$i++;
}
$columns = implode($this->settings['fieldTerminator'], $columns);
$insert = "";
// Find all rows
$rowCount = count($this->rows);
// Settings
$hexBlobs = $this->settings['hexBlobs'];
$rowsPerInsert = (int) $this->settings['rowsPerInsert'];
// Cycle rows
$i = 0;
$k = 1;
foreach ($this->rows as $row) {
if ($i == 0 && $this->settings['fieldsFirstRow']) {
echo $columns;
}
$attributes = $row->getAttributes();
SqlUtil::FixRow($attributes);
// Escape all contents
foreach ($attributes as $key => $value) {
if ($value === null) {
$attributes[$key] = 'NULL';
} elseif ($hexBlobs && in_array($key, $blobCols) && $value) {
$attributes[$key] = '0x' . bin2hex($value);
} else {
$attributes[$key] = $this->settings['fieldEncloseString'] . addcslashes($value, $this->settings['fieldEncloseString']) . $this->settings['fieldEncloseString'];
}
}
echo "\n", implode($this->settings['fieldTerminator'], $attributes);
if ($i == $rowCount - 1) {
echo "\n\n";
}
$i++;
$k++;
}
}
public function getOne($keyid, $return = '')
{
if (!$keyid) {
return false;
}
$item = Column::model()->findByPk($keyid);
if ($return != '') {
return $item[$return];
}
return $item;
}
public function actionDrop()
{
$columns = (array) $_POST['column'];
$response = new AjaxResponse();
$droppedColumns = $droppedSqls = array();
foreach ($columns as $column) {
$pk = array('TABLE_SCHEMA' => $this->schema, 'TABLE_NAME' => $this->table, 'COLUMN_NAME' => $column);
$column = Column::model()->findByPk($pk);
$column->throwExceptions = true;
try {
$sql = $column->delete();
$droppedColumns[] = $column->COLUMN_NAME;
$droppedSqls[] = $sql;
} catch (DbException $ex) {
$response->addNotification('error', Yii::t('core', 'errorDropColumn', array('{col}' => $column->COLUMN_NAME)), null, $ex->getText());
$response->refresh = true;
}
}
$count = count($droppedColumns);
if ($count > 0) {
$response->addNotification('success', Yii::t('core', 'successDropColumn', array($count, '{col}' => $droppedColumns[0], '{colCount}' => $count)), $count > 1 ? implode(', ', $droppedColumns) : null, implode("\n", $droppedSqls));
}
$this->sendJSON($response);
}
/**
* Test to create a Table
*/
public function testCreateTable()
{
$col1 = new Column();
$col1->COLUMN_NAME = 'test1';
$col1->setDataType('int');
$col1->setAutoIncrement(true);
$col1->setIsNullable(false);
$col1->size = 20;
$col1->createPrimaryKey = true;
$col2 = new Column();
$col2->COLUMN_NAME = 'test2';
$col2->setDataType('varchar');
$col2->setCollation('utf8_general_ci');
$col2->size = 250;
$columns = array($col1, $col2);
$table = new Table();
// Set some properties and save
$table->TABLE_NAME = 'innodb2';
$table->TABLE_SCHEMA = 'tabletest';
$table->optionChecksum = 1;
$table->optionDelayKeyWrite = 1;
$table->optionPackKeys = 0;
$table->ENGINE = 'MyISAM';
$table->TABLE_COLLATION = 'utf8_general_ci';
$table->comment = 'mein testkommentar';
$table->columns = $columns;
$table->insert();
$this->assertTrue(is_string($table->showCreateTable));
$pk = array('TABLE_SCHEMA' => 'tabletest', 'TABLE_NAME' => 'innodb2', 'COLUMN_NAME' => 'test1');
// Load column definition
$col = Column::model()->findByPk($pk);
$this->assertEquals('test1', $col->COLUMN_NAME);
$this->assertEquals('int', $col->getDataType());
$this->assertTrue($col->getAutoIncrement());
$this->assertFalse($col->getIsNullable());
$this->assertTrue($col->getIsPartOfPrimaryKey());
$this->assertEquals(20, $col->size);
$pk = array('TABLE_SCHEMA' => 'tabletest', 'TABLE_NAME' => 'innodb2', 'COLUMN_NAME' => 'test2');
// Load column definition
$col = Column::model()->findByPk($pk);
$this->assertEquals('test2', $col->COLUMN_NAME);
$this->assertEquals('varchar', $col->getDataType());
$this->assertFalse($col->getAutoIncrement());
$this->assertFalse($col->getIsNullable());
$this->assertFalse($col->getIsPartOfPrimaryKey());
$this->assertEquals('utf8_general_ci', $col->getCollation());
$this->assertEquals(250, $col->size);
}
/**
* Record can't be inserted cause its not new
*
* @expectedException CDbException
*/
public function testInsertNotNew()
{
$pk = array('TABLE_SCHEMA' => 'columntest', 'TABLE_NAME' => 'test', 'COLUMN_NAME' => 'test5');
// Load column definition
$col = Column::model()->findByPk($pk);
$col->insert();
}
