public void Guid_build_insert_entity_with_many_to_one_relationship()
{
var session = SessionHelper.Factory.OpenSession();
var builder = new InsertSqlBuilder();
UserAccount account = new UserAccount()
{
AccountCreatedOn = DateTime.Now,
EmailAddress = "*****@*****.**",
UserName = "******"
};
Task task = new Task()
{
AssignedTo = account,
CreatedOn = DateTime.Now,
Title = "fake task 133",
TaskDescription = "fake fake fake... ldjlkj ljljlk jlj"
};
var execList = builder.Build(task, session);
Assert.AreEqual(2, execList.Statements.Count);
Assert.IsFalse(task.Id.Equals(Guid.Empty));
Assert.IsFalse(account.Id.Equals(Guid.Empty));
Assert.AreEqual(2, execList.Execute(session));
var x = session.SelectAll <Task>().Where(c => c.Id).EqualToValue(task.Id).FetchAll().FirstOrDefault();
Assert.AreEqual(task, x);
}
public int Insert <T>(EntityMap entityMap, T entity)
{
var insert = new InsertSqlBuilder();
var execList = insert.Build(entity, entityMap, this);
return(execList.Execute(this));
}
public void AutoIncrement_Build_insert_entity_with_new_entity_in_many2one_relation()
{
var monkEntMap = SessionHelper.Factory.DbSettings.Map.EntityConfigs.FirstOrDefault(c => string.Equals(c.Name, "Monkey", StringComparison.Ordinal));
Monkey monkey = new Monkey()
{
Age = 12,
CanDoTricks = true,
Family = "Singe",
Location = "cage2344",
Name = "smart monkey",
ReceivedOn = DateTime.Now,
Zoo = new Zoo()
{
AcceptNewAnimals = true, Name = Guid.NewGuid().ToString(), City = "sfdfsdfsfe"
},
};
var session = SessionHelper.Factory.OpenSession();
InsertSqlBuilder builder = new InsertSqlBuilder();
var execList = builder.Build(monkey, monkEntMap, session);
Assert.AreEqual(3, execList.Statements.Count);
Assert.IsTrue(execList.Statements[2].Processed);
Assert.IsTrue(monkey.Id > 0);
Assert.IsTrue(monkey.Zoo.Id > 0);
}
public void Guid_build_insert_entity_with_many_to_many_create()
{
var session = SessionHelper.Factory.OpenSession();
var builder = new InsertSqlBuilder();
var role = new Role {
Description = "test", Name = "Fake Role 2"
};
var account = new UserAccount()
{
AccountCreatedOn = DateTime.Now,
EmailAddress = "*****@*****.**",
UserName = "******"
};
account.RolesOnUserRole_UserId.Add(role);
var execList = builder.Build(account, session);
Assert.AreEqual(3, execList.Statements.Count);
Assert.IsFalse(account.Id.Equals(Guid.Empty));
Assert.IsFalse(role.Id.Equals(Guid.Empty));
Assert.AreEqual(3, execList.Execute(session));
}
/// <summary>
/// Inserts the specified entity.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
/// <exception cref="GoliathDataException"></exception>
public int Insert(TEntity entity)
{
try
{
var insertBuilder = new InsertSqlBuilder();
var execList = insertBuilder.Build(entity, entityMap, session);
var result = execList.Execute(session);
//if it's a trackable entity let's reset it
var trackable = entity as ITrackable;
//ResetTrackableEntity(trackable);
if (trackable != null && !trackable.ChangeTracker.IsTracking)
{
trackable.ChangeTracker.Init();
//TODO: write method to initialize values;
trackable.ChangeTracker.Start();
}
return(result);
}
catch (GoliathDataException)
{
throw;
}
catch (Exception exception)
{
throw new GoliathDataException($"Error while trying to insert mapped entity {entityMap.FullName} of type {entity.GetType()}", exception);
}
}
public void AutoIncrement_Build_insert_entity_with_existing_entity_in_many2one_relation()
{
var monkEntMap = SessionHelper.Factory.DbSettings.Map.EntityConfigs.FirstOrDefault(c => string.Equals(c.Name, "Monkey", StringComparison.Ordinal));
var zooEntMap = SessionHelper.Factory.DbSettings.Map.EntityConfigs.FirstOrDefault(c => string.Equals(c.Name, "Zoo", StringComparison.Ordinal));
var session = SessionHelper.Factory.OpenSession();
InsertSqlBuilder builder = new InsertSqlBuilder();
Zoo zoo = new Zoo()
{
AcceptNewAnimals = true, Name = Guid.NewGuid().ToString(), City = "exwee"
};
builder.Build(zoo, zooEntMap, session);
Assert.IsTrue(zoo.Id > 0);
Monkey monkey = new Monkey()
{
Age = 12,
CanDoTricks = true,
Family = "Singe",
Location = "cage 48875",
Name = "curious george",
ReceivedOn = DateTime.Now,
Zoo = zoo,
};
Console.WriteLine("---- Building monkey ----");
var execList = builder.Build(monkey, monkEntMap, session);
Assert.AreEqual(2, execList.Statements.Count);
Assert.IsTrue(execList.Statements[1].Processed);
Assert.IsTrue(monkey.Id > 0);
Assert.AreEqual(zoo, monkey.Zoo);
}
public void Guid_build_sql_insert()
{
var session = SessionHelper.Factory.OpenSession();
var builder = new InsertSqlBuilder();
Role role = new Role {
Description = "test", Name = "Fake Role 1"
};
var execList = builder.Build(role, session);
Assert.AreEqual(1, execList.Statements.Count);
Assert.IsFalse(execList.Statements[0].Processed);
Assert.AreEqual(1, execList.Execute(session));
Assert.IsFalse(role.Id.Equals(Guid.Empty));
}
public void AutoIncrement_Build_insert_statements_for_simple_entity_without_relation_should_create_one_insert_statement()
{
//insert a zoo
var zooEntMap = SessionHelper.Factory.DbSettings.Map.EntityConfigs.FirstOrDefault(c => string.Equals(c.Name, "Zoo", StringComparison.Ordinal));
Zoo zoo = new Zoo()
{
AcceptNewAnimals = true, Name = Guid.NewGuid().ToString(), City = "kaaow"
};
var session = SessionHelper.Factory.OpenSession();
InsertSqlBuilder builder = new InsertSqlBuilder();
var execList = builder.Build(zoo, zooEntMap, session);
Assert.AreEqual(1, execList.Statements.Count);
Assert.IsTrue(execList.Statements[0].Processed);
Assert.IsTrue(zoo.Id > 0);
}
public void AutoIncrement_Build_insert_entity_check_that_it_generate_parent_sql_first_inheritance()
{
var monkEntMap = SessionHelper.Factory.DbSettings.Map.EntityConfigs.FirstOrDefault(c => string.Equals(c.Name, "Monkey", StringComparison.Ordinal));
Monkey monkey = new Monkey()
{
Age = 12,
CanDoTricks = true,
Family = "Singe",
Location = "somecage",
Name = "joemonkey",
ReceivedOn = DateTime.Now,
ZooId = 1
};
var session = SessionHelper.Factory.OpenSession();
InsertSqlBuilder builder = new InsertSqlBuilder();
var execList = builder.Build(monkey, monkEntMap, session);
Assert.AreEqual(2, execList.Statements.Count);
Assert.IsTrue(execList.Statements[1].Processed);
Assert.IsTrue(monkey.Id > 0);
}
public void AutoIncrement_Build_many_to_many_inverse_is_false_should_not_create_inserts_for_relations()
{
var session = SessionHelper.Factory.OpenSession();
InsertSqlBuilder builder = new InsertSqlBuilder();
Employee empl = new Employee {
AssignedToZooId = 1, EmailAddress = "mail@com", FirstName = "Joe", HiredOn = DateTime.Now, LastName = "Smith", Title = "some edm", Telephone = "125699555"
};
Animal marsu = new Animal()
{
Name = "marsupilami 5",
Age = 4,
ReceivedOn = DateTime.Now,
Location = "marsu L24",
ZooId = 1
};
marsu.EmployeesOnAnimalsHandler_AnimalId.Add(empl);
var execList = builder.Build(marsu, session);
Assert.AreEqual(1, execList.Statements.Count);
}
public void AutoIncrement_Build_many_to_many_relation_should_save_new_entities()
{
var session = SessionHelper.Factory.OpenSession();
InsertSqlBuilder builder = new InsertSqlBuilder();
Employee empl = new Employee {
AssignedToZooId = 1, EmailAddress = "mail@com", FirstName = "Joe", HiredOn = DateTime.Now, LastName = "Smith", Title = "some edm", Telephone = "125699555"
};
Animal marsu = new Animal()
{
Name = "marsupilami",
Age = 4,
ReceivedOn = DateTime.Now,
Location = "marsu L23",
ZooId = 1
};
empl.AnimalsOnAnimalsHandler_EmployeeId.Add(marsu);
var execList = builder.Build(empl, session);
Assert.AreEqual(3, execList.Statements.Count);
Assert.IsFalse(execList.Statements[2].Processed);
}