public void dbisanity()
{
using (VersaplexTester t = new VersaplexTester())
{
WvDbi dbi = t.dbi;
dbi.try_exec("drop table dbisanity");
dbi.exec("create table dbisanity (name varchar(80), age integer)");
dbi.exec("insert into dbisanity values ('frog', 12)");
dbi.exec("insert into dbisanity values ('bog', 13)");
dbi.exec("insert into dbisanity values ('hog', 14)");
using (var r = dbi.select("select * from dbisanity"))
{
WVPASSEQ(r.columns.Count(), 2);
WVPASSEQ(r.columns.Count(), 2);
WVPASSEQ(r.columns.Count(), 2);
WVPASSEQ(r.Count(), 3);
}
using (var r = dbi.select("select * from dbisanity"))
{
WVPASSEQ(r.columns.Count(), 2);
WVPASSEQ(r.columns.Count(), 2);
WVPASSEQ(r.columns.Count(), 2);
WVPASSEQ(r.Count(), 3);
}
dbi.try_exec("drop table dbisanity");
}
}
public SchemaCreator(VersaplexTester _t)
{
t = _t;
Cleanup();
tab1q = "CREATE TABLE [Tab1] (\n" +
"\t[f1] [int] NOT NULL,\n" +
"\t[f2] [money] NOT NULL,\n" +
"\t[f3] [varchar] (80) NULL);\n" +
"ALTER TABLE [Tab1] ADD CONSTRAINT [PK_Tab1] PRIMARY KEY (f1,f2)\n" +
"CREATE UNIQUE INDEX [Idx1] ON [Tab1]\n" +
"\t(f2, f3 DESC);\n\n";
tab1sch = "column: name=f1,type=int,null=0\n" +
"column: name=f2,type=money,null=0\n" +
"column: name=f3,type=varchar,null=1,length=80\n" +
"index: column=f2,column=f3 DESC,name=Idx1,unique=1,clustered=2\n" +
"primary-key: column=f1,column=f2,clustered=1\n";
tab2q = "CREATE TABLE [Tab2] (\n" +
"\t[f4] [binary] (1) NOT NULL);\n\n";
tab2sch = "column: name=f4,type=binary,null=0,length=1\n";
msg1 = "Hello, world, this is Func1!";
msg2 = "Hello, world, this is Func2!";
func1q = "create procedure Func1 as select '" + msg1 + "'\n";
func2q = "create function Func2 () returns varchar as begin " +
"return '" + msg2 + "'; end\n";
xmlq = "\nCREATE XML SCHEMA COLLECTION [dbo].[TestSchema] AS " +
"'<xsd:schema xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" +
"<xsd:element name=\"Employee\">" +
"<xsd:complexType>" +
"<xsd:complexContent>" +
"<xsd:restriction base=\"xsd:anyType\">" +
"<xsd:sequence>" +
"<xsd:element name=\"SIN\" type=\"xsd:string\"/>" +
"<xsd:element name=\"Name\" type=\"xsd:string\"/>" +
"<xsd:element name=\"DateOfBirth\" type=\"xsd:date\"/>" +
"<xsd:element name=\"EmployeeType\" type=\"xsd:string\"/>" +
"<xsd:element name=\"Salary\" type=\"xsd:long\"/>" +
"</xsd:sequence>" +
"</xsd:restriction>" +
"</xsd:complexContent>" +
"</xsd:complexType>" +
"</xsd:element>" +
"</xsd:schema>'\n";
tabfuncq = "create function TabFunc1 ( ) returns table as " +
"return (select 1 as col)\n";
triggerq = "create trigger Trigger1 on Tab1 for insert as " +
"select 1\n";
viewq = "create view View1 as select 1 as col\n";
}
