Few‐shot Prompting Exemplars

USER: Current Time: [2023-11-23 20:25:39]

CATEGORY(id, title): (1, "과제"), (2, "잡일"), (3, "운동"), (4, "약속"), (5, "시험"), (6, "봉사")

TODO(id, title): (1, "쓰레기 버리기"), (2, "밥먹기"), (3, "키보드 사기"), (4, "닭가슴살 시키기"), (5, "엄마한테 전화하기"), (6, "알고리즘 과제2"), (7, "알고리즘 과제1"), (8, "인공지능 과제"), (9, "소개원실 회의"), (10, "회의"), (11, "컴퓨터 구조 과제")

SCHEDULE(id, title): (1, "신영이랑 밥먹기"), (2, "알고리즘 수업"), (3, "헬스'), (4, "과외"), (5, "데이트"), (6, "자전거 타기'), (7, "디자인 워크샵"), (8, "영화감상회"), (9, "신영이랑 커피"), (10, "고급 수학 과외")

USER: //Enforce direct search on title instead of WHERE condition. Fix omitting behavior of other conditions such as time when searching on title. 23년 11월 18일 컴퓨터구조 과제 삭제해줘

ASSISTANT: "DELETE FROM TODO WHERE id=11 AND date(due_time)='2023-11-18';"

USER: //Use condition on catetgory instead of searching for all plan titles 내일 과제 모두 삭제

ASSISTANT: "DELETE FROM TODO WHERE category_id=1 AND date(due_time)='2023-11-24';”

USER: //Automatically categorize new plans 내일 8시 알골 과제 추가

ASSISTANT: "INSERT INTO TODO (title, due_time, category_id) VALUES ('알골 과제', '2023-11-24 08:00:00', 1);"

USER: //When time is not specified by the hour, consider plan as TODO. 이번 달 매주 화요일에 헬스하기 추가해줘

ASSISTANT: "INSERT INTO TODO(title, due_time) VALUES('헬스하기', '2023-11-07 23:59:59'), ('헬스하기', '2023-11-14 23:59:59'), ('헬스하기', '2023-11-21 23:59:59'), ('헬스하기', '2023-11-28 23:59:59');”

USER: //When user request change of plan type, delete and insert with corresponding values. 키보드 사기를 스케쥴로 바꿔줘.

ASSISTANT: "INSERT INTO SCHEDULE (title, start_time, end_time, memo, category_id, priority) SELECT title, due_time, due_time, memo, category_id, priority FROM TODO WHERE id=3; DELETE FROM TODO WHERE id=3"

USER: //When user request change of plan type, delete and insert with corresponding values. 신영이랑 밥먹기를 투두로 바꿔줘.

ASSISTANT: "INSERT INTO TODO (title, due_time, memo, category_id, priority) SELECT title, start_time, memo, category_id, priority FROM SCHEDULE WHERE id=1; DELETE FROM SCHEDULE WHERE id=1;"

USER: //When using WHERE condition on month, use LIKE to minimize query length 이번달 과제 모두 삭제해줘.

ASSISTANT: "DELETE FROM TODO WHERE category_id=1 AND date(due_time) LIKE '2023-11%';"

USER: //When searching based on ‘남은 거’, use current time as pivot 오늘 남은거 삭제해줘

ASSISTANT: "DELETE FROM TODO WHERE due_time>'2023-11-23 20:25:39' AND date(due_time)='2023-11-23'; DELETE FROM SCHEDULE WHERE start_time>'2023-11-23 20:25:39' AND date(end_time)='2023-11-23';"

USER: //Fix bug of adding requested time to the current time twice 3시간 후에 밥먹기

ASSISTANT: "INSERT INTO TODO (title, due_time) VALUES ('밥먹기', '2023-11-23 23:25:39');"

USER: //A week spans from Monday to Sunday 이번주 목요일에 알골 과제 추가

ASSISTANT: "INSERT INTO TODO (title, due_time, category_id) VALUES ('알골 과제', '2023-11-23 23:59:59', 1);"

USER: //Understand vague referencing of existing plans 밥먹기 3시간 이후에 공과금 내기

ASSISTANT: "INSERT INTO TODO (title, due_time) SELECT '공과금 내기', datetime(due_time, '+3 hours') FROM TODO WHERE id=2;"

USER: //Fix bug of interpreting ‘아침’ as midnight 내일 아침에 밥먹기

ASSISTANT: "INSERT INTO TODO (title, due_time) VALUES ('밥먹기', '2023-11-24 08:00:00');"