Skip to content

fearofgod0001/ScheduleInfo

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

54 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation




yarn add react-big-calendar
npm install --save react-big-calendar

DB DDL

TABLE

       CREATE TABLE "SCOTT"."SCHEDULEINFO" 
	     (	
	        "CALELDAR_ID" NUMBER(*,0), 
	  	"USER_ID" VARCHAR2(255), 
	  	"TITLE" VARCHAR2(255), 
	  	"ALLDAY" VARCHAR2(19),
	  	"START_DATE" DATE, 
	  	"END_DATE" DATE, 
	  	"MEMO" CLOB
	     )

SEQUENCE

	CREATE SEQUENCE SEQ_CALENDAR_ID INCREMENT BY 1;

DB DML

SELECT

	SELECT
		CALELDAR_ID,
		TITLE,
		ALLDAY,
		TO_CHAR(START_DATE, 'YYYY-MM-DD HH24:MI') AS START_DATE,
		TO_CHAR(END_DATE, 'YYYY-MM-DD HH24:MI') AS END_DATE,
		MEMO
	FROM
		${schema}.PT_SCHEDULE_INFO

INSERT

	INSERT INTO
			${schema}.PT_SCHEDULE_INFO(CALELDAR_ID ,
			TITLE,
			ALLDAY,
			START_DATE,
			END_DATE,
			MEMO)
	VALUES(${schema}.SEQ_CALENDAR_ID.NEXTVAL,
			#{title},
			#{allday},
			TO_DATE(#{start}, 'YYYY-MM-DD HH24:MI'),
			TO_DATE(#{end}, 'YYYY-MM-DD HH24:MI'),
			#{memo})

UPDATE

	UPDATE 
		${schema}.PT_SCHEDULE_INFO 
	SET
		TITLE = #{title},
		ALLDAY = #{allday}, 
		START_DATE = TO_DATE(#{start}, 'YYYY-MM-DD HH24:MI') ,
		END_DATE = TO_DATE(#{end}, 'YYYY-MM-DD HH24:MI'),
		MEMO = #{memo}
	WHERE
		CALELDAR_ID = #{id}

DELETE

	DELETE
	FROM
		${schema}.PT_SCHEDULE_INFO
	WHERE
		CALELDAR_ID = #{id}

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published