public void Test_ConvertSQLToReadable()
{
var dt2Sql = new Services.DataTableToSql(DataBaseType.SqlServer);
// create an datatable you want to convert to sql
var dt = new DataTable("Employee");
dt.Columns.Add("IdentityKey", typeof(int));
dt.Columns["IdentityKey"].AutoIncrement = true;
dt.PrimaryKey = new[] { dt.Columns["IdentityKey"] };
dt.Columns.Add("FirstName", typeof(string));
dt.Columns.Add("LastName", typeof(string));
dt.Rows.Add(1, "John", "Doe");
// create dbparameters from my object
var dbParameters = dt2Sql.BuildDbParameterList(dt.Rows[0], (s, o) => new SqlParameter(s, o));
// create my parameterized sql based on my specified action type
var insertSql = dt2Sql.BuildQuery(dt, ActionType.Insert);
// convert my parameterize sql to be readable
var readAble = dt2Sql.SqlSyntaxHelper.ConvertParameterSqlToReadable(dbParameters, insertSql, Encoding.UTF8);
// unit test
Assert.AreEqual(readAble, "INSERT INTO Employee ([FirstName],[LastName]) VALUES ('John','Doe')");
}
public void Test_Anonymous_T_BuildQuery_With_Specified_Table_Name()
{
RunTestOnAllDBTypes(delegate(DataBaseType type)
{
var dt2Sql = new Services.DataTableToSql(type);
var insertSql = dt2Sql.BuildQuery(MockDataIdentityKey, ActionType.Insert);
Assert.AreEqual(EmployeeWithIdentityKeySqlColumn.ToSql(ActionType.Insert, type), insertSql, "DataTable 2 Sql insertSql Failed");
var updateSQL = dt2Sql.BuildQuery(MockDataIdentityKey, ActionType.Update);
Assert.AreEqual(EmployeeWithIdentityKeySqlColumn.ToSql(ActionType.Update, type), updateSQL, "DataTable 2 Sql updateSQL Failed");
var deleteSQL = dt2Sql.BuildQuery(MockDataIdentityKey, ActionType.Delete);
Assert.AreEqual(EmployeeWithIdentityKeySqlColumn.ToSql(ActionType.Delete, type), deleteSQL, "DataTable 2 Sql deleteSQL Failed");
if (type == DataBaseType.Sqlite || type == DataBaseType.MySql)
{
return; // TODO :: fIX for sqlite
}
// TODO :: FIX
var upsertSQL = dt2Sql.BuildQuery(MockDataIdentityKey, ActionType.Upsert);
Assert.AreEqual(EmployeeWithIdentityKeySqlColumn.ToSql(ActionType.Upsert, type), upsertSQL, "DataTable 2 Sql upsertSQL Failed");
});
}