Skip to content

Instantly share code, notes, and snippets.

View viccherubini's full-sized avatar
🚀
Zooming

Vic Cherubini viccherubini

🚀
Zooming
View GitHub Profile
<?php
declare(encoding='UTF-8');
namespace DataModelerTest;
require_once 'PHPUnit/Framework.php';
require_once 'TestCase.php';
$data_modeler_test_path = dirname(__FILE__);
$data_modeler_lib_path = $data_modeler_test_path . '/../';
<?php
function setUp() {
$pdo = new \PDO(DB_DSN, DB_USERNAME, DB_PASSWORD);
$sqlFile = DIRECTORY_DATA . 'SqlTest-' . DB_TYPE . '.sql';
if ( true === is_file($sqlFile) ) {
$sqlData = @file_get_contents($sqlFile);
$pdo->exec($sqlData);
}
DROP TABLE IF EXISTS products;
CREATE TABLE products (id INTEGER PRIMARY KEY, name TEXT, price REAL, sku TEXT);
INSERT INTO products VALUES (NULL, 'Product 1', 10.95, 'P1');
INSERT INTO products VALUES (NULL, 'Product 2', 18.95, 'P2');
INSERT INTO products VALUES (NULL, 'Product 3', 22.97, 'P3');
DROP TABLE IF EXISTS users;
CREATE TABLE users (id INTEGER PRIMARY KEY, username TEXT, password TEXT, age INTEGER, favorite_book TEXT);
INSERT INTO users VALUES(NULL, 'vcherubini', 'password1', 25, 'xUnit Test Patterns');
INSERT INTO users VALUES(NULL, 'bsaget', 'password2', 50, 'The Olsen Twins: A Legacy');
DROP TABLE products;
CREATE TABLE products (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, price FLOAT NOT NULL, sku VARCHAR(12) NOT NULL) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
INSERT INTO products VALUES (NULL, 'Product 1', 10.95, 'P1');
INSERT INTO products VALUES (NULL, 'Product 2', 18.95, 'P2');
INSERT INTO products VALUES (NULL, 'Product 3', 22.97, 'P3');
DROP TABLE users;
CREATE TABLE users (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, username VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, age INT NOT NULL, favorite_book VARCHAR(255) NOT NULL) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
INSERT INTO users VALUES(NULL, 'vcherubini', 'password1', 25, 'xUnit Test Patterns');
INSERT INTO users VALUES(NULL, 'bsaget', 'password2', 50, 'The Olsen Twins: A Legacy');
<?php
/**
* Return a single entity object.
*/
$statement = $pdo->prepare('SELECT * FROM product WHERE product_id = ?');
$objectifier->setEntity(new Product);
$product1 = $objectifier->fetch($statement, array(10));
$product2 = $objectifier->fetch($statement, array(11));
<?php
declare(encoding='UTF-8');
use \Jolt\Router,
\Jolt\Route\Named\NamedGet,
\Jolt\Route\Named\NamedPost,
\Jolt\Dispatcher,
\Jolt\Client,
\Jolt\Jolt;
<?php
declare(encoding='UTF-8');
use \Jolt\Client,
\Jolt\Configuration,
\Jolt\Dispatcher,
\Jolt\Jolt,
\Jole\Route,
\Jolt\Route\Named\NamedGet,
#!/bin/bash
cd ~/daily-log
echo `date` >> daily-log.txt
echo $1 >> daily-log.txt
echo "================================================================================" >> daily-log.txt
git ci -am "New log entry."
<?php
function array_value($key, $search, $default=NULL, $callback=NULL) {
$value = $default;
if ( array_key_exists($key, $search) ) {
$value = $search[$key];
$value = ( function_exists($callback) ? $callback($value) : $value);
}
<?php // content="text/plain; charset=utf-8"
require_once ('jpgraph/jpgraph.php');
require_once ('jpgraph/jpgraph_line.php');
$data1 = array(
'2010-06-15' => 10454,
'2010-06-16' => 12321,
'2010-06-17' => 8956,
'2010-06-18' => 2365,
'2010-06-19' => 7854,