PHP fDatabase::execute Examples

Example #1

File: fORMOrderingTest.php Project: nurulimamnotes/flourish-old

 public static function setUpBeforeClass()
 {
     if (defined('SKIPPING')) {
         return;
     }
     $db = new fDatabase(DB_TYPE, DB, DB_USERNAME, DB_PASSWORD, DB_HOST, DB_PORT);
     if (DB_TYPE == 'sqlite') {
         $db->execute(file_get_contents(DB_SETUP_FILE));
         $db->execute(file_get_contents(DB_EXTENDED_SETUP_FILE));
     }
     $db->execute(file_get_contents(DB_POPULATE_FILE));
     $db->execute(file_get_contents(DB_EXTENDED_POPULATE_FILE));
     self::$db = $db;
     self::$schema = new fSchema($db);
     fORMDatabase::attach(self::$db);
     fORMSchema::attach(self::$schema);
     fORMOrdering::configureOrderingColumn('TopAlbum', 'position');
     fORMOrdering::configureOrderingColumn('FavoriteAlbum', 'position');
     fORMOrdering::configureOrderingColumn('YearFavoriteAlbum', 'position');
     if (defined('MAP_TABLES')) {
         fORM::mapClassToTable('User', 'user');
         fORM::mapClassToTable('Group', 'group');
         fORM::mapClassToTable('Artist', 'popular_artists');
         fORM::mapClassToTable('Album', 'records');
     }
 }

Example #2

File: fSchemaWithMultipleSchemasTest.php Project: philip/flourish

 protected function setUp()
 {
     if (defined('SKIPPING')) {
         return;
     }
     $db = new fDatabase(DB_TYPE, DB, DB_USERNAME, DB_PASSWORD, DB_HOST, DB_PORT);
     $db->execute(file_get_contents(DB_SETUP_FILE));
     $db->execute(fix_schema(file_get_contents(DB_ALTERNATE_SCHEMA_SETUP_FILE)));
     $this->sharedFixture = array('db' => $db, 'schema' => fJSON::decode(fix_schema(file_get_contents(DB_ALTERNATE_SCHEMA_SCHEMA_FILE)), TRUE));
 }

Example #3

File: fORMValidationTest.php Project: netcarver/flourish

 public static function setUpBeforeClass()
 {
     if (defined('SKIPPING')) {
         return;
     }
     $db = new fDatabase(DB_TYPE, DB, DB_USERNAME, DB_PASSWORD, DB_HOST, DB_PORT);
     $db->execute(file_get_contents(DB_SETUP_FILE));
     $db->execute(file_get_contents(DB_EXTENDED_SETUP_FILE));
     self::$db = $db;
     self::$schema = new fSchema($db);
 }

Example #4

File: fActiveRecordTest.php Project: philip/flourish

 protected function setUp()
 {
     if (defined('SKIPPING')) {
         return;
     }
     $db = new fDatabase(DB_TYPE, DB, DB_USERNAME, DB_PASSWORD, DB_HOST, DB_PORT);
     $db->execute(file_get_contents(DB_SETUP_FILE));
     $db->execute(file_get_contents(DB_EXTENDED_SETUP_FILE));
     $schema = new fSchema($db);
     $this->sharedFixture = array('db' => $db, 'schema' => $schema);
 }

Example #5

File: fRecordSetTest.php Project: philip/flourish

 protected function setUp()
 {
     if (defined('SKIPPING')) {
         return;
     }
     $db = new fDatabase(DB_TYPE, DB, DB_USERNAME, DB_PASSWORD, DB_HOST, DB_PORT);
     $db->execute(file_get_contents(DB_SETUP_FILE));
     $db->execute(file_get_contents(DB_EXTENDED_SETUP_FILE));
     fORMDatabase::attach($db);
     $this->sharedFixture = $db;
 }

Example #6

File: fSchemaWithMultipleSchemasTest.php Project: netcarver/flourish

 public static function setUpBeforeClass()
 {
     if (defined('SKIPPING')) {
         return;
     }
     $db = new fDatabase(DB_TYPE, DB, DB_USERNAME, DB_PASSWORD, DB_HOST, DB_PORT);
     $db->execute(file_get_contents(DB_SETUP_FILE));
     $db->execute(fix_schema(file_get_contents(DB_ALTERNATE_SCHEMA_SETUP_FILE)));
     self::$db = $db;
     self::$schema = fJSON::decode(fix_schema(file_get_contents(DB_ALTERNATE_SCHEMA_SCHEMA_FILE)), TRUE);
 }

Example #7

File: fSQLTranslationTest.php Project: nurulimamnotes/flourish-old

 public static function setUpBeforeClass()
 {
     if (defined('SKIPPING')) {
         return;
     }
     $db = new fDatabase(DB_TYPE, DB, DB_USERNAME, DB_PASSWORD, DB_HOST, DB_PORT);
     if (DB_TYPE == 'sqlite') {
         $db->execute(file_get_contents(DB_SETUP_FILE));
     }
     $db->execute(file_get_contents(DB_POPULATE_FILE));
     self::$db = $db;
 }

Example #8

File: fSQLSchemaTranslationTest.php Project: nurulimamnotes/flourish-old

 public static function setUpBeforeClass()
 {
     if (defined('SKIPPING')) {
         return;
     }
     $db = new fDatabase(DB_TYPE, DB, DB_USERNAME, DB_PASSWORD, DB_HOST, DB_PORT);
     if (DB_TYPE == 'sqlite') {
         $db->execute(file_get_contents(DB_SETUP_FILE));
         $db->execute(file_get_contents(DB_EXTENDED_SETUP_FILE));
     }
     $db->execute(file_get_contents(DB_POPULATE_FILE));
     self::$db = $db;
     self::$json_schema = fJSON::decode(file_get_contents(DB_SCHEMA_FILE), TRUE);
 }

Example #9

File: fRecordSetWithMultipleSchemasTest.php Project: philip/flourish

 protected function setUp()
 {
     if (defined('SKIPPING')) {
         return;
     }
     $db = new fDatabase(DB_TYPE, DB, DB_USERNAME, DB_PASSWORD, DB_HOST, DB_PORT);
     $db->execute(file_get_contents(DB_SETUP_FILE));
     $db->execute(file_get_contents(DB_EXTENDED_SETUP_FILE));
     $db->execute(fix_schema(file_get_contents(DB_ALTERNATE_SCHEMA_SETUP_FILE)));
     $db->clearCache();
     fORMDatabase::attach($db);
     $this->sharedFixture = $db;
     fORM::mapClassToTable('Flourish2User', fix_schema('flourish2.users'));
     fORM::mapClassToTable('Flourish2Group', fix_schema('flourish2.groups'));
     fORM::mapClassToTable('Flourish2Artist', fix_schema('flourish2.artists'));
     fORM::mapClassToTable('Flourish2Album', fix_schema('flourish2.albums'));
 }

Example #10

File: fRecordSetWithMultipleDatabasesTest.php Project: nurulimamnotes/flourish-old

 public static function setUpBeforeClass()
 {
     if (defined('SKIPPING')) {
         return;
     }
     $db = new fDatabase(DB_TYPE, DB, DB_USERNAME, DB_PASSWORD, DB_HOST, DB_PORT);
     if (DB_TYPE == 'sqlite') {
         $db->execute(file_get_contents(DB_SETUP_FILE));
     }
     $db->execute(file_get_contents(DB_POPULATE_FILE));
     $db2 = new fDatabase(DB_TYPE, DB_2, DB_2_USERNAME, DB_2_PASSWORD, DB_2_HOST, DB_2_PORT);
     if (DB_TYPE == 'sqlite') {
         $db2->execute(file_get_contents(DB_2_SETUP_FILE));
     }
     $db2->execute(file_get_contents(DB_2_POPULATE_FILE));
     self::$db = $db;
     self::$db2 = $db2;
     fORMDatabase::attach($db);
     fORMDatabase::attach($db2, 'db2');
     fORM::mapClassToTable('Db2User', 'users');
     fORM::mapClassToDatabase('Db2User', 'db2');
     fORM::mapClassToTable('Db2Group', 'groups');
     fORM::mapClassToDatabase('Db2Group', 'db2');
 }

Example #11

File: fRecordSetWithMultipleDatabasesTest.php Project: philip/flourish

 protected function setUp()
 {
     if (defined('SKIPPING')) {
         return;
     }
     $db = new fDatabase(DB_TYPE, DB, DB_USERNAME, DB_PASSWORD, DB_HOST, DB_PORT);
     $db->execute(file_get_contents(DB_SETUP_FILE));
     $db2 = new fDatabase(DB_TYPE, DB_2, DB_2_USERNAME, DB_2_PASSWORD, DB_2_HOST, DB_2_PORT);
     $db2->execute(file_get_contents(DB_2_SETUP_FILE));
     $this->sharedFixture = array($db, $db2);
     fORMDatabase::attach($db);
     fORMDatabase::attach($db2, 'db2');
     fORM::mapClassToTable('Db2User', 'users');
     fORM::mapClassToDatabase('Db2User', 'db2');
     fORM::mapClassToTable('Db2Group', 'groups');
     fORM::mapClassToDatabase('Db2Group', 'db2');
 }

Example #12

File: fRecordSetWithMultipleSchemasTest.php Project: nurulimamnotes/flourish-old

 public static function setUpBeforeClass()
 {
     if (defined('SKIPPING')) {
         return;
     }
     $db = new fDatabase(DB_TYPE, DB, DB_USERNAME, DB_PASSWORD, DB_HOST, DB_PORT);
     if (DB_TYPE == 'sqlite') {
         $db->execute(file_get_contents(DB_SETUP_FILE));
         $db->execute(file_get_contents(DB_EXTENDED_SETUP_FILE));
         $db->execute(fix_schema(file_get_contents(DB_ALTERNATE_SCHEMA_SETUP_FILE)));
     }
     $db->execute(file_get_contents(DB_POPULATE_FILE));
     $db->execute(file_get_contents(DB_EXTENDED_POPULATE_FILE));
     $db->execute(fix_schema(file_get_contents(DB_ALTERNATE_SCHEMA_POPULATE_FILE)));
     $db->clearCache();
     fORMDatabase::attach($db);
     self::$db = $db;
     fORM::mapClassToTable('Flourish2User', fix_schema('flourish2.users'));
     fORM::mapClassToTable('Flourish2Group', fix_schema('flourish2.groups'));
     fORM::mapClassToTable('Flourish2Artist', fix_schema('flourish2.artists'));
     fORM::mapClassToTable('Flourish2Album', fix_schema('flourish2.albums'));
 }

Example #13

File: bootstrap.php Project: mblarsen/ffixture

/**
 * Prepares classes and database for tests.
 */
// Some basics
date_default_timezone_set('Europe/Copenhagen');
define("FIXTURES_ROOT", dirname(__FILE__) . '/fixtures/');
include dirname(__FILE__) . '/flourish/fLoader.php';
fLoader::best();
// Include fFixture
include dirname(__FILE__) . '/../fFixture.php';
include dirname(__FILE__) . '/../fFixtureSeed.php';
// Emtpy database
$db = new fDatabase('sqlite', dirname(__FILE__) . '/test.db');
$db_setup_file = new fFile(dirname(__FILE__) . '/bootstrap.sql');
define("RESET_DATABASE_SQL", $db_setup_file->read());
$db->execute(RESET_DATABASE_SQL);
// Setup ORM
fORMDatabase::attach($db);
// Pretend implementations of fActiveRecord
class Category extends fActiveRecord
{
}
class Product extends fActiveRecord
{
}
class Shop extends fActiveRecord
{
}
class User extends fActiveRecord
{
}