public static string ValueToDb(string varName, DalColumn dalCol)
{
if (string.IsNullOrEmpty(dalCol.ToDb))
{
return varName;
}
else
{
return string.Format(dalCol.ToDb, varName);
}
}
private static void ParseScript(ScriptContext context)
{
context.ClassName = context.ScriptLines[0].Trim(new char[] { ' ', '*', '\t' });
context.SchemaName = context.ScriptLines[1].Trim(new char[] { ' ', '*', '\t' });
if (context.SchemaName.Contains("."))
{
context.DatabaseOwner = context.SchemaName.Substring(0, context.SchemaName.IndexOf("."));
context.SchemaName = context.SchemaName.Substring(context.SchemaName.IndexOf(".") + 1);
}
for (int i = 2; i <= (int)context.ScriptLines.Length - 1; i++)
{
string currentLine = context.ScriptLines[i];
string currentLineTrimmed = currentLine.Trim(new char[] { ' ', '*', '\t' });
if (currentLineTrimmed.StartsWith("@Index:", StringComparison.OrdinalIgnoreCase))
{
string[] indexArguments = currentLineTrimmed.Substring(7).Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
DalIndex dalIndex = new DalIndex();
for (int j = 0; j <= (int)indexArguments.Length - 1; j++)
{
string arg = indexArguments[j].Trim();
if (arg.StartsWith("NAME(", StringComparison.OrdinalIgnoreCase))
{
dalIndex.IndexName = arg.Substring(5, arg.IndexOf(")") - 5);
}
else if (arg.Equals("UNIQUE", StringComparison.OrdinalIgnoreCase))
{
dalIndex.IndexMode = DalIndexIndexMode.Unique;
}
else if (arg.Equals("PRIMARY KEY", StringComparison.OrdinalIgnoreCase) || arg.Equals("PRIMARYKEY", StringComparison.OrdinalIgnoreCase))
{
dalIndex.IndexMode = DalIndexIndexMode.PrimaryKey;
}
else if (arg.Equals("SPATIAL", StringComparison.OrdinalIgnoreCase))
{
dalIndex.IndexMode = DalIndexIndexMode.Spatial;
}
else if (arg.Equals("FULLTEXT", StringComparison.OrdinalIgnoreCase))
{
dalIndex.IndexMode = DalIndexIndexMode.FullText;
}
else if (arg.Equals("BTREE", StringComparison.OrdinalIgnoreCase))
{
dalIndex.IndexType = DalIndexIndexType.BTREE;
}
else if (arg.Equals("RTREE", StringComparison.OrdinalIgnoreCase))
{
dalIndex.IndexType = DalIndexIndexType.RTREE;
}
else if (arg.Equals("HASH", StringComparison.OrdinalIgnoreCase))
{
dalIndex.IndexType = DalIndexIndexType.HASH;
}
else if (arg.Equals("NONCLUSTERED", StringComparison.OrdinalIgnoreCase))
{
dalIndex.ClusterMode = DalIndexClusterMode.NonClustered;
}
else if (arg.Equals("CLUSTERED", StringComparison.OrdinalIgnoreCase))
{
dalIndex.ClusterMode = DalIndexClusterMode.Clustered;
}
else if (arg.StartsWith("[", StringComparison.OrdinalIgnoreCase))
{
string[] columns = arg
.Trim(new char[] { ' ', '[', ']', '\t' })
.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string column in columns)
{
if (column.EndsWith(@" ASC") || column.EndsWith(@" DESC"))
{
dalIndex.Columns.Add(new DalIndexColumn(column.Substring(0, column.LastIndexOf(' ')), column.Substring(column.LastIndexOf(' ') + 1)));
}
else
{
dalIndex.Columns.Add(new DalIndexColumn(column));
}
}
}
}
if (dalIndex.IndexMode == DalIndexIndexMode.PrimaryKey && dalIndex.Columns.Count == 1)
{
context.SingleColumnPrimaryKeyName = (context.SingleColumnPrimaryKeyName != null ? "" : dalIndex.Columns[0].Name);
}
context.Indices.Add(dalIndex);
}
else if (currentLineTrimmed.StartsWith("@ForeignKey:", StringComparison.OrdinalIgnoreCase))
{
string[] foreignKeyArguments = currentLineTrimmed.Substring(12).Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
DalForeignKey dalForeignKey = new DalForeignKey();
for (int l = 0; l <= (int)foreignKeyArguments.Length - 1; l++)
{
string arg = foreignKeyArguments[l].Trim();
if (arg.StartsWith("NAME(", StringComparison.OrdinalIgnoreCase))
{
dalForeignKey.ForeignKeyName = arg.Substring(5, arg.IndexOf(")") - 5);
}
else if (arg.StartsWith("FOREIGNTABLE(", StringComparison.OrdinalIgnoreCase))
{
dalForeignKey.ForeignTable = arg.Substring(13, arg.IndexOf(")") - 13);
}
else if (arg.StartsWith("ONUPDATE(", StringComparison.OrdinalIgnoreCase))
{
switch ((arg.Substring(9, arg.IndexOf(")") - 9)).ToUpper())
{
case "RESTRICT":
dalForeignKey.OnUpdate = DalForeignKeyReference.Restrict;
break;
case "CASCADE":
dalForeignKey.OnUpdate = DalForeignKeyReference.Cascade;
break;
case "SETNULL":
case "SET NULL":
dalForeignKey.OnUpdate = DalForeignKeyReference.SetNull;
break;
case "NOACTION":
dalForeignKey.OnUpdate = DalForeignKeyReference.NoAction;
break;
default:
dalForeignKey.OnUpdate = DalForeignKeyReference.None;
break;
}
}
else if (arg.StartsWith("ONDELETE(", StringComparison.OrdinalIgnoreCase))
{
switch ((arg.Substring(9, arg.IndexOf(")") - 9)).ToUpper())
{
case "RESTRICT":
dalForeignKey.OnDelete = DalForeignKeyReference.Restrict;
break;
case "CASCADE":
dalForeignKey.OnDelete = DalForeignKeyReference.Cascade;
break;
case "SETNULL":
case "SET NULL":
dalForeignKey.OnDelete = DalForeignKeyReference.SetNull;
break;
case "NOACTION":
dalForeignKey.OnDelete = DalForeignKeyReference.NoAction;
break;
default:
dalForeignKey.OnDelete = DalForeignKeyReference.None;
break;
}
}
else if (arg.StartsWith("COLUMNS[", StringComparison.OrdinalIgnoreCase))
{
string columns = arg.Substring(7).Trim(new char[] { ' ', '[', ']', '\t' });
string[] strArrays = columns.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int k = 0; k < strArrays.Length; k++)
{
dalForeignKey.Columns.Add(strArrays[k]);
}
}
else if (arg.StartsWith("FOREIGNCOLUMNS[", StringComparison.OrdinalIgnoreCase))
{
string columns = arg.Substring(14).Trim(new char[] { ' ', '[', ']', '\t' });
string[] strArrays = columns.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int k = 0; k < strArrays.Length; k++)
{
dalForeignKey.ForeignColumns.Add(strArrays[k]);
}
}
}
context.ForeignKeys.Add(dalForeignKey);
}
else if (currentLineTrimmed.StartsWith("@BeforeInsert:", StringComparison.OrdinalIgnoreCase))
{
context.CustomBeforeInsert = currentLineTrimmed.Substring(14).Trim();
}
else if (currentLineTrimmed.StartsWith("@BeforeUpdate:", StringComparison.OrdinalIgnoreCase))
{
context.CustomBeforeUpdate = currentLineTrimmed.Substring(14).Trim();
}
else if (currentLineTrimmed.StartsWith("@AfterRead:", StringComparison.OrdinalIgnoreCase))
{
context.CustomAfterRead = currentLineTrimmed.Substring(11).Trim();
}
else if (currentLineTrimmed.StartsWith("@StaticColumns", StringComparison.OrdinalIgnoreCase))
{
context.StaticColumns = true;
}
else if (currentLineTrimmed.StartsWith("@OmitCollection", StringComparison.OrdinalIgnoreCase))
{
context.ExportCollection = false;
}
else if (currentLineTrimmed.StartsWith("@AtomicUpdates", StringComparison.OrdinalIgnoreCase))
{
context.AtomicUpdates = true;
}
else if (currentLineTrimmed.StartsWith("@InsertAutoIncrement", StringComparison.OrdinalIgnoreCase))
{
context.InsertAutoIncrement = true;
}
else if (!currentLineTrimmed.StartsWith("@MySqlEngine:", StringComparison.OrdinalIgnoreCase))
{
int startPos = currentLineTrimmed.IndexOf(":");
DalColumn dalColumn = new DalColumn();
dalColumn.Name = currentLineTrimmed.Substring(0, startPos).Trim();
dalColumn.NameX = StripColumnName(dalColumn.Name);
if (context.ClassName == dalColumn.NameX || dalColumn.NameX == "Columns")
{
dalColumn.NameX += "X";
}
dalColumn.IsPrimaryKey = false;
dalColumn.IsNullable = false;
dalColumn.AutoIncrement = false;
dalColumn.Type = DalColumnType.TInt;
dalColumn.DefaultValue = "null";
dalColumn.ActualDefaultValue = "";
dalColumn.Comment = "";
dalColumn.EnumTypeName = "";
currentLineTrimmed = currentLineTrimmed.Substring(startPos + 1).Trim();
string[] columnKeywords = currentLineTrimmed.Split(new char[] { ';' }, StringSplitOptions.None);
for (int m = 0; m <= (int)columnKeywords.Length - 1; m++)
{
string columnKeyword = columnKeywords[m].Trim();
if (m == (int)columnKeywords.Length - 1)
{
if (!columnKeyword.EndsWith(":") ||
(int)context.ScriptLines.Length <= i + 2 ||
!context.ScriptLines[i + 1].Trim(new char[] { ' ', '*', '\t' }).StartsWith("\"") ||
!context.ScriptLines[i + 2].Trim(new char[] { ' ', '*', '\t' }).StartsWith("-"))
{
dalColumn.Comment = columnKeyword;
}
else
{
dalColumn.Comment = columnKeyword.Remove(columnKeyword.Length - 1, 1);
i++;
currentLineTrimmed = context.ScriptLines[i];
DalEnum dalEnum = new DalEnum();
dalEnum.Name = currentLineTrimmed.Trim(new char[] { ' ', '*', '\"', '\t' });
dalColumn.EnumTypeName = dalEnum.Name;
dalEnum.Items = new List<string>();
while ((int)context.ScriptLines.Length > i + 1 &&
context.ScriptLines[i + 1].Trim(new char[] { ' ', '*', '\t' }).StartsWith("-"))
{
i++;
currentLineTrimmed = context.ScriptLines[i].Trim(new char[] { ' ', '*', '-', '\t' });
dalEnum.Items.Add(currentLineTrimmed);
}
context.Enums.Add(dalEnum);
}
}
else if (columnKeyword.Equals("PRIMARY KEY", StringComparison.OrdinalIgnoreCase) ||
columnKeyword.Equals("PRIMARYKEY", StringComparison.OrdinalIgnoreCase))
{
dalColumn.IsPrimaryKey = true;
context.SingleColumnPrimaryKeyName = (context.SingleColumnPrimaryKeyName != null ? "" : dalColumn.NameX);
}
else if (columnKeyword.Equals("NULLABLE", StringComparison.OrdinalIgnoreCase))
{
dalColumn.IsNullable = true;
}
else if (columnKeyword.Equals("AUTOINCREMENT", StringComparison.OrdinalIgnoreCase) ||
columnKeyword.Equals("AUTO_INCREMENT", StringComparison.OrdinalIgnoreCase) ||
columnKeyword.Equals("AUTO INCREMENT", StringComparison.OrdinalIgnoreCase))
{
dalColumn.AutoIncrement = true;
}
else if (columnKeyword.Equals("NoProperty", StringComparison.OrdinalIgnoreCase))
{
dalColumn.NoProperty = true;
}
else if (columnKeyword.Equals("NoSave", StringComparison.OrdinalIgnoreCase))
{
dalColumn.NoSave = true;
}
else if (columnKeyword.StartsWith("PRECISION(", StringComparison.OrdinalIgnoreCase))
{
int precision = 0;
int.TryParse(columnKeyword.Substring(10, columnKeyword.IndexOf(")") - 10), out precision);
dalColumn.Precision = precision;
}
else if (columnKeyword.StartsWith("SCALE(", StringComparison.OrdinalIgnoreCase))
{
int scale = 0;
int.TryParse(columnKeyword.Substring(6, columnKeyword.IndexOf(")") - 6), out scale);
dalColumn.Scale = scale;
}
else if (columnKeyword.StartsWith("LITERALTYPE ", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TLiteral;
dalColumn.LiteralType = columnKeyword.Substring(12).Trim();
}
else if (columnKeyword.StartsWith("STRING(", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TString;
string maxLength = columnKeyword.Substring(7, columnKeyword.IndexOf(")") - 7);
if (maxLength == "MAX")
{
dalColumn.MaxLength = -1;
}
else
{
int iMaxLength = 0;
int.TryParse(maxLength, out iMaxLength);
dalColumn.MaxLength = iMaxLength;
}
}
else if (columnKeyword.StartsWith("FIXEDSTRING(", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TFixedString;
string maxLength = columnKeyword.Substring(12, columnKeyword.IndexOf(")") - 12);
if (maxLength == "MAX")
{
dalColumn.MaxLength = -1;
}
else
{
int iMaxLength = 0;
int.TryParse(maxLength, out iMaxLength);
dalColumn.MaxLength = iMaxLength;
}
}
else if (columnKeyword.Equals("TEXT", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TText;
}
else if (columnKeyword.StartsWith("TEXT(", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TText;
int maxLength = 0;
int.TryParse(columnKeyword.Substring(5, columnKeyword.IndexOf(")") - 5), out maxLength);
dalColumn.MaxLength = maxLength;
}
else if (columnKeyword.Equals("LONGTEXT", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TLongText;
}
else if (columnKeyword.StartsWith("LONGTEXT(", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TLongText;
int maxLength = 0;
int.TryParse(columnKeyword.Substring(9, columnKeyword.IndexOf(")") - 9), out maxLength);
dalColumn.MaxLength = maxLength;
}
else if (columnKeyword.Equals("MEDIUMTEXT", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TMediumText;
}
else if (columnKeyword.StartsWith("MEDIUMTEXT(", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TMediumText;
int maxLength = 0;
int.TryParse(columnKeyword.Substring(11, columnKeyword.IndexOf(")") - 1), out maxLength);
dalColumn.MaxLength = maxLength;
}
else if (columnKeyword.Equals("BOOL", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TBool;
}
else if (columnKeyword.Equals("GUID", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGuid;
}
else if (columnKeyword.Equals("DECIMAL", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TDecimal;
}
else if (columnKeyword.Equals("MONEY", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TMoney;
}
else if (columnKeyword.StartsWith("DECIMAL", StringComparison.OrdinalIgnoreCase) |
columnKeyword.StartsWith("MONEY", StringComparison.OrdinalIgnoreCase))
{
string precision = "";
string scale = "";
int leftPartIndex = columnKeyword.IndexOf("(");
int commaIndex = columnKeyword.IndexOf(",");
int rightParIndex = columnKeyword.IndexOf(")");
if (leftPartIndex > -1 & commaIndex > -1)
{
precision = columnKeyword.Substring(leftPartIndex + 1, commaIndex - leftPartIndex - 1).Trim();
scale = columnKeyword.Substring(commaIndex + 1, rightParIndex - commaIndex - 1).Trim();
}
else if (leftPartIndex > -1)
{
precision = columnKeyword.Substring(leftPartIndex + 1, rightParIndex - leftPartIndex - 1).Trim();
}
if (precision.Length > 0)
{
dalColumn.Precision = Convert.ToInt32(precision);
}
if (scale.Length > 0)
{
dalColumn.Scale = Convert.ToInt32(scale);
}
if (columnKeyword.StartsWith("MONEY", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TMoney;
}
else
{
dalColumn.Type = DalColumnType.TDecimal;
}
}
else if (columnKeyword.Equals("DOUBLE", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TDouble;
}
else if (columnKeyword.Equals("FLOAT", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TFloat;
}
else if (columnKeyword.Equals("INT", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TInt;
}
else if (columnKeyword.Equals("INTEGER", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TInt;
}
else if (columnKeyword.Equals("INT8", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TInt8;
}
else if (columnKeyword.Equals("INT16", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TInt16;
}
else if (columnKeyword.Equals("INT32", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TInt32;
}
else if (columnKeyword.Equals("INT64", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TInt64;
}
else if (columnKeyword.Equals("UINT8", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TUInt8;
}
else if (columnKeyword.Equals("UINT16", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TUInt16;
}
else if (columnKeyword.Equals("UINT32", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TUInt32;
}
else if (columnKeyword.Equals("UINT64", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TUInt64;
}
else if (columnKeyword.Equals("JSON", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TJson;
}
else if (columnKeyword.Equals("JSON_BINARY", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TJsonBinary;
}
else if (columnKeyword.Equals("GEOMETRY", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeometry;
}
else if (columnKeyword.Equals("GEOMETRYCOLLECTION", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeometryCollection;
}
else if (columnKeyword.Equals("POINT", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TPoint;
}
else if (columnKeyword.Equals("LINESTRING", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TLineString;
}
else if (columnKeyword.Equals("POLYGON", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TPolygon;
}
else if (columnKeyword.Equals("LINE", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TLine;
}
else if (columnKeyword.Equals("CURVE", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TCurve;
}
else if (columnKeyword.Equals("SURFACE", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TSurface;
}
else if (columnKeyword.Equals("LINEARRING", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TLinearRing;
}
else if (columnKeyword.Equals("MULTIPOINT", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TMultiPoint;
}
else if (columnKeyword.Equals("MULTILINESTRING", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TMultiLineString;
}
else if (columnKeyword.Equals("MULTIPOLYGON", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TMultiPolygon;
}
else if (columnKeyword.Equals("MULTICURVE", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TMultiCurve;
}
else if (columnKeyword.Equals("MULTISURFACE", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TMultiSurface;
}
else if (columnKeyword.Equals("GEOGAPHIC", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeographic;
}
else if (columnKeyword.Equals("GEOGAPHICCOLLECTION", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeographicCollection;
}
else if (columnKeyword.Equals("GEOGAPHIC_POINT", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeographicPoint;
}
else if (columnKeyword.Equals("GEOGAPHIC_LINESTRING", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeographicLineString;
}
else if (columnKeyword.Equals("GEOGAPHIC_POLYGON", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeographicPolygon;
}
else if (columnKeyword.Equals("GEOGAPHIC_LINE", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeographicLine;
}
else if (columnKeyword.Equals("GEOGAPHIC_CURVE", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeographicCurve;
}
else if (columnKeyword.Equals("GEOGAPHIC_SURFACE", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeographicSurface;
}
else if (columnKeyword.Equals("GEOGAPHIC_LINEARRING", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeographicLinearRing;
}
else if (columnKeyword.Equals("GEOGAPHIC_MULTIPOINT", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeographicMultiPoint;
}
else if (columnKeyword.Equals("GEOGAPHIC_MULTILINESTRING", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeographicMultiLineString;
}
else if (columnKeyword.Equals("GEOGAPHIC_MULTIPOLYGON", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeographicMultiPolygon;
}
else if (columnKeyword.Equals("GEOGAPHIC_MULTICURVE", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeographicMultiCurve;
}
else if (columnKeyword.Equals("GEOGAPHIC_MULTISURFACE", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TGeographicMultiSurface;
}
else if (columnKeyword.Equals("DATETIME", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TDateTime;
}
else if (columnKeyword.Equals("DATETIME_UTC", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TDateTimeUtc;
}
else if (columnKeyword.Equals("DATETIME_LOCAL", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Type = DalColumnType.TDateTimeLocal;
}
else if (columnKeyword.StartsWith("Default ", StringComparison.OrdinalIgnoreCase))
{
dalColumn.DefaultValue = columnKeyword.Substring(8);
}
else if (columnKeyword.StartsWith("ActualDefault ", StringComparison.OrdinalIgnoreCase))
{
dalColumn.ActualDefaultValue = columnKeyword.Substring(14);
}
else if (columnKeyword.StartsWith("ToDB ", StringComparison.OrdinalIgnoreCase))
{
dalColumn.ToDb = columnKeyword.Substring(5);
}
else if (columnKeyword.Equals("Virtual", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Virtual = true;
}
else if (columnKeyword.StartsWith("FromDB ", StringComparison.OrdinalIgnoreCase))
{
dalColumn.FromDb = columnKeyword.Substring(7);
}
else if (columnKeyword.StartsWith("ActualType ", StringComparison.OrdinalIgnoreCase))
{
dalColumn.ActualType = columnKeyword.Substring(11);
}
else if (columnKeyword.StartsWith("ColumnName ", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Name = columnKeyword.Substring(11);
}
else if (columnKeyword.StartsWith("PropertyName ", StringComparison.OrdinalIgnoreCase))
{
dalColumn.NameX = columnKeyword.Substring(13);
}
else if (columnKeyword.Equals("Unique Index", StringComparison.OrdinalIgnoreCase) ||
columnKeyword.Equals("Unique", StringComparison.OrdinalIgnoreCase))
{
DalIndex dalIx = new DalIndex();
dalIx.Columns.Add(new DalIndexColumn(dalColumn.Name));
dalIx.IndexMode = DalIndexIndexMode.Unique;
context.Indices.Add(dalIx);
}
else if (columnKeyword.StartsWith("Foreign ", StringComparison.OrdinalIgnoreCase))
{
DalForeignKey dalFk = new DalForeignKey();
string str30 = columnKeyword.Substring(8);
dalFk.ForeignTable = str30.Substring(0, str30.IndexOf("."));
dalFk.ForeignColumns.Add(str30.Substring(str30.IndexOf(".") + 1));
dalFk.Columns.Add(dalColumn.Name);
context.ForeignKeys.Add(dalFk);
}
else if (columnKeyword.StartsWith("IsMutatedProperty ", StringComparison.OrdinalIgnoreCase))
{
dalColumn.IsMutatedProperty = columnKeyword.Substring(18);
}
else if (columnKeyword.StartsWith("Charset ", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Charset = columnKeyword.Substring(8);
}
else if (columnKeyword.StartsWith("Collate ", StringComparison.OrdinalIgnoreCase))
{
dalColumn.Collate = columnKeyword.Substring(8);
}
}
if (dalColumn.IsPrimaryKey & dalColumn.Type == DalColumnType.TInt)
{
dalColumn.Type = DalColumnType.TInt64;
}
context.Columns.Add(dalColumn);
}
else
{
context.MySqlEngineName = currentLineTrimmed.Substring(13).Trim();
}
}
if (context.MySqlEngineName.Equals("MyISAM", StringComparison.OrdinalIgnoreCase))
{
context.MySqlEngineName = "MyISAM";
}
else if (context.MySqlEngineName.Equals("InnoDB", StringComparison.OrdinalIgnoreCase))
{
context.MySqlEngineName = "InnoDB";
}
else if (context.MySqlEngineName.Equals("ARCHIVE", StringComparison.OrdinalIgnoreCase))
{
context.MySqlEngineName = "ARCHIVE";
}
}
private static void WriteSchemaAddColumnArguments(DalColumn dalCol, StringBuilder stringBuilder)
{
string customActualType = dalCol.ActualType;
if (!string.IsNullOrEmpty(dalCol.EnumTypeName))
{
dalCol.ActualType = dalCol.EnumTypeName;
}
else if (dalCol.Type == DalColumnType.TBool)
{
dalCol.ActualType = "bool";
}
else if (dalCol.Type == DalColumnType.TGuid)
{
dalCol.ActualType = "Guid";
}
else if (dalCol.Type == DalColumnType.TDateTime ||
dalCol.Type == DalColumnType.TDateTimeUtc ||
dalCol.Type == DalColumnType.TDateTimeLocal)
{
dalCol.ActualType = "DateTime";
}
else if (dalCol.Type == DalColumnType.TInt)
{
dalCol.ActualType = "int";
}
else if (dalCol.Type == DalColumnType.TInt8)
{
dalCol.ActualType = "SByte";
}
else if (dalCol.Type == DalColumnType.TInt16)
{
dalCol.ActualType = "Int16";
}
else if (dalCol.Type == DalColumnType.TInt32)
{
dalCol.ActualType = "Int32";
}
else if (dalCol.Type == DalColumnType.TInt64)
{
dalCol.ActualType = "Int64";
}
else if (dalCol.Type == DalColumnType.TUInt8)
{
dalCol.ActualType = "Byte";
}
else if (dalCol.Type == DalColumnType.TUInt16)
{
dalCol.ActualType = "UInt16";
}
else if (dalCol.Type == DalColumnType.TUInt32)
{
dalCol.ActualType = "UInt32";
}
else if (dalCol.Type == DalColumnType.TUInt64)
{
dalCol.ActualType = "UInt64";
}
else if (dalCol.Type == DalColumnType.TString ||
dalCol.Type == DalColumnType.TText ||
dalCol.Type == DalColumnType.TLongText ||
dalCol.Type == DalColumnType.TMediumText ||
dalCol.Type == DalColumnType.TFixedString)
{
dalCol.ActualType = "string";
}
else if (dalCol.Type == DalColumnType.TDecimal ||
dalCol.Type == DalColumnType.TMoney)
{
dalCol.ActualType = "decimal";
}
else if (dalCol.Type == DalColumnType.TDouble)
{
dalCol.ActualType = "double";
}
else if (dalCol.Type == DalColumnType.TFloat)
{
dalCol.ActualType = "float";
}
else if (dalCol.Type == DalColumnType.TJson ||
dalCol.Type == DalColumnType.TJsonBinary)
{
dalCol.ActualType = "string";
}
else if (dalCol.Type == DalColumnType.TGeometry)
{
dalCol.ActualType = "Geometry";
}
else if (dalCol.Type == DalColumnType.TGeometryCollection)
{
dalCol.ActualType = "Geometry.GeometryCollection";
}
else if (dalCol.Type == DalColumnType.TPoint)
{
dalCol.ActualType = "Geometry.Point";
}
else if (dalCol.Type == DalColumnType.TLineString)
{
dalCol.ActualType = "Geometry.LineString";
}
else if (dalCol.Type == DalColumnType.TPolygon)
{
dalCol.ActualType = "Geometry.Polygon";
}
else if (dalCol.Type == DalColumnType.TLine)
{
dalCol.ActualType = "Geometry.Line";
}
else if (dalCol.Type == DalColumnType.TCurve)
{
dalCol.ActualType = "Geometry";
}
else if (dalCol.Type == DalColumnType.TSurface)
{
dalCol.ActualType = "Geometry";
}
else if (dalCol.Type == DalColumnType.TLinearRing)
{
dalCol.ActualType = "Geometry";
}
else if (dalCol.Type == DalColumnType.TMultiPoint)
{
dalCol.ActualType = "Geometry.MultiPoint";
}
else if (dalCol.Type == DalColumnType.TMultiLineString)
{
dalCol.ActualType = "Geometry.MultiLineString";
}
else if (dalCol.Type == DalColumnType.TMultiPolygon)
{
dalCol.ActualType = "Geometry.MultiPolygon";
}
else if (dalCol.Type == DalColumnType.TMultiCurve)
{
dalCol.ActualType = "Geometry.GeometryCollection";
}
else if (dalCol.Type == DalColumnType.TMultiSurface)
{
dalCol.ActualType = "Geometry.GeometryCollection";
}
else if (dalCol.Type == DalColumnType.TGeographic)
{
dalCol.ActualType = "Geometry";
}
else if (dalCol.Type == DalColumnType.TGeographicCollection)
{
dalCol.ActualType = "Geometry.GeometryCollection";
}
else if (dalCol.Type == DalColumnType.TGeographicPoint)
{
dalCol.ActualType = "Geometry.Point";
}
else if (dalCol.Type == DalColumnType.TGeographicLineString)
{
dalCol.ActualType = "Geometry.LineString";
}
else if (dalCol.Type == DalColumnType.TGeographicPolygon)
{
dalCol.ActualType = "Geometry.Polygon";
}
else if (dalCol.Type == DalColumnType.TGeographicLine)
{
dalCol.ActualType = "Geometry.Line";
}
else if (dalCol.Type == DalColumnType.TGeographicCurve)
{
dalCol.ActualType = "Geometry";
}
else if (dalCol.Type == DalColumnType.TGeographicSurface)
{
dalCol.ActualType = "Geometry";
}
else if (dalCol.Type == DalColumnType.TGeographicLinearRing)
{
dalCol.ActualType = "Geometry";
}
else if (dalCol.Type == DalColumnType.TGeographicMultiPoint)
{
dalCol.ActualType = "Geometry.MultiPoint";
}
else if (dalCol.Type == DalColumnType.TGeographicMultiLineString)
{
dalCol.ActualType = "Geometry.MultiLineString";
}
else if (dalCol.Type == DalColumnType.TGeographicMultiPolygon)
{
dalCol.ActualType = "Geometry.MultiPolygon";
}
else if (dalCol.Type == DalColumnType.TGeographicMultiCurve)
{
dalCol.ActualType = "Geometry.GeometryCollection";
}
else if (dalCol.Type == DalColumnType.TGeographicMultiSurface)
{
dalCol.ActualType = "Geometry.GeometryCollection";
}
else if (dalCol.Type == DalColumnType.TLiteral)
{
// Do not change it, specified by ACTUALTYPE
}
stringBuilder.AppendFormat("Columns.{0}, typeof({1})", dalCol.NameX, dalCol.ActualType);
if (dalCol.Type == DalColumnType.TText)
{
stringBuilder.Append(", DataType.Text");
}
else if (dalCol.Type == DalColumnType.TLongText)
{
stringBuilder.Append(", DataType.LongText");
}
else if (dalCol.Type == DalColumnType.TMediumText)
{
stringBuilder.Append(", DataType.MediumText");
}
else if (dalCol.Type == DalColumnType.TFixedString)
{
stringBuilder.Append(", DataType.Char");
}
else if (dalCol.Type == DalColumnType.TMoney)
{
stringBuilder.Append(", DataType.Money");
}
else if (dalCol.Type == DalColumnType.TJson)
{
stringBuilder.Append(", DataType.Json");
}
else if (dalCol.Type == DalColumnType.TJsonBinary)
{
stringBuilder.Append(", DataType.JsonBinary");
}
else if (dalCol.Type == DalColumnType.TGeometry)
{
stringBuilder.Append(", DataType.Geometry");
}
else if (dalCol.Type == DalColumnType.TGeometryCollection)
{
stringBuilder.Append(", DataType.GeometryCollection");
}
else if (dalCol.Type == DalColumnType.TPoint)
{
stringBuilder.Append(", DataType.Point");
}
else if (dalCol.Type == DalColumnType.TLineString)
{
stringBuilder.Append(", DataType.LineString");
}
else if (dalCol.Type == DalColumnType.TPolygon)
{
stringBuilder.Append(", DataType.Polygon");
}
else if (dalCol.Type == DalColumnType.TLine)
{
stringBuilder.Append(", DataType.Line");
}
else if (dalCol.Type == DalColumnType.TCurve)
{
stringBuilder.Append(", DataType.Curve");
}
else if (dalCol.Type == DalColumnType.TSurface)
{
stringBuilder.Append(", DataType.Surface");
}
else if (dalCol.Type == DalColumnType.TLinearRing)
{
stringBuilder.Append(", DataType.LinearRing");
}
else if (dalCol.Type == DalColumnType.TMultiPoint)
{
stringBuilder.Append(", DataType.MultiPoint");
}
else if (dalCol.Type == DalColumnType.TMultiLineString)
{
stringBuilder.Append(", DataType.MultiLineString");
}
else if (dalCol.Type == DalColumnType.TMultiPolygon)
{
stringBuilder.Append(", DataType.MultiPolygon");
}
else if (dalCol.Type == DalColumnType.TMultiCurve)
{
stringBuilder.Append(", DataType.MultiCurve");
}
else if (dalCol.Type == DalColumnType.TMultiSurface)
{
stringBuilder.Append(", DataType.MultiSurface");
}
else if (dalCol.Type == DalColumnType.TGeographic)
{
stringBuilder.Append(", DataType.Geographic");
}
else if (dalCol.Type == DalColumnType.TGeographicCollection)
{
stringBuilder.Append(", DataType.GeographicCollection");
}
else if (dalCol.Type == DalColumnType.TGeographicPoint)
{
stringBuilder.Append(", DataType.GeographicPoint");
}
else if (dalCol.Type == DalColumnType.TGeographicLineString)
{
stringBuilder.Append(", DataType.GeographicLineString");
}
else if (dalCol.Type == DalColumnType.TGeographicPolygon)
{
stringBuilder.Append(", DataType.GeographicPolygon");
}
else if (dalCol.Type == DalColumnType.TGeographicLine)
{
stringBuilder.Append(", DataType.GeographicLine");
}
else if (dalCol.Type == DalColumnType.TGeographicCurve)
{
stringBuilder.Append(", DataType.GeographicCurve");
}
else if (dalCol.Type == DalColumnType.TGeographicSurface)
{
stringBuilder.Append(", DataType.GeographicSurface");
}
else if (dalCol.Type == DalColumnType.TGeographicLinearRing)
{
stringBuilder.Append(", DataType.GeographicLinearRing");
}
else if (dalCol.Type == DalColumnType.TGeographicMultiPoint)
{
stringBuilder.Append(", DataType.GeographicMultiPoint");
}
else if (dalCol.Type == DalColumnType.TGeographicMultiLineString)
{
stringBuilder.Append(", DataType.GeographicMultiLineString");
}
else if (dalCol.Type == DalColumnType.TGeographicMultiPolygon)
{
stringBuilder.Append(", DataType.GeographicMultiPolygon");
}
else if (dalCol.Type == DalColumnType.TGeographicMultiCurve)
{
stringBuilder.Append(", DataType.GeographicMultiCurve");
}
else if (dalCol.Type == DalColumnType.TGeographicMultiSurface)
{
stringBuilder.Append(", DataType.GeographicMultiSurface");
}
else if (!string.IsNullOrEmpty(dalCol.EnumTypeName))
{
if (dalCol.Type == DalColumnType.TInt8)
{
stringBuilder.Append(", DataType.TinyInt");
}
else if (dalCol.Type == DalColumnType.TInt16)
{
stringBuilder.Append(", DataType.SmallInt");
}
else if (dalCol.Type == DalColumnType.TInt32)
{
stringBuilder.Append(", DataType.Int");
}
else if (dalCol.Type == DalColumnType.TInt64)
{
stringBuilder.Append(", DataType.BigInt");
}
else if (dalCol.Type == DalColumnType.TUInt8)
{
stringBuilder.Append(", DataType.UnsignedTinyInt");
}
else if (dalCol.Type == DalColumnType.TUInt16)
{
stringBuilder.Append(", DataType.UnsignedSmallInt");
}
else if (dalCol.Type == DalColumnType.TUInt32)
{
stringBuilder.Append(", DataType.UnsignedInt");
}
else if (dalCol.Type == DalColumnType.TUInt64)
{
stringBuilder.Append(", DataType.UnsignedBigInt");
}
}
if (!string.IsNullOrEmpty(customActualType))
{
dalCol.ActualType = customActualType;
}
else if (dalCol.IsNullable && dalCol.ActualType != "string")
{
dalCol.ActualType += "?";
}
stringBuilder.AppendFormat(", {0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}",
dalCol.MaxLength,
string.IsNullOrEmpty(dalCol.LiteralType) ? "null" : (@"""" + dalCol.LiteralType.Replace(@"""", @"""""") + @""""),
dalCol.Precision,
dalCol.Scale,
dalCol.AutoIncrement ? "true" : "false",
dalCol.IsPrimaryKey ? "true" : "false",
dalCol.IsNullable ? "true" : "false",
dalCol.DefaultValue);
if (!string.IsNullOrEmpty(dalCol.Charset) || !string.IsNullOrEmpty(dalCol.Collate))
{
stringBuilder.AppendFormat(@", {0}, {1}",
string.IsNullOrEmpty(dalCol.Charset) ? "null" : (@"""" + dalCol.Charset + @""""),
string.IsNullOrEmpty(dalCol.Collate) ? "null" : (@"""" + dalCol.Collate + @""""));
}
}
