Category: SQL
-
Post Views: 20 1. The current requirements are as follows. Based on the time range of article publishing, it is necessary to filter account rankings based on the number of articles published. as shown in Figure 1 2. View the method file of the obtained account list, the code is as follows 3, gethttp://api.channel-pub-api.localhost/v1/channel-app-sources?group_id=015ce30b116ce86058fa6ab4fea4ac63&sort=-channel_app_task_count。Sometimes, when connecting two tables, you may…
-
Post Views: 14 1. Main table: CPA_CHANNEL_APP_TASK and Schedule: CPA_Task: many-to-one. as shown in Figure 1 2, table: cpa_task and Table: CPA_baijia_article|cpa_customize_article|cpa_douyin_article|cp a_netease_article|cpa_qq_article|cpa_weibo_article|cpa_wx_article The association relationship: one-on-one. Table: A record in cpa_task will only exist in Table: CPA_baijia_article|cpa_customize_article|cpa_douyin_article|cp a_netease_article|cpa_qq_article|cpa_weibo_article|cpa_wx_article in one of the tables. As shown in Figure 2, Figure 3, Figure 4 3. Table: CPA_baijia_article|cpa_customize_article|cpa_douyin_article|c PA_Netease_Article|CPA_QQ_Article|CPA_Weibo_Article|CPA_WX_Article…
-
Post Views: 10 1. Table name: CPA_CHANNEL_APP_SOURCE design, table prefix: CPA_, as shown in Figure 1 2. View command: yii migrate/create help documentation 3. Add field. If the migrated name follows the format of add_xxx_to_yyy, the generated class file will contain the necessary addColumn and dropColumn. You can specify multiple fields like this: yii migrate/create add_xxx_column_yyy_column_to_zzz_table –fields=”xxx:integer,yyy:text”. as shown in…
-
Post Views: 17 1. Check the search model file: /common/logics/weiboWeiBoConnectWebAppUsersarch.php. 7. Edit method entry file: /weibo/rests/weibo_weibo_connect_web_app_user/indexaction.php. Implement the search and sorting of the channel_app_task_count. The inclusion of channel_app_task_count is prerequisite for the channel_app_task field status of 6. 2. View the method entry file: /weibo/rests/weibo_weibo_connect_web_app_user/indexaction.php.
-
Post Views: 13 1. In the topic selection list page, whether it has been extended, 0: no; 1: Yes, this field does not exist in the topic selection table. is calculated by program. $time is the current Beijing time, calculated by the server. as shown in Figure 1 2. In the latest version of the prototype, you need to support…
-
Post Views: 20 1. At this stage, there is a new requirement, and it is necessary to do some initial data work for the product when deploying the product. Prepare the corresponding SQL file in advance. Since multiple SQL statements need to be executed, and subsequent SQL statements depend on the primary key ID generated by the previous SQL statement.…
-
Post Views: 13 1. The request interface, the total number of resources in the response parameters is 30. Resources containing ids equal to 37918 are duplicates. A total of 2. as shown in Figure 1 2. Check the model class, /common/models/redis/cmc_console/user.php 3. Check /common/components/redis/activerecord.php , which defines the prefix and applies to all AR keys. 4. Open RedisDesktopManager, check the…
-
Post Views: 14 1. In the previous release interface, only one channel is supported for a release. Therefore, the release of the three channels needs to call the interface (APP, Netease account, Weibo) 3 times respectively, as shown in Figure 1 2. On the current release interface, it is ready to publish at one time and can be published on…