public MQTIndex(MQT mqt, string name, bool nonUnique, short type) { this.mqt = mqt; this.name = name; this.nonUnique = nonUnique; this.type = type; }
public static bool mqtsEqual(MQT mqt1, MQT mqt2) { string ddl1 = Regex.Replace(ddl(mqt1, Dialect.db2), "\\s", ""); string[] ddl1Value = Regex.Split(ddl1.ToUpper(), "datainitiallydeferred".ToUpper()); ddl1 = ddl1Value[0]; string ddl2 = Regex.Replace(ddl(mqt2, Dialect.db2), "\\s", ""); string[] ddl2Value = Regex.Split(ddl2.ToUpper(), "datainitiallydeferred".ToUpper()); ddl2 = ddl2Value[0]; return ddl1 == ddl2; }
public static string ddl(MQT mqt, Dialect dialect) { string sql = ""; if (dialect == Dialect.db2) { //sql = mqt.platformDdl.Replace(mqt.schema + ".", ""); sql = mqt.platformDdl; sql = System.Text.RegularExpressions.Regex.Replace(sql, @"""", ""); sql = sql.Replace(mqt.schema + ".", ""); } else sql = mqt.platformDdl; sql = System.Text.RegularExpressions.Regex.Replace(sql, @"\s{2,}", " "); return sql; }