/// <summary>
/// Create a primary key entry
/// </summary>
/// <param name="table">Name of Table key belongs to</param>
/// <param name="column">Column name to add ID to</param>
/// <returns>Column Entry</returns>
private SchemaItemObject CreatePrimaryKeyEntry(string table, string column = null)
{
var columname = column;
if (columname != null)
{
if (columname.Substring(columname.Length - 3) == "ies")
{
columname = columname.Replace("ies", "y");
}
}
else
{
columname = table;
}
columname += Constants.KeySuffix;
var row = new SchemaItemObject
{
ParentId = GetParentId(table),
TableName = table,
ColumnName = columname.Replace("\n", string.Empty),
ColumnType = "int",
ColumnSize = 0,
ColumnAttribute = "[Key]",
IsPrimaryKey = true,
IsAutoIncrement = true,
AllowDbNull = false,
IsUpdatedByNanite = true
};
return(row);
}
/// <summary>
/// Create a Table Name entry
/// </summary>
/// <param name="tablename">Table Name</param>
/// <returns>Table Entry</returns>
private SchemaItemObject CreateTableEntry(string tablename)
{
var row = new SchemaItemObject
{
//SchemaItemId = id,
SchemaItemId = SchemaItem.Count + 1,
ParentId = 0,
TableName = tablename,
ColumnName = tablename
};
return(row);
}
/// <summary>
/// Create a Column Name Entry
/// </summary>
/// <param name="parentid">Parent ID column belongs to</param>
/// <param name="tablename"></param>
/// <param name="columnname"></param>
/// <param name="type"></param>
/// <param name="size"></param>
/// <param name="attrib"></param>
/// <param name="allownull"></param>
/// <returns></returns>
private SchemaItemObject CreateColumnEntry(int parentid, string tablename, string columnname, string type, int size, bool allownull = true, string attrib = null)
{
var row = new SchemaItemObject
{
ParentId = parentid,
TableName = tablename,
ColumnName = columnname,
ColumnType = type,
ColumnSize = size,
AllowDbNull = allownull,
ColumnAttribute = attrib,
IsChecked = true,
IsUpdatedByNanite = true
};
return(row);
}
/// <summary>
/// Create a Foreign Key entry
/// </summary>
/// <param name="table">Name of Table key belongs to</param>
/// <param name="primarytable">Primary Table </param>
/// <param name="allownull"></param>
/// <param name="attrib"></param>
/// <returns></returns>
private SchemaItemObject CreateForeignKeyEntry(string table, string primarytable, bool allownull = true, string attrib = null)
{
var foreignKey = primarytable + Constants.KeySuffix;
var row = new SchemaItemObject
{
ParentId = GetParentId(table),
TableName = table,
ColumnName = foreignKey.Replace("\n", string.Empty),
ColumnType = "int",
ColumnSize = 0,
ColumnAttribute = attrib,
AllowDbNull = allownull,
IsChecked = true,
IsForeignKey = true,
IsUpdatedByNanite = true
};
return(row);
}
