public void DATETIMEOFFSET_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List <SQLColumn>()
{
FakeColumn("DateTimeOffset_7NotNull", "MyStuff", 80, "datetimeoffset", false, 0, 7),
FakeColumn("DateTimeOffset_7Null", "MyStuff", 80, "datetimeoffset", true, 0, 7),
FakeColumn("DateTimeOffset_2NotNull", "MyStuff", 80, "datetimeoffset", false, 0, 2),
FakeColumn("DateTimeOffset_2Null", "MyStuff", 80, "datetimeoffset", true, 0, 2),
FakeColumn("DateTimeOffset_4NotNull", "MyStuff", 80, "datetimeoffset", false, 0, 4),
FakeColumn("DateTimeOffset_4Null", "MyStuff", 80, "datetimeoffset", true, 0, 4)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
DateTimeOffset_7NotNull datetimeoffset NOT NULL,
DateTimeOffset_7Null datetimeoffset NULL,
DateTimeOffset_2NotNull datetimeoffset(2) NOT NULL,
DateTimeOffset_2Null datetimeoffset(2) NULL,
DateTimeOffset_4NotNull datetimeoffset(4) NOT NULL,
DateTimeOffset_4Null datetimeoffset(4) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void DATETIME2_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List <SQLColumn>()
{
FakeColumn("DateTime2_0_NotNull", "MyStuff", 8, "datetime2", false, 0, 0),
FakeColumn("DateTime2_0_Null", "MyStuff", 8, "datetime2", true, 0, 0),
FakeColumn("DateTime2_3_NotNull", "MyStuff", 8, "datetime2", false, 0, 3),
FakeColumn("DateTime2_3_Null", "MyStuff", 8, "datetime2", true, 0, 3),
FakeColumn("DateTime2_7_NotNull", "MyStuff", 8, "datetime2", false, 0, 7),
FakeColumn("DateTime2_7_Null", "MyStuff", 8, "datetime2", true, 0, 7)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
DateTime2_0_NotNull datetime2(0) NOT NULL,
DateTime2_0_Null datetime2(0) NULL,
DateTime2_3_NotNull datetime2(3) NOT NULL,
DateTime2_3_Null datetime2(3) NULL,
DateTime2_7_NotNull datetime2 NOT NULL,
DateTime2_7_Null datetime2 NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void FLOAT_AND_REAL_ScriptCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List <SQLColumn>()
{
FakeColumn("Float53NotNull", "MyStuff", 64, "float", false, 2, 1),
FakeColumn("Float53Null", "MyStuff", 64, "float", true, 2, 1),
FakeColumn("Float40NotNull", "MyStuff", 64, "float", false, 2, 1),
FakeColumn("Float40Null", "MyStuff", 64, "float", true, 2, 1),
FakeColumn("Float24NotNull", "MyStuff", 32, "real", false, 4, 3),
FakeColumn("Float24Null", "MyStuff", 32, "real", true, 4, 3),
FakeColumn("Float17NotNull", "MyStuff", 32, "real", false, 4, 3),
FakeColumn("Float17Null", "MyStuff", 32, "real", true, 4, 3)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
Float53NotNull float(53) NOT NULL,
Float53Null float(53) NULL,
Float40NotNull float(53) NOT NULL,
Float40Null float(53) NULL,
Float24NotNull float(24) NOT NULL,
Float24Null float(24) NULL,
Float17NotNull float(24) NOT NULL,
Float17Null float(24) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void DECIMAL_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List <SQLColumn>()
{
FakeColumn("decimal2_1NotNull", "MyStuff", 17, "decimal", false, 2, 1),
FakeColumn("decimal2_1Null", "MyStuff", 17, "decimal", true, 2, 1),
FakeColumn("decimal4_3NotNull", "MyStuff", 17, "decimal", false, 4, 3),
FakeColumn("decimal4_3Null", "MyStuff", 17, "decimal", true, 4, 3)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
decimal2_1NotNull decimal(2,1) NOT NULL,
decimal2_1Null decimal(2,1) NULL,
decimal4_3NotNull decimal(4,3) NOT NULL,
decimal4_3Null decimal(4,3) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void VARBINARY_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List <SQLColumn>()
{
FakeColumn("VarBin100NotNull", "MyStuff", 100, "varbinary", false, 0, 0),
FakeColumn("VarBinMaxNotNull", "MyStuff", Int32.MaxValue, "varbinary", false, 0, 0),
FakeColumn("VarBin100Null", "MyStuff", 100, "varbinary", true, 0, 0),
FakeColumn("VarBinMaxNull", "MyStuff", Int32.MaxValue, "varbinary", true, 0, 0)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
VarBin100NotNull varbinary(100) NOT NULL,
VarBinMaxNotNull varbinary(MAX) NOT NULL,
VarBin100Null varbinary(100) NULL,
VarBinMaxNull varbinary(MAX) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void NVARCHAR_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List <SQLColumn>()
{
FakeColumn("Name100NotNull", "MyStuff", 100, "nvarchar", false, 0, 0),
FakeColumn("NameMaxNotNull", "MyStuff", Int32.MaxValue, "nvarchar", false, 0, 0),
FakeColumn("Name100Null", "MyStuff", 100, "nvarchar", true, 0, 0),
FakeColumn("NameMaxNull", "MyStuff", Int32.MaxValue, "nvarchar", true, 0, 0)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
Name100NotNull nvarchar(100) NOT NULL,
NameMaxNotNull nvarchar(MAX) NOT NULL,
Name100Null nvarchar(100) NULL,
NameMaxNull nvarchar(MAX) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void TIME_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List <SQLColumn>()
{
FakeColumn("TimeNotNull", "MyStuff", 8, "time", false, 0, 7),
FakeColumn("TimeNull", "MyStuff", 8, "time", true, 0, 7),
FakeColumn("Time2NotNull", "MyStuff", 8, "time", false, 0, 2),
FakeColumn("Time2Null", "MyStuff", 8, "time", true, 0, 2),
FakeColumn("Time4NotNull", "MyStuff", 8, "time", false, 0, 4),
FakeColumn("Time4Null", "MyStuff", 8, "time", true, 0, 4),
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
TimeNotNull time NOT NULL,
TimeNull time NULL,
Time2NotNull time(2) NOT NULL,
Time2Null time(2) NULL,
Time4NotNull time(4) NOT NULL,
Time4Null time(4) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void BIGINT_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("BIGINTNotNull", "MyStuff", 8, "bigint", false,0,0), false);
dt.LoadDataRow(FakeColumn("BIGINTNull", "MyStuff", 8, "bigint", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
BIGINTNotNull bigint NOT NULL,
BIGINTNull bigint NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void BINARY_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List<SQLColumn>() {
FakeColumn("Binary100NotNull", "MyStuff", 100, "binary", false, 0, 0),
FakeColumn("Binary100Null", "MyStuff", 100, "binary", true, 0, 0)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
Binary100NotNull binary(100) NOT NULL,
Binary100Null binary(100) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void GEOMETRY_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("GeometryNotNull", "MyStuff", 0, "dbname.sys.geometry", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("GeometryNull", "MyStuff", 0, "dbname.sys.geometry", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
GeometryNotNull geometry NOT NULL,
GeometryNull geometry NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void XML_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("XMLNotNull", "MyStuff", 0, "xml", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("XMLNull", "MyStuff", 0, "xml", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
XMLNotNull xml NOT NULL,
XMLNull xml NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void SQL_VARIANT_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("Sql_VariantNotNull", "MyStuff", 128, "sql_variant", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("Sql_VariantNull", "MyStuff", 128, "sql_variant", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
Sql_VariantNotNull sql_variant NOT NULL,
Sql_VariantNull sql_variant NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void UNIQUEIDENTIFIER_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("UniqueIdentifierNotNull", "MyStuff", 128, "uniqueidentifier", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("UniqueIdentifierNull", "MyStuff", 128, "uniqueidentifier", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
UniqueIdentifierNotNull uniqueidentifier NOT NULL,
UniqueIdentifierNull uniqueidentifier NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void HIERARCHYID_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("HierarchyIdNotNull", "MyStuff", 8, "dbname.sys.hierarchyid", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("HierarchyIdNull", "MyStuff", 8, "dbname.sys.hierarchyid", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
HierarchyIdNotNull hierarchyid NOT NULL,
HierarchyIdNull hierarchyid NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void TIMESTAMP_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("TimeStampNotNull", "MyStuff", 8, "timestamp", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("TimeStampNull", "MyStuff", 8, "timestamp", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
TimeStampNotNull timestamp NOT NULL,
TimeStampNull timestamp NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void SMALLDATETIME_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("SmallDateTimeNotNull", "MyStuff", 8, "smalldatetime", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("SmallDateTimeNull", "MyStuff", 8, "smalldatetime", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
SmallDateTimeNotNull smalldatetime NOT NULL,
SmallDateTimeNull smalldatetime NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void BINARY_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("Binary100NotNull", "MyStuff", 100, "binary", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("Binary100Null", "MyStuff", 100, "binary", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
Binary100NotNull binary(100) NOT NULL,
Binary100Null binary(100) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void INT_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("IntNotNull", "MyStuff", 32, "int", false, 255, 255), false);
dt.LoadDataRow(FakeColumn("IntNull", "MyStuff", 32, "int", true, 255, 255), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
IntNotNull int NOT NULL,
IntNull int NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void NUMERIC_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("Numeric2_1NotNull", "MyStuff", 17, "numeric", false, 2, 1), false);
dt.LoadDataRow(FakeColumn("Numeric2_1Null", "MyStuff", 17, "numeric", true, 4, 3), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
Numeric2_1NotNull numeric(2,1) NOT NULL,
Numeric2_1Null numeric(4,3) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void MONEY_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List <SQLColumn>()
{
FakeColumn("MoneyNotNull", "MyStuff", 8, "money", false, 0, 0),
FakeColumn("MoneyNull", "MyStuff", 8, "money", true, 0, 0)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
MoneyNotNull money NOT NULL,
MoneyNull money NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void BIT_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List <SQLColumn>()
{
FakeColumn("BitNotNull", "MyStuff", 1, "bit", false, 255, 255),
FakeColumn("BitNull", "MyStuff", 1, "bit", true, 255, 255)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
BitNotNull bit NOT NULL,
BitNull bit NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void GEOGRAPHY_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List <SQLColumn>()
{
FakeColumn("GeographyNotNull", "MyStuff", 0, "dbname.sys.geography", false, 0, 0),
FakeColumn("GeographyNull", "MyStuff", 0, "dbname.sys.geography", true, 0, 0)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
GeographyNotNull geography NOT NULL,
GeographyNull geography NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void IMAGE_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List <SQLColumn>()
{
FakeColumn("ImageNotNull", "MyStuff", 0, "image", false, 0, 0),
FakeColumn("ImageNull", "MyStuff", 0, "image", true, 0, 0)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
ImageNotNull image NOT NULL,
ImageNull image NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void NUMERIC_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List <SQLColumn>()
{
FakeColumn("Numeric2_1NotNull", "MyStuff", 17, "numeric", false, 2, 1),
FakeColumn("Numeric2_1Null", "MyStuff", 17, "numeric", true, 4, 3)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
Numeric2_1NotNull numeric(2,1) NOT NULL,
Numeric2_1Null numeric(4,3) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void IMAGE_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("ImageNotNull", "MyStuff", 0, "image", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("ImageNull", "MyStuff", 0, "image", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
ImageNotNull image NOT NULL,
ImageNull image NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void VARBINARY_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("VarBin100NotNull", "MyStuff", 100, "varbinary", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("VarBinMaxNotNull", "MyStuff", Int32.MaxValue, "varbinary", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("VarBin100Null", "MyStuff", 100, "varbinary", true, 0, 0), false);
dt.LoadDataRow(FakeColumn("VarBinMaxNull", "MyStuff", Int32.MaxValue, "varbinary", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
VarBin100NotNull varbinary(100) NOT NULL,
VarBinMaxNotNull varbinary(MAX) NOT NULL,
VarBin100Null varbinary(100) NULL,
VarBinMaxNull varbinary(MAX) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void NVARCHAR_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("Name100NotNull", "MyStuff", 100, "nvarchar", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("NameMaxNotNull", "MyStuff", Int32.MaxValue, "nvarchar", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("Name100Null", "MyStuff", 100, "nvarchar", true, 0, 0), false);
dt.LoadDataRow(FakeColumn("NameMaxNull", "MyStuff", Int32.MaxValue, "nvarchar", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
Name100NotNull nvarchar(100) NOT NULL,
NameMaxNotNull nvarchar(MAX) NOT NULL,
Name100Null nvarchar(100) NULL,
NameMaxNull nvarchar(MAX) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void TIME_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List<SQLColumn>() {
FakeColumn("TimeNotNull", "MyStuff", 8, "time", false, 0, 7),
FakeColumn("TimeNull", "MyStuff", 8, "time", true, 0, 7),
FakeColumn("Time2NotNull", "MyStuff", 8, "time", false, 0, 2),
FakeColumn("Time2Null", "MyStuff", 8, "time", true, 0, 2),
FakeColumn("Time4NotNull", "MyStuff", 8, "time", false, 0, 4),
FakeColumn("Time4Null", "MyStuff", 8, "time", true, 0, 4),
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
TimeNotNull time NOT NULL,
TimeNull time NULL,
Time2NotNull time(2) NOT NULL,
Time2Null time(2) NULL,
Time4NotNull time(4) NOT NULL,
Time4Null time(4) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void DATETIME2_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("DateTime2NotNull", "MyStuff", 8, "datetime2", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("DateTime2Null", "MyStuff", 8, "datetime2", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
DateTime2NotNull datetime2 NOT NULL,
DateTime2Null datetime2 NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void DATETIMEOFFSET_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List<SQLColumn>() {
FakeColumn("DateTimeOffset_7NotNull", "MyStuff", 80, "datetimeoffset", false, 0, 7),
FakeColumn("DateTimeOffset_7Null", "MyStuff", 80, "datetimeoffset", true, 0, 7),
FakeColumn("DateTimeOffset_2NotNull", "MyStuff", 80, "datetimeoffset", false, 0, 2),
FakeColumn("DateTimeOffset_2Null", "MyStuff", 80, "datetimeoffset", true, 0, 2),
FakeColumn("DateTimeOffset_4NotNull", "MyStuff", 80, "datetimeoffset", false, 0, 4),
FakeColumn("DateTimeOffset_4Null", "MyStuff", 80, "datetimeoffset", true, 0, 4)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
DateTimeOffset_7NotNull datetimeoffset NOT NULL,
DateTimeOffset_7Null datetimeoffset NULL,
DateTimeOffset_2NotNull datetimeoffset(2) NOT NULL,
DateTimeOffset_2Null datetimeoffset(2) NULL,
DateTimeOffset_4NotNull datetimeoffset(4) NOT NULL,
DateTimeOffset_4Null datetimeoffset(4) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void XML_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List<SQLColumn>() {
FakeColumn("XMLNotNull", "MyStuff", 0, "xml", false, 0, 0),
FakeColumn("XMLNull", "MyStuff", 0, "xml", true, 0, 0)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
XMLNotNull xml NOT NULL,
XMLNull xml NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void GEOMETRY_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("GeometryNotNull", "MyStuff", 0, "dbname.sys.geometry", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("GeometryNull", "MyStuff", 0, "dbname.sys.geometry", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
GeometryNotNull geometry NOT NULL,
GeometryNull geometry NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void UNIQUEIDENTIFIER_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("UniqueIdentifierNotNull", "MyStuff", 128, "uniqueidentifier", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("UniqueIdentifierNull", "MyStuff", 128, "uniqueidentifier", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
UniqueIdentifierNotNull uniqueidentifier NOT NULL,
UniqueIdentifierNull uniqueidentifier NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void DATETIME_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List<SQLColumn>() {
FakeColumn("DateTimeNotNull", "MyStuff", 8, "datetime", false, 0, 0),
FakeColumn("DateTimeNull", "MyStuff", 8, "datetime", true, 0, 0)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
DateTimeNotNull datetime NOT NULL,
DateTimeNull datetime NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void GEOGRAPHY_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List<SQLColumn>() {
FakeColumn("GeographyNotNull", "MyStuff", 0, "dbname.sys.geography", false, 0, 0),
FakeColumn("GeographyNull", "MyStuff", 0, "dbname.sys.geography", true, 0, 0)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
GeographyNotNull geography NOT NULL,
GeographyNull geography NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void TIMESTAMP_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("TimeStampNotNull", "MyStuff", 8, "timestamp", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("TimeStampNull", "MyStuff", 8, "timestamp", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
TimeStampNotNull timestamp NOT NULL,
TimeStampNull timestamp NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void FLOAT_AND_REAL_ScriptCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("Float53NotNull", "MyStuff", 64, "float", false, 2, 1), false);
dt.LoadDataRow(FakeColumn("Float53Null", "MyStuff", 64, "float", true, 2, 1), false);
dt.LoadDataRow(FakeColumn("Float40NotNull", "MyStuff", 64, "float", false, 2, 1), false);
dt.LoadDataRow(FakeColumn("Float40Null", "MyStuff", 64, "float", true, 2, 1), false);
dt.LoadDataRow(FakeColumn("Float24NotNull", "MyStuff", 32, "real", false, 4, 3), false);
dt.LoadDataRow(FakeColumn("Float24Null", "MyStuff", 32, "real", true, 4, 3), false);
dt.LoadDataRow(FakeColumn("Float17NotNull", "MyStuff", 32, "real", false, 4, 3), false);
dt.LoadDataRow(FakeColumn("Float17Null", "MyStuff", 32, "real", true, 4, 3), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
Float53NotNull float(53) NOT NULL,
Float53Null float(53) NULL,
Float40NotNull float(53) NOT NULL,
Float40Null float(53) NULL,
Float24NotNull float(24) NOT NULL,
Float24Null float(24) NULL,
Float17NotNull float(24) NOT NULL,
Float17Null float(24) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void HIERARCHYID_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("HierarchyIdNotNull", "MyStuff", 8, "dbname.sys.hierarchyid", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("HierarchyIdNull", "MyStuff", 8, "dbname.sys.hierarchyid", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
HierarchyIdNotNull hierarchyid NOT NULL,
HierarchyIdNull hierarchyid NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void SMALLMONEY_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List<SQLColumn>() {
FakeColumn("SmallMoneyNotNull", "MyStuff", 4, "smallmoney", false, 0, 0),
FakeColumn("SmallMoneyNull", "MyStuff", 4, "smallmoney", true, 0, 0)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
SmallMoneyNotNull smallmoney NOT NULL,
SmallMoneyNull smallmoney NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void SQL_VARIANT_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("Sql_VariantNotNull", "MyStuff", 128, "sql_variant", false, 0, 0), false);
dt.LoadDataRow(FakeColumn("Sql_VariantNull", "MyStuff", 128, "sql_variant", true, 0, 0), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
Sql_VariantNotNull sql_variant NOT NULL,
Sql_VariantNull sql_variant NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void DECIMAL_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("decimal2_1NotNull", "MyStuff", 17, "decimal", false, 2, 1), false);
dt.LoadDataRow(FakeColumn("decimal2_1Null", "MyStuff", 17, "decimal", true, 2, 1), false);
dt.LoadDataRow(FakeColumn("decimal4_3NotNull", "MyStuff", 17, "decimal", false, 4, 3), false);
dt.LoadDataRow(FakeColumn("decimal4_3Null", "MyStuff", 17, "decimal", true, 4, 3), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
decimal2_1NotNull decimal(2,1) NOT NULL,
decimal2_1Null decimal(2,1) NULL,
decimal4_3NotNull decimal(4,3) NOT NULL,
decimal4_3Null decimal(4,3) NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void SMALLINT_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = FakeSchemaDataTable();
dt.LoadDataRow(FakeColumn("SmallIntNotNull", "MyStuff", 16, "smallint", false, 255, 255), false);
dt.LoadDataRow(FakeColumn("SmallIntNull", "MyStuff", 16, "smallint", true, 255, 255), false);
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
SmallIntNotNull smallint NOT NULL,
SmallIntNull smallint NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}
public void TINYINT_ScriptsCorrectly()
{
FlexResultSet fsr = new FlexResultSet();
var dt = new List<SQLColumn>() {
FakeColumn("TinyIntNotNull", "MyStuff", 8, "tinyint", false, 255, 255),
FakeColumn("TinyIntNull", "MyStuff", 8, "tinyint", true, 255, 255)
};
fsr.results.Add(new FlexResult());
fsr.results[0].schema = dt;
var expected = @"CREATE TABLE MyTable(
TinyIntNotNull tinyint NOT NULL,
TinyIntNull tinyint NULL
);
";
Assert.AreEqual(expected, fsr.ScriptResultAsCreateTable(0, "MyTable"));
}