// Statics // /// <summary> /// Combines two schemas; throws an exception if two columns have the same name. /// </summary> /// <param name="S1">The left schema</param> /// <param name="S2">The right schema</param> /// <returns>A combined schema</returns> public static Schema Join(Schema S1, Schema S2) { Schema s = new Schema(); for (int i = 0; i < S1.Count; i++) { s.Add(S1.ColumnName(i), S1.ColumnAffinity(i), S1.ColumnNull(i), S1.ColumnSize(i)); } for (int i = 0; i < S2.Count; i++) { s.Add(S2.ColumnName(i), S2.ColumnAffinity(i), S2.ColumnNull(i), S2.ColumnSize(i)); } return s; }
/// <summary> /// Creates a schema from another schema /// </summary> /// <param name="S">The starting point schema</param> /// <param name="K">A key representing the columns to keep</param> /// <returns>A schema</returns> public static Schema Split(Schema S, Key K) { Schema s = new Schema(); for (int i = 0; i < K.Count; i++) { s.Add(S.ColumnName(K[i]), S.ColumnAffinity(K[i]), S.ColumnNull(K[i]), S.ColumnSize(K[i])); } return s; }
public static Schema Build(Schema S1, string Alias1, Schema S2, string Alias2, string Delim) { Schema s = new Schema(); for (int i = 0; i < S1.Count; i++) s.Add(Alias1 + Delim + S1.ColumnName(i), S1.ColumnAffinity(i), S1.ColumnNull(i), S1.ColumnSize(i)); for (int i = 0; i < S2.Count; i++) s.Add(Alias2 + Delim + S2.ColumnName(i), S2.ColumnAffinity(i), S2.ColumnNull(i), S2.ColumnSize(i)); return s; }