private void GenerateContent()
{
try
{
ISQLGenerate generator = null;
sb.AppendLine("--DO NOT MODIFY THIS FILE. IT IS ALWAYS OVERWRITTEN ON GENERATION.");
sb.AppendLine("--Data Schema For Version " + _model.Version);
ValidationHelper.AppendCopyrightInSQL(sb, _model);
generator = new SQLSelectViewByAndTemplate(_model, _view);
generator.GenerateContent(sb);
generator = new SQLSelectViewByOrTemplate(_model, _view);
generator.GenerateContent(sb);
generator = new SQLSelectViewTemplate(_model, _view);
generator.GenerateContent(sb);
generator = new SQLPagedSelectViewTemplate(_model, _view);
generator.GenerateContent(sb);
}
catch (Exception ex)
{
throw;
}
}
private void GenerateContent()
{
try
{
ISQLGenerate generator = null;
if (!_singleFile)
{
sb.AppendLine("--DO NOT MODIFY THIS FILE. IT IS ALWAYS OVERWRITTEN ON GENERATION.");
sb.AppendLine();
}
sb.AppendLine("--This SQL is generated for the model defined view [" + _view.DatabaseName + "]");
sb.AppendLine();
nHydrate.Generator.GenerationHelper.AppendCopyrightInSQL(sb, _model);
generator = new SQLSelectViewTemplate(_model, _view, _grantSB);
generator.GenerateContent(sb);
}
catch (Exception ex)
{
throw;
}
}
private void GenerateContent()
{
try
{
ISQLGenerate generator = null;
sb.AppendLine("--DO NOT MODIFY THIS FILE. IT IS ALWAYS OVERWRITTEN ON GENERATION.");
sb.AppendLine("--Data Schema For Version " + _model.Version);
ValidationHelper.AppendCopyrightInSQL(sb, _model);
generator = new SQLDeleteBusinessObjectTemplate(_model, _table);
generator.GenerateContent(sb);
generator = new SQLSelectBusinessObjectByPrimaryKeyTemplate(_model, _table);
generator.GenerateContent(sb);
generator = new SQLInsertBusinessObjectTemplate(_model, _table);
generator.GenerateContent(sb);
generator = new SQLPagedSelectBusinessObjectTemplate(_model, _table);
generator.GenerateContent(sb);
generator = new SQLSelectBusinessObjectByAndTemplate(_model, _table);
generator.GenerateContent(sb);
generator = new SQLSelectBusinessObjectByFieldTemplate(_model, _table);
generator.GenerateContent(sb);
generator = new SQLUpdateBusinessObjectTemplate(_model, _table);
generator.GenerateContent(sb);
if (_table.AllowCreateAudit)
{
generator = new SQLSelectBusinessObjectByCreatedDateTemplate(_model, _table);
generator.GenerateContent(sb);
}
if (_table.AllowModifiedAudit)
{
generator = new SQLSelectBusinessObjectByModifiedDateTemplate(_model, _table);
generator.GenerateContent(sb);
}
generator = new SQLSelectBusinessObjectByOrTemplate(_model, _table);
generator.GenerateContent(sb);
generator = new SQLSelectBusinessObjectTemplate(_model, _table);
generator.GenerateContent(sb);
//All parent relationships
foreach (Relation relation in _table.ParentRoleRelations.Where(x => x.IsGenerated))
{
if (!relation.IsPrimaryKeyRelation())
{
generator = new SQLSelectBusinessObjectByRelationTemplate(_model, _table, relation);
generator.GenerateContent(sb);
}
}
foreach (Relation relation in _table.GetChildRoleRelationsFullHierarchy().Where(x => x.IsGenerated))
{
generator = new SQLSelectBusinessObjectByForeignKeyTemplate(_model, relation, _table);
generator.GenerateContent(sb);
}
//All Components for this table
foreach (TableComponent component in _table.ComponentList)
{
generator = new SQLPagedSelectComponentTemplate(_model, component);
generator.GenerateContent(sb);
generator = new SQLSelectComponentByPrimaryKeyTemplate(_model, component);
generator.GenerateContent(sb);
generator = new SQLSelectComponentByFieldTemplate(_model, component);
generator.GenerateContent(sb);
if (component.Parent.AllowCreateAudit)
{
generator = new SQLSelectComponentByCreatedDateTemplate(_model, component);
generator.GenerateContent(sb);
}
if (component.Parent.AllowModifiedAudit)
{
generator = new SQLSelectComponentByModifiedDateTemplate(_model, component);
generator.GenerateContent(sb);
}
generator = new SqlSelectComponentTemplate(_model, component);
generator.GenerateContent(sb);
generator = new SQLUpdateComponentTemplate(_model, component);
generator.GenerateContent(sb);
}
foreach (CustomRetrieveRule rule in _model.Database.CustomRetrieveRules)
{
Table table = (Table)rule.ParentTableRef.Object;
if (table == _table)
{
if (rule.Generated && table.Generated)
{
generator = new SQLSelectRetrieveRuleTemplate(_model, rule);
generator.GenerateContent(sb);
}
}
}
}
catch (Exception ex)
{
throw;
}
}
private void GenerateContent()
{
//if (_model.Database.AllowZeroTouch)
//{
// //Add drop SP here
// return;
//}
try
{
ISQLGenerate generator = null;
if (!_useSingleFile)
{
sb.AppendLine("--DO NOT MODIFY THIS FILE. IT IS ALWAYS OVERWRITTEN ON GENERATION.");
sb.AppendLine();
}
sb.AppendLine("--This SQL is generated for internal stored procedures for table [" + _table.DatabaseName + "]");
nHydrate.Generator.GenerationHelper.AppendCopyrightInSQL(sb, _model);
generator = new SQLDeleteBusinessObjectTemplate(_model, _table);
generator.GenerateContent(sb);
generator = new SQLInsertBusinessObjectTemplate(_model, _table);
generator.GenerateContent(sb);
generator = new SQLSelectAuditBusinessObjectTemplate(_model, _table);
generator.GenerateContent(sb);
generator = new SQLUpdateBusinessObjectTemplate(_model, _table);
generator.GenerateContent(sb);
//All Components for this table
foreach (TableComponent component in _table.ComponentList)
{
//generator = new SQLPagedSelectComponentTemplate(_model, component);
//generator.GenerateContent(sb);
//generator = new SQLSelectComponentByPrimaryKeyTemplate(_model, component);
//generator.GenerateContent(sb);
//generator = new SQLSelectComponentByFieldTemplate(_model, component);
//generator.GenerateContent(sb);
//if (component.Parent.AllowCreateAudit)
//{
// generator = new SQLSelectComponentByCreatedDateTemplate(_model, component);
// generator.GenerateContent(sb);
//}
//if (component.Parent.AllowModifiedAudit)
//{
// generator = new SQLSelectComponentByModifiedDateTemplate(_model, component);
// generator.GenerateContent(sb);
//}
//generator = new SqlSelectComponentTemplate(_model, component);
//generator.GenerateContent(sb);
generator = new SQLUpdateComponentTemplate(_model, component);
generator.GenerateContent(sb);
}
foreach (var rule in _model.Database.CustomRetrieveRules.ToList())
{
var table = (Table)rule.ParentTableRef.Object;
if (table == _table)
{
if (rule.Generated && table.Generated)
{
generator = new SQLSelectRetrieveRuleTemplate(_model, rule);
generator.GenerateContent(sb);
}
}
}
}
catch (Exception ex)
{
throw;
}
}