Beispiel #1
0
        public Lfx.Types.OperationResult Backup(BackupInfo backupInfo)
        {
            string WorkFolder = backupInfo.Name + System.IO.Path.DirectorySeparatorChar;

            Lfx.Environment.Folders.EnsurePathExists(this.BackupPath);

            if (!System.IO.Directory.Exists(Lfx.Environment.Folders.TemporaryFolder + WorkFolder))
            {
                System.IO.Directory.CreateDirectory(Lfx.Environment.Folders.TemporaryFolder + WorkFolder);
            }

            Lfx.Types.OperationProgress Progreso = new Lfx.Types.OperationProgress("Creando copia de seguridad", "Se está creando un volcado completo del almacén de datos en una carpeta, para resguardar.");
            Progreso.Modal     = true;
            Progreso.Advertise = true;
            Progreso.Begin();
            Progreso.Max = Lfx.Workspace.Master.Structure.Tables.Count + 1;

            Progreso.ChangeStatus("Exportando estructura");
            Progreso.ChangeStatus(Progreso.Value + 1);
            System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
            doc.AppendChild(Lfx.Workspace.Master.Structure.ToXml(doc));
            doc.Save(Lfx.Environment.Folders.TemporaryFolder + WorkFolder + "dbstruct.xml");

            BackupWriter Writer = new BackupWriter(Lfx.Environment.Folders.TemporaryFolder + WorkFolder + "dbdata.lbd");

            Writer.Write(":BKP");

            IList <string> TableList = Lfx.Data.DatabaseCache.DefaultCache.GetTableNames();

            foreach (string Tabla in TableList)
            {
                string NombreTabla = Tabla;
                if (Lfx.Workspace.Master.Structure.Tables.ContainsKey(Tabla))
                {
                    NombreTabla = Lfx.Workspace.Master.Structure.Tables[Tabla].Label;
                }

                Progreso.ChangeStatus("Volcando " + NombreTabla);
                Progreso.ChangeStatus(Progreso.Value + 1);
                ExportTableBin(Tabla, Writer);
            }
            Writer.Close();

            System.IO.FileStream Archivo = new System.IO.FileStream(Lfx.Environment.Folders.TemporaryFolder + WorkFolder + "info.txt", System.IO.FileMode.Append, System.IO.FileAccess.Write);
            using (System.IO.StreamWriter Escribidor = new System.IO.StreamWriter(Archivo, System.Text.Encoding.Default)) {
                Escribidor.WriteLine("Copia de seguridad de Lázaro");
                Escribidor.WriteLine("");
                Escribidor.WriteLine("Empresa=" + backupInfo.CompanyName);
                Escribidor.WriteLine("EspacioTrabajo=" + Lfx.Workspace.Master.Name);
                Escribidor.WriteLine("FechaYHora=" + System.DateTime.Now.ToString("dd-MM-yyyy") + " a las " + System.DateTime.Now.ToString("HH:mm:ss"));
                Escribidor.WriteLine("Usuario=" + backupInfo.UserName);
                Escribidor.WriteLine("Estación=" + Lfx.Environment.SystemInformation.MachineName);
                Escribidor.WriteLine("VersiónLazaro=" + backupInfo.ProgramVersion);
                Escribidor.WriteLine("");
                Escribidor.WriteLine("Por favor no modifique ni elimine este archivo.");
                Escribidor.Close();
                Archivo.Close();
            }

            if (Lfx.Workspace.Master.CurrentConfig.ReadGlobalSetting <int>("Sistema.ComprimirCopiasDeSeguridad", 0) != 0)
            {
                Progreso.ChangeStatus("Comprimiendo los datos");
                Lfx.FileFormats.Compression.Archive ArchivoComprimido = new Lfx.FileFormats.Compression.Archive(Lfx.Environment.Folders.TemporaryFolder + WorkFolder + "backup.7z");
                ArchivoComprimido.Add(Lfx.Environment.Folders.TemporaryFolder + WorkFolder + "*");
                if (System.IO.File.Exists(Lfx.Environment.Folders.TemporaryFolder + WorkFolder + "backup.7z"))
                {
                    Progreso.ChangeStatus("Eliminando archivos temporales");
                    // Borrar los archivos que acabo de comprimir
                    System.IO.DirectoryInfo Dir = new System.IO.DirectoryInfo(Lfx.Environment.Folders.TemporaryFolder + WorkFolder);
                    foreach (System.IO.FileInfo DirItem in Dir.GetFiles())
                    {
                        if (DirItem.Name != "backup.7z" && DirItem.Name != "info.txt")
                        {
                            System.IO.File.Delete(Lfx.Environment.Folders.TemporaryFolder + WorkFolder + DirItem.Name);
                        }
                    }
                }
            }

            Progreso.ChangeStatus("Almacenando");
            Progreso.ChangeStatus(Progreso.Value + 1);
            Lfx.Environment.Folders.MoveDirectory(Lfx.Environment.Folders.TemporaryFolder + WorkFolder, this.BackupPath + WorkFolder);

            int GuardarBackups = Lfx.Workspace.Master.CurrentConfig.ReadGlobalSetting <int>("Sisteam.Backup.CantMax", 14);

            if (GuardarBackups > 0)
            {
                List <BackupInfo> ListaDeBackups = this.GetBackups();
                if (ListaDeBackups.Count > GuardarBackups)
                {
                    Progreso.ChangeStatus("Eliminando copias de seguridad antiguas");
                    int BorrarBackups = ListaDeBackups.Count - GuardarBackups;
                    if (BorrarBackups < ListaDeBackups.Count)
                    {
                        for (int i = 1; i <= BorrarBackups; i++)
                        {
                            this.Delete(this.GetOldestBackupName());
                        }
                    }
                }
            }

            Progreso.End();

            return(new Lfx.Types.SuccessOperationResult());
        }
Beispiel #2
0
                public Lfx.Types.OperationResult Backup(BackupInfo backupInfo)
                {
                        string WorkFolder = backupInfo.Name + System.IO.Path.DirectorySeparatorChar;

                        Lfx.Environment.Folders.EnsurePathExists(this.BackupPath);

                        if (!System.IO.Directory.Exists(Lfx.Environment.Folders.TemporaryFolder + WorkFolder))
                                System.IO.Directory.CreateDirectory(Lfx.Environment.Folders.TemporaryFolder + WorkFolder);

                        Lfx.Types.OperationProgress Progreso = new Lfx.Types.OperationProgress("Creando copia de seguridad", "Se está creando un volcado completo del almacén de datos en una carpeta, para resguardar.");
                        Progreso.Modal = true;
                        Progreso.Advertise = true;
                        Progreso.Begin();
                        Progreso.Max = Lfx.Workspace.Master.Structure.Tables.Count + 1;

                        Progreso.ChangeStatus("Exportando estructura");
                        Progreso.ChangeStatus(Progreso.Value + 1);
                        System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
                        doc.AppendChild(Lfx.Workspace.Master.Structure.ToXml(doc));
                        doc.Save(Lfx.Environment.Folders.TemporaryFolder + WorkFolder + "dbstruct.xml");

                        BackupWriter Writer = new BackupWriter(Lfx.Environment.Folders.TemporaryFolder + WorkFolder + "dbdata.lbd");
                        Writer.Write(":BKP");

                        IList<string> TableList = Lfx.Data.DataBaseCache.DefaultCache.GetTableNames();
                        foreach (string Tabla in TableList) {
                                string NombreTabla = Tabla;
                                if (Lfx.Workspace.Master.Structure.Tables.ContainsKey(Tabla))
                                        NombreTabla = Lfx.Workspace.Master.Structure.Tables[Tabla].Label;

                                Progreso.ChangeStatus("Volcando " + NombreTabla);
                                Progreso.ChangeStatus(Progreso.Value + 1);
                                ExportTableBin(Tabla, Writer);

                        }
                        Writer.Close();

                        System.IO.FileStream Archivo = new System.IO.FileStream(Lfx.Environment.Folders.TemporaryFolder + WorkFolder + "info.txt", System.IO.FileMode.Append, System.IO.FileAccess.Write);
                        using (System.IO.StreamWriter Escribidor = new System.IO.StreamWriter(Archivo, System.Text.Encoding.Default)) {
                                Escribidor.WriteLine("Copia de seguridad de Lázaro");
                                Escribidor.WriteLine("");
                                Escribidor.WriteLine("Empresa=" + backupInfo.CompanyName);
                                Escribidor.WriteLine("EspacioTrabajo=" + Lfx.Workspace.Master.Name);
                                Escribidor.WriteLine("FechaYHora=" + System.DateTime.Now.ToString("dd-MM-yyyy") + " a las " + System.DateTime.Now.ToString("HH:mm:ss"));
                                Escribidor.WriteLine("Usuario=" + backupInfo.UserName);
                                Escribidor.WriteLine("Estación=" + Lfx.Environment.SystemInformation.MachineName);
                                Escribidor.WriteLine("VersiónLazaro=" + backupInfo.ProgramVersion);
                                Escribidor.WriteLine("");
                                Escribidor.WriteLine("Por favor no modifique ni elimine este archivo.");
                                Escribidor.Close();
                                Archivo.Close();
                        }

                        if (Lfx.Workspace.Master.CurrentConfig.ReadGlobalSetting<int>("Sistema.ComprimirCopiasDeSeguridad", 0) != 0) {
                                Progreso.ChangeStatus("Comprimiendo los datos");
                                Lfx.FileFormats.Compression.Archive ArchivoComprimido = new Lfx.FileFormats.Compression.Archive(Lfx.Environment.Folders.TemporaryFolder + WorkFolder + "backup.7z");
                                ArchivoComprimido.Add(Lfx.Environment.Folders.TemporaryFolder + WorkFolder + "*");
                                if (System.IO.File.Exists(Lfx.Environment.Folders.TemporaryFolder + WorkFolder + "backup.7z")) {
                                        Progreso.ChangeStatus("Eliminando archivos temporales");
                                        // Borrar los archivos que acabo de comprimir
                                        System.IO.DirectoryInfo Dir = new System.IO.DirectoryInfo(Lfx.Environment.Folders.TemporaryFolder + WorkFolder);
                                        foreach (System.IO.FileInfo DirItem in Dir.GetFiles()) {
                                                if (DirItem.Name != "backup.7z" && DirItem.Name != "info.txt") {
                                                        System.IO.File.Delete(Lfx.Environment.Folders.TemporaryFolder + WorkFolder + DirItem.Name);
                                                }
                                        }
                                }
                        }

                        Progreso.ChangeStatus("Almacenando");
                        Progreso.ChangeStatus(Progreso.Value + 1);
                        Lfx.Environment.Folders.MoveDirectory(Lfx.Environment.Folders.TemporaryFolder + WorkFolder, this.BackupPath + WorkFolder);

                        int GuardarBackups = Lfx.Workspace.Master.CurrentConfig.ReadGlobalSetting<int>("Sisteam.Backup.CantMax", 14);
                        if (GuardarBackups > 0) {
                                List<BackupInfo> ListaDeBackups = this.GetBackups();
                                if (ListaDeBackups.Count > GuardarBackups) {
                                        Progreso.ChangeStatus("Eliminando copias de seguridad antiguas");
                                        int BorrarBackups = ListaDeBackups.Count - GuardarBackups;
                                        if (BorrarBackups < ListaDeBackups.Count) {
                                                for (int i = 1; i <= BorrarBackups; i++) {
                                                        this.Delete(this.GetOldestBackupName());
                                                }
                                        }
                                }
                        }

                        Progreso.End();

                        return new Lfx.Types.SuccessOperationResult();
                }
Beispiel #3
0
        /// <summary>
        /// Exporta una tabla en un formato binario propietario, incluyendo BLOBs.
        /// </summary>
        public void ExportTableBin(string nombreTabla, BackupWriter writer)
        {
            qGen.Select           Comando     = new qGen.Select(nombreTabla);
            System.Data.DataTable TablaBackup = Lfx.Workspace.Master.MasterConnection.Select(Comando);

            bool EmitiTabla = false;

            string[] Fields = null;
            foreach (System.Data.DataRow RegistroBackup in TablaBackup.Rows)
            {
                if (EmitiTabla == false)
                {
                    Fields = new string[TablaBackup.Columns.Count];
                    for (int i = 0; i < TablaBackup.Columns.Count; i++)
                    {
                        Fields[i] = TablaBackup.Columns[i].ColumnName;
                    }
                    string FieldList = string.Join(",", Fields);
                    writer.Write(":TBL" + Comando.Tables[0].Name.Length.ToString("0000") + Comando.Tables[0].Name);
                    writer.Write(":FDL" + FieldList.Length.ToString("0000") + FieldList);
                    EmitiTabla = true;
                }
                writer.Write(":ROW");

                for (int i = 0; i < TablaBackup.Columns.Count; i++)
                {
                    object ValorOrigen     = RegistroBackup[Fields[i]];
                    string TipoCampoOrigen = ValorOrigen.GetType().ToString().Replace("System.", "");
                    string TipoCampoDestino;
                    switch (TipoCampoOrigen)
                    {
                    case "Byte[]":
                        TipoCampoDestino = "B";
                        break;

                    case "SByte":
                    case "Byte":
                    case "Int16":
                    case "Int32":
                    case "Int64":
                        ValorOrigen      = ValorOrigen.ToString();
                        TipoCampoDestino = "I";
                        break;

                    case "Single":
                    case "Double":
                        double ValDouble = System.Convert.ToDouble(ValorOrigen);
                        ValorOrigen      = ValDouble.ToString(System.Globalization.CultureInfo.InvariantCulture);
                        TipoCampoDestino = "N";
                        break;

                    case "Decimal":
                        decimal ValDecimal = System.Convert.ToDecimal(ValorOrigen);
                        ValorOrigen      = ValDecimal.ToString(System.Globalization.CultureInfo.InvariantCulture);
                        TipoCampoDestino = "N";
                        break;

                    case "DateTime":
                        ValorOrigen      = ((DateTime)ValorOrigen).ToString(Lfx.Types.Formatting.DateTime.SqlDateTimeFormat);
                        TipoCampoDestino = "D";
                        break;

                    case "String":
                        TipoCampoDestino = "S";
                        break;

                    case "DBNull":
                        TipoCampoDestino = "U";
                        ValorOrigen      = "";
                        break;

                    default:
                        TipoCampoDestino = "S";
                        ValorOrigen      = ValorOrigen.ToString();
                        break;
                    }

                    byte[] ValorDestino;

                    if (ValorOrigen is byte[])
                    {
                        ValorDestino = (byte[])ValorOrigen;
                    }
                    else if (ValorOrigen is string)
                    {
                        ValorDestino = System.Text.Encoding.UTF8.GetBytes((string)ValorOrigen);
                    }
                    else
                    {
                        throw new NotImplementedException();
                    }

                    writer.Write(":FLD" + TipoCampoDestino + ValorDestino.Length.ToString("00000000"));
                    if (ValorDestino.Length > 0)
                    {
                        writer.Write(ValorDestino);
                    }
                }
                writer.Write(".ROW");
                //writer.Write(":REM0002" + Lfx.Types.ControlChars.CrLf);
            }

            writer.Write(".TBL");
        }
Beispiel #4
0
                /// <summary>
                /// Exporta una tabla en un formato binario propietario, incluyendo BLOBs.
                /// </summary>
                public void ExportTableBin(string nombreTabla, BackupWriter writer)
                {
                        qGen.Select Comando = new qGen.Select(nombreTabla);
                        System.Data.DataTable TablaBackup = Lfx.Workspace.Master.MasterConnection.Select(Comando);

                        bool EmitiTabla = false;
                        string[] Fields = null;
                        foreach (System.Data.DataRow RegistroBackup in TablaBackup.Rows) {
                                if (EmitiTabla == false) {
                                        Fields = new string[TablaBackup.Columns.Count];
                                        for (int i = 0; i < TablaBackup.Columns.Count; i++) {
                                                Fields[i] = TablaBackup.Columns[i].ColumnName;
                                        }
                                        string FieldList = string.Join(",", Fields);
                                        writer.Write(":TBL" + Comando.Tables.Length.ToString("0000") + Comando.Tables);
                                        writer.Write(":FDL" + FieldList.Length.ToString("0000") + FieldList);
                                        EmitiTabla = true;
                                }
                                writer.Write(":ROW");

                                for (int i = 0; i < TablaBackup.Columns.Count; i++) {
                                        object ValorOrigen = RegistroBackup[Fields[i]];
                                        string TipoCampoOrigen = ValorOrigen.GetType().ToString().Replace("System.", "");
                                        string TipoCampoDestino;
                                        switch (TipoCampoOrigen) {
                                                case "Byte[]":
                                                        TipoCampoDestino = "B";
                                                        break;
                                                case "SByte":
                                                case "Byte":
                                                case "Int16":
                                                case "Int32":
                                                case "Int64":
                                                        ValorOrigen = ValorOrigen.ToString();
                                                        TipoCampoDestino = "I";
                                                        break;
                                                case "Single":
                                                case "Double":
                                                        double ValDouble = System.Convert.ToDouble(ValorOrigen);
                                                        ValorOrigen = ValDouble.ToString(System.Globalization.CultureInfo.InvariantCulture);
                                                        TipoCampoDestino = "N";
                                                        break;
                                                case "Decimal":
                                                        decimal ValDecimal = System.Convert.ToDecimal(ValorOrigen);
                                                        ValorOrigen = ValDecimal.ToString(System.Globalization.CultureInfo.InvariantCulture);
                                                        TipoCampoDestino = "N";
                                                        break;
                                                case "DateTime":
                                                        ValorOrigen = ((DateTime)ValorOrigen).ToString(Lfx.Types.Formatting.DateTime.SqlDateTimeFormat);
                                                        TipoCampoDestino = "D";
                                                        break;
                                                case "String":
                                                        TipoCampoDestino = "S";
                                                        break;
                                                case "DBNull":
                                                        TipoCampoDestino = "U";
                                                        ValorOrigen = "";
                                                        break;
                                                default:
                                                        TipoCampoDestino = "S";
                                                        ValorOrigen = ValorOrigen.ToString();
                                                        break;
                                        }

                                        byte[] ValorDestino;

                                        if (ValorOrigen is byte[])
                                                ValorDestino = (byte[])ValorOrigen;
                                        else if (ValorOrigen is string)
                                                ValorDestino = System.Text.Encoding.UTF8.GetBytes((string)ValorOrigen);
                                        else
                                                throw new NotImplementedException();

                                        writer.Write(":FLD" + TipoCampoDestino + ValorDestino.Length.ToString("00000000"));
                                        if (ValorDestino.Length > 0)
                                                writer.Write(ValorDestino);
                                }
                                writer.Write(".ROW");
                                //writer.Write(":REM0002" + Lfx.Types.ControlChars.CrLf);
                        }

                        writer.Write(".TBL");
                }