Example #1
0
        public virtual void GetForeignKeys(MetaInfoTables tables)
        {
            foreach (MetaInfoTable table in tables)
            {
                table.ForeignKeys.Clear();
                foreach (DataRow row in SelectData(GetForeignKeysSql(table)).Rows)
                {
                    string             persistentSchema = row[SqlColName_FKTableSchema].ToString();
                    string             persistentName   = row[SqlColName_ConstraintName].ToString();
                    MetaInfoForeignKey fk = table.ForeignKeys.FindByPersistentName(persistentSchema, persistentName, false);
                    if (fk == null)
                    {
                        string msg = String.Format("Importing FK: {0}...", MetaInfoBase.MakeFullName(persistentSchema, persistentName));
                        fk = new MetaInfoForeignKey();
                        fk.PersistentSchema = persistentSchema;
                        fk.PersistentName   = persistentName;
                        fk.Child            = table;
                        string parentTableSchema = row[SqlColName_FKParentTableSchema].ToString();
                        string parentTableName   = row[SqlColName_FKParentTableName].ToString();
                        fk.Parent = tables.FindByPersistentName(parentTableSchema, parentTableName, false);
                        if (fk.Parent != null)
                        {
                            table.ForeignKeys.Add(fk);
                            fk.Name = fk.Parent.Name;
                            Logger.TraceLine("{0}OK", msg);
                        }
                        else
                        {
                            Logger.TraceLine("{0}Ignored (parent table {1} was not imported)", msg, MetaInfoBase.MakeFullName(parentTableSchema, parentTableName));
                        }
                    }

                    if (fk.Child != null && fk.Parent != null)
                    {
                        MetaInfoColumnsMatch cm = new MetaInfoColumnsMatch();
                        cm.Child  = fk.Child.Columns.FindByPersistentName(row[SqlColName_ColumnName].ToString(), true);
                        cm.Parent = fk.Parent.Columns.FindByPersistentName(row[SqlColName_FKParentColumnName].ToString(), true);
                        fk.ColumnsMatches.Add(cm);
                    }
                    Logger.ProgressStep();
                }

                // Renaming duplicates in FK names
                foreach (MetaInfoForeignKey fk in table.ForeignKeys)
                {
                    int count = 1;
                    foreach (MetaInfoForeignKey fk2 in table.ForeignKeys)
                    {
                        if (fk != fk2 && fk.Name == fk2.Name)
                        {
                            fk2.Name = String.Format("{0}{1}", fk.Name, count++);
                        }
                    }
                }
            }
        }
Example #2
0
        public T FindByPersistentName(string schema, string name, bool throwException)
        {
            T o = null;

            persistentNames.TryGetValue(MetaInfoBase.MakeFullName(schema, name), out o);
            if (o == null && throwException)
            {
                throw new GlException("Item with persistent name not found: {0} ({1})", name, typeof(T).Name);
            }
            return(o);
        }