Function createTable

contrib/drivers/oracle/oracle_z_unit_init_test.go:107–163

(table ...string)

}

func createTable(table ...string) (name string) {
	if len(table) > 0 {
		name = table[0]
	} else {
		name = fmt.Sprintf("user_%d", gtime.Timestamp())
	}

	dropTable(name)

	// Step 1: Create table
	createTableSQL := fmt.Sprintf(`
    CREATE TABLE %s (
        ID NUMBER(10) NOT NULL,
        PASSPORT VARCHAR(45) NOT NULL,
        PASSWORD CHAR(32) NOT NULL,
        NICKNAME VARCHAR(45) NOT NULL,
        CREATE_TIME VARCHAR(45),
        SALARY NUMBER(18,2),
        PRIMARY KEY (ID)
    )`, name)

	if _, err := db.Exec(ctx, createTableSQL); err != nil {
		gtest.Fatal(err)
	}

	// Step 2: Create sequence
	createSeqSQL := fmt.Sprintf(`
    CREATE SEQUENCE %s_ID_SEQ
    START WITH 1
    INCREMENT BY 1
    MINVALUE 1
    MAXVALUE 9999999999
    NOCYCLE
    NOCACHE`, name)

	if _, err := db.Exec(ctx, createSeqSQL); err != nil {
		gtest.Fatal(err)
	}

	// Step 3: Create trigger - only set ID from sequence when it's NULL
	createTriggerSQL := fmt.Sprintf(`
CREATE OR REPLACE TRIGGER %s_ID_TRG
BEFORE INSERT ON %s
FOR EACH ROW
BEGIN
    IF :NEW.ID IS NULL THEN
        :NEW.ID := %s_ID_SEQ.NEXTVAL;
    END IF;
END;`, name, name, name)

	if _, err := db.Exec(ctx, createTriggerSQL); err != nil {
		gtest.Fatal(err)
	}

	// db.Schema("test")
	return
}