private static void SetupOracle()
{
using (var connection = new OracleConnection(String.Format("data source={0};password={1};user id={2}", "INSTANCE", "pass12!", "USER")))
{
connection.Open();
try
{
connection.Execute(@"drop table users");
}
catch (Exception)
{ }
try
{
connection.Execute(@"drop SEQUENCE users_seq");
}
catch (Exception)
{ }
try
{
connection.Execute(@"drop table car");
}
catch (Exception)
{ }
try
{
connection.Execute(@"drop SEQUENCE car_seq");
}
catch (Exception)
{ }
try
{
connection.Execute(@"drop table bigcar");
}
catch (Exception)
{ }
try
{
connection.Execute(@"drop SEQUENCE bigcar_seq");
}
catch (Exception)
{ }
try
{
connection.Execute(@"drop table city");
}
catch (Exception)
{ }
try
{
connection.Execute(@"drop table GUIDTest");
}
catch (Exception)
{ }
try
{
connection.Execute(@"drop table StrangeColumnNames");
}
catch (Exception)
{ }
try
{
connection.Execute(@"drop SEQUENCE StrangeColumnNames_seq");
}
catch (Exception)
{ }
try
{
connection.Execute(@"drop table UserWithoutAutoIdentity");
}
catch (Exception)
{ }
}
using (var connection = new OracleConnection(String.Format("data source={0};password={1};user id={2}", "DEVELOPMENT", "umhk79J&U", "BOWDENJ")))
{
connection.Open();
connection.Execute(@"CREATE TABLE Users (Id number(10), NAME NVARCHAR2(100) NOT NULL, Age INT NOT NULL, ScheduledDayOff NUMBER(10), CreatedDate DATE DEFAULT sysdate, CONSTRAINT USER_PK PRIMARY KEY (Id))");
connection.Execute(@"CREATE SEQUENCE Users_seq START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE");
connection.Execute(@"CREATE OR REPLACE TRIGGER USERS_INS_TRIG BEFORE INSERT ON Users FOR EACH ROW BEGIN IF :new.ID IS NULL THEN SELECT Users_seq.nextval INTO :new.ID FROM DUAL; END IF; END;");
connection.Execute(@"CREATE TABLE Car (CarId number(10), Id number(10), Make NVARCHAR2(100) NOT NULL, Model NVARCHAR2(100) NOT NULL, CONSTRAINT CAR_PK PRIMARY KEY (CARId))");
connection.Execute(@"CREATE SEQUENCE Car_seq START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE");
connection.Execute(@"CREATE OR REPLACE TRIGGER CAR_INS_TRIG BEFORE INSERT ON CAR FOR EACH ROW BEGIN IF :new.CarId IS NULL THEN SELECT Car_seq.nextval INTO :new.CarId FROM DUAL; END IF; END;");
connection.Execute(@"CREATE TABLE BigCar (CarId number(10), Make NVARCHAR2(100) NOT NULL, Model NVARCHAR2(100) NOT NULL, CONSTRAINT BIGCAR_PK PRIMARY KEY (CARId))");
connection.Execute(@"CREATE SEQUENCE BigCar_seq START WITH 2147483649 INCREMENT BY 1 NOCACHE NOCYCLE");
connection.Execute(@"CREATE OR REPLACE TRIGGER BIGCAR_INS_TRIG BEFORE INSERT ON BIGCAR FOR EACH ROW BEGIN IF :new.CarId IS NULL THEN SELECT BigCar_seq.nextval INTO :new.CarId FROM DUAL; END IF; END;");
connection.Execute(@"INSERT INTO BigCar (Make, Model) VALUES ('car', 'car')");
connection.Execute(@"CREATE TABLE City (NAME NVARCHAR2(100) NOT NULL, Population number(10) NOT NULL)");
connection.Execute(@"CREATE TABLE GUIDTest (Id char(38) default sys_guid(), NAME VARCHAR(50) NOT NULL, CONSTRAINT PK_GUIDTest PRIMARY KEY (Id))");
connection.Execute(@"CREATE TABLE StrangeColumnNames (ItemId NUMBER(10), word NVARCHAR2(100) NOT NULL, colstringstrangeword NVARCHAR2(100) NOT NULL, CONSTRAINT StrangeColumnNames_PK PRIMARY KEY (ItemId) )");
connection.Execute(@"CREATE SEQUENCE StrangeColumnNames_seq START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE");
connection.Execute(@"CREATE OR REPLACE TRIGGER SColNames_INS_TRIG BEFORE INSERT ON StrangeColumnNames FOR EACH ROW BEGIN IF :new.ItemId IS NULL THEN SELECT StrangeColumnNames_seq.nextval INTO :new.ItemId FROM DUAL; END IF; END;");
connection.Execute(@"CREATE TABLE UserWithoutAutoIdentity (Id number(10), NAME NVARCHAR2(100) NOT NULL, Age number(10) NOT NULL,CONSTRAINT UserWithoutAutoIdentity_PK PRIMARY KEY (Id) )");
}
}
