Пример #1
0
        public override int Run(string[] args)
        {
            SchemaImporter importer = null;

            switch (DatabaseType)
            {
            case "mssql":
            case "sqlserver":
                importer = new MSSqlSchemaImporter();
                break;
            }

            SchemaInfo schemaInfo = importer.GetSchemaFromDatabase(this);

            AutoDetectRelations(schemaInfo);
            schemaInfo.Resolve();
            RemoveReferencePrimaryKeys(schemaInfo);
            AutoDetectCollections(schemaInfo);

            DataSourceInfo dsi = new DataSourceInfo();

            dsi.Name           = "default";
            dsi.DataSourceType = "Sooda.Sql.SqlDataSource";
            schemaInfo.DataSources.Add(dsi);
            foreach (ClassInfo ci in schemaInfo.Classes)
            {
                int pkCount = 0;
                foreach (FieldInfo fi in ci.LocalTables[0].Fields)
                {
                    if (fi.IsPrimaryKey)
                    {
                        pkCount++;
                    }
                }
                if (pkCount == 0)
                {
                    Console.WriteLine("WARNING: Table {0} doesn't have a primary key.", ci.Name);
                }
            }
            XmlSerializer           ser = new XmlSerializer(typeof(SchemaInfo));
            XmlSerializerNamespaces ns  = new XmlSerializerNamespaces();

            ns.Add("", SchemaInfo.XmlNamespace);

            using (FileStream fs = File.Create(OutputFile))
            {
                ser.Serialize(fs, schemaInfo, ns);
            }

            return(0);
        }
        public override int Run(string[] args)
        {
            SchemaImporter importer = null;

            switch (DatabaseType)
            {
            case "mssql":
            case "sqlserver":
                importer = new MSSqlSchemaImporter();
                break;
            }

            SchemaInfo dbSchemaInfo = importer.GetSchemaFromDatabase(this);

            XmlSerializer ser = new XmlSerializer(typeof(SchemaInfo));

            SchemaInfo currentSchemaInfo;

            using (FileStream fs = File.OpenRead(SchemaFile))
            {
                currentSchemaInfo = (SchemaInfo)ser.Deserialize(fs);
            }

            if (UpdateTypes || UpdateSizes || UpdateNullable || UpdatePrimaryKeys)
            {
                foreach (ClassInfo ci in currentSchemaInfo.Classes)
                {
                    foreach (TableInfo ti in ci.LocalTables)
                    {
                        if (TableName == null || ti.DBTableName == TableName)
                        {
                            foreach (FieldInfo fi in ti.Fields)
                            {
                                UpdateFieldFromDbSchema(ti, fi, dbSchemaInfo);
                            }
                        }
                    }
                }
            }

            if (OutputSchemaFile == null)
            {
                string oldFile = Path.ChangeExtension(SchemaFile, ".old");
                if (File.Exists(oldFile))
                {
                    File.Delete(oldFile);
                }
                File.Move(SchemaFile, oldFile);
                using (FileStream fs = File.Create(SchemaFile))
                {
                    ser.Serialize(fs, currentSchemaInfo);
                }
            }
            else
            {
                using (FileStream fs = File.Create(OutputSchemaFile))
                {
                    ser.Serialize(fs, currentSchemaInfo);
                }
            }

            return(0);
        }