public static void Main (string[] args)
{
Console.WriteLine ("Hello World!");
OrmLiteConfig.DialectProvider = new FirebirdOrmLiteDialectProvider();
ServiceStack.OrmLite.SqlExpressionVisitor<Company> sql=
new FirebirdSqlExpressionVisitor<Company>();
List<Object> names = new List<Object>();
names.Add("SOME COMPANY");
names.Add("XYZ");
List<Object> ids = new List<Object>();
ids.Add(1);
ids.Add(2);
Company company = new Company(){ Id=1, Name ="XYZ"};
Console.WriteLine( company.Id.In(ids) );
Console.WriteLine( company.Name.In(names) );
sql.Where( cp => cp.Name == "On more Company");
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => cp.Name != "On more Company");
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => cp.Name == null );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => cp.Name != null);
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => cp.SomeBoolean); // TODO : fix
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => !cp.SomeBoolean && 1==1); //TODO : fix
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => cp.SomeBoolean && 1==1); //TODO : fix
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => 1 == 1 ); // TODO : fix ?
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => "1"== "1"); // TODO : fix ?
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => "1"== "0"); // TODO : fix ?
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => 1 != 1); //ok
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => cp.SomeBoolean==true); //OK
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => cp.SomeBoolean==false); //OK
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => !cp.SomeBoolean); // OK
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => (cp.Name==cp.Name) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => (cp.Name=="On more Company" || cp.Id>30) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => (cp.CreatedDate== DateTime.Today ));
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => (cp.CreatedDate==DateTime.Today && (cp.Name=="On more Company" || cp.Id>30)) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( cp.Name.ToUpper()=="ONE MORE COMPANY" ));
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( cp.Name.ToLower()=="ONE MORE COMPANY".ToLower() ) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( cp.Name.ToLower().StartsWith("one") ) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( cp.Name.ToUpper().EndsWith("COMPANY") ) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( cp.Name.ToUpper().Contains("MORE") ) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( cp.Name.Substring(0)=="ONE MORE COMPANY") );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( cp.Name.ToUpper().Substring(0,7)=="ONE MOR" ));
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => (cp.CreatedDate>= new DateTime(2000,1,1 ) ) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => (cp.Employees/2 > 10.0 ) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => (cp.Employees*2 > 10.0/5 ));
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ((cp.Employees+3) > (10.0+5) ) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ((cp.Employees-3) > (10.0+5) ) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => (( cp.Employees%3) > (10.0+5)) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( Math.Round( cp.SomeDouble) > (10.0+5) ) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( Math.Round( cp.SomeDouble,3) > (10.0+5) ) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( Math.Floor( cp.SomeDouble) > (10.0+5) ) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( Math.Ceiling( cp.SomeDouble) > (10.0+5) ) );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( string.Concat( cp.SomeDouble, "XYZ") =="SOME COMPANY XYZ") );
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( string.Concat( cp.SomeDouble, "X", "Y","Z") =="SOME COMPANY XYZ"));
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( string.Concat( cp.Name, "X", "Y","Z") =="SOME COMPANY XYZ"));
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( string.Concat( cp.SomeDouble.ToString(), "X", "Y","Z") =="SOME COMPANY XYZ"));
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( (cp.CreatedDate ?? DateTime.Today) == DateTime.Today));
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( (cp.Turnover ?? 0 )> 15));
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( Math.Abs(cp.Turnover ?? 0 )> 15));
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( cp.Name.In( names ) ));
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => ( cp.Id.In( ids ) ));
Console.WriteLine(sql.WhereExpression);
sql.OrderBy(cp=> cp.Name);
Console.WriteLine("{0}",sql.OrderByExpression);
sql.OrderBy(cp=> new{cp.Name, cp.Id} );
Console.WriteLine("{0}", sql.OrderByExpression);
sql.OrderBy(cp=> new{cp.Name, Id=cp.Id*-1} );
Console.WriteLine("{0}", sql.OrderByExpression);
sql.OrderByDescending(cp=> cp.Name);
Console.WriteLine("{0}",sql.OrderByExpression);
sql.OrderBy(cp=> new{cp.Name, X=cp.Id.Desc() } );
Console.WriteLine("{0}", sql.OrderByExpression);
sql.Limit(1,5);
Console.WriteLine(sql.LimitExpression);
sql.Limit(1);
Console.WriteLine(sql.LimitExpression);
sql.Where( cp => ( string.Concat( cp.Name, "_", cp.Employees) =="SOME COMPANY XYZ_2"));
Console.WriteLine(sql.WhereExpression);
sql.Where( cp => cp.Id != 1);
Console.WriteLine(sql.WhereExpression);
sql.Select(cp=>new{cp.Employees, cp.Name});
Console.WriteLine("To Select:'{0}' ",sql.SelectExpression);
sql.Select(cp=>new{cp.Employees, cp.Name, Some=(cp.Id*4).As("SomeExpression")});
Console.WriteLine("To Select:'{0}' ",sql.SelectExpression);
sql.Select(cp=>new{cp.Employees, cp.Name, Some=cp.Turnover.Sum().As("SomeExpression")});
Console.WriteLine("To Select:'{0}' ",sql.SelectExpression);
sql.Select(cp=>new{cp.Employees, cp.Name, Some=DbMethods.Sum(cp.Turnover ?? 0).As("SomeExpression")});
Console.WriteLine("To Select:'{0}' ",sql.SelectExpression);
sql.Update(cp=> new{cp.Employees,cp.Name} );
Console.WriteLine("To Update:'{0}' ", string.Join(",", sql.UpdateFields.ToArray() ) );
sql.Insert(cp=> new{cp.Id, cp.Employees,cp.Name} );
Console.WriteLine("To Insert:'{0}' ", string.Join(",", sql.InsertFields.ToArray()) );
Console.WriteLine ("This is The End my friend!");
}
public static void Main(string[] args)
{
//Set one before use (i.e. in a static constructor).
OrmLiteConfig.DialectProvider = new FirebirdOrmLiteDialectProvider();
using (IDbConnection db =
"User=SYSDBA;Password=masterkey;Database=employee.fdb;DataSource=localhost;Dialect=3;charset=ISO8859_1;".OpenDbConnection())
{
try
{
Console.WriteLine(db.HasChildren<Company>(new Company() { Id = 1000 }));
Console.WriteLine(db.HasChildren<Company>(new Company() { Id = 5 }));
Console.WriteLine(db.Exists<Company>(Company.Me.Id + "={0}", 5));
Console.WriteLine(db.Exists<Company>(Company.Me.Id + "={0}", 1000));
var rows = db.Select<Company>();
Console.WriteLine("Company: rows before insert :{0}", rows.Count);
Company cp = new Company {
Name = "One More Company",
Employees = 10,
Started = DateTime.Today,
Turnover = 12525,
CreatedDate = DateTime.Now
};
db.Insert(cp);
rows = db.Select<Company>();
Console.WriteLine("Company: rows after insert :{0}", rows.Count);
foreach (Company u in rows)
{
Console.WriteLine("{0} -- {1}", u.Id, u.Name);
}
Console.WriteLine("----------------------");
rows = db.Select<Company>(Company.Me.Id + ">={0} order by " + Company.Me.Id + " descending rows 5",
10);
Console.WriteLine(rows.Count);
foreach (Company u in rows)
{
Console.WriteLine("{0} -- {1} -- {2} -- {3} -- {4} -- {5} --{6}", u.Id, u.Name,
(u.Employees.HasValue) ? u.Employees.Value.ToString() : "",
u.Started.HasValue ? u.Started.Value.ToString() : "",
u.Turnover.HasValue ? u.Turnover.Value.ToString() : "",
u.CreatedDate.HasValue ? u.CreatedDate.Value.ToString() : "",
u.UpperName
);
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
}
public static void Main(string[] args)
{
Console.WriteLine ("Hello World!");
Config.DialectProvider = new FirebirdDialectProvider();
using (IDbConnection db =
//"User=SYSDBA;Password=masterkey;Database=MAQUINARIA.FDB;DataSource=172.16.7.40;Dialect=3;charset=ISO8859_1;".OpenDbConnection())
("User=SYSDBA;Password=masterkey;Database=employee.fdb;" +
"DataSource=localhost;Dialect=3;charset=ISO8859_1;").OpenDbConnection())
//("User=SYSDBA;Password=masterkey;Database=/home/angel/bd/INTER2011/INTERNACIONAL2011.FDB;" +
// "DataSource=localhost;Dialect=3;charset=ISO8859_1;").OpenDbConnection())
using ( IDbCommand dbConn = db.CreateCommand())
{
Schema fbd= new Schema(){
Connection = db
};
ClassWriter cw = new ClassWriter(){
Schema=fbd,
};
foreach(var t in fbd.Tables){
cw.WriteClass( t);
}
/*Table t = new Table(){Name= "CONCEPTO"};
cw.WriteClass(t);
*/
//var materiales = dbConn.Select<Materialsuc>(" MATID='{0}' AND SUCID='{1}'", 9136,30) ;
/*
var kardex = dbConn.Select<Kardex>(" NUMERO LIKE 'RMDT%' ORDER BY NUMERO DESC ROWS 1 ") ;
var r = kardex.FirstOrDefault();
if( r != default(Kardex) )
Console.WriteLine( r.Numero);
*/
//var concepto = dbConn.Select<Concepto>(" CODIGO = '{0}' ROWS 1 ", "000292") ; //does not work !!!
/*var concepto = dbConn.Select<Concepto>( string.Format(" CODIGO = '{0}' ROWS 1 ", "000292") );
var c = concepto.FirstOrDefault();
if( c != default(Concepto) )
Console.WriteLine( c.Descrip );
*/
//Console.WriteLine(materiales.Count);
//Console.WriteLine("there is company with id:'{0}' ? {1}",
// 5,
// dbConn.Exists<Company>( "Id='{0}'",5 ) );
//Console.WriteLine("there is company with id:'{0}' ? {1}",
// 100,
// dbConn.Exists<Company>( "Id='{0}'",100 )) ;
Company cp = new Company{Id=5};
Console.WriteLine("there is company with id:'{0}' ? {1}",
cp.Id,
dbConn.Exists<Company>( cp ) );
cp.Id=100;
Console.WriteLine("there is company with id:'{0}' ? {1}",
cp.Id,
dbConn.Exists<Company>( cp )) ;
Console.WriteLine(dbConn.HasChildren<Customer>(new Customer(){Id=20}) );
Console.WriteLine(dbConn.HasChildren<Customer>(new Customer(){Id=1001}) );
Customer cust =new Customer(){ Id=20};
Console.WriteLine("Has customer with Id:'{0}' Children in Sales ? {1}",
cust.Id,
dbConn.HasChildren<Sales>(cust) );
cust.Id=1001;
Console.WriteLine("Has customer with Id:'{0}' Children in Sales ? {1}",
cust.Id,
dbConn.HasChildren<Sales>(cust) );
}
Console.WriteLine ("This is The End my friend!");
}
