/// <exception cref="System.Exception"></exception>
public static User Popula(IOdb odb)
{
// cria perfil
var profileAdmin = new Profile("administrador");
odb.Store(profileAdmin);
var profileOper = new Profile("operador");
odb.Store(profileOper);
// cria funcao
CreateFunctionProfile(odb, profileAdmin, profileOper);
// cria usuario
var user = new User();
user.SetCreationDate(new DateTime());
user.SetDeleted(false);
user.SetLastLogin(new DateTime());
user.SetLogin("admin");
user.SetName("Administrador");
user.SetPassword("trocar");
user.SetProfileId(profileAdmin);
user.SetRejectedLogin(0);
user.SetUpdateDate(new DateTime());
user.SetStatus(true);
user.SetSessionKey("123456");
odb.Store(user);
return user;
}
public void CopyRegions(IOdb odb, NorthwindDataSet dataSet)
{
//Processing Regions
LogMessage("Reading Regions...", false);
var adapter1 = new RegionTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("Regions: " + row.RegionID.ToString() + " ...", false);
var r = new Region {RegionID = row.RegionID, RegionDescription = row.RegionDescription};
odb.Store(r);
LogMessage("saved", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor<Region>().AddUniqueIndexOn("Region_RegionID_PK_index", Domain.Region.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances<Region>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with Regions" + Environment.NewLine, true);
}
public static IStorageEngine GetEngine(IOdb odb)
{
var oa = odb as OdbAdapter;
if (oa != null)
return oa.GetSession().GetStorageEngine();
throw new OdbRuntimeException(
NDatabaseError.InternalError.AddParameter(string.Format("getEngine not implemented for {0}",
odb.GetType().FullName)));
}
public void Terminate(IOdb odb, NorthwindDataSet dataSet)
{
if (dataSet != null)
dataSet.Dispose();
if (odb == null)
return;
odb.Close();
}
public virtual void TestArray6UpdateIncreasingArraySize()
{
IOdb odb = null;
var size = 50;
try
{
DeleteBase("array10.ndb");
odb = Open("array10.ndb");
var array = new Decimal[size];
var array2 = new Decimal[size + 1];
for (var i = 0; i < size; i++)
{
array[i] = new Decimal(((double)i) * 78954545 / 89);
array2[i] = new Decimal(((double)i) * 78954545 / 89);
}
array2[size] = new Decimal(100);
var owna = new ObjectWithNativeArrayOfBigDecimal("t1", array);
odb.Store(owna);
odb.Close();
odb = Open("array10.ndb");
var query = odb.Query <ObjectWithNativeArrayOfBigDecimal>();
var l = query.Execute <ObjectWithNativeArrayOfBigDecimal>();
var owna2 = l.GetFirst();
owna2.SetNumbers(array2);
odb.Store <ObjectWithNativeArrayOfBigDecimal>(owna2);
odb.Close();
odb = Open("array10.ndb");
var query1 = odb.Query <ObjectWithNativeArrayOfBigDecimal>();
l = query1.Execute <ObjectWithNativeArrayOfBigDecimal>();
var o = l.GetFirst();
AssertEquals(size + 1, (int)o.GetNumbers().Length);
AssertEquals(new Decimal(100), o.GetNumber(size));
AssertEquals((object)owna2.GetNumber(1), (object)o.GetNumber(1));
odb.Close();
DeleteBase("array10.ndb");
}
catch (Exception)
{
if (odb != null)
{
odb.Rollback();
}
throw;
}
}
public virtual void Test1000Objects()
{
var OdbFileName = "index2.test1.odb";
IOdb odb = null;
var size = 1000;
var start = OdbTime.GetCurrentTimeInMs();
try
{
DeleteBase(OdbFileName);
odb = Open(OdbFileName);
for (var i = 0; i < size; i++)
{
var io = new IndexedObject("name" + i, i, new DateTime());
odb.Store(io);
}
odb.Close();
Println("\n\n END OF INSERT \n\n");
odb = Open(OdbFileName);
var names = new[] { "name" };
odb.IndexManagerFor <IndexedObject>().AddUniqueIndexOn("index1", names);
Println("\n\n after create index\n\n");
var query = odb.Query <IndexedObject>();
query.Descend("name").Constrain((object)"name0").Equal();
var objects =
query.Execute <IndexedObject>(true);
Println("\n\nafter get Objects\n\n");
AssertEquals(1, objects.Count);
var query2 = odb.Query <IndexedObject>();
query2.Descend("duration").Constrain((object)9).Equal();
objects = query2.Execute <IndexedObject>(true);
AssertEquals(1, objects.Count);
objects = odb.Query <IndexedObject>().Execute <IndexedObject>(true);
AssertEquals(size, objects.Count);
}
finally
{
var end = OdbTime.GetCurrentTimeInMs();
Println((end - start) + "ms");
odb.Close();
}
}
public void GetWarriorByNegation()
{
IOdb odb = OdbFactory.Open(DbName);
try
{
IQuery query = odb.Query <Warrior>();
query.Descend("_name").Constrain("Warrior 1").Equal().Not();
IObjectSet <Warrior> result = query.Execute <Warrior>();
Assert.That(result.Count, Is.EqualTo(1));
PrintResult(result);
}
finally
{
odb.Close();
}
}
public void GetWarriorByExactAttackValue()
{
IOdb odb = OdbFactory.Open(DbName);
try
{
IQuery query = odb.Query <Warrior>();
query.Descend("_attack").Constrain(3).Equal();
IObjectSet <Warrior> result = query.Execute <Warrior>();
Assert.That(result.Count, Is.EqualTo(2));
PrintResult(result);
}
finally
{
odb.Close();
}
}
public virtual void Test13()
{
var baseName = GetBaseName();
IOdb odb = null;
DeleteBase(baseName);
odb = Open(baseName);
var f1 = new VO.Login.Function("function1");
var f2 = new VO.Login.Function("function2");
var f3 = new VO.Login.Function("function3");
odb.Store(f1);
odb.Store(f2);
odb.Store(f3);
var idf1 = odb.GetObjectId(f1);
var idf2 = odb.GetObjectId(f2);
var idf3 = odb.GetObjectId(f3);
var storageEngine = ((global::NDatabase.Odb)odb).GetStorageEngine();
var p1 = storageEngine.GetObjectReader().GetObjectPositionFromItsOid(idf1, true, false);
var p2 = storageEngine.GetObjectReader().GetObjectPositionFromItsOid(idf2, true, false);
var p3 = storageEngine.GetObjectReader().GetObjectPositionFromItsOid(idf3, true, false);
odb.Close();
try
{
odb = Open(baseName);
f1 = (VO.Login.Function)odb.GetObjectFromId(idf1);
f2 = (VO.Login.Function)odb.GetObjectFromId(idf2);
f3 = (VO.Login.Function)odb.GetObjectFromId(idf3);
odb.Delete(f3);
odb.Delete(f2);
odb.Close();
odb = Open(baseName);
var query = odb.Query <VO.Login.Function>();
var l = query.Execute <VO.Login.Function>();
odb.Close();
AssertEquals(1, l.Count);
}
catch (OdbRuntimeException)
{
DeleteBase(baseName);
throw;
}
DeleteBase(baseName);
}
public static void GetWarriorsByComparison()
{
IOdb odb = OdbFactory.Open(DbName);
try
{
IQuery query = odb.Query <Warrior>();
query.Descend("_attack").Constrain(2).Greater();
IObjectSet <Warrior> result = query.Execute <Warrior>();
Assert.That(result.Count, Is.EqualTo(2));
PrintResult(result);
}
finally
{
odb.Close();
}
}
public virtual void Test11()
{
IOdb odb = null;
try
{
odb = Open("cyclic.ndb");
var ci = ((global::NDatabase.Odb)odb).GetStorageEngine().GetSession().GetMetaModel().GetClassInfo(typeof(User), true);
AssertFalse(ci.HasCyclicReference());
}
finally
{
if (odb != null)
{
odb.Close();
}
}
}
public virtual void TestArray5()
{
IOdb odb = null;
var size = 50;
try
{
DeleteBase("array7.ndb");
odb = Open("array7.ndb");
var array = new Decimal[size];
for (var i = 0; i < size; i++)
{
array[i] = new Decimal(((double)i) * 78954545 / 89);
}
var owna = new ObjectWithNativeArrayOfBigDecimal("t1", array);
odb.Store(owna);
odb.Close();
odb = Open("array7.ndb");
var query = odb.Query <ObjectWithNativeArrayOfBigDecimal>();
var l = query.Execute <ObjectWithNativeArrayOfBigDecimal>();
var owna2 = l.GetFirst();
owna2.SetNumber(0, new Decimal(1));
odb.Store <ObjectWithNativeArrayOfBigDecimal>(owna2);
odb.Close();
odb = Open("array7.ndb");
var query1 = odb.Query <ObjectWithNativeArrayOfBigDecimal>();
l = query1.Execute <ObjectWithNativeArrayOfBigDecimal>();
var o = l.GetFirst();
AssertEquals((object)owna2.GetNumber(0), (object)o.GetNumber(0));
AssertEquals((object)owna2.GetNumber(1), (object)o.GetNumber(1));
odb.Close();
DeleteBase("array7.ndb");
}
catch (Exception)
{
if (odb != null)
{
odb.Rollback();
}
throw;
}
}
public virtual void TestArray1()
{
IOdb odb = null;
try
{
DeleteBase("array1.ndb");
odb = Open("array1.ndb");
decimal nb = odb.Query <PlayerWithArray>().Count();
var player = new PlayerWithArray("kiko");
player.AddGame("volley-ball");
player.AddGame("squash");
player.AddGame("tennis");
player.AddGame("ping-pong");
odb.Store(player);
odb.Close();
odb = Open("array1.ndb");
var query = odb.Query <PlayerWithArray>();
var l = query.Execute <PlayerWithArray>(true);
AssertEquals(nb + 1, l.Count);
// gets first player
var player2 = l.GetFirst();
AssertEquals(player.ToString(), (string)player2.ToString());
}
catch (Exception e)
{
if (odb != null)
{
odb.Rollback();
odb = null;
}
Console.WriteLine(e);
throw e;
}
finally
{
if (odb != null)
{
odb.Close();
}
DeleteBase("array1.ndb");
}
}
public virtual void NewDownload(string name, string email, string downloadType, string fileName)
{
IOdb odb = null;
User user = null;
try
{
odb = Open("download.ndb");
var query = odb.Query <User>();
query.Descend("email").Constrain((object)email).Equal();
var users = query.Execute <User>();
if (users.Count != 0)
{
user = users.GetFirst();
user.SetLastDownload(new DateTime());
user.SetNbDownloads(user.GetNbDownloads() + 1);
odb.Store(user);
}
else
{
user = new User();
user.SetName(name);
user.SetEmail(email);
user.SetLastDownload(new DateTime());
user.SetNbDownloads(1);
odb.Store(user);
}
var download = new Download();
download.SetFileName(fileName);
download.SetType(downloadType);
download.SetUser(user);
download.SetWhen(new DateTime());
odb.Store(download);
}
finally
{
if (odb != null)
{
odb.Close();
}
}
}
private void CopyCategories(IOdb odb)
{
//Processing Categories
LogMessage("Reading Categories...", false);
var adapter1 = new CategoriesTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("Categories: " + row.CategoryID.ToString() + " ...", false);
var c = new Category
{
CategoryID = row.CategoryID,
CategoryName = row.CategoryName,
Description = row.IsDescriptionNull() ? null : row.Description,
Picture = row.IsPictureNull() ? null : row.Picture
};
odb.Store(c);
LogMessage("saved", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor <Category>().AddUniqueIndexOn("Category_CategoryID_PK_index", Category.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances <Category>(odb).Count;
if (table1.Count == objectCount)
{
LogMessage(table1.Count + " objects saved", true);
}
else
{
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
}
LogMessage("Done with Categories" + Environment.NewLine, true);
}
public virtual void TestIsNull()
{
IOdb odb = null;
try
{
odb = Open(BaseName);
var query = odb.Query <TestClass>();
query.Descend("bigDecimal1").Constrain(null).Equal();
var l = query.Execute <TestClass>();
AssertEquals(0, l.Count);
}
finally
{
if (odb != null)
{
odb.Close();
}
}
}
private void CopyShippers(IOdb odb)
{
//Processing Shippers
LogMessage("Reading Shippers...", false);
var adapter1 = new ShippersTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("Shippers: " + row.ShipperID.ToString() + " ...", false);
var s = new Shipper
{
ShipperID = row.ShipperID,
CompanyName = row.CompanyName,
Phone = row.IsPhoneNull() ? null : row.Phone
};
odb.Store(s);
LogMessage("saved", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor <Shipper>().AddUniqueIndexOn("Shipper_ShipperID_PK_index", Shipper.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances <Shipper>(odb).Count;
if (table1.Count == objectCount)
{
LogMessage(table1.Count + " objects saved", true);
}
else
{
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
}
LogMessage("Done with Shippers" + Environment.NewLine, true);
}
public virtual void TestArrayOfDate()
{
IOdb odb = null;
var size = 50;
try
{
DeleteBase("array6.ndb");
odb = Open("array6.ndb");
var array = new DateTime[size];
var now = new DateTime();
for (var i = 0; i < size; i++)
{
array[i] = new DateTime(now.Millisecond + i);
}
var owna = new ObjectWithNativeArrayOfDate("t1", array);
odb.Store(owna);
odb.Close();
odb = Open("array6.ndb");
var query = odb.Query <ObjectWithNativeArrayOfDate>();
var l = query.Execute <ObjectWithNativeArrayOfDate>();
var owna2 = l.GetFirst();
AssertEquals(owna.GetName(), (string)owna2.GetName());
for (var i = 0; i < size; i++)
{
AssertEquals(owna.GetNumbers()[i], owna2.GetNumbers()[i]);
}
odb.Close();
odb = null;
DeleteBase("array6.ndb");
}
catch (Exception)
{
if (odb != null)
{
odb.Rollback();
}
throw;
}
}
private void CopyTerritories(IOdb odb)
{
//Processing Territories
LogMessage("Reading Territories...", false);
var adapter1 = new TerritoriesTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("Territories: " + row.TerritoryID + " ...", false);
var t = new Territory {
TerritoryID = row.TerritoryID, TerritoryDescription = row.TerritoryDescription
};
LogMessage("linking member...", false);
t.Region = NDbUtil.GetByNumericalID <Region>(odb, Domain.Region.PK, row.RegionID);
odb.Store(t);
LogMessage("saved (" + t.TerritoryID + ")", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor <Territory>().AddUniqueIndexOn("Territory_TerritoryID_PK_index", Territory.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances <Territory>(odb).Count;
if (table1.Count == objectCount)
{
LogMessage(table1.Count + " objects saved", true);
}
else
{
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
}
LogMessage("Done with Territories" + Environment.NewLine, true);
}
private void CopyCustomerDemographics(IOdb odb)
{
//Processing CustomerDemographics
LogMessage("Reading CustomerDemographics...", false);
var adapter1 = new CustomerDemographicsTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("CustomerDemographics: " + row.CustomerTypeID + " ...", false);
var cd = new CustomerDemographics
{
CustomerTypeID = row.CustomerTypeID,
CustomerDesc = row.IsCustomerDescNull() ? null : row.CustomerDesc
};
odb.Store(cd);
LogMessage("saved", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor <CustomerDemographics>().AddUniqueIndexOn(
"CustomerDemographics_CustomerTypeID_PK_index", CustomerDemographics.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances <CustomerDemographics>(odb).Count;
if (table1.Count == objectCount)
{
LogMessage(table1.Count + " objects saved", true);
}
else
{
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
}
LogMessage("Done with CustomerDemographics" + Environment.NewLine, true);
}
public virtual void Test1()
{
IOdb odb = null;
DeleteBase(Base);
try
{
odb = Open(Base);
odb.TriggerManagerFor <ObjectWithAutoIncrementId>().AddInsertTrigger(new LocalAutoIncrementTrigger());
var o = new ObjectWithAutoIncrementId("Object 1");
odb.Store(o);
AssertEquals(1, o.GetId());
}
finally
{
if (odb != null)
{
odb.Close();
}
}
}
public virtual void Test3()
{
// LogUtil.objectReaderOn(true);
DeleteBase("map-with-collections");
IOdb odb = null;
odb = Open("map-with-collections");
var o = new MyMapObject("test");
IList <MyMapObject> c = new List <MyMapObject>();
c.Add(o);
var f1 = new VO.Login.Function("function1");
o.GetMap().Add("a", c);
var size = 1;
for (var i = 0; i < size; i++)
{
o.GetMap().Add("A" + i, f1);
}
o.GetMap().Add("c", f1);
Println("RealMap" + o.GetMap());
odb.Store(o);
odb.Close();
odb = Open("map-with-collections");
var query = odb.Query <MyMapObject>();
var os = query.Execute <MyMapObject>();
var mmo = os.GetFirst();
odb.Close();
DeleteBase("map-with-collections");
AssertEquals(o.GetName(), mmo.GetName());
AssertEquals(size + 2, mmo.GetMap().Count);
var enumerator = ((ICollection)mmo.GetMap()["a"]).GetEnumerator();
enumerator.MoveNext();
AssertEquals(mmo, enumerator.Current);
AssertEquals("function1", mmo.GetMap()["c"].ToString());
}
public virtual void TestArray4()
{
DeleteBase("array5.ndb");
IOdb odb = null;
var size = 50;
try
{
odb = Open("array5.ndb");
var array = new Decimal[size];
for (var i = 0; i < size; i++)
{
array[i] = new Decimal(((double)i) * 78954545 / 89);
}
var owna = new ObjectWithNativeArrayOfBigDecimal("t1", array);
odb.Store(owna);
odb.Close();
odb = Open("array5.ndb");
var query = odb.Query <ObjectWithNativeArrayOfBigDecimal>();
var l = query.Execute <ObjectWithNativeArrayOfBigDecimal>();
var owna2 = l.GetFirst();
AssertEquals(owna.GetName(), (string)owna2.GetName());
for (var i = 0; i < size; i++)
{
AssertEquals(owna.GetNumbers()[i], owna2.GetNumbers()[i]);
}
odb.Close();
odb = null;
DeleteBase("array5.ndb");
}
catch (Exception)
{
if (odb != null)
{
odb.Rollback();
odb = null;
}
throw;
}
}
public virtual void TestCollectionWithContain()
{
IOdb odb = null;
var baseName = GetBaseName();
try
{
odb = Open(baseName);
var nb = odb.Query <PlayerWithList>().Count();
var player = new PlayerWithList("kiko");
player.AddGame("volley-ball");
player.AddGame("squash");
player.AddGame("tennis");
player.AddGame("ping-pong");
odb.Store(player);
odb.Close();
odb = Open(baseName);
var query = odb.Query <PlayerWithList>();
query.Descend("games").Constrain("tennis").Contains();
var l = query.Execute <PlayerWithList>();
AssertEquals(nb + 1, l.Count);
}
catch (Exception)
{
if (odb != null)
{
odb.Rollback();
odb = null;
}
throw;
}
finally
{
if (odb != null)
{
odb.Close();
}
}
}
public virtual void TestListSizeNotEqulTo1()
{
IOdb odb = null;
try
{
var baseName = GetBaseName();
Init(baseName);
odb = Open(baseName);
var query = odb.Query <User>();
query.Descend("profile.functions").Constrain(1).SizeNe();
var l = query.Execute <User>();
AssertEquals(2, l.Count());
}
finally
{
if (odb != null)
{
odb.Close();
}
}
}
public virtual void Test2UpdateTriggers()
{
if (!testNewFeature)
{
return;
}
IOdb odb = null;
var baseName = GetBaseName();
DeleteBase(baseName);
var myTrigger = new MyUpdateTriggerBefore();
try
{
odb = Open(baseName);
var so = new SimpleObject(5);
var oid = odb.Store(so);
AssertEquals(5, so.GetId());
odb.Close();
odb = Open(baseName);
odb.TriggerManagerFor <SimpleObject>().AddUpdateTrigger(myTrigger);
var so2 = (SimpleObject)odb.GetObjectFromId(oid);
AssertEquals(5, so2.GetId());
odb.Store(so2);
odb.Close();
AssertEquals(6, so2.GetId());
odb = Open(baseName);
so2 = (SimpleObject)odb.GetObjectFromId(oid);
AssertEquals(6, so2.GetId());
}
finally
{
if (odb != null && !odb.IsClosed())
{
odb.Close();
}
}
DeleteBase(baseName);
}
private void CopyOrderDetails(IOdb odb, ref double progress)
{
//Processing OrderDetails
LogMessage("Reading OrderDetails...", false);
var adapter1 = new Order_DetailsTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("OrderDetails: " + row.OrderID.ToString() + "/" + row.ProductID.ToString() + " ...", false);
var od = new OrderDetail();
LogMessage("linking members...", false);
od.Order = NDbUtil.GetByNumericalID <Order>(odb, Order.PK, row.OrderID);
od.Product = NDbUtil.GetByNumericalID <Product>(odb, Product.PK, row.ProductID);
od.UnitPrice = Convert.ToDouble(row.UnitPrice);
od.Quantity = row.Quantity;
od.Discount = Convert.ToDouble(row.Discount);
odb.Store(od);
StepFinished(progress += 0.029);
LogMessage("saved (" + od.Order.OrderID.ToString() + "/" + od.Product.ProductID.ToString() + ")",
true);
}
odb.Commit();
long objectCount = NDbUtil.GetAllInstances <OrderDetail>(odb).Count;
if (table1.Count == objectCount)
{
LogMessage(table1.Count + " objects saved", true);
}
else
{
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
}
LogMessage("Done with OrderDetails" + Environment.NewLine, true);
}
public void CopyRegions(IOdb odb, NorthwindDataSet dataSet)
{
//Processing Regions
LogMessage("Reading Regions...", false);
var adapter1 = new RegionTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("Regions: " + row.RegionID.ToString() + " ...", false);
var r = new Region {
RegionID = row.RegionID, RegionDescription = row.RegionDescription
};
odb.Store(r);
LogMessage("saved", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor <Region>().AddUniqueIndexOn("Region_RegionID_PK_index", Domain.Region.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances <Region>(odb).Count;
if (table1.Count == objectCount)
{
LogMessage(table1.Count + " objects saved", true);
}
else
{
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
}
LogMessage("Done with Regions" + Environment.NewLine, true);
}
public virtual void TestSelectUnCommitedObject2()
{
IOdb odb = null;
try
{
DeleteBase(BaseName);
odb = Open(BaseName);
for (var i = 0; i < 4; i++)
{
odb.Store(new User("user" + i, "email" + i,
new Profile("profile" + i, new VO.Login.Function("function" + i))));
}
odb.Close();
// reopen the database
odb = Open(BaseName);
// stores a new function
odb.Store(new User("uncommited user", "uncommied email",
new Profile("uncommiedt profile", new VO.Login.Function("uncommited function"))));
var query = odb.Query <User>();
var users = query.Execute <User>();
AssertEquals(5, users.Count);
var query1 = odb.Query <VO.Login.Function>();
var functions = query1.Execute <VO.Login.Function>();
AssertEquals(5, functions.Count);
var query2 = odb.Query <Profile>();
var profiles = query2.Execute <Profile>();
AssertEquals(5, profiles.Count);
}
finally
{
if (odb != null)
{
odb.Close();
DeleteBase(BaseName);
}
}
}
public void GetWarriorsByStartsOrEndsWith()
{
IOdb odb = OdbFactory.Open(DbName);
try
{
IQuery query2 = odb.Query <Warrior>();
query2.Descend("_name").Constrain("Warr").StartsWith(false);
IObjectSet <Warrior> result1 = query2.Execute <Warrior>();
Assert.That(result1.Count, Is.EqualTo(2));
PrintResult(result1);
IQuery query3 = odb.Query <Warrior>();
query3.Descend("_name").Constrain("rior 1").EndsWith(false);
IObjectSet <Warrior> result2 = query3.Execute <Warrior>();
Assert.That(result2.Count, Is.EqualTo(1));
PrintResult(result2);
}
finally
{
odb.Close();
}
}
public virtual void Test3_BadAttributeInIndex()
{
var baseName = GetBaseName();
IOdb odb = null;
var fieldName = "fkjdsfkjdhfjkdhjkdsh";
try
{
odb = Open(baseName);
var fields = new[] { fieldName };
odb.IndexManagerFor <IndexedObject2>().AddUniqueIndexOn("index1", fields);
Fail("Should have thrown an exception because the field " + fieldName + " does not exist");
}
catch (Exception)
{
}
finally
{
// normal
odb.Close();
DeleteBase(baseName);
}
}
public virtual void Test5_byOid()
{
IOdb odb = null;
var baseName = GetBaseName();
odb = Open(baseName);
var f = new VO.Login.Function("function1");
odb.Store(f);
var oid = odb.GetObjectId(f);
try
{
odb.DeleteObjectWithId(oid);
var id2 = odb.GetObjectId(f);
Fail("The object has been deleted, the id should have been marked as deleted");
}
catch (OdbRuntimeException)
{
odb.Close();
DeleteBase(baseName);
}
}
public virtual void Test8()
{
var baseName = GetBaseName();
Println(baseName);
IOdb odb = null;
var utilDate = new DateTime();
var sqlDate = new DateTime(utilDate.Millisecond + 10000);
var timestamp = new DateTime(utilDate.Millisecond + 20000);
try
{
odb = Open(baseName);
var o = new ObjectWithDates("object1", utilDate, sqlDate, timestamp);
odb.Store(o);
odb.Close();
odb = Open(baseName);
var query = odb.Query <ObjectWithDates>();
var dates = query.Execute <ObjectWithDates>();
var o2 = dates.GetFirst();
Println(o2.GetName());
Println(o2.GetJavaUtilDate());
Println(o2.GetJavaSqlDte());
Println(o2.GetTimestamp());
AssertEquals((string)"object1", (string)o2.GetName());
AssertEquals(utilDate, o2.GetJavaUtilDate());
AssertEquals(sqlDate, o2.GetJavaSqlDte());
AssertEquals(timestamp, o2.GetTimestamp());
}
finally
{
if (odb != null)
{
odb.Close();
}
}
}
public virtual void Test12()
{
var baseName = GetBaseName();
IOdb odb = null;
odb = Open(baseName);
var f1 = new VO.Login.Function("function1");
var f2 = new VO.Login.Function("function2");
var f3 = new VO.Login.Function("function3");
odb.Store(f1);
odb.Store(f2);
odb.Store(f3);
var idf1 = odb.GetObjectId(f1);
var idf2 = odb.GetObjectId(f2);
var idf3 = odb.GetObjectId(f3);
odb.Close();
try
{
odb = Open(baseName);
odb.DeleteObjectWithId(idf3);
odb.DeleteObjectWithId(idf2);
odb.Close();
odb = Open(baseName);
var query = odb.Query <VO.Login.Function>();
var l = query.Execute <VO.Login.Function>();
odb.Close();
AssertEquals(1, l.Count);
}
catch (OdbRuntimeException)
{
DeleteBase(baseName);
throw;
}
}
private void CopyCustomerDemographics(IOdb odb)
{
//Processing CustomerDemographics
LogMessage("Reading CustomerDemographics...", false);
var adapter1 = new CustomerDemographicsTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("CustomerDemographics: " + row.CustomerTypeID + " ...", false);
var cd = new CustomerDemographics
{
CustomerTypeID = row.CustomerTypeID,
CustomerDesc = row.IsCustomerDescNull() ? null : row.CustomerDesc
};
odb.Store(cd);
LogMessage("saved", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor<CustomerDemographics>().AddUniqueIndexOn(
"CustomerDemographics_CustomerTypeID_PK_index", CustomerDemographics.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances<CustomerDemographics>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with CustomerDemographics" + Environment.NewLine, true);
}
private void CopyCustomerCustomerDemo(IOdb odb)
{
//Processing CustomerCustomerDemo
LogMessage("Reading CustomerCustomerDemo...", false);
var adapter1 = new CustomerCustomerDemoTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("CustomerCustomerDemo: " + row.CustomerID + "/" + row.CustomerTypeID + " ...", false);
var ccd = new CustomerCustomerDemo();
LogMessage("linking members...", false);
ccd.CustomerID = NDbUtil.GetByStringID<Customer>(odb, Customer.PK, row.CustomerID);
ccd.CustomerTypeID = NDbUtil.GetByStringID<CustomerDemographics>(odb, CustomerDemographics.PK,
row.CustomerTypeID);
odb.Store(ccd);
LogMessage("saved (" + ccd.CustomerID.CustomerID + "/" + ccd.CustomerTypeID.CustomerTypeID + ")", true);
}
odb.Commit();
long objectCount = NDbUtil.GetAllInstances<CustomerCustomerDemo>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with CustomerCustomerDemo" + Environment.NewLine, true);
}
private void CopyOrderDetails(IOdb odb, ref double progress)
{
//Processing OrderDetails
LogMessage("Reading OrderDetails...", false);
var adapter1 = new Order_DetailsTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("OrderDetails: " + row.OrderID.ToString() + "/" + row.ProductID.ToString() + " ...", false);
var od = new OrderDetail();
LogMessage("linking members...", false);
od.Order = NDbUtil.GetByNumericalID<Order>(odb, Order.PK, row.OrderID);
od.Product = NDbUtil.GetByNumericalID<Product>(odb, Product.PK, row.ProductID);
od.UnitPrice = Convert.ToDouble(row.UnitPrice);
od.Quantity = row.Quantity;
od.Discount = Convert.ToDouble(row.Discount);
odb.Store(od);
StepFinished(progress += 0.029);
LogMessage("saved (" + od.Order.OrderID.ToString() + "/" + od.Product.ProductID.ToString() + ")",
true);
}
odb.Commit();
long objectCount = NDbUtil.GetAllInstances<OrderDetail>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with OrderDetails" + Environment.NewLine, true);
}
/// <exception cref="System.Exception"></exception>
public static void CreateFunctionProfile(IOdb odb, Profile admin, Profile oper)
{
var function = new Functions();
function.SetDescription("Inclus√£o de usu√£rio");
function.SetName("incluiUsuario");
function.SetNameUrl("usuario.do/criar");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Edi√£√£o de Usu√£rio");
function.SetName("editaUsuario");
function.SetNameUrl("usuario.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Exclus√£o de Usu√£rio");
function.SetName("excluiUsuario");
function.SetNameUrl("usuario.do/excluir");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Consulta de Usu√£rios");
function.SetName("listaUsuario");
function.SetNameUrl("usuario.do/visualizar");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do usu√£rio");
function.SetName("usuario");
function.SetNameUrl("consultaUsuario.do/editar");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do usu√£rio");
function.SetName("usuario");
function.SetNameUrl("consultaUsuario.do/excluir");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do usu√£rio");
function.SetName("usuario");
function.SetNameUrl("consultaUsuario.do/visualizar");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller da senha");
function.SetName("alteraSenha");
function.SetNameUrl("alteraSenha.do/editar");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller da senha");
function.SetName("alteraSenha");
function.SetNameUrl("alteraSenha.do");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Altera√£√£o de Senha de outros");
function.SetName("alteraSenhaOutros");
function.SetNameUrl("alteraSenhaOutros.do/editar");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Altera√£√£o de Senha de outros");
function.SetName("alteraSenhaOutros");
function.SetNameUrl("alteraSenhaOutros.do");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("P√£gina Principal");
function.SetName("main");
function.SetNameUrl("main.jsp");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("P√£gina Sobre");
function.SetName("main_sobre");
function.SetNameUrl("main_sobre.jsp");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Inclus√£o de PMV");
function.SetName("incluiPmv");
function.SetNameUrl("pmv.do/create");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Edi√£√£o de PMV");
function.SetName("editaPmv");
function.SetNameUrl("pmv.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Exclus√£o de Pmv");
function.SetName("excluiPmv");
function.SetNameUrl("pmv.do/delete");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Consulta de PMV");
function.SetName("listaPmv");
function.SetNameUrl("pmv.do/view");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do PMV");
function.SetName("PMV");
function.SetNameUrl("searchPmv.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do PMV");
function.SetName("PMV");
function.SetNameUrl("searchPmv.do/delete");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do PMV");
function.SetName("PMV");
function.SetNameUrl("searchPmv.do/view");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Inclus√£o de Fornecedor");
function.SetName("incluiFornecedor");
function.SetNameUrl("constructor.do/create");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Edi√£√£o de Fornecedor");
function.SetName("editaFornecedor");
function.SetNameUrl("constructor.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Exclus√£o de Fornecedor");
function.SetName("excluiFornecedor");
function.SetNameUrl("constructor.do/delete");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Consulta de Fornecedor");
function.SetName("listaFornecedor");
function.SetNameUrl("constructor.do/view");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do Fornecedor");
function.SetName("Fornecedor");
function.SetNameUrl("searchConstructor.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do Fornecedor");
function.SetName("Fornecedor");
function.SetNameUrl("searchConstructor.do/delete");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do Fornecedor");
function.SetName("Fornecedor");
function.SetNameUrl("searchConstructor.do/view");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Inclus√£o de AT");
function.SetName("incluiAT");
function.SetNameUrl("at.do/create");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Edi√£√£o de AT");
function.SetName("editaAT");
function.SetNameUrl("at.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Exclus√£o de AT");
function.SetName("excluiAT");
function.SetNameUrl("at.do/delete");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Consulta de AT");
function.SetName("listaAT");
function.SetNameUrl("at.do/view");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do AT");
function.SetName("AT");
function.SetNameUrl("searchAt.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do AT");
function.SetName("AT");
function.SetNameUrl("searchAt.do/delete");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do AT");
function.SetName("AT");
function.SetNameUrl("searchAt.do/view");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Inclus√£o de Sensor AT");
function.SetName("incluiSensorAT");
function.SetNameUrl("sensorAt.do/create");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Edi√£√£o de Sensor AT");
function.SetName("editaSensorAT");
function.SetNameUrl("sensorAt.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Exclus√£o de Sensor AT");
function.SetName("excluiSensorAT");
function.SetNameUrl("sensorAt.do/delete");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Consulta de Sensor AT");
function.SetName("listaSensorAT");
function.SetNameUrl("sensorAt.do/view");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do Sensor AT");
function.SetName("SensorAT");
function.SetNameUrl("searchSensorAt.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do Sensor AT");
function.SetName("SensorAT");
function.SetNameUrl("searchSensorAt.do/delete");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do Sensor AT");
function.SetName("SensorAT");
function.SetNameUrl("searchSensorAt.do/view");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Inclus√£o de Meteo");
function.SetName("incluiMeteo");
function.SetNameUrl("meteo.do/create");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Edi√£√£o de Meteo");
function.SetName("editaMeteo");
function.SetNameUrl("meteo.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Exclus√£o de Meteo");
function.SetName("excluiMeteo");
function.SetNameUrl("meteo.do/delete");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Consulta de Meteo");
function.SetName("listaMeteo");
function.SetNameUrl("meteo.do/view");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do Meteo");
function.SetName("Meteo");
function.SetNameUrl("searchMeteo.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do Meteo");
function.SetName("Meteo");
function.SetNameUrl("searchMeteo.do/delete");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do Meteo");
function.SetName("Meteo");
function.SetNameUrl("searchMeteo.do/view");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Inclus√£o de Sensor Meteo");
function.SetName("incluiSensorMeteo");
function.SetNameUrl("sensorMeteo.do/create");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Edi√£√£o de Sensor Meteo");
function.SetName("editaSensorMeteo");
function.SetNameUrl("sensorMeteo.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Exclus√£o de Sensor Meteo");
function.SetName("excluiSensorMeteo");
function.SetNameUrl("sensorMeteo.do/delete");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Consulta de Sensor Meteo");
function.SetName("listaSensorMeteo");
function.SetNameUrl("sensorMeteo.do/view");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do Sensor Meteo");
function.SetName("SensorMeteo");
function.SetNameUrl("searchSensorMeteo.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do Sensor Meteo");
function.SetName("SensorMeteo");
function.SetNameUrl("searchSensorMeteo.do/delete");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do Sensor Meteo");
function.SetName("SensorMeteo");
function.SetNameUrl("searchSensorMeteo.do/view");
function.AddProfile(admin);
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do PmvMessage");
function.SetName("sendPmvMessage");
function.SetNameUrl("sendMessagePmv.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do ActiveConf");
function.SetName("activeConf");
function.SetNameUrl("activeConf.do/edit");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do Monitor");
function.SetName("monitor");
function.SetNameUrl("monitor.do/view");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller do Monitor");
function.SetName("monitor");
function.SetNameUrl("monitor.do/view");
function.AddProfile(oper);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller da Consulta Mensage");
function.SetName("searchMessagePMV");
function.SetNameUrl("searchMessagePmv.do/view");
function.AddProfile(admin);
odb.Store(function);
function = new Functions();
function.SetDescription("Controller da Consulta Mensage");
function.SetName("searchMessagePMV");
function.SetNameUrl("searchMessagePmv.do/view");
function.AddProfile(oper);
odb.Store(function);
}
private void CopyEmployees(IOdb odb)
{
var employees = new List<Employee>();
var reportingEmployees = new Hashtable();
//Processing Employees
LogMessage("Reading Employees...", false);
var adapter1 = new EmployeesTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
var e = new Employee
{
EmployeeID = row.EmployeeID,
FirstName = row.FirstName,
LastName = row.LastName,
Title = row.IsTitleNull() ? null : row.Title,
TitleOfCourtesy = row.IsTitleOfCourtesyNull() ? null : row.TitleOfCourtesy,
Address = row.IsAddressNull() ? null : row.Address,
City = row.IsCityNull() ? null : row.City,
Region = row.IsRegionNull() ? null : row.Region,
PostalCode = row.IsPostalCodeNull() ? null : row.PostalCode,
Country = row.IsCountryNull() ? null : row.Country,
HomePhone = row.IsHomePhoneNull() ? null : row.HomePhone,
Extension = row.IsExtensionNull() ? null : row.Extension,
Notes = row.IsNotesNull() ? null : row.Notes,
Photo = row.IsPhotoNull() ? null : row.Photo,
PhotoPath = row.IsPhotoPathNull() ? null : row.PhotoPath
};
if (!row.IsBirthDateNull())
e.BirthDate = row.BirthDate;
if (!row.IsHireDateNull())
e.HireDate = row.HireDate;
if (!row.IsReportsToNull())
reportingEmployees.Add(e.EmployeeID, row.ReportsTo);
employees.Add(e);
}
foreach (var e in employees)
{
LogMessage("Employee: " + e.EmployeeID.ToString() + " ...", false);
if (reportingEmployees.ContainsKey(e.EmployeeID))
{
LogMessage("linking member...", false);
var reportsToID = Convert.ToInt64(reportingEmployees[e.EmployeeID]);
var found = employees.Find(p => p.EmployeeID == reportsToID);
e.ReportsTo = found;
}
odb.Store(e);
LogMessage("saved (" + e.EmployeeID.ToString() + ")", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor<Employee>().AddUniqueIndexOn("Employee_EmployeeID_PK_index", Employee.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances<Employee>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with Employees" + Environment.NewLine, true);
}
private void CopyCategories(IOdb odb)
{
//Processing Categories
LogMessage("Reading Categories...", false);
var adapter1 = new CategoriesTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("Categories: " + row.CategoryID.ToString() + " ...", false);
var c = new Category
{
CategoryID = row.CategoryID,
CategoryName = row.CategoryName,
Description = row.IsDescriptionNull() ? null : row.Description,
Picture = row.IsPictureNull() ? null : row.Picture
};
odb.Store(c);
LogMessage("saved", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor<Category>().AddUniqueIndexOn("Category_CategoryID_PK_index", Category.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances<Category>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with Categories" + Environment.NewLine, true);
}
private void CopySuppliers(IOdb odb)
{
//Processing Suppliers
LogMessage("Reading Suppliers...", false);
var adapter1 = new SuppliersTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("Supplier: " + row.SupplierID.ToString() + " ...", false);
var s = new Supplier
{
SupplierID = row.SupplierID,
CompanyName = row.CompanyName,
ContactName = row.IsContactNameNull() ? null : row.ContactName,
ContactTitle = row.IsContactTitleNull() ? null : row.ContactTitle,
Address = row.IsAddressNull() ? null : row.Address,
City = row.IsCityNull() ? null : row.City,
Region = row.IsRegionNull() ? null : row.Region,
PostalCode = row.IsPostalCodeNull() ? null : row.PostalCode,
Country = row.IsCountryNull() ? null : row.Country,
Phone = row.IsPhoneNull() ? null : row.Phone,
Fax = row.IsFaxNull() ? null : row.Fax,
HomePage = row.IsHomePageNull() ? null : row.HomePage
};
odb.Store(s);
LogMessage("saved", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor<Supplier>().AddUniqueIndexOn("Supplier_SupplierID_PK_index", Supplier.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances<Supplier>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with Suppliers" + Environment.NewLine, true);
}
private void CopyTerritories(IOdb odb)
{
//Processing Territories
LogMessage("Reading Territories...", false);
var adapter1 = new TerritoriesTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("Territories: " + row.TerritoryID + " ...", false);
var t = new Territory {TerritoryID = row.TerritoryID, TerritoryDescription = row.TerritoryDescription};
LogMessage("linking member...", false);
t.Region = NDbUtil.GetByNumericalID<Region>(odb, Domain.Region.PK, row.RegionID);
odb.Store(t);
LogMessage("saved (" + t.TerritoryID + ")", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor<Territory>().AddUniqueIndexOn("Territory_TerritoryID_PK_index", Territory.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances<Territory>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with Territories" + Environment.NewLine, true);
}
private void CopyShippers(IOdb odb)
{
//Processing Shippers
LogMessage("Reading Shippers...", false);
var adapter1 = new ShippersTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("Shippers: " + row.ShipperID.ToString() + " ...", false);
var s = new Shipper
{
ShipperID = row.ShipperID,
CompanyName = row.CompanyName,
Phone = row.IsPhoneNull() ? null : row.Phone
};
odb.Store(s);
LogMessage("saved", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor<Shipper>().AddUniqueIndexOn("Shipper_ShipperID_PK_index", Shipper.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances<Shipper>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with Shippers" + Environment.NewLine, true);
}
private void CopyProducts(IOdb odb)
{
var products = new List<Product>();
var suppliers = new Hashtable();
var categories = new Hashtable();
//Processing Products
LogMessage("Reading Products...", false);
var adapter1 = new ProductsTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
var p = new Product
{
ProductID = row.ProductID,
ProductName = row.ProductName,
QuantityPerUnit = row.IsQuantityPerUnitNull() ? null : row.QuantityPerUnit,
UnitPrice = row.IsUnitPriceNull() ? 0 : Convert.ToDouble(row.UnitPrice),
UnitsInStock = row.IsUnitsInStockNull() ? 0 : row.UnitsInStock,
UnitsOnOrder = row.IsUnitsOnOrderNull() ? 0 : row.UnitsOnOrder,
ReorderLevel = row.IsReorderLevelNull() ? 0 : row.ReorderLevel,
Discontinued = row.Discontinued
};
if (!row.IsSupplierIDNull())
suppliers.Add(p.ProductID, row.SupplierID);
if (!row.IsCategoryIDNull())
categories.Add(p.ProductID, row.CategoryID);
products.Add(p);
}
foreach (var p in products)
{
LogMessage("Product: " + p.ProductID.ToString() + " ...", false);
if (suppliers.ContainsKey(p.ProductID))
{
LogMessage("linking member...", false);
var supplierID = Convert.ToInt64(suppliers[p.ProductID]);
var found = NDbUtil.GetByNumericalID<Supplier>(odb, Supplier.PK, supplierID);
p.Supplier = found;
}
if (categories.ContainsKey(p.ProductID))
{
LogMessage("linking member...", false);
var categoryID = Convert.ToInt64(categories[p.ProductID]);
var found = NDbUtil.GetByNumericalID<Category>(odb, Category.PK, categoryID);
p.Category = found;
}
odb.Store(p);
LogMessage("saved (" + p.ProductID.ToString() + ")", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor<Product>().AddUniqueIndexOn("Product_ProductID_PK_index", Product.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances<Product>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with Products" + Environment.NewLine, true);
}
private void CopyOrders(IOdb odb, ref double progress)
{
var orders = new List<Order>();
var customers = new Hashtable();
var employees = new Hashtable();
var shippers = new Hashtable();
//Processing Orders
LogMessage("Reading Orders...", false);
var adapter1 = new OrdersTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
var o = new Order
{
OrderID = row.OrderID,
Freight = row.IsFreightNull() ? 0 : Convert.ToDouble(row.Freight),
ShipName = row.IsShipNameNull() ? null : row.ShipName,
ShipAddress = row.IsShipAddressNull() ? null : row.ShipAddress,
ShipCity = row.IsShipCityNull() ? null : row.ShipCity,
ShipRegion = row.IsShipRegionNull() ? null : row.ShipRegion,
ShipPostalCode = row.IsShipPostalCodeNull() ? null : row.ShipPostalCode,
ShipCountry = row.IsShipCountryNull() ? null : row.ShipCountry
};
if (!row.IsCustomerIDNull())
customers.Add(o.OrderID, row.CustomerID);
if (!row.IsEmployeeIDNull())
employees.Add(o.OrderID, row.EmployeeID);
if (!row.IsShipViaNull())
shippers.Add(o.OrderID, row.ShipVia);
if (!row.IsOrderDateNull())
o.OrderDate = row.OrderDate;
if (!row.IsRequiredDateNull())
o.RequiredDate = row.RequiredDate;
if (!row.IsShippedDateNull())
o.ShippedDate = row.ShippedDate;
orders.Add(o);
}
foreach (var o in orders)
{
LogMessage("Order: " + o.OrderID.ToString() + " ...", false);
if (customers.ContainsKey(o.OrderID))
{
LogMessage("linking member...", false);
var customerID = Convert.ToString(customers[o.OrderID]);
var found = NDbUtil.GetByStringID<Customer>(odb, Customer.PK, customerID);
o.Customer = found;
}
if (employees.ContainsKey(o.OrderID))
{
LogMessage("linking member...", false);
var employeeID = Convert.ToInt64(employees[o.OrderID]);
var found = NDbUtil.GetByNumericalID<Employee>(odb, Employee.PK, employeeID);
o.Employee = found;
}
if (shippers.ContainsKey(o.OrderID))
{
LogMessage("linking member...", false);
var shipperID = Convert.ToInt64(shippers[o.OrderID]);
var found = NDbUtil.GetByNumericalID<Shipper>(odb, Shipper.PK, shipperID);
o.ShipVia = found;
}
odb.Store(o);
StepFinished(progress += 0.029);
LogMessage("saved (" + o.OrderID.ToString() + ")", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor<Order>().AddUniqueIndexOn("Order_OrderID_PK_index", Order.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances<Order>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with Orders" + Environment.NewLine, true);
}
private IOdb GetOdb()
{
if (odb == null)
odb = NDatabase.OdbFactory.Open(Bot.Name);
return odb;
}
private void CloseAndReopenDb()
{
odb.Close();
odb = Open(Testdbname);
}
public override void SetUp()
{
base.SetUp();
DeleteBase(Testdbname);
odb = Open(Testdbname);
}
private void CopyEmployeeTerritories(IOdb odb)
{
//Processing EmployeeTerritories
LogMessage("Reading EmployeeTerritories...", false);
var adapter1 = new EmployeeTerritoriesTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("EmployeeTerritories: " + row.EmployeeID.ToString() + "/" + row.TerritoryID + " ...", false);
var et = new EmployeeTerritory();
LogMessage("linking members...", false);
et.Employee = NDbUtil.GetByNumericalID<Employee>(odb, Employee.PK, row.EmployeeID);
et.Territory = NDbUtil.GetByStringID<Territory>(odb, Territory.PK, row.TerritoryID);
odb.Store(et);
LogMessage("saved (" + et.Employee.EmployeeID.ToString() + "/" + et.Territory.TerritoryID + ")",
true);
}
odb.Commit();
long objectCount = NDbUtil.GetAllInstances<EmployeeTerritory>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with EmployeeTerritories" + Environment.NewLine, true);
}
