| 
<?phpnamespace eMapper\SQLite;
 
 use Acme\Type\RGBColorTypeHandler;
 use eMapper\SQL\Statement;
 use eMapper\Engine\SQLite\SQLiteDriver;
 use eMapper\Mapper;
 
 abstract class SQLiteTest extends \PHPUnit_Framework_TestCase {
 public static $env_config = ['environment.id' => 'default', 'environment.class' => 'eMapper\Dynamic\Environment\DynamicSQLEnvironment'];
 
 public static $filename;
 public static $conn;
 public static $driver;
 public static $mapper;
 public static $blob;
 
 public static function setUpBeforeClass() {
 self::$filename = __DIR__ . '/testing.db';
 self::$conn = new \SQLite3(self::$filename);
 self::$driver = new SQLiteDriver(self::$filename);
 self::$mapper = new Mapper(self::$driver);
 self::$mapper->addType('Acme\RGBColor', new RGBColorTypeHandler(), 'color');
 self::$mapper->addStatement(new Statement('getProduct', "SELECT * FROM products WHERE product_id = #{productId}"));
 self::$mapper->addStatement(new Statement('getUser', "SELECT * FROM users WHERE user_id = %{int}", Statement::type('array')));
 
 self::$blob = file_get_contents(__DIR__ . '/../avatar.gif');
 }
 
 public static function tearDownAfterClass() {
 self::$conn->close();
 self::$mapper->close();
 }
 }
 ?>
 |