{"id":5526,"date":"2024-05-06T12:09:48","date_gmt":"2024-05-06T03:09:48","guid":{"rendered":"https:\/\/taitan916.info\/blog\/?p=5526"},"modified":"2024-03-19T16:50:47","modified_gmt":"2024-03-19T07:50:47","slug":"post-5526","status":"publish","type":"post","link":"https:\/\/taitan916.info\/blog\/archives\/5526","title":{"rendered":"PHP\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u53d6\u308a\u6271\u3044\u3084\u3059\u304f\u306a\u308bORM\u30e9\u30a4\u30d6\u30e9\u30ea\u300cidiorm\u300d\u306e\u5229\u7528\u65b9\u6cd5"},"content":{"rendered":"

Codeigniter\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u53d6\u308a\u6271\u3046\u969b\u306b\u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u30af\u30e9\u30b9\u3092\u7528\u3044\u3066\u53ef\u8aad\u6027\u306e\u9ad8\u3044\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u8a18\u8ff0\u3067\u304d\u308b\u304c\u3001\u30d0\u30cb\u30e9PHP\u3067\u3082\u540c\u3058\u3088\u3046\u306a\u3053\u3068\u3092\u3057\u305f\u3044\u3002\u8abf\u3079\u3066\u307f\u308b\u3068\u300cj4mie \/ idiorm\u300d\u3068\u3044\u3046ORM\u30e9\u30a4\u30d6\u30e9\u30ea\u304c\u30b7\u30f3\u30d7\u30eb\u3067\u826f\u3055\u305d\u3046\u3002\u4ee5\u4e0b\u306b\u5229\u7528\u65b9\u6cd5\u306e\u30e1\u30e2\u3002<\/p>\n

 <\/p>\n

j4mie \/ idiorm<\/h2>\n

GitHub<\/h3>\n

https:\/\/github.com\/j4mie\/idiorm<\/a><\/p>\n

\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9<\/h3>\n

https:\/\/idiorm.readthedocs.io\/en\/latest\/index.html<\/a><\/p>\n

 <\/p>\n

\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/span><\/h2>\n

\u3053\u3061\u3089\u306e\u30da\u30fc\u30b8<\/a>\u304b\u3089idiorm.php\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3001\u9069\u5f53\u306a\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u3002<\/p>\n

 <\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u69cb\u9020<\/h2>\n

\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30c6\u30fc\u30d6\u30eb\u3092\u7528\u610f\u3057\u305f\u3002<\/p>\n

mysql> SHOW COLUMNS FROM `test_table`;\r\n+------------+--------------+------+-----+---------+----------------+\r\n| Field      | Type         | Null | Key | Default | Extra          |\r\n+------------+--------------+------+-----+---------+----------------+\r\n| id         | int          | NO   | PRI | NULL    | auto_increment |\r\n| name       | varchar(255) | NO   |     | NULL    |                |\r\n| score      | int          | NO   |     | NULL    |                |\r\n| regist_ymd | datetime     | NO   |     | NULL    |                |\r\n+------------+--------------+------+-----+---------+----------------+\r\n<\/pre>\n
 <\/p>\n
\u5229\u7528\u65b9\u6cd5<\/h2>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a<\/h3>\n
\/\/MySQL\u63a5\u7d9a\r\nORM::configure('mysql:host=\u3010\u30db\u30b9\u30c8\u3011;dbname=\u3010\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3011');\r\nORM::configure('username', '\u3010\u30e6\u30fc\u30b6\u30fc\u3011');\r\nORM::configure('password', '\u3010\u30d1\u30b9\u30ef\u30fc\u30c9\u3011');<\/pre>\n
\u30ad\u30e3\u30c3\u30b7\u30e5\u53ca\u3073\u30ed\u30b0\u8a2d\u5b9a<\/h3>\n
\/\/\u30ad\u30e3\u30c3\u30b7\u30e5\u8a2d\u5b9a\r\nORM::configure('caching', true);\r\nORM::configure('caching_auto_clear', true);\r\n\r\n\/\/\u30ed\u30b0\u8a2d\u5b9a\r\nORM::configure('logging', true);<\/pre>\n
INSERT<\/h3>\n
$now = new DateTime();\r\n$data = array(\r\n    'name' => '\u9234\u6728',\r\n    'score' => 61,\r\n    'regist_ymd' => $now->format('Y-m-d H:i:s')\r\n);\r\n\r\n$query = ORM::for_table('test_table')->create()->set($data)->save();\r\n\r\n$sqls = ORM::get_query_log();\r\nvar_dump($sqls);\r\n\/\/INSERT INTO `test_table` (`name`, `score`, `regist_ymd`) VALUES ('\u9234\u6728', '61', '2024-05-11 12:41:51')<\/pre>\n
UPDATE<\/h3>\n
$data = array(\r\n    'id' => 6,\r\n    'score' => 77,\r\n);\r\n\r\n$query = ORM::for_table('test_table')->find_one($data['id'])->set($data)->save();\r\n$sqls = ORM::get_query_log();\r\nvar_dump($sqls);\r\n\/*\r\narray(2) {\r\n  [0]=>\r\n  string(51) \"SELECT * FROM `test_table` WHERE `id` = '6' LIMIT 1\"\r\n  [1]=>\r\n  string(67) \"UPDATE `test_table` SET `id` = '6', `score` = '77' WHERE `id` = '6'\"\r\n}\r\n*\/<\/pre>\n
SELECT<\/h3>\n
$data = ORM::for_table('test_table')->find_many();\r\nforeach( (array)$data as $val ){\r\n    var_dump($val->id);\r\n    var_dump($val->name);\r\n    var_dump($val->score);\r\n    var_dump($val->regist_ymd);\r\n}\r\n\r\n$sqls = ORM::get_query_log();\r\nvar_dump($sqls);\r\n\/\/SELECT * FROM `test_table`<\/pre>\n
DELETE<\/h3>\n
$data = array(\r\n    'id' => 6,\r\n);\r\n$query = ORM::for_table('test_table')->find_one($data['id'])->delete();\r\n$sqls = ORM::get_query_log();\r\nvar_dump($sqls);\r\n\/*\r\narray(2) {\r\n  [0]=>\r\n  string(51) \"SELECT * FROM `test_table` WHERE `id` = '6' LIMIT 1\"\r\n  [1]=>\r\n  string(41) \"DELETE FROM `test_table` WHERE `id` = '6'\"\r\n}\r\n*\/<\/pre>\n
\u7d20\u306eSQL\u6587\u3092\u5b9f\u884c\u3057\u305f\u3044\u5834\u5408<\/h3>\n
$sql = '\r\n    SELECT * \r\n    FROM test_table \r\n    WHERE score > 30\r\n';\r\n$query = ORM::for_table('test_table')->raw_query($sql)->find_many();\r\nforeach( (array)$query as $val ){\r\n    var_dump($val->id);\r\n    var_dump($val->name);\r\n    var_dump($val->score);\r\n    var_dump($val->regist_ymd);\r\n}\r\n\r\n$sqls = ORM::get_query_log();\r\nvar_dump($sqls);\r\n\/*\r\narray(1) {\r\n  [0]=>\r\n  string(52) \"\r\n    SELECT * \r\n    FROM test_table \r\n    WHERE score > 30\r\n\"\r\n}\r\n*\/<\/pre>\n
 <\/p>\n
ORM\u306b\u3064\u3044\u3066<\/h2>\n
ORM(Object-Relational Mapping)\u3068\u306f<\/h3>\n
\u30a6\u30a3\u30ad\u30da\u30c7\u30a3\u30a2\u306b\u3088\u308b\u3068\u4ee5\u4e0b\u306e\u901a\u308a\u3002<\/p>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u6307\u5411\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u8a00\u8a9e\u306e\u9593\u306e\u975e\u4e92\u63db\u306a\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u6280\u6cd5\u3067\u3042\u308b\u3002<\/p><\/blockquote>\n
\u3056\u3063\u304f\u308a\u3068\u300cSQL\u3092\u76f4\u63a5\u66f8\u304f\u3053\u3068\u306a\u304f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30e1\u30bd\u30c3\u30c9\u3067DB\u64cd\u4f5c\u304c\u3067\u304d\u308b\u300d\u624b\u6cd5\u3068\u899a\u3048\u3066\u304a\u3044\u3066\u3088\u3055\u305d\u3046\u3002<\/p>\n
ORM\u306e\u30e1\u30ea\u30c3\u30c8<\/h3>\n
\u4ee5\u4e0b\u304c\u30e1\u30ea\u30c3\u30c8\u3067\u7279\u306b\u5f8c\u8005\u306e\u65b9\u304c\u5927\u304d\u3044\u3088\u3046\u306b\u601d\u3046\u3002<\/p>\n