Category: MySQL
-
Post Views: 17 1. Table: Fields in pub_log: The type of data is: text, as shown in Figure 1 2. Table: field in pub_log: data structure of data is: json, the formatted data is as follows, as shown in Figure 2 3. The current requirement is that if “channel_app_task_status”: 6, it needs to be changed to: “channel_app_task_status”: 7, that is,…
-
Post Views: 16 1. Reference URL:https://www.shuijingwanwq.com/2019/08/15/3427/ 2. Update table: field in channel_app_source: The value of Permission is: 3, as shown in Figure 1 3. Based on the database migration command, generate the implementation of a SQL as shown above, edit \console\migrations\m190815_020034_permission.php 4. Execute the database migration command, as shown in Figure 2 5. Check the table: the field in channel_app_source:…
-
Post Views: 18 1. Table: weibo_weibo_connect_web_app_user field: permission, ready to move to table: channel_app_source field in: Permission, and then delete the table: weibo_weibo_connect_web_app_user field: Permission, as shown in Figure 1 2. Table: Fields in channel_app_source: Permission, table: weibo_weibo_connect_web_app_user: CHANNEL_APP_SOURCE_ID Associated with the field: ID in CHANNEL_APP_SOURCE, as shown in Figure 2 3. SQL is as follows, update the table: fields…
-
Post Views: 13 1. In Postman, open the URL:http://api.pcs-api.localhost/v1/plan-config-column-users?login_id=2e368664c41b8bf511bcc9c65d86dbc3&login_tid=685f805f71faedfe215f55bbb01b50c6&filter[config_column_id]=1 , only the fields are supported: config_column_id queries, the response is as follows: 2. The SQL statement is as follows: 3. Existing new requirements need to support the fuzzy query of user_nick, but the field: user_nick does not exist in mysql ActiveRecord, but exists in Redis ActiveRecord. And Redis ActiveRecord does…
-
Post Views: 48 1. Execute the update statement in mysql workbench, the statement is as follows: 2. Error code: 1175, the specific error information is as follows:, as shown in Figure 1 3. Execute the update statement in phpmyadmin, the statement is as follows: the execution is successful, as shown in Figure 2 4. According to the prompts, to disable…
-
Post Views: 11 1. Column configuration: pa_config_column, as shown in Figure 1 2. Column staff configuration: PA_CONFIG_COLUMN_USER, as shown in Figure 2 3. Topic: PA_plan, as shown in Figure 3 4. Topic selection task: PA_PLAN_TASK, as shown in Figure 4 5. Task management – my task, query rules (1) The tenant ID of the task is the tenant ID of…
-
Post Views: 40 1. In Postman, posthttp://api.github-shuijingwan-yii2-app-advanced.localhost/v1/users201 response, the status value is 1 by default 2. In Postman, deletehttp://api.github-shuijingwan-yii2-app-advanced.localhost/v1/users/1, 200 responses 3. In Postman, posthttp://api.github-shuijingwan-yii2-app-advanced.localhost/v1/users,422 response, not as expected, expected to be 201 response, because “username”: “111111” has been deleted 4. Create a new \console\migrations\m180925_054952_add_is_deleted_and_deleted_at_to_user.php. Update field, status, status, 0: disabled; 1: enabled, default: 1. Added field, is_deleted, whether it…
-
Post Views: 14 1. The current upgrade plan, after the Rancher container is upgraded, enter the Docker container and run it in sequence on the command line: 2. The problem with the current upgrade plan is that sometimes after the Rancher container is upgraded, the operation and maintenance personnel need to paste and run at least 2 commands in each…
-
Post Views: 39 1. The copy API application is QQ and WX. After adjusting the corresponding configuration, the final application directory structure is as follows 2. Nginx-based single domain name configuration on Yii 2 advanced project template, refer to the website:https://www.shuijingwanwq.com/2018/08/16/2836/, the API application is cross-channel, the QQ application is Penguin, and the WX application is the WeChat public account,…