Tag: MySQL
-
Post Views: 45 1. Since the log message is stored in the log table of mysql, in the production environment, a large amount of data has been accumulated, and the data length of the log table has reached hundreds of gigabytes. Therefore, it is decided to implement the timing deletion of log messages based on the console command line, and…
-
Post Views: 14 1. Open the URL in Postman:http://api.pcs-api.localhost/v1/plans/have?login_id=2e368664c41b8bf511bcc9c65d86dbc3&login_tid=f347ba5bb18cb3fbef94c0b37c796bf5&filter[and][0][or][0][title][like]=Shenzhen &Filter[status][neq]=0&filter[and][0][or][1][keyword]= keyword, as shown in Figure 1 2. Print request parameter: $requestParams 3. Print the filter: $filter 4. The final generated SQL is as follows, as shown in Figure 2 5. The current requirement is that the field keyword, keywords, multiple uses, and numbers are separated, and accurate matching is required,…
-
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: 14 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: 42 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,…
-
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,…