public void LargeDeleteHandling()
{
InitConnection();
List <GrantedAppsInfo> appsLst = qbApp.GrantedDBs();
foreach (var app in appsLst)
{
foreach (var tab in app.GrantedTables)
{
if (tab.Name == "APITestApp: APIBigDelTestTable")
{
IQTable tbl = qbApp.GetTable(tab.Dbid);
qbApp.DeleteTable(tbl);
break;
}
}
}
IQTable testTable = qbApp.NewTable("APIBigDelTestTable", "dummyRec");
testTable.Columns.Add(new QColumn("NumberValue", FieldType.@float));
testTable.Columns.Add(new QColumn("TextValue", FieldType.text));
for (int i = 0; i < 500; i++)
{
IQRecord newRec = testTable.NewRecord();
newRec["NumberValue"] = i;
newRec["TextValue"] = "Record " + i;
testTable.Records.Add(newRec);
}
testTable.AcceptChanges();
List <int> delList = new List <int>
{
5,
6,
7,
8,
9,
10
};
Random rndSrc = new Random();
while (delList.Count < 120)
{
int addVal = rndSrc.Next(500);
if (!delList.Contains(addVal))
{
delList.Add(addVal);
}
}
foreach (int i in delList.OrderByDescending(x => x))
{
testTable.Records.RemoveAt(i);
}
testTable.AcceptChanges();
testTable.Query();
Assert.AreEqual(testTable.Records.Count, 380, "Big Record deletion fails");
}
public void TestDuration()
{
InitConnection();
IQTable testTable = qbApp.GetTable("bnrmadvx3");
TimeSpan tstVal = new TimeSpan(1, 23, 55, 11);
IQRecord newRec = testTable.NewRecord();
newRec["DurationTest"] = tstVal;
testTable.Records.Add(newRec);
testTable.AcceptChanges();
testTable.Query();
IQRecord loopRec = testTable.Records[0];
Assert.AreEqual(tstVal, loopRec["DurationTest"], "Duration doesn't round trip");
}
public bool CreateUser(String userName, String password)
{
table = application.GetTable(GetTableID("Users"));
//check the passwords before calling method
table.Query();
bool userCreated = false;
IQRecord tempUser = table.Records.Where(x => x[1] == userName).SingleOrDefault();
if (tempUser == null)
{
tempUser = table.NewRecord();
tempUser[0] = curUserID.ToString();
tempUser[1] = userName;
tempUser[2] = password;
table.Records.Add(tempUser);
table.AcceptChanges();
userCreated = true;
}
else
{
//Error username exists
}
return(userCreated);
}
public void BasicCreationAndRoundTripTest()
{
InitConnection();
List <GrantedAppsInfo> appsLst = qbApp.GrantedDBs();
foreach (var app in appsLst)
{
foreach (var tab in app.GrantedTables)
{
if (tab.Name == "APITestApp: APITestTable")
{
IQTable tbl = qbApp.GetTable(tab.Dbid);
qbApp.DeleteTable(tbl);
break;
}
}
}
IQTable testTable = qbApp.NewTable("APITestTable", "dummyRec");
testTable.Columns.Add(new QColumn("TextTest", FieldType.text));
testTable.Columns.Add(new QColumn("FloatTest", FieldType.@float));
testTable.Columns.Add(new QColumn("CheckboxTest", FieldType.checkbox));
testTable.Columns.Add(new QColumn("DateTest", FieldType.date));
testTable.Columns.Add(new QColumn("TimeStampTest", FieldType.timestamp));
testTable.Columns.Add(new QColumn("TimeOfDayTest", FieldType.timeofday));
testTable.Columns.Add(new QColumn("DurationTest", FieldType.duration));
testTable.Columns.Add(new QColumn("CurrencyTest", FieldType.currency));
testTable.Columns.Add(new QColumn("PercentTest", FieldType.percent));
testTable.Columns.Add(new QColumn("EmailTest", FieldType.email));
testTable.Columns.Add(new QColumn("PhoneTest", FieldType.phone));
testTable.Columns.Add(new QColumn("UrlTest", FieldType.url));
testTable.Columns.Add(new QColumn("MultiTextTest", FieldType.multitext));
testTable.Columns.Add(new QColumn("RatingTest", FieldType.rating));
testTable.Columns.Add(new QColumn("FileTest", FieldType.file));
foreach (string val in multiTextOptions)
{
testTable.Columns["MultiTextTest"].AddChoice(val);
}
TestRecord exemplar = new TestRecord();
exemplar.SetupTestValues();
IQRecord inRec = testTable.NewRecord();
inRec["TextTest"] = exemplar.textVal;
inRec["FloatTest"] = exemplar.floatVal;
inRec["CheckboxTest"] = exemplar.checkboxVal;
inRec["DateTest"] = exemplar.dateVal;
inRec["TimeStampTest"] = exemplar.timeStampVal;
inRec["TimeOfDayTest"] = exemplar.timeOfDayVal;
inRec["DurationTest"] = exemplar.durationVal;
inRec["CurrencyTest"] = exemplar.currencyVal;
inRec["PercentTest"] = exemplar.percentVal;
inRec["EmailTest"] = exemplar.emailVal;
inRec["PhoneTest"] = exemplar.phoneVal;
inRec["UrlTest"] = exemplar.urlVal;
inRec["MultiTextTest"] = exemplar.multiTextVal;
inRec["RatingTest"] = exemplar.ratingVal;
Assert.AreEqual(exemplar.textVal, inRec["TextTest"], "Strings setter fails");
Assert.AreEqual(exemplar.floatVal, inRec["FloatTest"], "Floats setter fails");
Assert.AreEqual(exemplar.checkboxVal, inRec["CheckboxTest"], "Checkboxes setter fails");
Assert.AreEqual(exemplar.dateVal, inRec["DateTest"], "Dates setter fails");
Assert.AreEqual(exemplar.timeStampVal, inRec["TimeStampTest"], "TimeStamps setter fails");
Assert.AreEqual(exemplar.timeOfDayVal, inRec["TimeOfDayTest"], "TimeOfDays setter fails");
Assert.AreEqual(exemplar.durationVal, inRec["DurationTest"], "Durations setter fails");
Assert.AreEqual(exemplar.currencyVal, inRec["CurrencyTest"], "Currency setter fails");
Assert.AreEqual(exemplar.percentVal, inRec["PercentTest"], "Percent setter fails");
Assert.AreEqual(exemplar.emailVal, inRec["EmailTest"], "Email setter fails");
Assert.AreEqual(exemplar.phoneVal, inRec["PhoneTest"], "Phone setter fails");
Assert.AreEqual(exemplar.urlVal, inRec["UrlTest"], "Url setter fails");
Assert.AreEqual(exemplar.multiTextVal, inRec["MultiTextTest"], "MultiTextSetter fails");
Assert.AreEqual(exemplar.ratingVal, inRec["RatingTest"], "RatingSetter fails");
testTable.Records.Add(inRec);
testTable.AcceptChanges();
Assert.AreEqual(exemplar.textVal, inRec["TextTest"], "Strings wrong post upload");
Assert.AreEqual(exemplar.floatVal, inRec["FloatTest"], "Floats wrong post upload");
Assert.AreEqual(exemplar.checkboxVal, inRec["CheckboxTest"], "Checkboxes wrong post upload");
Assert.AreEqual(exemplar.dateVal, inRec["DateTest"], "Dates wrong post upload");
Assert.AreEqual(exemplar.timeStampVal, inRec["TimeStampTest"], "TimeStamps wrong post upload");
Assert.AreEqual(exemplar.timeOfDayVal, inRec["TimeOfDayTest"], "TimeOfDays wrong post upload");
Assert.AreEqual(exemplar.durationVal, inRec["DurationTest"], "Durations wrong post upload");
Assert.AreEqual(exemplar.currencyVal, inRec["CurrencyTest"], "Currency wrong post upload");
Assert.AreEqual(exemplar.percentVal, inRec["PercentTest"], "Percent wrong post upload");
Assert.AreEqual(exemplar.emailVal, inRec["EmailTest"], "Email wrong post upload");
Assert.AreEqual(exemplar.phoneVal, inRec["PhoneTest"], "Phone wrong post upload");
Assert.AreEqual(exemplar.urlVal, inRec["UrlTest"], "Url wrong post upload");
Assert.IsTrue(exemplar.multiTextVal.SetEquals((HashSet <int>)inRec["MultiTextTest"]), "MultiText wrong post upload");
Assert.AreEqual(exemplar.ratingVal, inRec["RatingTest"], "Rating wrong post upload");
testTable.Records.Clear();
testTable.Query();
IQRecord outRec = testTable.Records[0];
Assert.AreEqual(exemplar.textVal, outRec["TextTest"], "Strings roundtrip fail");
Assert.AreEqual(exemplar.floatVal, outRec["FloatTest"], "Floats roundtrip fail");
Assert.AreEqual(exemplar.checkboxVal, outRec["CheckboxTest"], "Checkboxes roundtrip fail");
Assert.AreEqual(exemplar.dateVal, outRec["DateTest"], "Dates roundtrip fail");
Assert.AreEqual(exemplar.timeStampVal, outRec["TimeStampTest"], "TimeStamps roundtrip fail");
Assert.AreEqual(exemplar.timeOfDayVal, outRec["TimeOfDayTest"], "TimeOfDays roundtrip fail");
Assert.AreEqual(exemplar.durationVal, outRec["DurationTest"], "Durations roundtrip fail");
Assert.AreEqual(exemplar.currencyVal, outRec["CurrencyTest"], "Currencies roundtrip fail");
Assert.AreEqual(exemplar.percentVal, outRec["PercentTest"], "Percents roundtrip fail");
Assert.AreEqual(exemplar.emailVal, outRec["EmailTest"], "Emails roundtrip fail");
Assert.AreEqual(exemplar.phoneVal, outRec["PhoneTest"], "Phones roundtrip fail");
Assert.AreEqual(exemplar.urlVal, outRec["UrlTest"], "Url roundtrip fail");
Assert.IsTrue(exemplar.multiTextVal.SetEquals((HashSet <int>)outRec["MultiTextTest"]), "MultiText roundtrip fail");
Assert.AreEqual(exemplar.ratingVal, outRec["RatingTest"], "Rating roundtrip fail");
exemplar.Setup2ndValues();
outRec["TextTest"] = exemplar.textVal;
outRec["FloatTest"] = exemplar.floatVal;
outRec["CheckboxTest"] = exemplar.checkboxVal;
outRec["DateTest"] = exemplar.dateVal;
outRec["TimeStampTest"] = exemplar.timeStampVal;
outRec["TimeOfDayTest"] = exemplar.timeOfDayVal;
outRec["DurationTest"] = exemplar.durationVal;
outRec["CurrencyTest"] = exemplar.currencyVal;
outRec["PercentTest"] = exemplar.percentVal;
outRec["EmailTest"] = exemplar.emailVal;
outRec["PhoneTest"] = exemplar.phoneVal;
outRec["UrlTest"] = exemplar.urlVal;
outRec["MultiTextTest"] = exemplar.multiTextVal;
outRec["RatingTest"] = exemplar.ratingVal;
testTable.AcceptChanges();
testTable.Query();
IQRecord outRec2 = testTable.Records[0];
Assert.AreEqual(exemplar.textVal, outRec2["TextTest"], "Strings update fail");
Assert.AreEqual(exemplar.floatVal, outRec2["FloatTest"], "Floats update fail");
Assert.AreEqual(exemplar.checkboxVal, outRec2["CheckboxTest"], "Checkboxes update fail");
Assert.AreEqual(exemplar.dateVal, outRec2["DateTest"], "Dates update fail");
Assert.AreEqual(exemplar.timeStampVal, outRec2["TimeStampTest"], "TimeStamps update fail");
Assert.AreEqual(exemplar.timeOfDayVal, outRec2["TimeOfDayTest"], "TimeOfDays update fail");
Assert.AreEqual(exemplar.durationVal, outRec2["DurationTest"], "Durations update fail");
Assert.AreEqual(exemplar.currencyVal, outRec2["CurrencyTest"], "Currencies update fail");
Assert.AreEqual(exemplar.percentVal, outRec2["PercentTest"], "Percents update fail");
Assert.AreEqual(exemplar.emailVal, outRec2["EmailTest"], "Emails update fail");
Assert.AreEqual(exemplar.phoneVal, outRec2["PhoneTest"], "Phones update fail");
Assert.AreEqual(exemplar.urlVal, outRec2["UrlTest"], "Url update fail");
Assert.IsTrue(exemplar.multiTextVal.SetEquals((HashSet <int>)outRec2["MultiTextTest"]), "MultiText update fail");
Assert.AreEqual(exemplar.ratingVal, outRec2["RatingTest"], "Rating update fail");
}
public void DeletionTest()
{
InitConnection();
List <GrantedAppsInfo> appsLst = qbApp.GrantedDBs();
foreach (var app in appsLst)
{
foreach (var tab in app.GrantedTables)
{
if (tab.Name == "APITestApp: APIDelTestTable")
{
IQTable tbl = qbApp.GetTable(tab.Dbid);
qbApp.DeleteTable(tbl);
break;
}
}
}
IQTable testTable = qbApp.NewTable("APIDelTestTable", "dummyRec");
testTable.Columns.Add(new QColumn("NumberValue", FieldType.@float));
testTable.Columns.Add(new QColumn("TextValue", FieldType.text));
IQRecord newRec = testTable.NewRecord();
newRec["NumberValue"] = 0;
newRec["TextValue"] = "Zeroeth";
testTable.Records.Add(newRec);
newRec = testTable.NewRecord();
newRec["NumberValue"] = 1;
newRec["TextValue"] = "First";
testTable.Records.Add(newRec);
newRec = testTable.NewRecord();
newRec["NumberValue"] = 2;
newRec["TextValue"] = "Second";
testTable.Records.Add(newRec);
newRec = testTable.NewRecord();
newRec["NumberValue"] = 3;
newRec["TextValue"] = "Third";
testTable.Records.Add(newRec);
newRec = testTable.NewRecord();
newRec["NumberValue"] = 4;
newRec["TextValue"] = "Fourth";
testTable.Records.Add(newRec);
newRec = testTable.NewRecord();
newRec["NumberValue"] = 5;
newRec["TextValue"] = "Fifth";
testTable.Records.Add(newRec);
newRec = testTable.NewRecord();
newRec["NumberValue"] = 6;
newRec["TextValue"] = "Sixth";
testTable.Records.Add(newRec);
newRec = testTable.NewRecord();
newRec["NumberValue"] = 7;
newRec["TextValue"] = "Seventh";
testTable.Records.Add(newRec);
newRec = testTable.NewRecord();
newRec["NumberValue"] = 8;
newRec["TextValue"] = "Eighth";
testTable.Records.Add(newRec);
newRec = testTable.NewRecord();
newRec["NumberValue"] = 9;
newRec["TextValue"] = "Ninth";
testTable.Records.Add(newRec);
newRec = testTable.NewRecord();
newRec["NumberValue"] = 10;
newRec["TextValue"] = "Tenth";
testTable.Records.Add(newRec);
testTable.AcceptChanges();
testTable.Records.RemoveAt(10);
testTable.Records.RemoveAt(8);
testTable.Records.RemoveAt(7);
testTable.Records.RemoveAt(6);
testTable.Records.RemoveAt(3);
testTable.Records.RemoveAt(1);
testTable.AcceptChanges();
testTable.Query();
Assert.AreEqual(testTable.Records.Count, 5, "Record deletion fails");
}