Online PHP editor | perf for mULe0

<?php /*-------------------------------------------------------- クラス --------------------------------------------------------*/ // fetch, fetchAll で実行される abstract class DataModel { const BOOLEAN = 'boolean' , INTEGER = 'integer' , DOUBLE = 'double' , FLOAT = 'double' , STRING = 'string' , DATETIME = 'dateTime'; const BIND_TYPE = array( 'boolean' => PDO::PARAM_BOOL, 'integer' => PDO::PARAM_INT, 'double' => PDO::PARAM_STR, 'string' => PDO::PARAM_STR, 'dateTime' => PDO::PARAM_STR, ); protected array $data = array(); // 拡張クラスで宣言される protected static string $primaryKeyName; protected static array $omit = array(); protected static array $schema = array(); function __get($prop) { if (property_exists($this, $prop)) { return static::$$prop; } elseif (isset($this->data[$prop])) { return $this->data[$prop]; } elseif (isset(static::$schema[$prop])) { return null; } else { throw new InvalidArgumentException($prop . 'は存在しません'); } } function __isset($prop) { return isset($this->data[$prop]); } /** * @throws Exception */ function __set($prop, $val) { if (!isset(static::$schema[$prop])) { throw new InvalidArgumentException($prop . 'はセットできません'); } $schema = static::$schema[$prop]; if ($schema === static::DATETIME) { if ($val instanceof DateTime) { $this->data[$prop] = $val; } else { $this->data[$prop] = new DateTime($val); } return $this->data[$prop]; } else { return match ($schema) { static::BOOLEAN => $this->data[$prop] = (bool)$val, static::INTEGER => $this->data[$prop] = (int)$val, static::DOUBLE => $this->data[$prop] = (double)$val, default => $this->data[$prop] = (string)$val, }; } } function toArray(): array { return $this->data; } /** * @throws Exception */ function fromArray(array $arr): void { foreach ($arr as $key => $val) { $this->__set($key, $val); } } abstract function isValid(string $save_type); // TIMESTAMP のオブジェクトを探し DATETIME の値に変換する public function convertTimestampToDatetime(){ $result = $this; $data = []; foreach ($this->data as $key => $value) { if ($value instanceof DateTime) { $data[$key] = $value->format('Y-m-d H:i:s'); } else { $data[$key] = $value; } } $result->data = $data; return $result; } } abstract class DataMapper { const MODEL_CLASS = ''; const TABLE_NAME = ''; protected PDO $pdo; function __construct() { // 拡張クラスで宣言される値を確認 if (!class_exists(static::MODEL_CLASS)) { throw new InvalidArgumentException('MODEL_CLASSが存在しません'); } assert(!empty(static::TABLE_NAME), 'TABLE_NAMEが存在しません'); // pdo if (empty($pdo)) { $pdo = new PDO ('mysql:host=host.docker.internal;dbname=test', 'test', 'pass'); } $this->pdo = $pdo; } protected function decorate(PDOStatement $stmt) { $stmt->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, static::MODEL_CLASS); return $stmt; } public function insert(DataModel $data, array $omit = []) { // isValid $valided = $data->isValid('insert'); if ($valided !== true) { throw new InvalidArgumentException($valided.'の値が不正です'); } $schema = $data->schema; $pk = $data->primaryKeyName; $omitCols = array_merge($omit, $data->omit); $cols = array_diff(array_keys($schema), array_merge(array($pk), $omitCols)); $colsClause = implode(',', $cols); $valsClause = rtrim(str_repeat('?,', count($cols)), ','); $sql = 'INSERT INTO ' . static::TABLE_NAME . ' (' . $colsClause . ')' . ' VALUES(' . $valsClause . ')'; echo '<h4>【$sql】</h4>'; var_dump($sql); $sth = $this->pdo->prepare($sql); $this->decorate($sth); $n = 1; foreach($cols as $col) { $val = $data->$col; $schemaType = $schema[$col]; if ($schemaType == DataModel::DATETIME) { /** @var DateTime $val */ $val = $val->format('Y-m-d H:i:s'); } $sth->bindValue($n++, $val, DataModel::BIND_TYPE[$schemaType]); } $sth->execute(); $data->$pk = $this->pdo->lastInsertId(); // var_dump($omitCols); // 'author' を含んでいる foreach($omitCols as $omitCol) { unset($data->$omitCol); // 削除されない } } } class Entry extends DataModel { protected static string $primaryKeyName = 'entryId'; protected static array $omit = array('created_at', 'updated_at'); // CREATE TABLE でのデフォ値を使用 protected static array $schema = array( 'entryId' => parent::INTEGER , 'author' => parent::STRING , 'title' => parent::STRING , 'content' => parent::STRING , 'published' => parent::DATETIME ); function isValid(string $save_type) { // authorは100文字まで、insertで必須 $val = $this->author; if ( ($save_type === 'insert' && empty($val)) || (!mb_check_encoding($val) || mb_strlen($val) > 100) ) { return 'author'; } // titleは100文字まで、必須 $val = $this->title; if (empty($val) || !mb_check_encoding($val) || mb_strlen($val) > 100) { return 'title'; } // contentは10000字まで、必須 $val = $this->content; if (empty($val) || !mb_check_encoding($val) || mb_strlen($val) > 10000) { return 'content'; } // publishedは型があっていれば問題ない $val = $this->published; if (empty($val)) { return 'published'; } return true; } } class EntryMapper extends DataMapper { const MODEL_CLASS = 'Entry'; const TABLE_NAME = 'entries'; } /*-------------------------------------------------------- 実行 --------------------------------------------------------*/ $entry = new Entry(); $entryMapper = new EntryMapper(); $new_info = [ 'author' => '太郎', 'title' => '今日の天気', 'content' => '雨です', 'published' => new DateTime ]; $entry->fromArray($new_info); $entryMapper->insert($entry, ['author']); echo '<h4>【$entry】</h4>'; var_export($entry); echo '<h4>【$entryArr】</h4>'; $entryArr = $entry->convertTimestampToDatetime()->toArray(); var_export($entryArr);

Version	System time (s)	User time (s)	Memory (MiB)
8.5.1	0.011	0.006	19.68
8.5.0	0.014	0.008	20.14
8.4.15	0.002	0.000	14.05
8.4.14	0.014	0.007	17.89
8.4.13	0.010	0.011	17.80
8.4.12	0.009	0.012	24.27
8.4.11	0.004	0.005	18.80
8.4.10	0.016	0.007	19.06
8.4.9	0.009	0.012	20.67
8.4.8	0.012	0.007	17.97
8.4.7	0.008	0.006	17.95
8.4.6	0.013	0.006	20.49
8.4.5	0.011	0.012	17.98
8.4.4	0.013	0.007	20.74
8.4.3	0.010	0.010	22.29
8.4.2	0.004	0.004	18.12
8.4.1	0.013	0.007	22.27
8.3.28	0.012	0.008	18.65
8.3.27	0.011	0.009	16.54
8.3.26	0.010	0.006	16.54
8.3.25	0.013	0.007	16.69
8.3.24	0.009	0.010	17.32
8.3.23	0.014	0.005	18.43
8.3.22	0.012	0.008	19.17
8.3.21	0.011	0.004	16.99
8.3.20	0.003	0.006	16.69
8.3.19	0.014	0.005	17.34
8.3.18	0.006	0.002	18.16
8.3.17	0.012	0.003	18.93
8.3.16	0.007	0.013	16.82
8.3.15	0.004	0.004	16.85
8.3.14	0.009	0.009	18.89
8.3.13	0.000	0.008	18.35
8.3.12	0.004	0.004	19.24
8.3.11	0.008	0.000	20.94
8.3.10	0.008	0.000	24.06
8.3.9	0.008	0.000	26.77
8.3.8	0.006	0.003	17.97
8.3.7	0.012	0.004	16.50
8.3.6	0.004	0.011	16.61
8.3.5	0.009	0.012	18.48
8.3.4	0.011	0.004	20.25
8.3.3	0.013	0.003	18.76
8.3.2	0.008	0.000	24.18
8.3.1	0.003	0.005	24.66
8.3.0	0.003	0.005	26.16
8.2.29	0.009	0.007	20.72
8.2.28	0.007	0.002	18.51
8.2.27	0.013	0.009	17.46
8.2.26	0.009	0.000	18.48
8.2.25	0.006	0.003	18.68
8.2.24	0.004	0.004	18.84
8.2.23	0.003	0.006	22.58
8.2.22	0.003	0.005	37.54
8.2.21	0.009	0.006	26.77
8.2.20	0.007	0.003	18.42
8.2.19	0.014	0.007	16.88
8.2.18	0.007	0.013	16.88
8.2.17	0.011	0.007	19.06
8.2.16	0.007	0.007	22.96
8.2.15	0.008	0.000	25.66
8.2.14	0.004	0.004	24.66
8.2.13	0.004	0.004	26.16
8.2.12	0.004	0.004	19.77
8.2.11	0.010	0.000	20.89
8.2.10	0.006	0.006	18.16
8.2.9	0.000	0.009	18.00
8.2.8	0.004	0.004	19.03
8.2.7	0.004	0.004	17.75
8.2.6	0.020	0.000	17.46
8.2.5	0.007	0.011	17.11
8.2.4	0.013	0.003	17.75
8.2.3	0.013	0.003	17.50
8.2.2	0.005	0.005	17.63
8.2.1	0.008	0.008	17.50
8.2.0	0.008	0.008	17.63
8.1.33	0.011	0.010	22.04
8.1.32	0.014	0.007	16.53
8.1.31	0.011	0.004	18.41
8.1.30	0.005	0.003	18.04
8.1.29	0.006	0.003	30.84
8.1.28	0.016	0.000	25.92
8.1.27	0.014	0.004	24.66
8.1.26	0.004	0.004	26.35
8.1.25	0.004	0.004	28.09
8.1.24	0.006	0.003	22.13
8.1.23	0.008	0.004	21.10
8.1.22	0.003	0.005	18.60
8.1.21	0.009	0.000	18.77
8.1.20	0.000	0.009	17.38
8.1.19	0.009	0.000	17.47
8.1.18	0.014	0.003	17.25
8.1.17	0.012	0.005	17.25
8.1.16	0.014	0.003	17.13
8.1.15	0.003	0.014	17.13
8.1.14	0.000	0.011	17.47
8.1.13	0.013	0.004	17.22
8.1.12	0.012	0.006	17.13
8.1.11	0.006	0.013	17.00
8.1.10	0.007	0.011	17.46
8.1.9	0.011	0.005	17.38
8.1.8	0.013	0.004	17.11
8.1.7	0.008	0.008	17.38
8.1.6	0.009	0.009	17.63
8.1.5	0.010	0.007	17.34
8.1.4	0.010	0.008	17.50
8.1.3	0.014	0.003	17.63
8.1.2	0.018	0.000	17.38
8.1.1	0.011	0.008	17.47
8.1.0	0.017	0.000	17.25
8.0.30	0.003	0.007	19.93
8.0.29	0.000	0.008	16.88
8.0.28	0.012	0.005	16.75
8.0.27	0.014	0.003	16.52
8.0.26	0.012	0.004	16.63
8.0.25	0.010	0.007	16.75
8.0.24	0.012	0.006	16.87
8.0.23	0.014	0.004	16.88
8.0.22	0.017	0.003	16.52
8.0.21	0.010	0.007	16.88
8.0.20	0.009	0.009	16.61
8.0.19	0.008	0.008	16.63
8.0.18	0.017	0.000	16.75
8.0.17	0.017	0.000	16.63
8.0.16	0.016	0.000	16.63
8.0.15	0.017	0.000	16.52
8.0.14	0.008	0.008	16.63
8.0.13	0.015	0.003	16.88
8.0.12	0.010	0.007	16.63
8.0.11	0.010	0.007	16.75
8.0.10	0.006	0.010	16.63
8.0.9	0.006	0.012	16.88
8.0.8	0.008	0.008	16.88
8.0.7	0.009	0.009	16.88
8.0.6	0.017	0.000	16.63
8.0.5	0.014	0.002	16.63
8.0.3	0.006	0.010	16.75
8.0.2	0.012	0.004	16.75
8.0.1	0.011	0.006	16.75