12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970 |
- <?php
- /**
- * This file is part of webman.
- *
- * Licensed under The MIT License
- * For full copyright and license information, please see the MIT-LICENSE.txt
- * Redistributions of files must retain the above copyright notice.
- *
- * @author walkor<[email protected]>
- * @copyright walkor<[email protected]>
- * @link http://www.workerman.net/
- * @license http://www.opensource.org/licenses/mit-license.php MIT License
- */
- namespace support\bootstrap\db;
- use Webman\Bootstrap;
- use Workerman\Worker;
- use PDOStatement;
- use PDO;
- /**
- * Class Raw
- * @package support\bootstrap\db
- */
- class Raw implements Bootstrap
- {
- /**
- * @var \PDO
- */
- public static $pdo;
- /**
- * @var PDOStatement
- */
- public static $statement;
- /**
- * @var PDOStatement
- */
- public static $fortune;
- /**
- * @var PDOStatement
- */
- public static $random;
- /**
- * @var PDOStatement
- */
- public static $update;
- /**
- * @param Worker $worker
- *
- * @return void
- */
- public static function start($worker)
- {
- $pdo = new PDO('pgsql:host=tfb-database;dbname=hello_world',
- 'benchmarkdbuser', 'benchmarkdbpass',
- [PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
- PDO::ATTR_EMULATE_PREPARES => false]
- );
- self::$statement = $pdo->prepare('SELECT id,randomNumber FROM World WHERE id=?');
- self::$fortune = $pdo->prepare('SELECT id,message FROM Fortune');
- self::$random = $pdo->prepare('SELECT id,randomNumber FROM World WHERE id=?');
- self::$update = $pdo->prepare('UPDATE World SET randomNumber=? WHERE id=?');
- self::$pdo = $pdo;
- }
- }
|