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 = ?'