internal static void SetPrimaryKey(MariaDbSchema obj)
{
if (obj.Fields.Select(x => x.Key.ToUpper()).Contains("ID"))
{
obj.PrimaryKey = true;
}
}
internal void StartConstraint()
{
Console.WriteLine("The constraints are starting to print...");
var i = 1;
foreach (var item in dataList)
{
Data = item;
var codeDom = RenderConstraint();
var fileName = item.TableName;
if (onlyOneFile)
{
fileName = Repository.DbConfig.DataBase;
}
var filePath = $"{Path}/{fileName}{FileExtension}";
if (!WriteToFile(filePath, codeDom))
{
Console.WriteLine("It can be not write to file! -- Maybe administrator permission!");
}
Console.WriteLine($"[{i}] > {item.TableName} Constraint");
i++;
}
}
/// <summary>
/// Create the template output
/// </summary>
public virtual string TransformText()
{
this.Write("\r\n");
this.Write("\r\n");
this.Write("\r\n");
this.Write("\r\n\r\n");
#line 11 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
MariaDbSchema model = MariaDbSchemaManager.Data;
#line default
#line hidden
this.Write("\r\nCREATE TABLE IF NOT EXISTS `");
#line 13 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(model.TableName));
#line default
#line hidden
this.Write("` (");
#line 13 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
foreach (var item in model.Fields)
{
#line default
#line hidden
this.Write(" \r\n\t`");
#line 14 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Key));
#line default
#line hidden
this.Write("` ");
#line 14 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Value));
#line default
#line hidden
#line 14 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
if (model.Fields.Last().Key != item.Key)
{
#line default
#line hidden
this.Write(", ");
#line 14 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
}
#line default
#line hidden
this.Write(" ");
#line 14 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
}
#line default
#line hidden
#line 14 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
if (model.PrimaryKey)
{
#line default
#line hidden
this.Write(", \r\n\tINDEX `PK_");
#line 15 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(model.TableName));
#line default
#line hidden
this.Write("` (`ID`),\r\n\tCONSTRAINT `PK_");
#line 16 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(model.TableName));
#line default
#line hidden
this.Write("` PRIMARY KEY ( `ID` ASC )");
#line 16 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
if (model.Indexs.Count() != 0)
{
#line default
#line hidden
this.Write(",\r\n\tUNIQUE KEY (");
#line 17 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
foreach (var item in model.Indexs)
{
#line default
#line hidden
this.Write("`");
#line 17 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item));
#line default
#line hidden
this.Write("`");
#line 17 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
if (model.Indexs.Last() != item)
{
#line default
#line hidden
this.Write(", ");
#line 17 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
}
#line default
#line hidden
this.Write(" ");
#line 17 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
}
#line default
#line hidden
this.Write(") ");
#line 17 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
}
#line default
#line hidden
this.Write(" ");
#line 17 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaTableTemplate.tt"
}
#line default
#line hidden
this.Write(" \r\n) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;\r\n");
return(this.GenerationEnvironment.ToString());
}
internal static MariaDbSchema ToSetLogic(this MariaDbSchema obj)
{
LogicalUnit.SetPrimaryKey(obj);
return(obj);
}
/// <summary>
/// Create the template output
/// </summary>
public virtual string TransformText()
{
this.Write("\r\n");
this.Write("\r\n");
this.Write("\r\n");
this.Write("\r\n\r\n");
#line 11 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaConstraintTemplate.tt"
MariaDbSchema model = MariaDbSchemaManager.Data;
#line default
#line hidden
this.Write("\r\n");
#line 13 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaConstraintTemplate.tt"
if (model.ForeingKeys.Count() != 0)
{
#line default
#line hidden
this.Write("ALTER TABLE `");
#line 14 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaConstraintTemplate.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(model.TableName));
#line default
#line hidden
this.Write("` ");
#line 14 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaConstraintTemplate.tt"
foreach (var item in model.ForeingKeys)
{
#line default
#line hidden
this.Write(" \r\nADD CONSTRAINT `");
#line 15 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaConstraintTemplate.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.KeyName));
#line default
#line hidden
this.Write("` FOREIGN KEY (`");
#line 15 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaConstraintTemplate.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.ColumnName));
#line default
#line hidden
this.Write("`) REFERENCES `");
#line 15 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaConstraintTemplate.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.ReferenceTableName));
#line default
#line hidden
this.Write("` (`ID`) ");
#line 15 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaConstraintTemplate.tt"
if (model.ForeingKeys.Last().KeyName != item.KeyName)
{
#line default
#line hidden
this.Write(" , ");
#line 15 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaConstraintTemplate.tt"
}
else
{
#line default
#line hidden
this.Write(" ; ");
#line 15 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaConstraintTemplate.tt"
}
#line default
#line hidden
this.Write(" ");
#line 15 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaConstraintTemplate.tt"
}
#line default
#line hidden
this.Write(" ");
#line 15 "C:\Users\user\source\repos\OYASAR.CodeGenerator\OYASAR.CodeGenerator.Lib\TextTemplate\MariaDbSchemaConstraintTemplate.tt"
}
#line default
#line hidden
return(this.GenerationEnvironment.ToString());
}
