protected override SqlClause GetCommandText(object[] restrictions)
{
var sql = new SqlClause();
var col = _sqlClauses.Select("CollectionName = 'Tables' and Version=" + _version.ver1);
sql.Select = col[0]["SelectMain"].ToString();
sql.AppendWhere(col[0]["Where1"].ToString());
if (restrictions != null)
{
var index = 0;
// TABLE_CATALOG
if (restrictions.Length >= 1 && restrictions[0] != null)
{
}
// TABLE_SCHEMA
if (restrictions.Length >= 2 && restrictions[1] != null)
{
sql.AppendWhereFormat(CultureInfo.CurrentCulture, col[0]["Where2"].ToString(), index++);
}
// TABLE_NAME
if (restrictions.Length >= 3 && restrictions[2] != null)
{
sql.AppendWhereFormat(CultureInfo.CurrentCulture, col[0]["Where3"].ToString(), index);
}
// TABLE_TYPE
if (restrictions.Length >= 4 && restrictions[3] != null)
{
switch (restrictions[3].ToString())
{
case "VIEW":
sql.AppendWhere(col[0]["Where4"].ToString());
break;
case "SYSTEM TABLE":
sql.AppendWhere(col[0]["Where5"].ToString());
break;
//case "BASE TABLE":
default:
sql.AppendWhere(col[0]["Where6"].ToString());
break;
}
}
}
sql.AppendOrder(col[0]["Order1"].ToString());
return(sql);
}
protected override SqlClause GetCommandText(object[] restrictions)
{
var sql = new SqlClause();
var col = _sqlClauses.Select("CollectionName = 'Triggers' and Version=" + _version.ver1);
sql.Select = col[0]["SelectMain"].ToString();
sql.AppendWhere(col[0]["Where1"].ToString());
if (restrictions != null)
{
var index = 0;
// TABLE_CATALOG
if (restrictions.Length >= 1 && restrictions[0] != null)
{}
// TABLE_SCHEMA
if (restrictions.Length >= 2 && restrictions[1] != null)
sql.AppendWhereFormat(CultureInfo.CurrentCulture, col[0]["Where2"].ToString(), index++);
// TABLE_NAME
if (restrictions.Length >= 3 && restrictions[2] != null)
sql.AppendWhereFormat(CultureInfo.CurrentCulture, col[0]["Where3"].ToString(), index++);
// TRIGGER_NAME
if (restrictions.Length >= 4 && restrictions[3] != null)
sql.AppendWhereFormat(CultureInfo.CurrentCulture, col[0]["Where4"].ToString(), index);
}
sql.AppendOrder(col[0]["Order1"].ToString());
return sql;
}
protected override SqlClause GetCommandText(object[] restrictions)
{
var sql = new SqlClause();
var col = _sqlClauses.Select("CollectionName = 'CheckConstraints' and Version=" + _version.ver1);
sql.Select = col[0]["SelectMain"].ToString();
sql.AppendWhere(col[0]["Where1"].ToString());
if (restrictions != null)
{
var index = 0;
// TABLE_CATALOG
if (restrictions.Length >= 1 && restrictions[0] != null)
{
}
// TABLE_SCHEMA
if (restrictions.Length >= 2 && restrictions[1] != null)
{
sql.AppendWhereFormat(CultureInfo.CurrentCulture, col[0]["Where2"].ToString(), index++);
}
// TABLE_NAME
if (restrictions.Length >= 3 && restrictions[2] != null)
{
sql.AppendWhereFormat(CultureInfo.CurrentCulture, col[0]["Where3"].ToString(), index);
}
}
return(sql);
}
protected override SqlClause GetCommandText(object[] restrictions)
{
var sql = new SqlClause();
var col = _sqlClauses.Select("CollectionName = 'ForeignKeys' and Version=" + _version.ver1);
sql.Select = col[0]["SelectMain"].ToString();
sql.AppendWhere(col[0]["Where1"].ToString());
if (restrictions != null)
{
var index = 0;
//// PK_TABLE_CATALOG
//if (restrictions.Length >= 1 && restrictions[0] != null)
//{
//}
//// PK_TABLE_SCHEMA
//if (restrictions.Length >= 2 && restrictions[1] != null)
//{
// sql.AppendWhereFormat(CultureInfo.CurrentCulture, col[0]["Where2"].ToString(), index++);
//}
//// PK_TABLE_NAME
//if (restrictions.Length >= 3 && restrictions[2] != null)
//{
// sql.AppendWhereFormat(CultureInfo.CurrentCulture, col[0]["Where3"].ToString(), index++);
//}
// FK_TABLE_CATALOG
if (restrictions.Length >= 1 && restrictions[0] != null)
{
}
// FK_TABLE_SCHEMA
if (restrictions.Length >= 2 && restrictions[1] != null)
{
sql.AppendWhereFormat(CultureInfo.CurrentCulture, col[0]["Where4"].ToString(), index++);
}
// FK_TABLE_NAME
if (restrictions.Length >= 3 && restrictions[2] != null)
{
sql.AppendWhereFormat(CultureInfo.CurrentCulture, col[0]["Where5"].ToString(), index++);
}
// FK_NAME
if (restrictions.Length >= 4 && restrictions[3] != null)
{
sql.AppendWhereFormat(CultureInfo.CurrentCulture, col[0]["Where6"].ToString(), index);
}
}
sql.AppendOrder(col[0]["Order1"].ToString());
return(sql);
}
