Category: MySQL 5.7
-
Post Views: 17 1. Gethttp://api.channel-pub-api.localhost/qq/v1/qq-cw-apps/edit/148d4df6eba311e899f654ee75d2ebc1?group_id=spider, the response is as follows, based on security reasons, reset the client secret to an empty string 2, therefore, PUThttp://api.channel-pub-api.localhost/qq/v1/qq-cw-apps/148d4df6eba311e899f654ee75d2ebc1?group_id=spider, if the value of client_secret is not updated, its value is an empty string Body 3. The request response failed, 422, as shown in Figure 1 4. Now you need to realize that when the…
-
Post Views: 17 1. The design of the database structure, a resource table, a video file upload table of a Penguin number, and a transaction table of a penguin. The structure is as follows: 2. The upload of resources is implemented based on the queue, so the resource data will be stored in the resource table first, and then the…
-
Post Views: 29 1. Implement the corresponding RESTful-style web service API of the page in the API directory, and then adjust it to the RPC client 2. After all the corresponding APIs of the page are implemented, the POST request is executed in Postman, and the response is normal, as shown in Figure 1 3. Execute the PUT /pages/1 request…
-
Post Views: 14 1. Dynamic configuration of database connection in Yii 2 Starter Kit, the configuration attribute comes from the multi-tenant system,https://www.shuijingwanwq.com/2018/01/18/2328/, multi-tenant physical isolation implementation 2. In the public cloud, the system should serve multiple tenants at the same time, and multiple tenants share a database. Therefore, it is necessary to realize the logical isolation of multi-tenancy, that is,…
-
Post Views: 32 1. Based on yii2tech\ar\SoftDelete\SoftDeleteBehavior, the soft deletion of ActiveRecord is realized, and the URL is opened:https://github.com/yiisoft/yii2/blob/master/docs/guide-zh-CN/concept-behaviors.md, as shown in Figure 1 2. Install the ActiveRecord extension of Yii2, use the self-update command to update the composer to the latest version, use the update command to obtain the latest version of the dependencies, and upgrade the composer.lock file,…
-
Post Views: 53 1. In the development environment, the execution of the database migration command fails: 1071 Specified key was too long; Max key length is 767 bytes, as shown in Figure 17 2. Run sql in the database in the development environment, and report an error: #1071 – specific key was too long; max key length is 767 bytes,…