function setUp() { DB::openConnection(Config::instance()->TEST_DB_NAME, "localhost", Config::instance()->TEST_DB_USERNAME, Config::instance()->TEST_DB_PASSWORD, false); $sql = DB::newDirectSql("CREATE TABLE simple3_table(\n id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id),\n nome VARCHAR(255),\n livello INT,\n properties TEXT);"); $sql->exec(); ActiveRecord::init("Simple3"); }
public function setUp() { DB::openConnection(Config::instance()->TEST_DB_NAME, "localhost", Config::instance()->TEST_DB_USERNAME, Config::instance()->TEST_DB_PASSWORD, false); $this->__dropTable(); $this->__createTable(); $this->__loadData(1, "Marco", 2); $this->__loadData(2, "Federico", 5); }
private function initializeDatabase() { $db_name = Config::instance()->{IDBConfigKeys::DEFAULT_DB_NAME}; $db_hostname = Config::instance()->{IDBConfigKeys::DEFAULT_DB_HOSTNAME}; $db_username = Config::instance()->{IDBConfigKeys::DEFAULT_DB_USERNAME}; $db_password = Config::instance()->{IDBConfigKeys::DEFAULT_DB_PASSWORD}; $db_persistent_connection = Config::instance()->{IDBConfigKeys::DEFAULT_DB_PERSISTENT_CONNECTION}; DB::openConnection($db_name, $db_hostname, $db_username, $db_password, $db_persistent_connection); }
function setUp() { DB::openConnection(Config::instance()->TEST_DB_NAME, "localhost", Config::instance()->TEST_DB_USERNAME, Config::instance()->TEST_DB_PASSWORD, false); $sql1 = DB::newDirectSql("CREATE TABLE test_tab_dipinti(\n id_dipinto INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id_dipinto),\n nome VARCHAR(255),\n id_autore INT NOT NULL,\n periodo INT NOT NULL,\n properties TEXT NOT NULL);"); $sql1->exec(); $sql2 = DB::newDirectSql("CREATE TABLE test_tab_colori_dipinto(\n id_colore_dipinto INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id_colore_dipinto),\n id_dipinto INT NOT NULL,\n id_colore INT NOT NULL);"); $sql2->exec(); $sql3 = DB::newDirectSql("CREATE TABLE test_tab_colori(\n id_colore INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id_colore),\n nome INT NOT NULL,\n rgb VARCHAR(6) NOT NULL);"); $sql3->exec(); $sql4 = DB::newDirectSql("CREATE TABLE test_tab_autori(\n id_autore INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id_autore),\n nome VARCHAR(64) NOT NULL,\n cognome VARCHAR(64) NOT NULL,\n stile VARCHAR(32));"); $sql4->exec(); ActiveRecord::init("TestDipinto"); ActiveRecord::init("TestAutore"); ActiveRecord::init("TestColore"); ActiveRecord::init("TestColoreDipinto"); }
function setUp() { DB::openConnection(Config::instance()->TEST_DB_NAME, "localhost", Config::instance()->TEST_DB_USERNAME, Config::instance()->TEST_DB_PASSWORD, false); }
public function setUp() { DB::openConnection(Config::instance()->TEST_DB_NAME, "localhost", Config::instance()->TEST_DB_USERNAME, Config::instance()->TEST_DB_PASSWORD, false); ActiveRecord::init("SimpleBis"); }
function setUp() { DB::openConnection(Config::instance()->TEST_DB_NAME, "localhost", Config::instance()->TEST_DB_USERNAME, Config::instance()->TEST_DB_PASSWORD, false); DB::newDirectSql($this->setup_sql)->exec(); }
<?php define('HOST_NAME', $_SERVER['HTTP_HOST']); header('Content-Type: application/json'); require 'vendor/autoload.php'; require_once 'lib/Db.class.php'; $app = new Slim\App(); $app->get('/', function () { var_dump($_SERVER); DB::openConnection(); }); $app->group('/app', function () use($app) { $app->get('/hello/{name}', function ($request, $response, $args) { $response->write("Hello, " . $args['name']); return $response; }); $app->group('/user', function () use($app) { $app->post('/login/', function () { var_dump('OK'); }); }); }); $app->run();