fuelphp / database
FuelPHP Database Component
Installs: 1 363
Dependents: 1
Suggesters: 0
Security: 0
Stars: 12
Watchers: 8
Forks: 7
Open Issues: 0
Requires
- doctrine/dbal: 2.4.*
- psr/log: 1.0.*
Requires (Dev)
- codeception/codeception: 2.0
- codeception/mockery-module: dev-master
This package is auto-updated.
Last update: 2023-01-30 20:24:31 UTC
README
Database abstraction layer for FuelPHP
Sample code until examples can be constructed
<?php include 'vendor/autoload.php'; use Fuel\Database\DB; class Dummy { public $_constructed = false; public $_before = array(); public $_after = array(); public $_arguments = array(); public function __construct() { $this->_constructed = true; $this->_arguments = func_get_args(); } public function __set($key, $value) { if ($this->_constructed) { $this->_after[$key] = $value; } else { $this->_before[$key] = $value; } } }; $connection = DB::connection(array( 'driver' => 'mysql', 'username' => 'root', 'password' => 'root', 'database' => 'ku_cms', 'persistant' => false, )); $select = $connection->select(DB::when('thing')->is(1, 2)->is(3, 4)) ->from('table') ->where('a', 'b') ->orWhere('b', 1) ->having('a', 2) ->orNotHaving('a', 1) ->getQuery(); die($select); die($connection->select('*') ->from('users') ->where(function($where){ $where->where('this', 'that') ->orWhere('sus', DB::value('zo')); }) ->andWhere('what', array('some', 'vals')) ->where('time', '<', DB::command('now')) ->getQuery()); $schema = $connection->getSchema(); //print_r($schema->tableDetails('some_table')); print_r($schema->createTable('new_table', function($table) { $table->integer('id')->increment(); $table->string('name', 250)->null(); $table->string('surname', 250)->null(); $table->string('email', 250)->nullable()->unique(); $table->engine('MyISAM'); $table->unique(array( 'name', 'surname', ), 'full_name'); })); print_r($schema->alterTable('some_table', function($table) { $table->string('something', 20); $table->boolean('boelala', true); $table->string('lala', 20)->default('wow'); $table->change('uid')->default(11); $table->drop('uid'); $table->rename('name', 'other_name'); })); print_r($schema->dropTable('some_table')); // $platform = $doctrineSchema->getDatabasePlatform(); // $schema = $doctrineSchema->createSchema(); // $table = $schema->getTable('some_table'); // $newSchema = clone $schema; // $new = $newSchema->getTable('some_table'); // $new->addColumn('new_column', 'string', array('length' => 12)); // $comp = new \Doctrine\DBAL\Schema\Comparator(); // $diff = $comp->compare($schema, $newSchema); // print_r(get_class_methods($diff)); // //$diff = $comp->compare($newSchema, $schema); // print_r($diff->toSql($platform)); // die(); // foreach($doctrineSchema->listTableColumns('some_table') as $column) // { // $s = serialize($column); // echo $s; // $u = unserialize($s); // echo $u->getName(); // } die(); $schema->dropTable('some_table', true); $schema->createTable('some_table', function($table) { $table->varchar('name', 20) ->nullable() ->comment('A comment is places') ->default('This value') ->charset('utf8_unicode_ci'); $table->integer('id', 11)->increment(); $table->integer('uid', 11)->default(12); }); $schema = $connection->getSchema(); var_dump($schema->listFields('some_table')); die(); //print_r($connection->lastQuery()); $connection->insert('some_table')->values(array( 'name' => 'One', ))->execute(); $object = new stdClass; $connection->select() ->from('some_table') ->fetchInto($object) ->execute(); print_r($object); die(); $connection->insert('menu') ->values(array('position' => 2)) ->execute(); $connection->update('menu') ->set('position', 3) ->where('position', 2) ->execute(); $result = $connection->select() ->from('menu') ->asObject('Dummy') ->orderBy('id', 'desc') ->lateProperties() ->withArguments(array('woo' => 22)) ->execute(); $connection->delete('menu') ->whereArray(array( 'position' => array('!=', '?'), 'id' => array('!=', '?') )) ->execute(array( 1, 1 )); print_r($connection->lastQuery());