Now is start live

这篇博客记录了作者日常生活中的点滴,包括对于个人博客的使用情况和个人生活的感悟。
tody is my other blog is access , this is blog is use full  my heard ,at there write all of my live 
SELECT COUNT(*) FROM (select t.live_room_id as liveRoomId, t.code as code, t.live_type as liveType, t.mode_app as modeApp, t.mode_pc as modePc, t.mode_courseware as modeCourseware, t.live_room_name as liveRoomName, t.live_start_time as liveStartTime, t.live_end_time as liveEndTime, t.really_start_time as reallyStartTime, t.really_end_time as reallyEndTime, t.is_clear as isClear, t.live_img as liveImg, t.is_must_phone as isMustPhone, t.live_time_length as liveTimeLength, t.display_form as displayForm, CASE WHEN t.live_type=1 and t.really_start_time is null and t.live_end_time > NOW() THEN '未开始' WHEN t.live_type=1 and t.really_start_time is not null and t.really_end_time is null THEN '直播中' WHEN t.live_type=1 and (t.really_end_time IS NOT NULL OR (t.really_start_time IS NULL AND t.live_end_time <= NOW())) THEN '回放中' ELSE NULL WHEN t.live_type=2 and t.really_start_time > NOW() THEN '未开始' WHEN t.live_type=2 and t.really_end_time is null THEN '直播中' WHEN t.live_type=2 and t.really_end_time > now() THEN '回放中' ELSE null END AS status from live_room t where t.is_delete=0 and t.sale_way=1 and t.tenant_id=? and t.live_room_id not in (select liveRoom.live_room_id from live_room liveRoom where liveRoom.is_delete = 0 and liveRoom.live_type=2 and ( liveRoom.really_end_time IS NOT NULL OR ( liveRoom.really_start_time IS NULL AND liveRoom.live_end_time <= NOW())) ) AND CASE WHEN ( t.live_type=1 and t.really_end_time IS NOT NULL OR ( t.really_start_time IS NULL AND t.live_end_time <= NOW())) THEN t.playback_make_status = 1 AND t.playback_view_status = 1 AND t.playback_view_close_time >= now() AND t.bjy_video_status = 100 ELSE 1 = 1
09-19
SELECT COUNT(*) FROM (select t.live_room_id as liveRoomId, t.code as code, t.live_type as liveType, t.mode_app as modeApp, t.mode_pc as modePc, t.mode_courseware as modeCourseware, t.live_room_name as liveRoomName, t.live_start_time as liveStartTime, t.live_end_time as liveEndTime, t.really_start_time as reallyStartTime, t.really_end_time as reallyEndTime, t.is_clear as isClear, t.live_img as liveImg, t.is_must_phone as isMustPhone, t.live_time_length as liveTimeLength, t.display_form as displayForm, CASE WHEN t.live_type = 1 AND t.really_start_time IS NULL AND t.live_end_time > NOW() THEN '未开始' WHEN t.live_type = 1 AND t.really_start_time IS NOT NULL AND t.really_end_time IS NULL THEN '直播中' WHEN t.live_type = 1 AND (t.really_end_time IS NOT NULL OR (t.really_start_time IS NULL AND t.live_end_time <= NOW())) THEN '回放中' WHEN t.live_type = 2 AND t.really_start_time > NOW() THEN '未开始' WHEN t.live_type = 2 AND t.really_end_time IS NULL THEN '直播中' WHEN t.live_type = 2 AND t.really_end_time IS NOT NULL '回放中' ELSE NULL END AS status from live_room t where t.is_delete=0 and t.sale_way=1 and t.tenant_id=2158 and t.live_room_id not in (select liveRoom.live_room_id from live_room liveRoom where liveRoom.is_delete = 0 and liveRoom.live_type=2 and ( liveRoom.really_end_time IS NOT NULL OR ( liveRoom.really_start_time IS NULL AND liveRoom.live_end_time <= NOW())) ) AND CASE WHEN ( t.live_type=1 and t.really_end_time IS NOT NULL OR ( t.really_start_time IS NULL AND t.live_end_time <= NOW())) THEN t.playback_make_status = 1 AND t.playback_view_status = 1 AND t.playback_view_close_time >= now() AND t.bjy_video_status = 100 ELSE 1 = 1 END ORDER BY CASE status WHEN '回放中' THEN 2 WHEN '直播中' THEN 0 WHEN '已结束' THEN 1 ELSE 3 END ASC,t.live_start_time ASC) TOTAL > 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''回放中' ELSE NULL END AS status from liv' at line 24 > 时间: 0.016s
09-21
下面SQL则呢创建索引SELECT t.live_room_id AS liveRoomId, t.CODE AS CODE, t.live_type AS liveType, t.mode_app AS modeApp, t.mode_pc AS modePc, t.mode_courseware AS modeCourseware, t.live_room_name AS liveRoomName, t.live_start_time AS liveStartTime, t.live_end_time AS liveEndTime, t.really_start_time AS reallyStartTime, t.really_end_time AS reallyEndTime, t.is_clear AS isClear, t.live_img AS liveImg, t.is_must_phone AS isMustPhone, t.live_time_length AS liveTimeLength, t.display_form AS displayForm, CASE WHEN t.really_start_time IS NULL AND t.live_end_time > NOW() THEN '未开始' WHEN t.really_start_time IS NOT NULL AND t.really_end_time IS NULL THEN '直播中' WHEN ( t.really_end_time IS NOT NULL OR ( t.really_start_time IS NULL AND t.live_end_time <= NOW())) THEN '回放中' ELSE NULL END AS STATUS FROM live_room t WHERE t.is_delete = 0 AND t.sale_way = 1 AND t.tenant_id = 2155 AND t.live_room_id NOT IN ( SELECT liveRoom.live_room_id FROM live_room liveRoom WHERE liveRoom.is_delete = 0 AND liveRoom.tenant_id = 2155 AND ( liveRoom.really_end_time IS NOT NULL OR ( liveRoom.really_start_time IS NULL AND liveRoom.live_end_time <= NOW())) ) AND CASE WHEN ( t.really_end_time IS NOT NULL OR ( t.really_start_time IS NULL AND t.live_end_time <= NOW())) THEN t.playback_make_status = 1 AND t.playback_view_status = 1 AND ( t.playback_view_close_time IS NULL OR t.playback_view_close_time <= now() ) AND t.bjy_video_status = 100 ELSE 1 = 1 END ORDER BY CASE STATUS WHEN '回放中' THEN 2 WHEN '直播中' THEN 0 WHEN '已结束' THEN 1 ELSE 3 END ASC, t.create_time ASC LIMIT 5
09-08
AI 代码审查Review工具 是一个旨在自动化代码审查流程的工具。它通过集成版本控制系统(如 GitHub 和 GitLab)的 Webhook,利用大型语言模型(LLM)对代码变更进行分析,并将审查意见反馈到相应的 Pull Request 或 Merge Request 中。此外,它还支持将审查结果通知到企业微信等通讯工具。 一个基于 LLM 的自动化代码审查助手。通过 GitHub/GitLab Webhook 监听 PR/MR 变更,调用 AI 分析代码,并将审查意见自动评论到 PR/MR,同时支持多种通知渠道。 主要功能 多平台支持: 集成 GitHub 和 GitLab Webhook,监听 Pull Request / Merge Request 事件。 智能审查模式: 详细审查 (/github_webhook, /gitlab_webhook): AI 对每个变更文件进行分析,旨在找出具体问题。审查意见会以结构化的形式(例如,定位到特定代码行、问题分类、严重程度、分析和建议)逐条评论到 PR/MR。AI 模型会输出 JSON 格式的分析结果,系统再将其转换为多条独立的评论。 通用审查 (/github_webhook_general, /gitlab_webhook_general): AI 对每个变更文件进行整体性分析,并为每个文件生成一个 Markdown 格式的总结性评论。 自动化流程: 自动将 AI 审查意见(详细模式下为多条,通用模式下为每个文件一条)发布到 PR/MR。 在所有文件审查完毕后,自动在 PR/MR 中发布一条总结性评论。 即便 AI 未发现任何值得报告的问题,也会发布相应的友好提示和总结评论。 异步处理审查任务,快速响应 Webhook。 通过 Redis 防止对同一 Commit 的重复审查。 灵活配置: 通过环境变量设置基
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值