neubig

# NOTE:
# You can find an updated, more robust and feature-rich implementation
# in Zeno Build
# - Zeno Build: https://github.com/zeno-ml/zeno-build/
# - Implementation: https://github.com/zeno-ml/zeno-build/blob/main/zeno_build/models/providers/openai_utils.py

import openai
import asyncio
from typing import Any

kachok

create table dictionary_dump_20120504 as
select l.prefix, v.id, v.word, vhr.translation, a.worker_id, p.quality, p.total 
from voc_hits_results vhr, languages l, vocabulary v, assignments a, voc_hits_workers_performance p 

where 
a.id=vhr.assignment_id and
p.id=a.worker_id and p.language_id=l.id and
vhr.is_control=1 and vhr.quality=1
and v.id=vhr.word_id
and v.language_id=l.id