static void main2()
{
var m = new Prasatec.Cu2Com.Data.User();
m.Login = "******";
m.Email = "root@localhost";
var b = new ConnectionBuilder <Raden.Engines.MysqlEngine>()
.Server("nctslaws")
.Database("timetrack")
.Username("timetrack")
.Password("timetrack");
var c = b.Build();
var qbuilder = new QueryBuilder <Prasatec.Cu2Com.Data.User>()
.Where(x => x.ID, 2)
/*.Where(x => x.ID, 4, QueryLogicalOperators.LogicalOr, QueryComparisonOperators.IsLike, 4, "*")
* .Where<Prasatec.Cu2Com.Data.Role>(x => x.ID, y => y.Role, QueryLogicalOperators.LogicalOr, QueryComparisonOperators.EqualTo, 3)
* .Group(x => x.Role)
* .Having(x => x.ID, 4, QueryLogicalOperators.LogicalOr, QueryComparisonOperators.IsNotNull, 4, "*", QueryColumnActions.Count)
* .Sort(x => x.Name, QuerySortDirections.Descending)
* .SetLimit(100, 13)*/;
var q = qbuilder.Build();
var r = c.Retrieve <Prasatec.Cu2Com.Data.User>(q);// m);
m = r.Records[0];
c.Update <User>(q, m);
/*foreach (var p in q.Parameters)
* {
* Console.WriteLine(p);
* }*/
Console.WriteLine("AffectedRows: {0}", r.AffectedRows);
Console.WriteLine("InsertId: {0}", r.InsertId);
Console.WriteLine("CountPages: {0}", r.CountPages);
Console.WriteLine("CountRecords: {0}", r.CountRecords);
Console.WriteLine("CountTotal: {0}", r.CountTotal);
Console.WriteLine("ErrorMessage: {0}", r.ErrorMessage);
Console.WriteLine("ScalarValue: {0}", r.ScalarValue);
Console.WriteLine("Successful: {0}", r.Successful);
if (r.Records != null)
{
foreach (var record in r.Records)
{
Console.WriteLine("--> Record ID: {0}", record.ID);
Console.WriteLine("--> Record Code: {0}", record.Code);
Console.WriteLine("--> Record CreatedAt: {0}", record.CreatedAt);
Console.WriteLine("--> Record CreatedBy: {0}", record.CreatedBy);
Console.WriteLine("--> Record Email: {0}", record.Email);
Console.WriteLine("--> Record Login: {0}", record.Login);
Console.WriteLine("--> Record ModifiedAt: {0}", record.ModifiedAt);
Console.WriteLine("--> Record ModifiedBy: {0}", record.ModifiedBy);
Console.WriteLine("--> Record Name: {0}", record.Name);
Console.WriteLine("--> Record Password: {0}", record.Password);
Console.WriteLine("--> Record Role: {0}", record.Role);
}
}
}
static void main4()
{
var m = new Prasatec.Cu2Com.Data.User();
var c = new ConnectionBuilder <Raden.Engines.MysqlEngine>()
.Server("nctslaws")
.Database("timetrack")
.Username("timetrack")
.Password("timetrack")
.Build();
Console.WriteLine("connected");
//var r = c.Backup();
Type modelType = typeof(IModel);
var models = AppDomain.CurrentDomain.GetAssemblies()
.SelectMany(s => s.GetTypes())
.Where(p => modelType.IsAssignableFrom(p) && p != modelType);
foreach (var model in models)
{
Console.WriteLine(model);
}
}