René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"pgsql-swoole driver can not prompt errors","articleBody":"## app/Controller/TestController.php\r\n```php\r\n    #[RequestMapping(path: \"create\", methods: \"get\")]\r\n    public function create(ResponseInterface $response)\r\n    {\r\n        $s = \\App\\Model\\Session::create([\r\n            'id' =\u003e '131',\r\n            'store_id' =\u003e 111,\r\n            'uuid' =\u003e 'abc',\r\n            'visitor_id' =\u003e '321',\r\n            'user_id' =\u003e '0',\r\n            'fingerprint' =\u003e '11111111111',\r\n            'client_ip' =\u003e '127.0.0.1',\r\n        ]);\r\n        var_dump($s);\r\n        return $response-\u003eraw('create session'); \r\n    }\r\n```\r\n## pgsql 日志\r\n```bash\r\n2023-04-23 13:43:37.125 CST,\"track\",\"track\",46662,\"172.17.0.3:36156\",6444c589.b646,7,\"PARSE\",2023-04-23 13:43:37 CST,3/48,0,LOG,00000,\"duration: 1.488 ms  parse swoole_stmt_2: insert into \"\"sessions\"\" (\"\"id\"\", \"\"store_id\"\", \"\"uuid\"\", \"\"visitor_id\"\", \"\"user_id\"\", \"\"fingerprint\"\", \"\"client_ip\"\", \"\"updated_at_gmt\"\", \"\"created_at_gmt\"\") values ($1, $2, $3, $4, $5, $6, $7, $8, $9)\",,,,,,,,,\"\",\"client backend\",,0\r\n2023-04-23 13:43:37.127 CST,\"track\",\"track\",46662,\"172.17.0.3:36156\",6444c589.b646,8,\"BIND\",2023-04-23 13:43:37 CST,3/49,0,LOG,00000,\"duration: 0.839 ms  bind swoole_stmt_2: insert into \"\"sessions\"\" (\"\"id\"\", \"\"store_id\"\", \"\"uuid\"\", \"\"visitor_id\"\", \"\"user_id\"\", \"\"fingerprint\"\", \"\"client_ip\"\", \"\"updated_at_gmt\"\", \"\"created_at_gmt\"\") values ($1, $2, $3, $4, $5, $6, $7, $8, $9)\",\"parameters: $1 = '131', $2 = '111', $3 = 'abc', $4 = '321', $5 = '0', $6 = '11111111111', $7 = '127.0.0.1', $8 = '2023-04-23 05:43:37', $9 = '2023-04-23 05:43:37'\",,,,,,,,\"\",\"client backend\",,0\r\n2023-04-23 13:43:37.127 CST,\"track\",\"track\",46662,\"172.17.0.3:36156\",6444c589.b646,9,\"INSERT\",2023-04-23 13:43:37 CST,3/49,0,LOG,00000,\"execute swoole_stmt_2: insert into \"\"sessions\"\" (\"\"id\"\", \"\"store_id\"\", \"\"uuid\"\", \"\"visitor_id\"\", \"\"user_id\"\", \"\"fingerprint\"\", \"\"client_ip\"\", \"\"updated_at_gmt\"\", \"\"created_at_gmt\"\") values ($1, $2, $3, $4, $5, $6, $7, $8, $9)\",\"parameters: $1 = '131', $2 = '111', $3 = 'abc', $4 = '321', $5 = '0', $6 = '11111111111', $7 = '127.0.0.1', $8 = '2023-04-23 05:43:37', $9 = '2023-04-23 05:43:37'\",,,,,,,,\"\",\"client backend\",,0\r\n2023-04-23 13:43:37.128 CST,\"track\",\"track\",46662,\"172.17.0.3:36156\",6444c589.b646,10,\"INSERT\",2023-04-23 13:43:37 CST,3/49,1052,ERROR,23505,\"duplicate key value violates unique constraint \"\"sessions_pkey\"\"\",\"Key (store_id, uuid)=(111, abc) already exists.\",,,,,\"insert into \"\"sessions\"\" (\"\"id\"\", \"\"store_id\"\", \"\"uuid\"\", \"\"visitor_id\"\", \"\"user_id\"\", \"\"fingerprint\"\", \"\"client_ip\"\", \"\"updated_at_gmt\"\", \"\"created_at_gmt\"\") values ($1, $2, $3, $4, $5, $6, $7, $8, $9)\",,,\"\",\"client backend\",,0\r\n```\r\n## 响应结果\r\n![image](https://user-images.githubusercontent.com/29323350/233822978-44b3c6e6-e714-4158-a7a6-e30adfd70722.png)\r\n\r\n\r\n## 问题\r\n当我的数据库驱动使用 `pgsql-swoole` 并使用 `model` 去创建新的数据时，无论写入的 SQL 在数据库里是否发生了错误。 model 总能返回一个正确的对象给我，但 pgsql 里却没有对应的数据。","author":{"url":"https://github.com/wuxi889","@type":"Person","name":"wuxi889"},"datePublished":"2023-04-23T06:09:46.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/9/database-pgsql/issues/9"}