protected override string ParseColumnAlter(TableColumnSchema mColumn, TableColumnSchema eColumn) { return(string.Format(@" [{0}] {1}{2} ", mColumn.Name, SqliteSchemaLoader.TypeDbsmToSqlite(mColumn), mColumn.Nullable ? string.Empty : @" NOT NULL")); }
/// <summary> /// Создать схему метаданных из исходной базы /// </summary> /// <param name="connStr"></param> public override DBSchema LoadExistingSchema(string connStr) { var schema = SqliteSchemaLoader.LoadSchema(connStr); var keys = new List <KeySchema>(); foreach (var table in schema.Tables) { keys.Clear(); keys.AddRange(table.Keys.Where(key => key.KeyType != ConstraintType.Default)); table.Keys = keys.ToArray(); } return(schema); }
protected override string ParseColumn(TableColumnSchema eColumn) { var stat = new StringBuilder(); stat.AppendFormat(@" [" + eColumn.Name + @"] " + SqliteSchemaLoader.TypeDbsmToSqlite(eColumn)); if (!String.IsNullOrEmpty(eColumn.DefaultValue)) { stat.Append(@" DEFAULT " + eColumn.DefaultValue); } if (!eColumn.Nullable) { stat.Append(@" NOT NULL"); } return(stat.ToString()); }