Spaces:
Runtime error
Runtime error
File size: 1,473 Bytes
0e12014 b87ab87 0e12014 b87ab87 0e12014 b87ab87 0e12014 b87ab87 0e12014 b87ab87 0e12014 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
import gradio as gr
import json
def split(value):
return value.split(",")
def merge_texts(text1, text2):
paket_id_by_pr_id = dict(map(split, text1.splitlines()))
datasets = list(map(split, text2.splitlines()))
output = { dataset[0]: {"car_id": dataset[1], "client_id": dataset[2], "origin": "team", "packet_id": paket_id_by_pr_id[dataset[0]] } for dataset in datasets }
return json.dumps(output, indent=2)
demo = gr.Interface(
merge_texts,
[
gr.Textbox(
label="[prereserve_id,packet_id]",
info="""[select id,
case when service_id = 16106 then 16 when service_id = 16107 then 17 end as packet_id,
status
from prereserves
where service_id in (16106, 16107) and status = 'ACTIVE' and client_id = 49795 order by id;]""",
placeholder="9371,17\n9390,16\n9391,17\n9393,16\n9397,17\n...",
lines=15,
),
gr.Textbox(
label="[prereserve_id,car_id,client_id]",
info="SELECT prereserve_id, car_id, client_id FROM car_prereserves WHERE prereserve_id in(...)",
placeholder="9371,25668,70633\n9390,45233,103994\n9391,45233,103994\n9393,37033,47747\n9397,12914,12358\n...",
lines=15,
),
],
#"textbox",
#gr.HTML(),
#gr.JSON(),
gr.Code(
language="json"
),
theme=gr.themes.Base()
)
demo.launch()
|