def search(self, word):
res = self.sql.query(DictJA)\
.filter(DictJA.word == word)\
.first()
if res:
return {'status': 'duplicated', 'result': result_parse(res)}
else:
return {
'status': 'success',
}
def query(self, kana):
res = self.sql.query(DictJA)\
.filter(DictJA.detail.has(DictJADetail.kana == jaconv.kata2hira(kana)))\
.all()
if res:
return {
'status': 'duplicated',
'results': [result_parse(r) for r in res]
}
else:
return {
'status': 'success',
}
def save(self, data):
if 'audio' in data:
audio = data['audio']
if type(audio) == list:
name_list = []
for a in audio:
if a['url'].find('forvo') > -1:
data['forvo'] = True
response = requests.get(a['url'], headers=headers)
audio_data = compress_mp3(response.content)
audio_name = a['file_name'].replace(' ', '') + '.mp3'
self.save_to_s3(audio_name, audio_data)
name_list.append(audio_name)
data['audio'] = ','.join(name_list)
else:
if audio.find('forvo') > -1:
data['forvo'] = True
response = requests.get(audio, headers=headers)
audio_data = compress_mp3(response.content)
audio_name = data['word'] + '.mp3'
self.save_to_s3(audio_name, audio_data)
data['audio'] = audio_name
if 'image' in data:
image_name = str(uuid.uuid4()) + '.jpg'
self.save_to_s3('image/' + image_name,
base64_to_jpg(data['image']))
data['image'] = image_name
if 'kana' in data:
data['kana'] = jaconv.kata2hira(data['kana']).replace(' ',
'').replace(
' ', '')
data_ = {'word': data.pop('word')}
data_['new'] = True
for key in ['need_update', 'type', 'addReverse']:
if key in data:
data_[key] = data.pop(key)
# テーブルinstance作成
dict_ja_detail = DictJADetail(**data)
data_['detail'] = dict_ja_detail
dict_ja = DictJA(**data_)
# sessionに追加
self.sql.add(dict_ja)
# sessionデータをMySQLに更新する
self.sql.commit()
# データベースと一致させる
self.sql.refresh(dict_ja)
result = result_parse(dict_ja)
return {"status": 'success', "result": result}
def add_alternative_word(self, data):
res = self.sql.query(DictJA)\
.filter(DictJA.word == data['word'])\
.first()
if res:
return {"status": 'error', "error_detail": 'もう追加された'}
dict_ja = DictJA(**data)
# sessionに追加
self.sql.add(dict_ja)
# sessionデータをMySQLに更新する
self.sql.commit()
# データベースと一致させる
self.sql.refresh(dict_ja)
result = result_parse(dict_ja)
return {"status": 'success', "result": result}
def update(self, data):
id = data.pop('id')
raw = self.sql.query(DictEN)\
.filter(DictEN.id == id)\
.first()
if 'image' in data:
image_name = str(uuid.uuid4()) + '.jpg'
self.save_to_s3('image/' + image_name,
base64_to_jpg(data['image']))
data['image'] = image_name
for key in data:
setattr(raw.detail, key, data[key])
raw.has_updated = True
# sessionデータをMySQLに更新する
self.sql.commit()
# データベースと一致させる
self.sql.refresh(raw)
result = result_parse(raw)
return {"status": 'success', "result": result}