public async Task Initialize()
{
Environment.CurrentDirectory = AppDomain.CurrentDomain.BaseDirectory;
var schema = new DBSchema("common_database");
schema.Generate(new[] {
typeof(Customer).Assembly,
typeof(User).Assembly
});
DBService.Schems.Add(schema);
Assert.IsNotNull(schema);
Assert.IsNotNull(Book.DBTable);
Assert.IsNotNull(UserGroup.DBTable);
Assert.IsNotNull(GroupPermission.DBTable);
Assert.IsNotNull(User.DBTable);
Assert.IsNotNull(Position.DBTable);
Assert.IsNotNull(UserReg.DBTable);
Assert.IsNotNull(Company.DBTable);
DBService.Save();
schema.Connection = new DBConnection
{
Name = "test.common",
System = DBSystem.SQLite,
DataBase = "test.common"
};
schema.DropDatabase();
schema.CreateDatabase();
var group = new UserGroup()
{
Number = "GP1",
Name = "Group1"
};
await group.Save();
var position = new Position()
{
Code = "PS1",
Name = "Position"
};
var user = new User()
{
Login = "******",
Name = "Test User",
Password = "******",
Position = position,
AuthType = UserAuthType.Internal,
Access = new AccessValue(new[] { new AccessItem(group, AccessType.Create) })
};
await user.Save();
await User.StartSession("test", "UserCommon1!");
await GroupPermission.CachePermission();
}
public override Task CreateNew()
{
Schema = new DBSchema()
{
Name = schemaName,
Connection = new DBConnection
{
Name = schemaName,
System = DBSystem.SQLite,
DataBase = $"{schemaName}.sqlite"
}
};
Generate();
Schema.DropDatabase();
Schema.CreateDatabase();
Save();
return(Task.CompletedTask);
}
public async void Generate(DBConnection connection)
{
Assert.AreEqual(true, connection.CheckConnection(), $"Connection Fail!");
schema = DBSchema.Generate(GetType().Assembly, SchemaName);
Assert.IsNotNull(schema, "Attribute Generator Fail. On Schema");
Assert.IsNotNull(Employer.DBTable, "Attribute Generator Fail. On Employer Table");
Assert.IsNotNull(Position.DBTable, "Attribute Generator Fail. On Position Table");
var idColumn = Employer.DBTable.Columns["id"];
Assert.IsNotNull(idColumn, "Attribute Generator Fail. On Column Employer Id");
var positionColumn = Employer.DBTable.Columns["positionid"];
Assert.IsNotNull(positionColumn, "Attribute Generator Fail. On Column Employer Position");
Assert.IsNotNull(positionColumn.ReferenceTable, "Attribute Generator Fail. On Column Employer Position Reference");
schema.Connection = connection;
schema.DropDatabase();
schema.CreateDatabase();
var result = schema.GetTablesInfo(connection.Schema, EmployerTableName);
Assert.IsTrue(result.Count() == 1, "Generate Sql Table / Get Information Fail.");
result = schema.GetTablesInfo(connection.Schema, PositionTableName);
Assert.IsTrue(result.Count() == 1, "Generate Sql Table / Get Information Fail.");
//Insert
var employer = new Employer()
{
Identifier = $"{1:8}",
Lodar = true,
Age = 40,
Height = 180,
LongId = 120321312321L,
Weight = 123.12333F,
DWeight = 123.1233433424434D,
Salary = 231323.32M,
Name = "Ivan",
Access = new AccessValue(new[]
{
new AccessItem(AccessValue.Groups.First(i => i.Id == 1), AccessType.Read),
new AccessItem(AccessValue.Groups.First(i => i.Id == 2), AccessType.Admin),
new AccessItem(AccessValue.Groups.First(i => i.Id == 3), AccessType.Create)
})
};
Assert.AreEqual(employer.Type, EmployerType.Type2, "Default Value & Enum");
employer.GenerateId();
Assert.NotNull(employer.Id, "Id Generator Fail");
await employer.Save();
var qresult = schema.Connection.ExecuteQResult($"select * from {EmployerTableName}");
Assert.AreEqual(1, qresult.Values.Count, "Insert sql Fail");
Assert.AreEqual(employer.Id, qresult.Get(0, "id"), "Insert sql Fail Int");
Assert.AreEqual(employer.Identifier, qresult.Get(0, "identifier"), "Insert sql Fail String");
Assert.AreEqual((int?)employer.Type, qresult.Get(0, "typeid"), "Insert sql Fail Enum");
Assert.AreEqual(employer.Age, qresult.Get(0, "age"), "Insert sql Fail Byte");
Assert.AreEqual(employer.Height, qresult.Get(0, "height"), "Insert sql Fail Short");
Assert.AreEqual(employer.LongId, qresult.Get(0, "longid"), "Insert sql Fail Long");
Assert.AreEqual(employer.Weight, qresult.Get(0, "weight"), "Insert sql Fail Float");
Assert.AreEqual(employer.DWeight, qresult.Get(0, "dweight"), "Insert sql Fail Double");
Assert.AreEqual(employer.Salary, qresult.Get(0, "salary"), "Insert sql Fail Decimal");
var lodar = qresult.Get(0, "lodar").ToString();
Assert.IsTrue(lodar == "1" || lodar == "True", "Insert sql Fail Bool");
Assert.IsInstanceOf <byte[]>(qresult.Get(0, "group_access"), "Insert sql Fail Byte Array");
var accessValue = new AccessValue((byte[])qresult.Get(0, "group_access"));
Assert.AreEqual(3, accessValue.Items.Count(), "Insert sql Fail Byte Array");
Assert.AreEqual(true, accessValue.Items.ElementAt(0).Read, "Insert sql Fail Byte Array");
Assert.AreEqual(true, accessValue.Items.ElementAt(1).Admin, "Insert sql Fail Byte Array");
Assert.AreEqual(false, accessValue.Items.ElementAt(2).Delete, "Insert sql Fail Byte Array");
Employer.DBTable.Clear();
Assert.AreEqual(0, Employer.DBTable.Count, "Clear table Fail");
//Insert Several
Position.DBTable.Add(new Position()
{
Code = "1", Name = "First Position"
});
Position.DBTable.Add(new Position()
{
Code = "2", Name = "Second Position"
});
var position = new Position()
{
Id = 0, Code = "3", Name = "Group Position"
};
position.Attach();
var sposition = new Position()
{
Code = "4", Parent = position, Name = "Sub Group Position"
};
sposition.Attach();
//Select from internal Index
Position.DBTable.Add(new Position()
{
Code = "t1", Name = "Null Index"
});
Position.DBTable.Add(new Position()
{
Code = "t2", Name = "Null Index"
});
Position.DBTable.Add(new Position()
{
Code = "t3", Name = "Null Index"
});
var nullIds = Position.DBTable.Select(Position.DBTable.PrimaryKey, CompareType.Is, null).ToList();
Assert.AreEqual(6, nullIds.Count, "Select by null Fail");
await Position.DBTable.Save();
Position.DBTable.Clear();
var positions = Position.DBTable.Load();
Assert.AreEqual(7, positions.Count(), "Insert/Read several Fail");
//GetById
employer = Employer.DBTable.LoadById(1);
Assert.IsNotNull(employer, "GetById Fail");
position = Position.DBTable.LoadById(4);
Assert.IsNotNull(position, "GetById Fail");
//Update
employer.Position = position;
await employer.Save();
qresult = schema.Connection.ExecuteQResult($"select * from {EmployerTableName}");
Assert.AreEqual(4, qresult.Get(0, "positionid"), "Update sql Fail");
connection.ExecuteQuery(@"create table test_table(
id int primary key,
test_date date,
test_varchar varchar(512),
test_numeric numeric(20,10))");
result = schema.GetTablesInfo(connection.Schema, "test_table");
schema.GenerateTablesInfo(result);
var table = schema.Tables["test_table"] as DBTable <DBItem>;
Assert.IsNotNull(table, "DBInformation Load Fail");
table.Load().LastOrDefault();
for (int i = 0; i < 1000; i++)
{
var row = table.NewItem();
row["id"] = i;
row["test_date"] = DateTime.Now.AddDays(-i);
row["test_varchar"] = "string value " + i;
row["test_numeric"] = i / 1000M;
table.Add(row);
}
await table.Save();
table.Clear();
int c = 0;
foreach (var item in table.Load(string.Empty))
{
if (++c == 5)
{
break;
}
}
}
public async Task Initialize()
{
Environment.CurrentDirectory = AppDomain.CurrentDomain.BaseDirectory;
var schema = new DBSchema("wf_customer");
schema.Generate(new[] { typeof(User).Assembly, typeof(Customer).Assembly });
Assert.IsNotNull(Location.DBTable);
Assert.IsNotNull(Address.DBTable);
Assert.IsNotNull(Customer.DBTable);
Assert.IsNotNull(CustomerAddress.DBTable);
Assert.IsNotNull(PersoneIdentify.DBTable);
Assert.IsNotNull(CustomerReference.DBTable);
DBService.Save();
schema.Connection = new DBConnection
{
Name = "test.common",
DataBase = "test.common",
System = DBSystem.SQLite
};
schema.DropDatabase();
schema.CreateDatabase();
Location.DBTable.Add(new Continent {
Code = "AF", Name = "Africa"
});
Location.DBTable.Add(new Continent {
Code = "AN", Name = "Antarctica"
});
Location.DBTable.Add(new Continent {
Code = "AS", Name = "Asia"
});
Location.DBTable.Add(new Continent {
Code = "EU", Name = "Europa"
});
Location.DBTable.Add(new Continent {
Code = "EUAS", Name = "Eurasia"
});
Location.DBTable.Add(new Continent {
Code = "NA", Name = "North america"
});
Location.DBTable.Add(new Continent {
Code = "OC", Name = "Oceania"
});
Location.DBTable.Add(new Continent {
Code = "SA", Name = "South america"
});
var russia = new Country
{
Parent = Location.DBTable.LoadByCode("EUAS"),
Code = "RU",
Name = "Russia"
};
Location.DBTable.Add(russia);
var ruble = new Currency
{
Parent = russia,
Code = "RUB",
Name = "Ruble"
};
Location.DBTable.Add(ruble);
Assert.AreEqual(1, DBTable.GetTable <Country>().Count);
Assert.AreEqual(1, DBTable.GetTable <Currency>().Count);
await Location.DBTable.Save();
Assert.AreEqual(1, DBTable.GetTable <Country>().Count);
Assert.AreEqual(1, DBTable.GetTable <Currency>().Count);
Location.DBTable.Clear();
Location.DBTable.Load().LastOrDefault();
Assert.AreEqual(1, DBTable.GetTable <Country>().Count);
Assert.AreEqual(1, DBTable.GetTable <Currency>().Count);
}