Spaces:

fudii0921
/

db2html

Sleeping

Update app.py

8e5e795 verified over 1 year ago

2.88 kB

import gradio as gr
import requests
import json
    
def upload_text_to_server(text, url, fname):
    try:
        # テキストを送信
        payload = {"content": text, "filename": fname}
        response = requests.post(url, data=payload)

        # HTTPステータスコードを確認
        response.raise_for_status()  # エラーがあれば例外を発生させる
        return response.status_code, response.text

    except requests.exceptions.RequestException as e:
        # エラー処理
        print(f"Error occurred during the request: {e}")
        return None, str(e)

# 自然言語にする関数
def json_to_text(outname, param_array, tablename):
    parms = eval(param_array)
    # Fetch JSON data from the API
    dataid = requests.get("https://www.ryhintl.com/dbjson/getjson?sqlcmd=select * from "+tablename)

    # Decode the JSON response
    data_str = dataid.content.decode('utf-8')
    data = json.loads(data_str)

    final_context = ""
    for item in data:
        text = ""
        # Dynamically fetch values based on the parameter array
        for param in parms:
            if param in item:  # Ensure the key exists in the item
                text += f"{param}: {item[param]}\n"
            else:
                text += f"{param}: [値が見つかりません]\n"
        final_context += text + "\n"  # Append each item's data to final_context

    # Save the final_context to a file
    file_name = outname
    with open(file_name, "w", encoding="utf-8") as file:
        file.write(final_context)

    # Server URL for upload
    server_url = "https://www.ryhintl.com/company_matters.php"

    # Upload the final_context to the server
    status, response_text = upload_text_to_server(final_context, server_url, outname)

    data = json.loads(response_text)

    # メッセージを取得
    message = data.get("message", "")

    print(f"アップロードのステータス: {status}")
    print(f"レスポンス: {message}")
    
    #return response_text
    return message


# Gradioの関数
def search(outname,params,tablename):
    result = json_to_text(outname,params,tablename)
    return result

# Gradioインターフェース
interface = gr.Interface(
    css="footer {visibility: hidden;}",
    theme=gr.themes.Glass(),
    fn=search,
    inputs=[gr.Textbox(label="出力ファイル名",value="cm_output.html"), gr.Textbox(label="パラメーター",value="['caption','title','content','date']"), gr.Textbox(label="テーブル名",value="company_matters")],
    outputs=gr.Textbox(label="結果"),
    title="DB HTML",
    description="MySQLのテーブルからデータを取得し、Agent用のHTMLを生成します。",
    submit_btn="実行",
    stop_btn="中止",
    clear_btn="クリア",
    flagging_mode="never"
)

# アプリの実行
if __name__ == "__main__":
    interface.launch()

	import gradio as gr
	import requests
	import json

	def upload_text_to_server(text, url, fname):
	try:
	# テキストを送信
	payload = {"content": text, "filename": fname}
	response = requests.post(url, data=payload)

	# HTTPステータスコードを確認
	response.raise_for_status() # エラーがあれば例外を発生させる
	return response.status_code, response.text

	except requests.exceptions.RequestException as e:
	# エラー処理
	print(f"Error occurred during the request: {e}")
	return None, str(e)

	# 自然言語にする関数
	def json_to_text(outname, param_array, tablename):
	parms = eval(param_array)
	# Fetch JSON data from the API
	dataid = requests.get("https://www.ryhintl.com/dbjson/getjson?sqlcmd=select * from "+tablename)

	# Decode the JSON response
	data_str = dataid.content.decode('utf-8')
	data = json.loads(data_str)

	final_context = ""
	for item in data:
	text = ""
	# Dynamically fetch values based on the parameter array
	for param in parms:
	if param in item: # Ensure the key exists in the item
	text += f"{param}: {item[param]}\n"
	else:
	text += f"{param}: [値が見つかりません]\n"
	final_context += text + "\n" # Append each item's data to final_context

	# Save the final_context to a file
	file_name = outname
	with open(file_name, "w", encoding="utf-8") as file:
	file.write(final_context)

	# Server URL for upload
	server_url = "https://www.ryhintl.com/company_matters.php"

	# Upload the final_context to the server
	status, response_text = upload_text_to_server(final_context, server_url, outname)

	data = json.loads(response_text)

	# メッセージを取得
	message = data.get("message", "")

	print(f"アップロードのステータス: {status}")
	print(f"レスポンス: {message}")

	#return response_text
	return message


	# Gradioの関数
	def search(outname,params,tablename):
	result = json_to_text(outname,params,tablename)
	return result

	# Gradioインターフェース
	interface = gr.Interface(
	css="footer {visibility: hidden;}",
	theme=gr.themes.Glass(),
	fn=search,
	inputs=[gr.Textbox(label="出力ファイル名",value="cm_output.html"), gr.Textbox(label="パラメーター",value="['caption','title','content','date']"), gr.Textbox(label="テーブル名",value="company_matters")],
	outputs=gr.Textbox(label="結果"),
	title="DB HTML",
	description="MySQLのテーブルからデータを取得し、Agent用のHTMLを生成します。",
	submit_btn="実行",
	stop_btn="中止",
	clear_btn="クリア",
	flagging_mode="never"
	)

	# アプリの実行
	if __name__ == "__main__":
	interface.launch()