6-3
<h4>数据库批量替换 http</h4>
<pre><code>update `lite_articles` set `content` = replace(content, 'https', 'http') where article_type = 2 </code></pre>
<pre><code>update `lite_articles` set `cover_url` = replace(cover_url, 'https', 'http') where article_type = 2 and id = 77835</code></pre>
<h4>解锁文章异步</h4>
<p>hdel h:async:handle:article {article_id}</p>
<p>hdel h:async:handle:article {article_id}</p>
<h4>python 的视频上传</h4>
<p><a href="https://help.aliyun.com/document_detail/61054.html?spm=a2c4g.11186623.4.2.427e7d4eXT5Zcn">https://help.aliyun.com/document_detail/61054.html?spm=a2c4g.11186623.4.2.427e7d4eXT5Zcn</a></p>
<p><a href="https://help.aliyun.com/document_detail/61052.html?spm=a2c4g.11186623.2.21.2a18ce9dObfHkl#InitVodClient">https://help.aliyun.com/document_detail/61052.html?spm=a2c4g.11186623.2.21.2a18ce9dObfHkl#InitVodClient</a></p>
<p><a href="https://github.com/aliyun/aliyun-oss-python-sdk/blob/master/oss2/auth.py">https://github.com/aliyun/aliyun-oss-python-sdk/blob/master/oss2/auth.py</a></p>
<p>结合工单摸索出来的上传方式：</p>
<pre><code>import oss2
yourAccessKeyId = 'STS.NHJHWMo6NPBE2bq1PrmMZMjrc'
yourAccessKeySecret = 'C2v6H9YU2WFaBANFdqzNn3D5Km8Gvt1HfXH38Ztpj7s1'
yourSecurityToken = 'CAIS0AR1q6Ft5B2yfSjIr4v/A+35gulv54CuMETA1VAnYcJ2oq/ZgTz2IH9IdHVoAO8fvvU0m2tY7PsZlrUqFcYaGRCZPJostM0GqV7xJpfZv8u84YADi5CjQcUrq5YhmZ28Wf7waf+AUBXGCTmd5MMYo9bTcTGlQCZuW//toJV7b9MRcxClZD5dfrl/LRdjr8lo1xGzUPG2KUzSn3b3BkhlsRYe72Rk8vaHxdaAzRDcgVbmqJcSvJ+jC4C8Ys9gG519XtypvopxbbGT8CNZ5z9A9qp9kM49/izc7P6QH35b4RiNL8/Z7tQNXwhiffobHa9YrfHgmNhlvvDSj43t1ytVOeZcX0akQ5u7ku7ZHP+oLt8jaYvjP3PE3rLpMYLu4T48ZXUSODtDYcZDUHhrEk4RUjXdI6Of8UrWSQC7Wsr217otg7Fyyk3s8MaHAkWLX7SB2DwEB4c4aEokVW4RxnezW6UBaRBpbld7Bq6cV5lOdBRZoK+KzQrJTX9Ez2pLmuD6e/LOs7oDVJ37WZtKyuh4Y49d4U8rVEjPQqiykT0pFgpfTK1RzbPmNLKm9baB25/zW+PdDe0dsVgoIFKOpiGWG3RLNn+ztJ9xbkeE+sKUwqKWo50+Gwdz6I1SVFiIINxh/wA+u/LstBnK+7/vWHnt5XR/uPugptgRuRo8I6372bTJ42WG5Ub9O/dpxJ3lP0R0WgmydnBDx/Sfu2kKvRhpkRvvZEpPtwzIij/gLZZEiazRmyhefo5XmPXFTQmn8l5pAMmy/60xXudvbE2R0EQDY9YCGoABLjU2pEpDvcWHehc1t5N2RjC8HWSXvga3wJvn/u85o1yF+EeW2GPt2bJatoECIaQXbaSQHHYzv4QBRbAy5ZPFQMUMoessoW+kOKztez9XCrcBkgivfdDWcgmy+HLxpIL6JbBQJhhH2LVwSwCcC69A8VVgq9rhyQfp5W8Y+gzLlUo='
yourLocalFile = '/home/share/848.mp4'
Endpoint = 'https://oss-cn-shanghai.aliyuncs.com'
Bucket = 'outin-ff28f6cd5f5e11e9bd8400163e1c8dba'
FILeName = 'sv/3c610357-16b2bdb5a22/3c610357-16b2bdb5a22.mp4'
auth = oss2.StsAuth(yourAccessKeyId, yourAccessKeySecret, yourSecurityToken)
bucket = oss2.Bucket(auth, Endpoint, Bucket)
bucket.put_object_from_file(FILeName, yourLocalFile)</code></pre>
<p>注意问题！！！
获取这个之后，信息没刷新再上传一次，会覆盖掉原来的视频，初步判断是根据 FILeName 属性</p>