def main(from_java_string):
fj_string = from_java_string
group_id_start = len('group_id=')
group_id_start += 1
group_id_end = fj_string.find(',')
group_id = fj_string[group_id_start:group_id_end]
item_id_start = fj_string.find('item_id')
item_id_start += len('item_id')
item_id_start += 1
item_id = fj_string[item_id_start:-1]
print (group_id + item_id, flush=True)
#items = []
to_jikkyolizer_data = JikkyolizerAccess()
#if item_id is None: #false
if isinstance(item_id, str):
dummy = 'aaa'
else:
dummy = 'ccc'
#if group_id is None: #false
if isinstance(group_id, str):
dummy2 = 'bbb'
else:
dummy2 = 'ddd'
try:
to_jikkyolizer_data.dict_insert('sox_jikkyolized',{ 'group_id':group_id, 'item_id':item_id, 'total_number':0 })
except:
#f.write('group_id=' + group_id + ', item_id=' +item_id + '\n')
#f.flush()
pass
return item_id, str(type(item_id))
def main(from_jikkyolizer_string):
group_id, item_id, raw_value, row_timestamp = parse_arg(
from_jikkyolizer_string)
if judge_item_kind(raw_value) == float:
raw_value = '{0:4.4g}'.format(raw_value)
to_outer = [group_id, item_id, raw_value, row_timestamp]
to_jikkyolizer_data = JikkyolizerAccess()
to_jikkyolizer_data.dict_insert(
'sox_data', {
'group_id': group_id,
'item_id': item_id,
'raw_value': raw_value,
'row_timestamp': row_timestamp
})
jikkyolize_flag = insert_jikkyolized(item_id, group_id, raw_value,
row_timestamp, to_jikkyolizer_data)
last_change = insert_last_data(item_id, group_id, raw_value, row_timestamp,
to_jikkyolizer_data)
raw_ok, last_ok, jikkyolized_ok = check_too_past(to_jikkyolizer_data)
item_blacklist = [
'longitude', 'latitude', 'url', 'address', '運行状況', '遅延時配信日時', 'image',
'URL', 'TEL'
]
if item_id in item_blacklist:
return 0
raw_value_blacklist = ['', '-']
if raw_value == raw_value_blacklist or len(raw_value) > 200:
return 0
#raw_ok, last_ok, jikkyolized_ok = number_voices(to_jikkyolizer_data)
SearchRelation(to_outer)
jikkyolized = 0
if jikkyolized_ok == 1:
if jikkyolize_flag == 'upper_jikkyolized':
JikkyolizerVocalize(item_id, group_id, raw_value, row_timestamp,
'upper_jikkyolized', 2, last_change)
jikkyolized = 1
elif jikkyolize_flag == 'lower_jikkyolized':
JikkyolizerVocalize(item_id, group_id, raw_value, row_timestamp,
'lower_jikkyolized', 2, last_change)
jikkyolized = 1
elif jikkyolize_flag == 'max_jikkyolized':
JikkyolizerVocalize(item_id, group_id, raw_value, row_timestamp,
'max_jikkyolized', 1, last_change)
jikkyolized = 1
elif jikkyolize_flag == 'min_jikkyolized':
JikkyolizerVocalize(item_id, group_id, raw_value, row_timestamp,
'min_jikkyolized', 1, last_change)
jikkyolized = 1
if last_ok == 1 and jikkyolized == 0 and last_change == 1:
JikkyolizerVocalize(item_id, group_id, raw_value, row_timestamp,
'last_changed', 3, last_change)
jikkyolized = 1
if raw_ok == 1 and jikkyolized == 0:
JikkyolizerVocalize(item_id, group_id, raw_value, row_timestamp,
'raw_data', 4, last_change)
jikkyolized = 1
def fetch_new_voice(past_voices):
to_voice_data = JikkyolizerAccess()
sql = 'select * from voice_prior order by vocalize_prior asc, insert_timestamp desc;'
to_voice_data.cursor.execute(sql)
voice_priority = to_voice_data.cursor.fetchall()
for voice_pri in voice_priority:
if '{0:07d}'.format(voice_pri['ID']) in past_voices.values():
pass
else:
return voice_pri['ID']
return 0
def main(from_java_string):
fj_string = from_java_string
group_id_start = len('group_id=')
group_id_start += 1
group_id_end = fj_string.find(',')
group_id = fj_string[group_id_start:group_id_end]
item_id_start = fj_string.find('item_id')
item_id_start += len('item_id')
item_id_start += 1
item_id_end = fj_string.find(',')
item_id = fj_string[item_id_start:item_id_end]
#item_id = fj_string[item_id_start:-1]
group_name_start = fj_string.find('group_name')
group_name_start += len('group_name')
group_name_start += 1
group_name = fj_string[group_name:-1]
print(group_id + item_id + group_name, flush=True)
#items = []
to_jikkyolizer_data = JikkyolizerAccess()
#if item_id is None: #false
if isinstance(item_id, str):
dummy = 'aaa'
else:
dummy = 'ccc'
#if group_id is None: #false
if isinstance(group_id, str):
dummy2 = 'bbb'
else:
dummy2 = 'ddd'
try:
to_jikkyolizer_data.dict_insert('sox_jikkyolized', {
'group_id': group_id,
'item_id': item_id,
'total_number': 0
})
except:
#f.write('group_id=' + group_id + ', item_id=' +item_id + '\n')
#f.flush()
pass
pre_ID = to_jikkyolizer_data.dict_select('sox_jikkyolized', {
'group_id': group_id,
'item_id': item_id
})
voice_ID = '{0:07d}'.format(pre_ID[0]['ID'])
pre_ID = to_jikkyolizer_data.dict_insert('sox_id_name_relation', {
'device_id': group_id,
'device_name': item_id
})
MakeVoice.raw_vocalize(group_name + 'の' + item_id, 'group_item',
'id-' + voice_ID)
return item_id, str(type(item_id))
def main(from_jikkyolizer_string):
group_id, item_id, raw_value, row_timestamp = parse_arg(
from_jikkyolizer_string)
to_jikkyolizer_data = JikkyolizerAccess()
to_jikkyolizer_data.dict_insert(
'sox_data', {
'group_id': group_id,
'item_id': item_id,
'raw_value': raw_value,
'row_timestamp': row_timestamp
})
insert_jikkyolized(item_id, group_id, raw_value, row_timestamp,
to_jikkyolizer_data)
def ex_main():
to_jikkyolizer_data = JikkyolizerAccess()
to_jikkyolizer_data.dict_insert('sox_jikkyolized',{ 'group_id':'"123"', 'item_id':'ううう' })
def __init__(self, item_id, group_id, raw_value, row_timestamp, reason,
vocalize_prior, is_change, rel_flag, relations):
to_vocalize_data = JikkyolizerAccess()
sql = 'SELECT auto_increment FROM information_schema.tables WHERE table_name = "voice_prior";'
to_vocalize_data.cursor.execute(sql)
jikkyo_id_pre = to_vocalize_data.cursor.fetchone()
jikkyo_id = jikkyo_id_pre['auto_increment']
voice_prior_dicts = {
'vocalize_kind': reason,
'vocalize_prior': vocalize_prior,
'group_id': group_id,
'item_id': item_id,
'raw_value': raw_value,
'row_timestamp': row_timestamp,
'relation_reason': rel_flag,
'voice_0': 1,
'voice_1': 1,
'voice_2': 1,
'voice_3': 1,
'voice_4': 1,
'voice_5': 0,
'voice_6': 0,
'voice_7': 0
}
if reason == 'raw_data' and reason == 'last_changed':
pass
elif reason == 'upper_jikkyolized' or reason == 'lower_jikkyolized' or reason == 'max_jikkyolized' or reason == 'min_jikkyolized':
voice_prior_dicts['voice_5'] = 1
if rel_flag != 'No_relation' and rel_flag != 'No_speciality':
voice_prior_dicts['voice_6'] = 1
voice_prior_dicts['voice_7'] = 1
to_vocalize_data.dict_insert('voice_prior', voice_prior_dicts)
voice_prior_dicts['ID'] = jikkyo_id
to_vocalize_data.dict_insert('voice_prior_record', voice_prior_dicts)
jikkyo_id7 = '{0:07d}'.format(jikkyo_id)
how_ago = int(time.mktime(datetime.now().timetuple())) - int(
datetime.strptime(row_timestamp,
'%Y-%m-%d %H:%M:%S').strftime('%s'))
how_ago_second = how_ago % 60
how_ago_minute = int(how_ago % 3600 / 60)
how_ago_hour = int(how_ago % 86400 / 3600)
vocalize_sentence = '今から'
if how_ago_minute < 1:
vocalize_sentence += str(how_ago_second) + '秒まえ、'
elif how_ago_minute >= 1 and how_ago_hour < 1:
vocalize_sentence += str(how_ago_minute) + '分まえ、'
else:
vocalize_sentence += str(how_ago_hour) + '時間まえ、'
cmd = 'curl "https://api.voicetext.jp/v1/tts" -u "mpbw1hnrp32pdde7:" -d "text= \'' + vocalize_sentence + '\'" -d "speaker=hikari" -d "speed=100" -o /var/www/html/voices/jikkyo-' + jikkyo_id7 + '-0.wav'
subprocess.call(cmd, shell=True)
vocalize_sentence = group_id + 'の' + item_id
cmd = 'curl "https://api.voicetext.jp/v1/tts" -u "mpbw1hnrp32pdde7:" -d "text= \'' + vocalize_sentence + '\'" -d "speaker=hikari" -d "speed=100" -d "pitch=100" -d "volume=100" -o /var/www/html/voices/jikkyo-' + jikkyo_id7 + '-1.wav'
subprocess.call(cmd, shell=True)
vocalize_sentence = 'の値が'
cmd = 'curl "https://api.voicetext.jp/v1/tts" -u "mpbw1hnrp32pdde7:" -d "text= \'' + vocalize_sentence + '\'" -d "speaker=hikari" -d "speed=100" -o /var/www/html/voices/jikkyo-' + jikkyo_id7 + '-2.wav'
subprocess.call(cmd, shell=True)
vocalize_sentence = str(raw_value)
cmd = 'curl "https://api.voicetext.jp/v1/tts" -u "mpbw1hnrp32pdde7:" -d "text= \'' + vocalize_sentence + '\'" -d "speaker=hikari" -d "speed=100" -o /var/www/html/voices/jikkyo-' + jikkyo_id7 + '-3.wav'
subprocess.call(cmd, shell=True)
if is_change == 1:
vocalize_sentence = 'になりました。'
else:
vocalize_sentence = 'を示しました。'
cmd = 'curl "https://api.voicetext.jp/v1/tts" -u "mpbw1hnrp32pdde7:" -d "text= \'' + vocalize_sentence + '\'" -d "speaker=hikari" -d "speed=100" -o /var/www/html/voices/jikkyo-' + jikkyo_id7 + '-4.wav'
subprocess.call(cmd, shell=True)
if reason == 'upper_jikkyolized':
vocalize_sentence = 'これはとても高い値です。'
cmd = 'curl "https://api.voicetext.jp/v1/tts" -u "mpbw1hnrp32pdde7:" -d "text= \'' + vocalize_sentence + '\'" -d "speaker=hikari" -d "speed=100" -d "pitch=100" -d "volume=100" -o /var/www/html/voices/jikkyo-' + jikkyo_id7 + '-5.wav'
subprocess.call(cmd, shell=True)
elif reason == 'lower_jikkyolized':
vocalize_sentence = 'これはとても低い値です。'
cmd = 'curl "https://api.voicetext.jp/v1/tts" -u "mpbw1hnrp32pdde7:" -d "text= \'' + vocalize_sentence + '\'" -d "speaker=hikari" -d "speed=100" -d "pitch=100" -d "volume=100" -o /var/www/html/voices/jikkyo-' + jikkyo_id7 + '-5.wav'
subprocess.call(cmd, shell=True)
elif reason == 'max_jikkyolized':
vocalize_sentence = 'これは今までで最高の値です。'
cmd = 'curl "https://api.voicetext.jp/v1/tts" -u "mpbw1hnrp32pdde7:" -d "text= \'' + vocalize_sentence + '\'" -d "speaker=hikari" -d "speed=100" -d "pitch=100" -d "volume=100" -o /var/www/html/voices/jikkyo-' + jikkyo_id7 + '-5.wav'
subprocess.call(cmd, shell=True)
elif reason == 'min_jikkyolized':
vocalize_sentence = 'これは今までで最低の値です。'
cmd = 'curl "https://api.voicetext.jp/v1/tts" -u "mpbw1hnrp32pdde7:" -d "text= \'' + vocalize_sentence + '\'" -d "speaker=hikari" -d "speed=100" -d "pitch=100" -d "volume=100" -o /var/www/html/voices/jikkyo-' + jikkyo_id7 + '-5.wav'
subprocess.call(cmd, shell=True)
if rel_flag != 'No_relation' and rel_flag != 'No_speciality':
vocalize_sentence = 'なお、同種類の' + relations + 'の値の中で'
cmd = 'curl "https://api.voicetext.jp/v1/tts" -u "mpbw1hnrp32pdde7:" -d "text= \'' + vocalize_sentence + '\'" -d "speaker=hikari" -d "speed=100" -o /var/www/html/voices/jikkyo-' + jikkyo_id7 + '-6.wav'
subprocess.call(cmd, shell=True)
if rel_flag == 'rel_max':
vocalize_sentence = '最高の値を示しています。'
cmd = 'curl "https://api.voicetext.jp/v1/tts" -u "mpbw1hnrp32pdde7:" -d "text= \'' + vocalize_sentence + '\'" -d "speaker=hikari" -d "speed=100" -d "pitch=100" -d "volume=100" -o /var/www/html/voices/jikkyo-' + jikkyo_id7 + '-7.wav'
subprocess.call(cmd, shell=True)
if rel_flag == 'rel_min':
vocalize_sentence = '最低の値を示しています。'
cmd = 'curl "https://api.voicetext.jp/v1/tts" -u "mpbw1hnrp32pdde7:" -d "text= \'' + vocalize_sentence + '\'" -d "speaker=hikari" -d "speed=100" -d "pitch=100" -d "volume=100" -o /var/www/html/voices/jikkyo-' + jikkyo_id7 + '-7.wav'
subprocess.call(cmd, shell=True)
if rel_flag == 'rel_much':
vocalize_sentence = 'とても高い値を示しています。'
cmd = 'curl "https://api.voicetext.jp/v1/tts" -u "mpbw1hnrp32pdde7:" -d "text= \'' + vocalize_sentence + '\'" -d "speaker=hikari" -d "speed=100" -d "pitch=100" -d "volume=100" -o /var/www/html/voices/jikkyo-' + jikkyo_id7 + '-7.wav'
subprocess.call(cmd, shell=True)
if rel_flag == 'rel_little':
vocalize_sentence = 'とても低い値を示しています。'
cmd = 'curl "https://api.voicetext.jp/v1/tts" -u "mpbw1hnrp32pdde7:" -d "text= \'' + vocalize_sentence + '\'" -d "speaker=hikari" -d "speed=100" -d "pitch=100" -d "volume=100" -o /var/www/html/voices/jikkyo-' + jikkyo_id7 + '-7.wav'
subprocess.call(cmd, shell=True)
def __init__(self, group_id = None, item_id = None): self.ja = JikkyolizerAccess() self.group_id = group_id self.item_id = item_id self.search_sessions = ['week', 'month', 'year']
def __init__(self):
self.relation_access = JikkyolizerAccess()
def main(from_jikkyolizer_string):
group_id, item_id, raw_value, row_timestamp = parse_arg(
from_jikkyolizer_string)
d_time = datetime.strptime(
row_timestamp,
'%Y-%m-%d %H:%M:%S') # + timedelta(minutes=21) #この部分、ワンチャン直った？
row_timestamp = d_time.strftime('%Y-%m-%d %H:%M:%S')
if judge_item_kind(raw_value) == float:
raw_value = '{0:4.4g}'.format(raw_value)
to_jikkyolizer_data = JikkyolizerAccess()
to_jikkyolizer_data.dict_insert(
'sox_data', {
'group_id': group_id,
'item_id': item_id,
'raw_value': raw_value,
'row_timestamp': row_timestamp
})
jikkyolize_flag, rel_flag, relations = insert_jikkyolized(
item_id, group_id, raw_value, row_timestamp, to_jikkyolizer_data)
last_change = insert_last_data(item_id, group_id, raw_value, row_timestamp,
to_jikkyolizer_data)
raw_ok, last_ok, jikkyolized_ok = check_too_past(to_jikkyolizer_data)
item_blacklist = [
'longitude', 'latitude', 'url', 'address', '運行状況', '遅延時配信日時', 'image',
'URL', 'TEL', 'ジャンル', '住所', '交通手段', '営業時間'
]
if item_id in item_blacklist:
return 0
raw_value_blacklist = ['', '-']
if raw_value == raw_value_blacklist or len(raw_value) > 200:
return 0
#raw_ok, last_ok, jikkyolized_ok = number_voices(to_jikkyolizer_data)
jikkyolized = 0
if jikkyolized_ok == 1:
if jikkyolize_flag == 'upper_jikkyolized':
JikkyolizerVocalize(item_id, group_id, raw_value, row_timestamp,
'upper_jikkyolized', 2, last_change, rel_flag,
relations)
jikkyolized = 1
elif jikkyolize_flag == 'lower_jikkyolized':
JikkyolizerVocalize(item_id, group_id, raw_value, row_timestamp,
'lower_jikkyolized', 2, last_change, rel_flag,
relations)
jikkyolized = 1
elif jikkyolize_flag == 'max_jikkyolized':
JikkyolizerVocalize(item_id, group_id, raw_value, row_timestamp,
'max_jikkyolized', 1, last_change, rel_flag,
relations)
jikkyolized = 1
elif jikkyolize_flag == 'min_jikkyolized':
JikkyolizerVocalize(item_id, group_id, raw_value, row_timestamp,
'min_jikkyolized', 1, last_change, rel_flag,
relations)
jikkyolized = 1
elif relations == 'rel_max' or relations == 'rel_min' or relations == 'rel_little' or relations == 'rel_much':
JikkyolizerVocalize(item_id, group_id, raw_value, row_timestamp,
'raw_data', 2, last_change, rel_flag,
relations)
return 0
if last_ok == 1 and jikkyolized == 0 and last_change == 1:
JikkyolizerVocalize(item_id, group_id, raw_value, row_timestamp,
'last_changed', 3, last_change, rel_flag,
relations)
jikkyolized = 1
if raw_ok == 1 and jikkyolized == 0:
JikkyolizerVocalize(item_id, group_id, raw_value, row_timestamp,
'raw_data', 4, last_change, rel_flag, relations)
jikkyolized = 1
