main.py 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551
  1. from fastapi import FastAPI,Cookie, Depends, Query, status,File, UploadFile,Request,Response,HTTPException
  2. from fastapi.templating import Jinja2Templates
  3. from fastapi.responses import HTMLResponse, RedirectResponse, JSONResponse
  4. from typing import List, Optional
  5. from os.path import isfile, isdir, join
  6. import threading
  7. import zhtts
  8. import os
  9. import urllib
  10. import requests
  11. from bs4 import BeautifulSoup
  12. from PIL import Image,ImageDraw,ImageFont
  13. import pyttsx3
  14. import rpyc
  15. import random
  16. import time
  17. import math
  18. import hashlib
  19. import re
  20. import asyncio
  21. import urllib.request
  22. from fastapi.responses import FileResponse
  23. from fastapi.middleware.cors import CORSMiddleware
  24. import dataset
  25. from datetime import datetime, timedelta
  26. from util.swap_face import swap_face
  27. from fastapi.staticfiles import StaticFiles
  28. import shutil
  29. import io
  30. from first import first
  31. from passlib.context import CryptContext
  32. from jose import JWTError, jwt
  33. from fastapi_jwt_auth import AuthJWT
  34. from fastapi_jwt_auth.exceptions import AuthJWTException
  35. from fastapi.security import OAuth2PasswordBearer, OAuth2PasswordRequestForm
  36. import models
  37. import pymysql
  38. from first import first
  39. import mailer
  40. from moviepy.editor import VideoFileClip
  41. import traceback
  42. import logging
  43. pymysql.install_as_MySQLdb()
  44. app = FastAPI()
  45. app.add_middleware(
  46. CORSMiddleware,
  47. allow_origins=["*"],
  48. allow_credentials=True,
  49. allow_methods=["*"],
  50. allow_headers=["*"],
  51. )
  52. SECRET_KEY = "df2f77bd544240801a048bd4293afd8eeb7fff3cb7050e42c791db4b83ebadcd"
  53. ALGORITHM = "HS256"
  54. ACCESS_TOKEN_EXPIRE_MINUTES = 300
  55. pwd_context = CryptContext(schemes=["bcrypt"], deprecated="auto")
  56. app.mount("/static", StaticFiles(directory="static"), name="static")
  57. app.mount("/static/img", StaticFiles(directory="static/img"), name="static/img")
  58. app.mount("/templates", StaticFiles(directory="templates"), name="templates")
  59. templates = Jinja2Templates(directory="templates")
  60. oauth2_scheme = OAuth2PasswordBearer(tokenUrl="token")
  61. tmp_video_dir = '../OpenshotService/tmp_video/'
  62. tmp_avatar_dir = '../../face_swap/tmp_avatar/' #change source face path here
  63. video_sub_folder = 'ai_anchor_video/'
  64. avatar_sub_folder = 'swap_save/'
  65. tmp_img_sub_folder = 'tmp_img/'
  66. img_upload_folder = '/var/www/html/'+tmp_img_sub_folder
  67. video_dest = '/var/www/html/'+video_sub_folder
  68. avatar_dest = '/var/www/html/'+avatar_sub_folder
  69. @app.get("/index2")
  70. async def index2():
  71. return FileResponse('static/index2.html')
  72. @app.get("/index_eng")
  73. async def index2():
  74. return FileResponse('static/index_eng.html')
  75. # home page
  76. @app.get("/index", response_class=HTMLResponse)
  77. async def get_home_page(request: Request, response: Response):
  78. return templates.TemplateResponse("index.html", {"request": request, "response": response})
  79. @app.get("/", response_class=HTMLResponse)
  80. async def get_home_page(request: Request, response: Response):
  81. return templates.TemplateResponse("index.html", {"request": request, "response": response})
  82. @app.get("/make_video", response_class=HTMLResponse)
  83. async def get_home_page(request: Request, response: Response, Authorize: AuthJWT = Depends()):
  84. try:
  85. Authorize.jwt_required()
  86. except Exception as e:
  87. print(e)
  88. return '請先登入帳號'
  89. current_user = Authorize.get_jwt_subject()
  90. return templates.TemplateResponse("make_video.html", {"request": request, "response": response})
  91. @app.get('/user_profile', response_class=HTMLResponse)
  92. def protected(request: Request, Authorize: AuthJWT = Depends()):
  93. Authorize.jwt_required()
  94. current_user = Authorize.get_jwt_subject()
  95. return current_user
  96. # login & register page
  97. @app.get("/login", response_class=HTMLResponse)
  98. async def get_login_and_register_page(request: Request):
  99. return templates.TemplateResponse("login.html", {"request": request})
  100. @app.post("/login")
  101. async def login_for_access_token(request: Request, form_data: OAuth2PasswordRequestForm = Depends(), Authorize: AuthJWT = Depends()):
  102. db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/AI_anchor?charset=utf8mb4')
  103. user = authenticate_user(form_data.username, form_data.password)
  104. if not user:
  105. raise HTTPException(
  106. status_code=status.HTTP_401_UNAUTHORIZED,
  107. detail="Incorrect username or password",
  108. headers={"WWW-Authenticate": "Bearer"},
  109. )
  110. access_token_expires = timedelta(minutes=ACCESS_TOKEN_EXPIRE_MINUTES)
  111. access_token = create_access_token(
  112. data={"sub": user.username}, expires_delta=access_token_expires
  113. )
  114. table = db['users']
  115. user.token = access_token
  116. table.update(dict(user), ['username'])
  117. access_token = Authorize.create_access_token(subject=user.username)
  118. refresh_token = Authorize.create_refresh_token(subject=user.username)
  119. Authorize.set_access_cookies(access_token)
  120. Authorize.set_refresh_cookies(refresh_token)
  121. #return templates.TemplateResponse("index.html", {"request": request, "msg": 'Login'})
  122. return {"access_token": access_token, "token_type": "bearer"}
  123. @app.post("/token")
  124. async def access_token(form_data: OAuth2PasswordRequestForm = Depends(), Authorize: AuthJWT = Depends()):
  125. db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/AI_anchor?charset=utf8mb4')
  126. user = authenticate_user(form_data.username, form_data.password)
  127. if not user:
  128. raise HTTPException(
  129. status_code=status.HTTP_401_UNAUTHORIZED,
  130. detail="Incorrect username or password",
  131. headers={"WWW-Authenticate": "Bearer"},
  132. )
  133. access_token_expires = timedelta(minutes=ACCESS_TOKEN_EXPIRE_MINUTES)
  134. access_token = create_access_token(
  135. data={"sub": user.username}, expires_delta=access_token_expires
  136. )
  137. return {"access_token": access_token, "token_type": "bearer"}
  138. @app.post("/register")
  139. async def register(request: Request):
  140. user = models.User(**await request.form())
  141. user_register(user)
  142. return templates.TemplateResponse("login.html", {'request': request,"success": True}, status_code=status.HTTP_302_FOUND)
  143. @app.get('/user_profile', response_class=HTMLResponse)
  144. def protected(request: Request, Authorize: AuthJWT = Depends()):
  145. Authorize.jwt_required()
  146. current_user = Authorize.get_jwt_subject()
  147. return current_user
  148. @app.get('/logout')
  149. def logout(request: Request, Authorize: AuthJWT = Depends()):
  150. Authorize.jwt_required()
  151. Authorize.unset_jwt_cookies()
  152. return {"msg": "Successfully logout"}
  153. @app.get("/gen_avatar")
  154. async def avatar():
  155. return FileResponse('static/gen_avatar.html')
  156. @app.post("/swapFace")
  157. async def swapFace(req:models.swap_req):
  158. if 'http' not in req.imgurl:
  159. req.imgurl= 'http://'+req.imgurl
  160. try:
  161. im = Image.open(requests.get(req.imgurl, stream=True).raw)
  162. im= im.convert("RGB")
  163. except:
  164. return {'msg':"無法辨別圖片網址"+req.imgurl}
  165. name_hash = str(time.time()).replace('.','')
  166. x = threading.Thread(target=gen_avatar, args=(name_hash,req.imgurl))
  167. x.start()
  168. return {'msg':'人物生成中,請稍候'}
  169. @app.post("/uploadfile/")
  170. async def create_upload_file(file: UploadFile = File(...)):
  171. img_name = str(time.time()).replace('.','')
  172. try:
  173. contents = await file.read()
  174. image = Image.open(io.BytesIO(contents))
  175. image= image.convert("RGB")
  176. image.save(img_upload_folder+img_name+'.jpg')
  177. except:
  178. return {'msg':'檔案無法使用'}
  179. return {"msg": 'www.choozmo.com:8168/'+tmp_img_sub_folder+img_name+'.jpg'}
  180. @app.post("/make_anchor_video")
  181. async def make_anchor_video(req:models.request,token: str = Depends(oauth2_scheme)):
  182. if len(req.image_urls) != len(req.text_content):
  183. return {'msg':'副標題數量、圖片(影片)數量以及台詞數量必須一致'}
  184. for idx in range(len(req.image_urls)):
  185. if 'http' not in req.image_urls[idx]:
  186. req.image_urls[idx] = 'http://'+req.image_urls[idx]
  187. for txt in req.text_content:
  188. if re.search('[a-zA-Z]', txt) !=None:
  189. return {'msg':'輸入字串不能包含英文字!'}
  190. name_hash = str(time.time()).replace('.','')
  191. for imgu in req.image_urls:
  192. try:
  193. if get_url_type(imgu) =='video/mp4':
  194. r=requests.get(imgu)
  195. else:
  196. im = Image.open(requests.get(imgu, stream=True).raw)
  197. im= im.convert("RGB")
  198. except:
  199. return {'msg':"無法辨別圖片網址"+imgu}
  200. user_id = get_user_id(token)
  201. save_history(req,name_hash,user_id)
  202. x = threading.Thread(target=gen_video_queue, args=(name_hash,req.name, req.text_content, req.image_urls,int(req.avatar),user_id))
  203. x.start()
  204. return {"msg":"製作影片需要時間,請您耐心等候,成果會傳送至LINE群組中"}
  205. @app.post("/make_anchor_video_eng")
  206. async def make_anchor_video_eng(req:models.request_eng):
  207. if len(req.image_urls) != len(req.sub_titles) or len(req.sub_titles) != len(req.text_content):
  208. return {'msg':'副標題數量、圖片(影片)數量以及台詞數量必須一致'}
  209. for idx in range(len(req.image_urls)):
  210. if 'http' not in req.image_urls[idx]:
  211. req.image_urls[idx] = 'http://'+req.image_urls[idx]
  212. name_hash = str(time.time()).replace('.','')
  213. for imgu in req.image_urls:
  214. try:
  215. if get_url_type(imgu) =='video/mp4':
  216. r=requests.get(imgu)
  217. else:
  218. im = Image.open(requests.get(imgu, stream=True).raw)
  219. im= im.convert("RGB")
  220. except:
  221. return {'msg':"無法辨別圖片網址"+imgu}
  222. save_history(req,name_hash)
  223. x = threading.Thread(target=gen_video_queue_eng, args=(name_hash,req.name, req.text_content, req.image_urls,req.sub_titles,int(req.avatar)))
  224. x.start()
  225. return {"msg":"製作影片需要時間,請您耐心等候,成果會傳送至LINE群組中"}
  226. @app.get("/history_input")
  227. async def history_input(request: Request, Authorize: AuthJWT = Depends()):
  228. Authorize.jwt_required()
  229. current_user = Authorize.get_jwt_subject()
  230. db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/AI_anchor?charset=utf8mb4')
  231. user_id = first(db.query('SELECT * FROM users where username="' + current_user +'"'))['id']
  232. statement = 'SELECT * FROM history_input WHERE user_id="'+str(user_id)+'" ORDER BY timestamp DESC LIMIT 50'
  233. logs = []
  234. for row in db.query(statement):
  235. logs.append({'id':row['id'],'name':row['name'],'text_content':row['text_content'].split(','),'link':row['link'],'image_urls':row['image_urls'].split(',')})
  236. return logs
  237. @AuthJWT.load_config
  238. def get_config():
  239. return models.Settings()
  240. @app.exception_handler(AuthJWTException)
  241. def authjwt_exception_handler(request: Request, exc: AuthJWTException):
  242. return JSONResponse(
  243. status_code=exc.status_code,
  244. content={"detail": exc.message}
  245. )
  246. def get_user_id(token):
  247. db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/AI_anchor?charset=utf8mb4')
  248. credentials_exception = HTTPException(
  249. status_code=status.HTTP_401_UNAUTHORIZED,
  250. detail="Could not validate credentials",
  251. headers={"WWW-Authenticate": "Bearer"},
  252. )
  253. try:
  254. payload = jwt.decode(token, SECRET_KEY, algorithms=[ALGORITHM])
  255. username: str = payload.get("sub")
  256. if username is None:
  257. raise credentials_exception
  258. token_data = models.TokenData(username=username)
  259. except JWTError:
  260. raise credentials_exception
  261. user = get_user(username=token_data.username)
  262. if user is None:
  263. raise credentials_exception
  264. user_id = first(db.query('SELECT * FROM users where username="' + user.username+'"'))['id']
  265. return user_id
  266. def check_user_exists(username):
  267. db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/AI_anchor?charset=utf8mb4')
  268. if int(next(iter(db.query('SELECT COUNT(*) FROM AI_anchor.users WHERE username = "'+username+'"')))['COUNT(*)']) > 0:
  269. return True
  270. else:
  271. return False
  272. def get_user(username: str):
  273. db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/AI_anchor?charset=utf8mb4')
  274. if not check_user_exists(username): # if user don't exist
  275. return False
  276. user_dict = next(
  277. iter(db.query('SELECT * FROM AI_anchor.users where username ="'+username+'"')))
  278. user = models.User(**user_dict)
  279. return user
  280. def user_register(user):
  281. db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/AI_anchor?charset=utf8mb4')
  282. table = db['users']
  283. user.password = get_password_hash(user.password)
  284. table.insert(dict(user))
  285. def get_password_hash(password):
  286. return pwd_context.hash(password)
  287. def verify_password(plain_password, hashed_password):
  288. return pwd_context.verify(plain_password, hashed_password)
  289. def authenticate_user(username: str, password: str):
  290. db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/AI_anchor?charset=utf8mb4')
  291. if not check_user_exists(username): # if user don't exist
  292. return False
  293. user_dict = next(iter(db.query('SELECT * FROM AI_anchor.users where username ="'+username+'"')))
  294. user = models.User(**user_dict)
  295. if not verify_password(password, user.password):
  296. return False
  297. return user
  298. def create_access_token(data: dict, expires_delta: Optional[timedelta] = None):
  299. to_encode = data.copy()
  300. if expires_delta:
  301. expire = datetime.utcnow() + expires_delta
  302. else:
  303. expire = datetime.utcnow() + timedelta(minutes=15)
  304. to_encode.update({"exp": expire})
  305. encoded_jwt = jwt.encode(to_encode, SECRET_KEY, algorithm=ALGORITHM)
  306. return encoded_jwt
  307. def save_history(req,name_hash,user_id):
  308. db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/AI_anchor?charset=utf8mb4')
  309. log_table = db['history_input']
  310. txt_content_seperate_by_dot = ''
  311. for txt in req.text_content:
  312. txt_content_seperate_by_dot += txt+","
  313. txt_content_seperate_by_dot = txt_content_seperate_by_dot[:-1]
  314. img_urls_seperate_by_dot = ''
  315. for iurl in req.image_urls:
  316. img_urls_seperate_by_dot += iurl+","
  317. img_urls_seperate_by_dot = img_urls_seperate_by_dot[:-1]
  318. time_stamp = datetime.fromtimestamp(time.time())
  319. time_stamp = time_stamp.strftime("%Y-%m-%d %H:%M:%S")
  320. pk = log_table.insert({'name':req.name,'text_content':txt_content_seperate_by_dot,'image_urls':img_urls_seperate_by_dot
  321. ,'user_id':user_id,'link':'www.choozmo.com:8168/'+video_sub_folder+name_hash+'.mp4','timestamp':time_stamp})
  322. def get_url_type(url):
  323. req = urllib.request.Request(url, method='HEAD', headers={'User-Agent': 'Mozilla/5.0'})
  324. r = urllib.request.urlopen(req)
  325. contentType = r.getheader('Content-Type')
  326. return contentType
  327. def notify_line_user(msg, line_token):
  328. headers = {
  329. "Authorization": "Bearer " + line_token,
  330. "Content-Type": "application/x-www-form-urlencoded"
  331. }
  332. params = {"message": msg}
  333. r = requests.post("https://notify-api.line.me/api/notify",headers=headers, params=params)
  334. def notify_group(msg):
  335. glist=['WekCRfnAirSiSxALiD6gcm0B56EejsoK89zFbIaiZQD']
  336. for gid in glist:
  337. headers = {
  338. "Authorization": "Bearer " + gid,
  339. "Content-Type": "application/x-www-form-urlencoded"
  340. }
  341. params = {"message": msg}
  342. r = requests.post("https://notify-api.line.me/api/notify",headers=headers, params=params)
  343. def gen_video(name_hash,name,text_content, image_urls,avatar):
  344. c = rpyc.connect("localhost", 8858)
  345. c._config['sync_request_timeout'] = None
  346. remote_svc = c.root
  347. my_answer = remote_svc.call_video(name_hash,name,text_content, image_urls,avatar) # method call
  348. shutil.copy(tmp_video_dir+name_hash+'.mp4',video_dest+name_hash+'.mp4')
  349. os.remove(tmp_video_dir+name_hash+'.mp4')
  350. def gen_video_eng(name_hash,name,text_content, image_urls,sub_titles,avatar):
  351. c = rpyc.connect("localhost", 8858)
  352. c._config['sync_request_timeout'] = None
  353. remote_svc = c.root
  354. my_answer = remote_svc.call_video_eng(name_hash,name,text_content, image_urls,sub_titles,avatar) # method call
  355. shutil.copy(tmp_video_dir+name_hash+'.mp4',video_dest+name_hash+'.mp4')
  356. os.remove(tmp_video_dir+name_hash+'.mp4')
  357. def gen_video_queue(name_hash,name,text_content, image_urls,avatar,user_id):
  358. db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/AI_anchor?charset=utf8mb4')
  359. time_stamp = datetime.fromtimestamp(time.time()).strftime("%Y-%m-%d %H:%M:%S")
  360. txt_content_seperate_by_dot = ''
  361. for txt in text_content:
  362. txt_content_seperate_by_dot += txt+","
  363. txt_content_seperate_by_dot = txt_content_seperate_by_dot[:-1]
  364. img_urls_seperate_by_dot = ''
  365. for iurl in image_urls:
  366. img_urls_seperate_by_dot += iurl+","
  367. img_urls_seperate_by_dot = img_urls_seperate_by_dot[:-1]
  368. db['video_queue'].insert({'name_hash':name_hash,'name':name,'text_content':txt_content_seperate_by_dot,'image_urls':img_urls_seperate_by_dot,'avatar':avatar,'timestamp':time_stamp})
  369. while True:
  370. if first(db.query('SELECT * FROM video_queue_status'))['status'] == 1:#only one row in this table, which is the id 1 one
  371. print('another process running, leave loop')#1 means already running
  372. break
  373. if first(db.query('SELECT COUNT(1) FROM video_queue'))['COUNT(1)'] == 0:
  374. print('all finish, leave loop')
  375. break
  376. top1 = first(db.query('SELECT * FROM video_queue'))
  377. try:
  378. # if True:
  379. db.query('UPDATE video_queue_status SET status = 1;')
  380. c = rpyc.connect("localhost", 8858)
  381. c._config['sync_request_timeout'] = None
  382. remote_svc = c.root
  383. my_answer = remote_svc.call_video(top1['name_hash'],top1['name'],top1['text_content'].split(','), top1['image_urls'].split(','),top1['avatar']) # method call
  384. shutil.copy(tmp_video_dir+top1['name_hash']+'.mp4',video_dest+top1['name_hash']+'.mp4')
  385. os.remove(tmp_video_dir+top1['name_hash']+'.mp4')
  386. vid_duration = VideoFileClip(video_dest+top1['name_hash']+'.mp4').duration
  387. user_obj = first(db.query('SELECT * FROM users where id ="'+str(user_id)+'"'))
  388. line_token = user_obj['line_token'] # aa
  389. left_time = user_obj['left_time']
  390. email = user_obj['email']
  391. print('left_time is '+str(left_time))
  392. if left_time is None:
  393. left_time = 5*60
  394. if left_time < vid_duration:
  395. msg = '您本月額度剩下'+str(left_time)+'秒,此部影片有'+str(vid_duration)+'秒, 若要繼續產生影片請至 192.168.1.106:8887/confirm_add_value?name_hash='+name_hash+' 加值'
  396. print(msg)
  397. msg =msg.encode(encoding='utf-8')
  398. mailer.send(msg, email)
  399. notify_line_user(msg, line_token)
  400. else:
  401. left_time = left_time - vid_duration
  402. db.query('UPDATE users SET left_time ='+str(left_time)+' WHERE id='+str(user_id)+';')
  403. notify_group(name+"的影片已經產生完成囉! www.choozmo.com:8168/"+video_sub_folder+name_hash+".mp4")
  404. notify_line_user(name+"的影片已經產生完成囉! www.choozmo.com:8168/"+video_sub_folder+name_hash+".mp4", line_token)
  405. except Exception as e:
  406. logging.error(traceback.format_exc())
  407. print('video generation error')
  408. notify_group('影片錯誤')
  409. db['video_queue'].delete(id=top1['id'])
  410. db.query('UPDATE video_queue_status SET status = 0')
  411. def gen_video_queue_eng(name_hash,name,text_content, image_urls,sub_titles,avatar):
  412. db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/AI_anchor?charset=utf8mb4')
  413. time_stamp = datetime.fromtimestamp(time.time()).strftime("%Y-%m-%d %H:%M:%S")
  414. txt_content_seperate_by_dot = ''
  415. for txt in text_content:
  416. txt_content_seperate_by_dot += txt+","
  417. txt_content_seperate_by_dot = txt_content_seperate_by_dot[:-1]
  418. img_urls_seperate_by_dot = ''
  419. for iurl in image_urls:
  420. img_urls_seperate_by_dot += iurl+","
  421. img_urls_seperate_by_dot = img_urls_seperate_by_dot[:-1]
  422. subtitles_seperate_by_dot = ''
  423. for sub in sub_titles:
  424. subtitles_seperate_by_dot += sub+","
  425. subtitles_seperate_by_dot = subtitles_seperate_by_dot[:-1]
  426. db['video_queue'].insert({'name_hash':name_hash,'name':name,'text_content':txt_content_seperate_by_dot,'image_urls':img_urls_seperate_by_dot,'subtitles':subtitles_seperate_by_dot,'avatar':avatar,'timestamp':time_stamp})
  427. while True:
  428. if first(db.query('SELECT * FROM video_queue_status'))['status'] == 1:#only one row in this table, which is the id 1 one
  429. print('another process running, leave loop')
  430. break
  431. if first(db.query('SELECT COUNT(1) FROM video_queue'))['COUNT(1)'] == 0:
  432. print('all finish, leave loop')
  433. break
  434. top1 = first(db.query('SELECT * FROM video_queue'))
  435. try:
  436. db.query('UPDATE video_queue_status SET status = 1;')
  437. c = rpyc.connect("localhost", 8858)
  438. c._config['sync_request_timeout'] = None
  439. remote_svc = c.root
  440. my_answer = remote_svc.call_video_eng(top1['name_hash'],top1['name'],top1['text_content'].split(','), top1['image_urls'].split(','),top1['subtitles'].split(','),top1['avatar']) # method call
  441. shutil.copy(tmp_video_dir+top1['name_hash']+'.mp4',video_dest+top1['name_hash']+'.mp4')
  442. os.remove(tmp_video_dir+top1['name_hash']+'.mp4')
  443. except:
  444. print('video generation error')
  445. notify_group('影片錯誤')
  446. db['video_queue'].delete(id=top1['id'])
  447. db.query('UPDATE video_queue_status SET status = 0')
  448. def gen_avatar(name_hash, imgurl):
  449. db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/AI_anchor?charset=utf8mb4')
  450. db['avatar_queue'].insert({'name_hash':name_hash,'imgurl':imgurl})
  451. while True:
  452. statement = 'SELECT * FROM avatar_service_status'#only one row in this table, which is the id 1 one
  453. status = -1
  454. for row in db.query(statement):
  455. status = row['status']
  456. if status == 1:
  457. print('leave process loop')
  458. break
  459. statement = 'SELECT * FROM avatar_queue'
  460. works = []
  461. for row in db.query(statement):
  462. works.append({'id':row['id'],'name_hash':row['name_hash'],'imgurl':row['imgurl']})
  463. if len(works)==0:
  464. print('leave process loop')
  465. break
  466. try:
  467. statement = 'UPDATE avatar_service_status SET status = 1 WHERE id=1;'
  468. db.query(statement)
  469. name_hash = works[0]['name_hash']
  470. imgurl = works[0]['imgurl']
  471. c = rpyc.connect("localhost", 8868)
  472. c._config['sync_request_timeout'] = None
  473. remote_svc = c.root
  474. my_answer = remote_svc.call_avatar(name_hash,imgurl) # method call
  475. shutil.copy(tmp_avatar_dir+name_hash+'.mp4',avatar_dest+name_hash+'.mp4')
  476. os.remove(tmp_avatar_dir+name_hash+'.mp4')
  477. except:
  478. print('gen error')
  479. notify_group('無法辨識人臉')
  480. db['avatar_queue'].delete(id=works[0]['id'])
  481. statement = 'UPDATE avatar_service_status SET status = 0 WHERE id=1;' #only one row in this table, which id 1 one
  482. db.query(statement)