本文整理汇总了PHP中CakeSchema类的典型用法代码示例。如果您正苦于以下问题:PHP CakeSchema类的具体用法?PHP CakeSchema怎么用?PHP CakeSchema使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了CakeSchema类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: _schema
/**
* Return CakeSchema object for given Schema name
*
* @return CakeSchema
*/
protected function _schema()
{
if ($this->_Schema) {
return $this->_Schema;
}
$db = ConnectionManager::getDataSource($this->useDbConfig);
$this->_Schema = new CakeSchema(array('connection' => $db));
$this->_Schema->build(array($this->_tableName() => $this->_schema));
Cache::drop('_cake_model_');
$db->cacheSources = false;
$db->reconnect();
return $this->_Schema;
}
开发者ID:maxleonov,项目名称:cakephp-clope-clustering-plugin,代码行数:18,代码来源:ClopeSchema.php
示例2: _update
/**
* Update database with Schema object
* Should be called via the run method
*
* @param CakeSchema &$Schema The schema instance
* @param string $table The table name.
*
* @return void
*/
protected function _update(&$Schema, $table = NULL)
{
$db = ConnectionManager::getDataSource($this->Schema->connection);
$this->out(__d('cake_console', 'Comparing Database to Schema...'));
$options = array();
if (isset($this->params['force'])) {
$options['models'] = FALSE;
}
$Old = $this->Schema->read($options);
$compare = $this->Schema->compare($Old, $Schema);
$contents = array();
if (empty($table)) {
foreach ($compare as $table => $changes) {
if (isset($compare[$table]['create'])) {
$contents[$table] = $db->createSchema($Schema, $table);
} else {
$contents[$table] = $db->alterSchema(array($table => $compare[$table]), $table);
}
}
} elseif (isset($compare[$table])) {
if (isset($compare[$table]['create'])) {
$contents[$table] = $db->createSchema($Schema, $table);
} else {
$contents[$table] = $db->alterSchema(array($table => $compare[$table]), $table);
}
}
if (empty($contents)) {
$this->out(__d('cake_console', 'Schema is up to date.'));
return $this->_stop();
}
$this->out("\n" . __d('cake_console', 'The following statements will run.'));
$this->out(array_map('trim', $contents));
if (!empty($this->params['yes']) || $this->in(__d('cake_console', 'Are you sure you want to alter the tables?'), array('y', 'n'), 'n') === 'y') {
$this->out();
$this->out(__d('cake_console', 'Updating Database...'));
$this->_run($contents, 'update', $Schema);
}
$this->out(__d('cake_console', 'End update.'));
}
开发者ID:mrbadao,项目名称:api-official,代码行数:48,代码来源:SchemaShell.php
示例3: testCompareEmptyStringAndNull
/**
* test comparing '' and null and making sure they are different.
*
* @return void
*/
public function testCompareEmptyStringAndNull()
{
$One = new CakeSchema(array('posts' => array('id' => array('type' => 'integer', 'null' => false, 'default' => null, 'key' => 'primary'), 'name' => array('type' => 'string', 'null' => false, 'default' => ''))));
$Two = new CakeSchema(array('posts' => array('id' => array('type' => 'integer', 'null' => false, 'default' => null, 'key' => 'primary'), 'name' => array('type' => 'string', 'null' => false, 'default' => null))));
$compare = $One->compare($Two);
$expected = array('posts' => array('change' => array('name' => array('type' => 'string', 'null' => false, 'default' => null))));
$this->assertEquals($expected, $compare);
}
开发者ID:jgera,项目名称:orangescrum,代码行数:13,代码来源:CakeSchemaTest.php
示例4: _getTables
protected function _getTables()
{
$_Schema = new CakeSchema();
$database = $_Schema->read();
$tables = array();
foreach ($database['tables'] as $tableName => $schema) {
if (in_array($tableName, $this->ignoredTables) || empty($tableName) || $tableName === 'missing') {
continue;
}
$tables[$tableName] = $schema;
}
return $tables;
}
开发者ID:radig,项目名称:auditable,代码行数:13,代码来源:AuditableShell.php
示例5: afterSave
/**
* afterSave method
*
* If a default has just been saved check the db and update the table if the db default is different.
*
* @return void
* @access public
*/
function afterSave()
{
if (isset($this->data['Enum']['default']) && $this->data['Enum']['default']) {
$conditions['type'] = isset($this->data['Enum']['type']) ? $this->data['Enum']['type'] : $this->field('type');
$conditions['NOT']['Enum.id'] = $this->id;
$this->updateAll(array('default' => 'false'), $conditions);
$default = isset($this->data['Enum']['value']) ? $this->data['Enum']['value'] : $this->field('value');
if ($default) {
$db =& ConnectionManager::getDataSource($this->useDbConfig);
App::import('Model', 'CakeSchema');
$Schema = new CakeSchema(array('connection' => $this->useDbConfig));
$update = $current = $Schema->read(array('models' => false));
list($model, $field) = explode('.', $conditions['type']);
$table = Inflector::tableize($model);
if (isset($update['tables'][$table][$field])) {
$update['tables'][$table][$field]['default'] = $default;
$update['tables'][$table][$field]['null'] = true;
$compare = $Schema->compare($current, $update);
foreach ($compare as $table => $changes) {
$db->execute($db->alterSchema(array($table => $changes), $table));
}
Cache::delete($this->useDbConfig . '_' . $table, '_cake_model_');
}
}
}
}
开发者ID:razzman,项目名称:mi_enums,代码行数:34,代码来源:Enum.php
示例6: testAlteringTwoTables
/**
* test alterSchema on two tables.
*
* @return void
*/
public function testAlteringTwoTables()
{
$schema1 = new CakeSchema(array('name' => 'AlterTest1', 'connection' => 'test', 'altertest' => array('id' => array('type' => 'integer', 'null' => false, 'default' => 0), 'name' => array('type' => 'string', 'null' => false, 'length' => 50)), 'other_table' => array('id' => array('type' => 'integer', 'null' => false, 'default' => 0), 'name' => array('type' => 'string', 'null' => false, 'length' => 50))));
$schema2 = new CakeSchema(array('name' => 'AlterTest1', 'connection' => 'test', 'altertest' => array('id' => array('type' => 'integer', 'null' => false, 'default' => 0), 'field_two' => array('type' => 'string', 'null' => false, 'length' => 50)), 'other_table' => array('id' => array('type' => 'integer', 'null' => false, 'default' => 0), 'field_two' => array('type' => 'string', 'null' => false, 'length' => 50))));
$result = $this->db->alterSchema($schema2->compare($schema1));
$this->assertEquals(2, substr_count($result, 'field_two'), 'Too many fields');
$this->assertFalse(strpos(';ALTER', $result), 'Too many semi colons');
}
开发者ID:jeffersongoncalves,项目名称:estudos,代码行数:13,代码来源:PostgresTest.php
示例7: _run
/**
* Runs sql from _create() or _update()
*
* @param array $contents
* @param string $event
* @param CakeSchema $Schema
* @return void
*/
protected function _run($contents, $event, &$Schema)
{
if (empty($contents)) {
$this->err(__d('cake_console', 'Sql could not be run'));
return;
}
Configure::write('debug', 2);
$db = ConnectionManager::getDataSource($this->Schema->connection);
foreach ($contents as $table => $sql) {
if (empty($sql)) {
$this->out(__d('cake_console', '%s is up to date.', $table));
} else {
if ($this->_dry === true) {
$this->out(__d('cake_console', 'Dry run for %s :', $table));
$this->out($sql);
} else {
if (!$Schema->before(array($event => $table))) {
return false;
}
$error = null;
try {
$db->execute($sql);
} catch (PDOException $e) {
$error = $table . ': ' . $e->getMessage();
}
$Schema->after(array($event => $table, 'errors' => $error));
if (!empty($error)) {
$this->err($error);
} else {
$this->out(__d('cake_console', '%s updated.', $table));
}
}
}
}
}
开发者ID:sanyaade-machine-learning,项目名称:Catool,代码行数:43,代码来源:SchemaShell.php
示例8: _runSchema
/**
* Runs sql from _createSchema()
*
* NOTE: adapted from the schema shell lib/Cake/Console/Command/SchemaShell.php
*
* @param array $contents
* @param string $event
* @param CakeSchema $Schema
* @return string
*/
protected function _runSchema($db, $contents, $event, &$Schema)
{
$out = '';
if (empty($contents)) {
$this->error('Sql could not be run');
return false;
}
foreach ($contents as $table => $sql) {
if (empty($sql)) {
$out .= sprintf("%s is up to date.\n", $table);
} else {
if (!$Schema->before(array($event => $table))) {
return false;
}
$error = null;
try {
$db->execute($sql);
} catch (PDOException $e) {
$error = $table . ': ' . $e->getMessage();
}
$Schema->after(array($event => $table, 'errors' => $error));
if (!empty($error)) {
$this->error($error);
return false;
} else {
$out .= sprintf("%s updated\n", $table);
}
}
}
return $out;
}
开发者ID:sanyaade-machine-learning,项目名称:Catool,代码行数:41,代码来源:install.php
示例9: fixture
function fixture($model, $useTable = null)
{
if (!class_exists('CakeSchema')) {
App::import('Model', 'Schema');
}
$out = "\nclass {$model}Fixture extends CakeTestFixture {\n";
if (!$useTable) {
$useTable = Inflector::tableize($model);
} else {
//$out .= "\tvar \$table = '$useTable';\n";
}
$schema = new CakeSchema();
$data = $schema->read(array('models' => false, 'connection' => $this->useDbConfig));
if (!isset($data['tables'][$useTable])) {
return false;
}
$out .= "\tvar \$name = '{$model}';\n";
$out .= "\tvar \$import = array('table' => '{$useTable}', 'records' => true, 'connection' => '{$this->useDbConfig}');\n";
$tempModel = ClassRegistry::init($model);
$tempModel->recursive = -1;
$count = $tempModel->find('count');
$response = '';
$example = 'Q';
while ($response == '') {
$this->out('');
$response = $this->in("'{$model}' has " . $count . " records. Set limit number?" . "\nLimit number or [A]ll" . "\n[Q]uit", null, $example);
if (strtoupper($response) === 'Q') {
$this->out('Fake Aborted');
return false;
}
}
if (!is_numeric($response) && strtoupper($response) !== 'A') {
$this->out(__('You have made an invalid selection. Please choose a command to execute by entering A or Q or number.', true));
$this->execute();
}
if (is_numeric($response) && $response > $count) {
$this->out(__('The number that you selected is more than the number of records. Please try again.', true));
$this->execute();
}
$query = array();
if (is_numeric($response)) {
$query['limit'] = $response;
}
$results = $tempModel->find('all', $query);
$records = array();
foreach ($results as $result) {
$record = array();
foreach ($result[$model] as $field => $value) {
$record[] = "\t\t'{$field}' => '{$value}'";
}
$records[] = "array(\n" . implode(",\n", $record) . ")";
}
$records = implode(",\n", $records);
$out .= "\tvar \$records = array(\n{$records}\n\t);\n";
$out .= "}\n";
$path = TESTS . DS . 'fixtures' . DS;
if (isset($this->plugin)) {
$pluginPath = 'plugins' . DS . Inflector::underscore($this->plugin) . DS;
$path = APP . $pluginPath . 'tests' . DS . 'fixtures' . DS;
}
$filename = Inflector::underscore($model) . '_fixture.php';
$header = '$Id';
$content = "<?php \n/* SVN FILE: {$header}\$ */\n/* " . $model . " Fixture generated on: " . date('Y-m-d H:i:s') . " : " . time() . "*/\n{$out}?>";
$this->out("\nBaking test fixture for {$model}...");
if ($this->createFile($path . $filename, $content)) {
return str_replace("\t\t", "\t\t\t", $records);
}
return false;
}
开发者ID:k1LoW,项目名称:fake,代码行数:69,代码来源:fake_fixture.php
示例10: admin_export
function admin_export($id = null)
{
$this->layout = null;
$this->autoRender = false;
if (!$id) {
$this->Session->setFlash(__('Invalid Node Schema', true));
$this->redirect(array('action' => 'index'));
}
$this->NodeSchema->recursive = -1;
$this->set('node_schemas', $node_schemas = $this->NodeSchema->read(null, $id));
App::Import('CakeSchema');
$CakeSchema = new CakeSchema();
//debug($CakeSchema->tables);
//debug($CakeSchema->read(array('default', 'test')));
// The above only works for tables that have models, our models are only instantiated when needed in memory
$db =& ConnectionManager::getDataSource($node_schemas['NodeSchema']['datasource']);
//$tables = array();
$Model = new Model(null, $node_schemas['NodeSchema']['table_name'], $node_schemas['NodeSchema']['datasource']);
$Model->name = $Model->alias = Inflector::classify($node_schemas['NodeSchema']['table_name']);
$Object = ClassRegistry::init(array('class' => Inflector::pluralize($Model->name), 'ds' => $node_schemas['NodeSchema']['datasource']));
// These cause issues for one reason or another
unset($Object->tableToModel);
unset($Object->__associationKeys);
unset($Object->__associations);
unset($Object->_findMethods);
// The rest here just aren't needed, but don't cause any issues (not sure if it makes the export any faster, but makes the import php file smaller)
unset($Object->Behaviors);
unset($Object->useCache);
unset($Object->cacheSources);
unset($Object->alias);
unset($Object->recursive);
unset($Object->primaryKey);
unset($Object->table);
unset($Object->useTable);
unset($Object->displayField);
unset($Object->useDbConfig);
// This may eventually get used, if I can figure how to set it so it writes to the file
// This is weird and doesn't even seem right, but it renames the property and works
$Object->{$node_schemas}['NodeSchema']['table_name'] = $Object->_schema;
unset($Object->_schema);
$CakeSchema->path = $this->nodeSchemaPath;
$CakeSchema->file = $node_schemas['NodeSchema']['table_name'] . '.php';
$CakeSchema->write($Object);
if (file_exists($this->nodeSchemaPath . DS . $CakeSchema->file)) {
$file = $this->nodeSchemaPath . DS . $CakeSchema->file;
header("Content-Type: application/octet-stream");
header("Accept-Ranges: bytes");
header("Content-Length: " . filesize($file));
header("Content-Disposition: attachment; filename=" . $CakeSchema->file);
readfile($file);
} else {
$this->Session->setFlash(__('Could not export node schema, ensure the path: ' . $this->nodeSchemaPath . ' is writeable by the server.', true));
$this->redirect(array('action' => 'index'));
}
}
开发者ID:hgassen,项目名称:node_schema,代码行数:55,代码来源:node_schemas_controller.php
示例11: fixture
/**
* Builds the tests fixtures for the model and create the file
*
* @param string $model the name of the model
* @param string $useTable table name
* @return array $records, used in ModelTask::bakeTest() to create $expected
* @todo move this to a task
*/
function fixture($model, $useTable = null)
{
if (!class_exists('CakeSchema')) {
App::import('Model', 'Schema');
}
$out = "\nclass {$model}Fixture extends CakeTestFixture {\n";
$out .= "\tvar \$name = '{$model}';\n";
if (!$useTable) {
$useTable = Inflector::tableize($model);
} else {
$out .= "\tvar \$table = '{$useTable}';\n";
}
$schema = new CakeSchema();
$data = $schema->read(array('models' => false, 'connection' => $this->useDbConfig));
if (!isset($data['tables'][$useTable])) {
return false;
}
$tables[$model] = $data['tables'][$useTable];
foreach ($tables as $table => $fields) {
if (!is_numeric($table) && $table !== 'missing') {
$out .= "\tvar \$fields = array(\n";
$records = array();
if (is_array($fields)) {
$cols = array();
foreach ($fields as $field => $value) {
if ($field != 'indexes') {
if (is_string($value)) {
$type = $value;
$value = array('type' => $type);
}
$col = "\t\t'{$field}' => array('type'=>'" . $value['type'] . "', ";
switch ($value['type']) {
case 'float':
case 'integer':
$insert = 1;
break;
case 'binary':
case 'string':
$insert = "Lorem ipsum dolor sit amet";
if (!empty($value['length'])) {
$insert = substr($insert, 0, (int) $value['length'] - 2);
}
$insert = "'{$insert}'";
break;
case 'datetime':
$ts = date('Y-m-d H:i:s');
$insert = "'{$ts}'";
break;
case 'date':
$ts = date('Y-m-d');
$insert = "'{$ts}'";
break;
case 'time':
$ts = date('H:i:s');
$insert = "'{$ts}'";
break;
case 'boolean':
$insert = 1;
break;
case 'text':
$insert = "'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida,";
$insert .= "phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam,";
$insert .= "vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit,";
$insert .= "feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.'";
break;
}
$records[] = "\t\t'{$field}' => {$insert}";
unset($value['type']);
$col .= implode(', ', $schema->__values($value));
} else {
$col = "\t\t'indexes' => array(";
$props = array();
foreach ((array) $value as $key => $index) {
$props[] = "'{$key}' => array(" . implode(', ', $schema->__values($index)) . ")";
}
$col .= implode(', ', $props);
}
$col .= ")";
$cols[] = $col;
}
$out .= implode(",\n", $cols);
}
$out .= "\n\t);\n";
}
}
$records = implode(",\n", $records);
$out .= "\tvar \$records = array(array(\n{$records}\n\t));\n";
$out .= "}\n";
$path = TESTS . DS . 'fixtures' . DS;
if (isset($this->plugin)) {
$pluginPath = 'plugins' . DS . Inflector::underscore($this->plugin) . DS;
$path = APP . $pluginPath . 'tests' . DS . 'fixtures' . DS;
//.........这里部分代码省略.........
开发者ID:uuking,项目名称:wildflower,代码行数:101,代码来源:model.php
示例12: fixture
/**
* Builds the tests fixtures for the model and create the file
*
* @param string $model the name of the model
* @param string $useTable table name
* @return array $records, used in ModelTask::bakeTest() to create $expected
* @todo move this to a task
*/
function fixture($model, $useTable = null)
{
if (!class_exists('CakeSchema')) {
App::import('Model', 'Schema');
}
$out = "\nclass {$model}Fixture extends CakeTestFixture {\n";
$out .= "\tvar \$name = '{$model}';\n";
if (!$useTable) {
$useTable = Inflector::tableize($model);
} else {
$out .= "\tvar \$table = '{$useTable}';\n";
}
$schema = new CakeSchema();
$data = $schema->read(array('models' => false));
if (!isset($data['tables'][$useTable])) {
return false;
}
$tables[$model] = $data['tables'][$useTable];
foreach ($tables as $table => $fields) {
if (!is_numeric($table) && $table !== 'missing') {
$out .= "\tvar \$fields = array(\n";
$records = array();
if (is_array($fields)) {
$cols = array();
foreach ($fields as $field => $value) {
if ($field != 'indexes') {
if (is_string($value)) {
$type = $value;
$value = array('type' => $type);
}
$col = "\t\t\t'{$field}' => array('type'=>'" . $value['type'] . "', ";
switch ($value['type']) {
case 'integer':
$insert = 1;
break;
case 'string':
$insert = "Lorem ipsum dolor sit amet";
if (!empty($value['length'])) {
$insert = substr($insert, 0, (int) $value['length'] - 2);
}
$insert = "'{$insert}'";
break;
case 'datetime':
$ts = date('Y-m-d H:i:s');
$insert = "'{$ts}'";
break;
case 'date':
$ts = date('Y-m-d');
$insert = "'{$ts}'";
break;
case 'time':
$ts = date('H:i:s');
$insert = "'{$ts}'";
break;
case 'boolean':
$insert = 1;
break;
case 'text':
$insert = '\'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida,
phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam,
vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit,
feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.
Orci aliquet, in lorem et velit maecenas luctus, wisi nulla at, mauris nam ut a, lorem et et elit eu.
Sed dui facilisi, adipiscing mollis lacus congue integer, faucibus consectetuer eros amet sit sit,
magna dolor posuere. Placeat et, ac occaecat rutrum ante ut fusce. Sit velit sit porttitor non enim purus,
id semper consectetuer justo enim, nulla etiam quis justo condimentum vel, malesuada ligula arcu. Nisl neque,
ligula cras suscipit nunc eget, et tellus in varius urna odio est. Fuga urna dis metus euismod laoreet orci,
litora luctus suspendisse sed id luctus ut. Pede volutpat quam vitae, ut ornare wisi. Velit dis tincidunt,
pede vel eleifend nec curabitur dui pellentesque, volutpat taciti aliquet vivamus viverra, eget tellus ut
feugiat lacinia mauris sed, lacinia et felis.\'';
break;
}
$records[] = "\t\t\t'{$field}' => {$insert}";
unset($value['type']);
$col .= join(', ', $schema->__values($value));
} else {
$col = "\t\t\t'indexes' => array(";
$props = array();
foreach ((array) $value as $key => $index) {
$props[] = "'{$key}' => array(" . join(', ', $schema->__values($index)) . ")";
}
$col .= join(', ', $props);
}
$col .= ")";
$cols[] = $col;
}
$out .= join(",\n", $cols);
}
$out .= "\n\t\t\t);\n";
}
}
$records = join(",\n", $records);
//.........这里部分代码省略.........
开发者ID:subh,项目名称:raleigh-workshop-08,代码行数:101,代码来源:model.php
示例13: testCakeSchema
/**
* testCakeSchema method
*
* Test that schema generated postgresql queries are valid. ref #5696
* Check that the create statement for a schema generated table is the same as the original sql
*
* @return void
* @access public
*/
function testCakeSchema()
{
$db1 =& ConnectionManager::getDataSource('test_suite');
$db1->cacheSources = false;
$db1->reconnect(array('persistent' => false));
$db1->query('CREATE TABLE ' . $db1->fullTableName('datatypes') . ' (
id serial NOT NULL,
"varchar" character varying(40) NOT NULL,
"timestamp" timestamp without time zone,
date date,
CONSTRAINT test_suite_data_types_pkey PRIMARY KEY (id)
)');
$model =& ClassRegistry::init('datatypes');
$schema = new CakeSchema(array('connection' => 'test_suite'));
$result = $schema->read(array('connection' => 'test_suite'));
$schema->tables = $result['tables']['missing'];
$result = $db1->createSchema($schema, 'datatypes');
$this->assertNoPattern('/timestamp DEFAULT/', $result);
$this->assertPattern('/timestamp\\s*,/', $result);
$db1->query('DROP TABLE ' . $db1->fullTableName('datatypes'));
$db1->query($result);
$result2 = $schema->read(array('connection' => 'test_suite'));
$schema->tables = $result2['tables']['missing'];
$result2 = $db1->createSchema($schema, 'datatypes');
$this->assertEqual($result, $result2);
$db1->query('DROP TABLE ' . $db1->fullTableName('datatypes'));
}
开发者ID:jerzzz777,项目名称:cake-cart,代码行数:36,代码来源:dbo_postgres.test.php
示例14: testAlterIndexes
/**
* Test the alter index capabilities of postgres
*
* @access public
* @return void
*/
function testAlterIndexes()
{
$this->db->cacheSources = false;
$schema1 = new CakeSchema(array('name' => 'AlterTest1', 'connection' => 'test_suite', 'altertest' => array('id' => array('type' => 'integer', 'null' => false, 'default' => 0), 'name' => array('type' => 'string', 'null' => false, 'length' => 50), 'group1' => array('type' => 'integer', 'null' => true), 'group2' => array('type' => 'integer', 'null' => true))));
$this->db->query($this->db->createSchema($schema1));
$schema2 = new CakeSchema(array('name' => 'AlterTest2', 'connection' => 'test_suite', 'altertest' => array('id' => array('type' => 'integer', 'null' => false, 'default' => 0), 'name' => array('type' => 'string', 'null' => false, 'length' => 50), 'group1' => array('type' => 'integer', 'null' => true), 'group2' => array('type' => 'integer', 'null' => true), 'indexes' => array('name_idx' => array('column' => 'name', 'unique' => 0), 'group_idx' => array('column' => 'group1', 'unique' => 0), 'compound_idx' => array('column' => array('group1', 'group2'), 'unique' => 0), 'PRIMARY' => array('column' => 'id', 'unique' => 1)))));
$this->db->query($this->db->alterSchema($schema2->compare($schema1)));
$indexes = $this->db->index('altertest');
$this->assertEqual($schema2->tables['altertest']['indexes'], $indexes);
// Change three indexes, delete one and add another one
$schema3 = new CakeSchema(array('name' => 'AlterTest3', 'connection' => 'test_suite', 'altertest' => array('id' => array('type' => 'integer', 'null' => false, 'default' => 0), 'name' => array('type' => 'string', 'null' => false, 'length' => 50), 'group1' => array('type' => 'integer', 'null' => true), 'group2' => array('type' => 'integer', 'null' => true), 'indexes' => array('name_idx' => array('column' => 'name', 'unique' => 1), 'group_idx' => array('column' => 'group2', 'unique' => 0), 'compound_idx' => array('column' => array('group2', 'group1'), 'unique' => 0), 'another_idx' => array('column' => array('group1', 'name'), 'unique' => 0)))));
$this->db->query($this->db->alterSchema($schema3->compare($schema2)));
$indexes = $this->db->index('altertest');
$this->assertEqual($schema3->tables['altertest']['indexes'], $indexes);
// Compare us to ourself.
$this->assertEqual($schema3->compare($schema3), array());
// Drop the indexes
$this->db->query($this->db->alterSchema($schema1->compare($schema3)));
$indexes = $this->db->index('altertest');
$this->assertEqual(array(), $indexes);
$this->db->query($this->db->dropSchema($schema1));
}
开发者ID:evrard,项目名称:cakephp2x,代码行数:28,代码来源:dbo_postgres.test.php
示例15: build
/**
* Overwritten to change $this->path when it's been specifically given in the first parameter
* CakePHP has a problem where it would override the path if it's a plugin, without checking if it was specified
*/
public function build($data)
{
parent::build($data);
if (!empty($data['path'])) {
$this->path = $data['path'];
}
}
开发者ID:ayaou,项目名称:Zuha,代码行数:11,代码来源:ZuhaSchema.php
示例16: array
/**
* Update database with Schema object
* Should be called via the run method
*
* @access private
*/
function __update(&$Schema, $table = null)
{
$db = ConnectionManager::getDataSource($this->Schema->connection);
$this->out(__('Comparing Database to Schema...'));
$options = array();
if (isset($this->params['force'])) {
$options['models'] = false;
}
$Old = $this->Schema->read($options);
$compare = $this->Schema->compare($Old, $Schema);
$contents = array();
if (empty($table)) {
foreach ($compare as $table => $changes) {
$contents[$table] = $db->alterSchema(array($table => $changes), $table);
}
} elseif (isset($compare[$table])) {
$contents[$table] = $db->alterSchema(array($table => $compare[$table]), $table);
}
if (empty($contents)) {
$this->out(__('Schema is up to date.'));
$this->_stop();
}
$this->out("\n" . __('The following statements will run.'));
$this->out(array_map('trim', $contents));
if ('y' == $this->in(__('Are you sure you want to alter the tables?'), array('y', 'n'), 'n')) {
$this->out();
$this->out(__('Updating Database...'));
$this->__run($contents, 'update', $Schema);
}
$this->out(__('End update.'));
}
开发者ID:robotarmy,项目名称:Phog,代码行数:37,代码来源:schema.php
示例17:
/**
* Setup DataSource Object and get tables information
*
* @param string $datasouce
* @return bool
*/
function _setupDataSource($datasouce)
{
// get datasource
$this->DataSource =& ConnectionManager::getDataSource($datasouce);
if (!is_subclass_of($this->DataSource, 'DboSource')) {
// DataSource is not subclass of DboSource
return false;
}
// get datasouces tables
$schema = $this->Schema->read(array('connection' => $this->DataSource->configKeyName, 'models' => false));
$this->_tables = $schema['tables'];
return true;
}
开发者ID:nojimage,项目名称:sql_dumper,代码行数:19,代码来源:sql_dumper.php
示例18: __construct
public function __construct($options = array())
{
parent::__construct();
}
开发者ID:sunhk25,项目名称:Chats-Zuha-Cakephp-Plugin,代码行数:4,代码来源:schema.php
示例19: __construct
public function __construct($options = array())
{
parent::__construct();
$this->renames = array('contact_details' => array('contact_detail_type_id' => 'contact_detail_type'));
}
开发者ID:ayaou,项目名称:Zuha,代码行数:5,代码来源:schema.php
示例20: _generateSchema
/**
* Generates a string representation of a schema.
*
* @param array $tableInfo Table schema array
* @return string fields definitions
*/
protected function _generateSchema($tableInfo)
{
$schema = $this->_Schema->generateTable('f', $tableInfo);
return substr($schema, 10, -2);
}
开发者ID:kevguy,项目名称:Auth-Website,代码行数:11,代码来源:FixtureTask.php
注:本文中的CakeSchema类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论