public void OrdersInsertBad()
{
var storage = new SqlServerStorage(typeof(OrdersVerticalBar));
storage.ServerName = "NEON-64";
storage.DatabaseName = "Northwind";
storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSqlOrder);
var res =
(OrdersVerticalBar[])
CommonEngine.ReadFile(typeof(OrdersVerticalBar),
TestCommon.GetPath("Good", "OrdersVerticalBar.txt"));
var res2 = new OrdersVerticalBar[1];
res2[0] = res[0];
//storage.ExecuteInBatchSize
//res2[0].OrderDate = new DateTime(1750, 10, 10);
try {
storage.InsertRecords(res2);
}
catch (SqlException ex) {
if (ex.Number == 208)
{
Assert.Ignore("You dont have this tables in your SqlServer");
}
if (ex.Number == 6)
{
Assert.Ignore("SqlServer not found, skipping this test.");
}
Assert.Ignore(ex.ToString());
}
}
public void OrdersExtractToFile()
{
SqlServerStorage storage = new SqlServerStorage(typeof(OrdersVerticalBar));
storage.ServerName = "NEON-64";
storage.DatabaseName = "Northwind";
storage.SelectSql = "SELECT * FROM Orders";
storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder);
FileDataLink.EasyExtractToFile(storage, "tempord.txt");
FileDataLink link = new FileDataLink(storage);
link.ExtractToFile("tempord.txt");
OrdersVerticalBar[] res = CommonEngine.ReadFile(typeof(OrdersVerticalBar), "tempord.txt") as OrdersVerticalBar[];
if (File.Exists("tempord.txt"))
{
File.Delete("tempord.txt");
}
Assert.AreEqual(830, res.Length);
Assert.AreEqual("VINET", res[0].CustomerID);
Assert.AreEqual("TOMSP", res[1].CustomerID);
Assert.AreEqual("HANAR", res[2].CustomerID);
}
public void CustomerInsert()
{
var storage = new SqlServerStorage(typeof(CustomersVerticalBar));
storage.ServerName = "NEON-64";
storage.DatabaseName = "Northwind";
storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSqlCust);
try {
storage.InsertRecords(CommonEngine.ReadFile(typeof(CustomersVerticalBar),
TestCommon.GetPath("Good", "CustomersVerticalBar.txt")));
}
catch (SqlException ex) {
if (ex.Number == 208)
{
Assert.Ignore("You dont have this tables in your SqlServer");
}
if (ex.Number == 6)
{
Assert.Ignore("SqlServer not found, skipping this test.");
}
Assert.Ignore(ex.ToString());
}
}
public void CurrencyOracleExtractToFile( )
{
GenericDatabaseStorage <OracleConnection, OracleCommand> storage = new GenericDatabaseStorage <OracleConnection, OracleCommand>(typeof(TestRecord), "User Id=SHELL;Password=shell;Data Source=ora9dev");
storage.SelectSql = "SELECT * FROM CURRENCY";
storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder);
FileDataLink.EasyExtractToFile(storage, "tempord.txt");
FileDataLink link = new FileDataLink(storage);
link.ExtractToFile("tempord.txt");
TestRecord[] res = CommonEngine.ReadFile(typeof(TestRecord), "tempord.txt") as TestRecord[];
if (File.Exists("tempord.txt"))
{
File.Delete("tempord.txt");
}
Assert.AreEqual(3, res.Length);
Assert.AreEqual("AED", res[0].CurrencyCode);
Assert.AreEqual("AFA", res[1].CurrencyCode);
Assert.AreEqual("ALL", res[2].CurrencyCode);
}
public void CurrencySqlExtractToFile( )
{
GenericDatabaseStorage <SqlConnection, SqlCommand> storage = new GenericDatabaseStorage <SqlConnection, SqlCommand>(typeof(TestRecord), "Data Source=FRENZY;Initial Catalog=Pruebas;User Id=sa;Password=Toshiba;");
storage.SelectSql = "SELECT * FROM Currency";
storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder);
FileDataLink.EasyExtractToFile(storage, "tempord.txt");
FileDataLink link = new FileDataLink(storage);
link.ExtractToFile("tempord.txt");
TestRecord[] res = CommonEngine.ReadFile(typeof(TestRecord), "tempord.txt") as TestRecord[];
if (File.Exists("tempord.txt"))
{
File.Delete("tempord.txt");
}
Assert.AreEqual(105, res.Length);
Assert.AreEqual("AED", res[0].CurrencyCode);
Assert.AreEqual("AFA", res[1].CurrencyCode);
Assert.AreEqual("ALL", res[2].CurrencyCode);
}
public void OrdersInsert()
{
SqlServerStorage storage = new SqlServerStorage(typeof(CustomersVerticalBar));
storage.ServerName = "NEON-64";
storage.DatabaseName = "Northwind";
storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSqlCust);
storage.InsertRecords(CommonEngine.ReadFile(typeof(CustomersVerticalBar), TestCommon.TestPath(@"Good\CustomersVerticalBar.txt")));
}
static void Main(string[] args)
{
SqlServerStorage storage = new SqlServerStorage(typeof(CustomersVerticalBar));
storage.ServerName = "MYSERVER";
storage.DatabaseName = "Northwind";
// Comment this for Windows Auth
storage.UserName = "******";
storage.UserPass = "******";
storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSqlCust);
storage.InsertRecords(CommonEngine.ReadFile(typeof(CustomersVerticalBar), "infile.txt"));
Console.ReadKey();
}
public void OrdersDbToFileEasy()
{
var storage = new AccessStorage(typeof(OrdersFixed), @"..\data\TestData.mdb");
storage.SelectSql = "SELECT * FROM Orders";
storage.FillRecordCallback = new FillRecordHandler(FillRecordOrders);
var records = (OrdersFixed[])FileDataLink.EasyExtractToFile(storage, @"..\data\temp.txt");
int extractNum = records.Length;
records = (OrdersFixed[])CommonEngine.ReadFile(typeof(OrdersFixed), @"..\data\temp.txt");
Assert.AreEqual(extractNum, records.Length);
}
public void ReadFileStatic()
{
SampleType[] res;
res = CommonEngine.ReadFile <SampleType>(FileTest.Good.Test1.Path);
Assert.AreEqual(4, res.Length);
Assert.AreEqual(new DateTime(1314, 12, 11), res[0].Field1);
Assert.AreEqual("901", res[0].Field2);
Assert.AreEqual(234, res[0].Field3);
Assert.AreEqual(new DateTime(1314, 11, 10), res[1].Field1);
Assert.AreEqual("012", res[1].Field2);
Assert.AreEqual(345, res[1].Field3);
}
public void ReadFileStatic()
{
SampleType[] res;
res = (SampleType[])CommonEngine.ReadFile(typeof(SampleType), TestCommon.TestPath(@"Good\test1.txt"));
Assert.AreEqual(4, res.Length);
Assert.AreEqual(new DateTime(1314, 12, 11), res[0].Field1);
Assert.AreEqual("901", res[0].Field2);
Assert.AreEqual(234, res[0].Field3);
Assert.AreEqual(new DateTime(1314, 11, 10), res[1].Field1);
Assert.AreEqual("012", res[1].Field2);
Assert.AreEqual(345, res[1].Field3);
}
public void OrdersExtractToFile()
{
var storage = new SqlServerStorage(typeof(OrdersVerticalBar));
storage.ServerName = "NEON-64";
storage.DatabaseName = "Northwind";
storage.SelectSql = "SELECT * FROM Orders";
storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder);
try
{
FileDataLink.EasyExtractToFile(storage, "tempord.txt");
}
catch (SqlException ex)
{
if (ex.Number == 208)
{
Assert.Ignore("You dont have this tables in your SqlServer");
}
if (ex.Number == 6)
{
Assert.Ignore("SqlServer not found, skipping this test.");
}
Assert.Ignore(ex.ToString());
}
var link = new FileDataLink(storage);
link.ExtractToFile("tempord.txt");
var res = CommonEngine.ReadFile(typeof(OrdersVerticalBar), "tempord.txt") as OrdersVerticalBar[];
if (File.Exists("tempord.txt"))
{
File.Delete("tempord.txt");
}
Assert.AreEqual(830, res.Length);
Assert.AreEqual("VINET", res[0].CustomerID);
Assert.AreEqual("TOMSP", res[1].CustomerID);
Assert.AreEqual("HANAR", res[2].CustomerID);
}
public void ReadFileMaxRecords10()
{
object[] res = CommonEngine.ReadFile(typeof(SampleType), Common.TestPath(@"Good\test1.txt"), -1);
Assert.AreEqual(4, res.Length);
}
