Ejemplo n.º 1
0
        /// <summary>
        /// Tries to get the latest database with a prefix 'backup'
        /// </summary>
        /// <param name="cstr">Connection string to the server from which the latest database is picked</param>
        /// <returns></returns>
        private async Task <string> GetLatestOnlineBackupDatabase(SqlConnectionStringBuilder cstr)
        {
            // Connect to the master database
            using (var connection = await cstr.ConnectToMaster())
            {
                // Get databases
                var databases = await GetDatabases(connection, DatabaseState.ONLINE);

                // Gather backups with matching prefix and order descending
                var ordered = from db in databases
                              let backupMeta = db.GetBackupMetadata()
                                               where backupMeta != null &&
                                               String.Equals(
                    ExportPrefix,
                    backupMeta.Prefix,
                    StringComparison.OrdinalIgnoreCase)
                                               orderby backupMeta.Timestamp descending
                                               select backupMeta;

                // Take the most recent one and check it's time
                var mostRecent = ordered.FirstOrDefault();
                if (mostRecent != null)
                {
                    return(mostRecent.Db.name);
                }
            }

            return(null);
        }
Ejemplo n.º 2
0
        private async Task <bool> DoesDBExist(SqlConnectionStringBuilder cstr, string name)
        {
            // Connect to the master database
            using (var connection = await cstr.ConnectToMaster())
            {
                var db = await GetDatabase(connection, name);

                return(db != null);
            }
        }
Ejemplo n.º 3
0
        private async Task CleanExports(SqlConnectionStringBuilder cstr, DateTime timestampUtc)
        {
            using (var connection = await cstr.ConnectToMaster())
            {
                // Get databases
                var databases = await GetDatabases(connection);

                // Delete matching DBs
                var toDelete = from d in databases
                               let backupMeta = d.GetBackupMetadata()
                                                where backupMeta != null &&
                                                String.Equals(
                    ExportPrefix,
                    backupMeta.Prefix,
                    StringComparison.OrdinalIgnoreCase) &&
                                                backupMeta.Timestamp.UtcDateTime <= timestampUtc
                                                select d;
                foreach (var db in toDelete)
                {
                    Log.DroppingDatabase(db.name);
                    await connection.ExecuteAsync("DROP DATABASE [" + db.name + "]");
                }
            }
        }