public void CustomersDbToFile()
{
var storage = new AccessStorage(typeof (CustomersVerticalBar), @"..\data\TestData.mdb");
storage.SelectSql = "SELECT * FROM Customers";
storage.FillRecordCallback = new FillRecordHandler(FillRecordCustomers);
mLink = new FileDataLink(storage);
mLink.ExtractToFile(@"..\data\temp.txt");
int extractNum = mLink.LastExtractedRecords.Length;
var records = (CustomersVerticalBar[]) mLink.FileHelperEngine.ReadFile(@"..\data\temp.txt");
Assert.AreEqual(extractNum, records.Length);
}
private void cmdRun_Click(object sender, EventArgs e)
{
try
{
cmdRun.Enabled = false;
lblStatus.Text = "Creating the DataLinkEngine";
AccessStorage storage = new AccessStorage(typeof(CustomersVerticalBar), MainClass.GlobalTestMdb);
storage.SelectSql = "SELECT * FROM Customers";
storage.FillRecordCallback = new FillRecordHandler(FillRecord);
storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSql);
FileDataLink mLink = new FileDataLink(storage);
Application.DoEvents();
Thread.Sleep(800);
// Db -> File
lblStatus.Text = "Extracting records from the access db to a file";
mLink.ExtractToFile(@"temp.txt");
Application.DoEvents();
Thread.Sleep(800);
// File -> Db
lblStatus.Text = "Inserting records from a file to the access db";
mLink.InsertFromFile(@"temp.txt");
if (File.Exists(@"temp.txt"))
File.Delete(@"temp.txt");
Application.DoEvents();
Thread.Sleep(800);
lblStatus.Text = "DONE !!!";
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Unexpected Error !!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
cmdRun.Enabled = true;
}
}
public void CustomersFileToDb()
{
var storage = new AccessStorage(typeof(CustomersVerticalBar), @"..\data\TestData.mdb");
storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSqlCust);
mLink = new FileDataLink(storage);
ClearData(((AccessStorage) mLink.DataStorage).AccessFileName, "CustomersTemp");
int count = Count(((AccessStorage) mLink.DataStorage).AccessFileName, "CustomersTemp");
Assert.AreEqual(0, count);
mLink.InsertFromFile(@"..\data\UpLoadCustomers.txt");
count = Count(((AccessStorage) mLink.DataStorage).AccessFileName, "CustomersTemp");
Assert.AreEqual(91, count);
ClearData(((AccessStorage) mLink.DataStorage).AccessFileName, "CustomersTemp");
}
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);
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());
}
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 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 );
}
/// <summary>The short way to Insert Records from a file to a DataStorage</summary>
/// <param name="storage">The DataStorage where store the records.</param>
/// <param name="filename">The file with the SourceRecords</param>
/// <returns>The Inserted records</returns>
public static object[] EasyInsertFromFile(DataStorage storage, string filename)
{
FileDataLink link = new FileDataLink(storage);
return(link.InsertFromFile(filename));
}
/// <summary>The short way to Extract the records from a DataStorage to a file</summary>
/// <param name="storage">The DataStorage from where get the records</param>
/// <param name="filename">The file where to write the records to.</param>
/// <returns>The Extracted records.</returns>
public static object[] EasyExtractToFile(DataStorage storage, string filename)
{
FileDataLink link = new FileDataLink(storage);
return(link.ExtractToFile(filename));
}
/// <summary>The short way to Insert Records from a file to a DataStorage</summary>
/// <param name="storage">The DataStorage where store the records.</param>
/// <param name="filename">The file with the SourceRecords</param>
/// <returns>The Inserted records</returns>
public static object[] EasyInsertFromFile(DataStorage storage, string filename)
{
FileDataLink link = new FileDataLink(storage);
return link.InsertFromFile(filename);
}
/// <summary>The short way to Extract the records from a DataStorage to a file</summary>
/// <param name="storage">The DataStorage from where get the records</param>
/// <param name="filename">The file where to write the records to.</param>
/// <returns>The Extracted records.</returns>
public static object[] EasyExtractToFile(DataStorage storage, string filename)
{
FileDataLink link = new FileDataLink(storage);
return link.ExtractToFile(filename);
}
public void OrdersFileToDb()
{
AccessStorage storage = new AccessStorage(typeof(OrdersFixed), @"..\data\TestData.mdb");
storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSqlOrder);
mLink = new FileDataLink(storage);
ClearData(((AccessStorage) mLink.DataStorage).AccessFileName, "OrdersTemp");
int count = Count(((AccessStorage) mLink.DataStorage).AccessFileName, "OrdersTemp");
Assert.AreEqual(0, count);
mLink.InsertFromFile(@"..\data\UpLoadOrders.txt");
count = Count(((AccessStorage) mLink.DataStorage).AccessFileName, "OrdersTemp");
Assert.AreEqual(830, count);
ClearData(((AccessStorage) mLink.DataStorage).AccessFileName, "OrdersTemp");
}
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 );
}
