hhh-home-mb/genjson/gen_webp.py

import time
import os
import dataset

db = dataset.connect('mysql://hhh7796hhh:lYmWsu^ujcA1@hhh-v57.cmab1ctkglka.ap-northeast-2.rds.amazonaws.com:3306/xoops?charset=utf8mb4')

cursor = db.query("SELECT adid,adlogo_mobile FROM xoops._had where length(adlogo_mobile_webp)<5  order by adid desc limit 100;")

for c in cursor:
    print(c['adid'])
    
print('test')