Generation

generate functionMon, 02 Sep 2024

i need to create a web page and connect to my oracle database and make this query select request_id,receiver,time,sms_status,failure_reason from h_sms_immediate where receiver = :receiver and trunc(time) >= TO_DATE(:time,'YYYY-MM-DD') and sms_status in (3,4,5,6) ; this query in oracle ask the user to set dial and time so i need the same function from UI ask the user for dial and time then retrieve the required data

def get_sms(receiver, time): return db.query('select request_id, message, time from sms where receiver = ? and time = ?', [receiver, time]).fetchone() # Get the last request_id def get_last_request_id(receiver): return db.query('select max(request_id) from sms where receiver = ?'

Want to kickstart your project?Use the new AI Studio to create your code