hhh_webp_images/process_webp_from_db.py

import time
import random
import dataset
import os


db = dataset.connect('mysql://hhh7796hhh:lYmWsu^ujcA1@hhh-v57.cmab1ctkglka.ap-northeast-2.rds.amazonaws.com:3306/xoops?charset=utf8mb4')
db2 = dataset.connect('mysql://hhh7796hhh:lYmWsu^ujcA1@hhh-v57.cmab1ctkglka.ap-northeast-2.rds.amazonaws.com:3306/xoops?charset=utf8mb4')
table=db2['_had']
cursor=db.query('SELECT adid,adlogo_mobile FROM xoops._had where length(adlogo_mobile_webp)<5  and adlogo_mobile not like "%.gif" order by adid desc limit 30;')
for c in cursor:
#    print(c['adid'])
    adid=c['adid']
    mobile_h=c['adlogo_mobile'].replace('https://images.hhh.com.tw/','/home/hhh-images/')
    if '.gif' in mobile_h:
        continue
    print(mobile_h)
    print(os.path.exists(mobile_h))
    cmd='cwebp '+mobile_h+" -o "+mobile_h+".webp"
    print(cmd)
    os.system(cmd)
    mobile_h_url=mobile_h.replace('/home/hhh-images/','https://images.hhh.com.tw/')
    mobile_h_url+=".webp"
    sqlcmd='update _had set adlogo_mobile_webp="'+mobile_h_url+'" where adid="'+str(adid)+'"'
    print(sqlcmd)
    db2.query(sqlcmd)
#    db2.query()
#    break