How incatswetrust/databasebackuputility works
Database Backup Utility is a .NET command-line tool for testing connections, listing backups, scheduling runs, and backing up or restoring MySQL, PostgreSQL, MongoDB, and SQLite. The principal workflow starts at the CLI, validates configuration, selects a database connection, then saves backup data and chain metadata; restore resolves a chain before applying it. The README documents cloud storage, compression, and notifications. Sampled Program code confirms CLI setup, connection-factory creation, and chain handling; many service implementations were not excerpted, so their detailed call paths are not asserted.
Main entry points: Program.cs CLI workflow · DatabaseConnectionFactory.cs Connection factory · PostgreSqlConnectionService.cs PostgreSQL operations · MySqlConnectionService.cs MySQL operations
Components 27
CLI and configuration
- CLI workflow
DatabaseBackupUtility/Program.cs - Command parser
DatabaseBackupUtility/Services/CommandLineParser.cs - Database config
DatabaseBackupUtility/Models/DatabaseConfig.cs - Database validation
DatabaseBackupUtility/Validator/DatabaseConfigValidator.cs - Storage validation
DatabaseBackupUtility/Validator/StorageConfigValidator.cs - Notification validation
DatabaseBackupUtility/Validator/NotificationConfigValidator.cs
Database operations
- Connection factory
DatabaseBackupUtility/Services/Fabric/DatabaseConnectionFactory.cs - MySQL operations
DatabaseBackupUtility/Services/MySqlConnectionService.cs - PostgreSQL operations
DatabaseBackupUtility/Services/PostgreSqlConnectionService.cs - MongoDB operations
DatabaseBackupUtility/Services/MongoDbConnectionService.cs - SQLite operations
DatabaseBackupUtility/Services/SqliteConnectionService.cs - MongoDB chain restore
DatabaseBackupUtility/Services/MongoDbRestoreService.cs
Backup chains
- Chain resolution
DatabaseBackupUtility/Services/BackupChainService.cs - Chain manifest
DatabaseBackupUtility/Models/BackupManifest.cs - Backup context
DatabaseBackupUtility/Models/BackupParent.cs - Backup types
DatabaseBackupUtility/Models/BackupType.cs
Storage and delivery
- Local storage
DatabaseBackupUtility/Services/LocalStorageService.cs - Cloud storage
DatabaseBackupUtility/Services/AwsS3StorageService.cs - Azure Blob storage
DatabaseBackupUtility/Services/AzureBlobStorageService.cs - Google Cloud storage
DatabaseBackupUtility/Services/GoogleCloudStorageService.cs
Supporting services
- Gzip compression
DatabaseBackupUtility/Services/CompressionService.cs - Notifications
DatabaseBackupUtility/Services/SlackNotificationService.cs - Null notifications
DatabaseBackupUtility/Services/NullNotificationService.cs - External process runner
DatabaseBackupUtility/Services/ProcessRunner.cs - SQL table filtering
DatabaseBackupUtility/Services/SqlDumpTableFilter.cs - WAL translation
DatabaseBackupUtility/Services/Wal2JsonTranslator.cs
Other components
- Operator
Connections 28
- Operator → CLI workflow: runs commands
- CLI workflow → Command parser: parses options
DatabaseBackupUtility/Program.cs - CLI workflow → Database validation: validates config
DatabaseBackupUtility/Program.cs - CLI workflow → Storage validation: validates storage
DatabaseBackupUtility/Program.cs - CLI workflow → Notification validation: validates notifications
DatabaseBackupUtility/Program.cs - CLI workflow → Connection factory: creates connection
DatabaseBackupUtility/Program.cs - Connection factory → MySQL operations: selects MySQL
DatabaseBackupUtility/Services/Fabric/DatabaseConnectionFactory.cs - Connection factory → PostgreSQL operations: selects PostgreSQL
DatabaseBackupUtility/Services/Fabric/DatabaseConnectionFactory.cs - Connection factory → MongoDB operations: selects MongoDB
DatabaseBackupUtility/Services/Fabric/DatabaseConnectionFactory.cs - Connection factory → SQLite operations: selects SQLite
DatabaseBackupUtility/Services/Fabric/DatabaseConnectionFactory.cs - CLI workflow → Chain resolution: resolves chains
DatabaseBackupUtility/Program.cs - CLI workflow → Local storage: stores backup files
- CLI workflow → Cloud storage: stores backup blobs
- CLI workflow → Azure Blob storage: stores backup blobs
- CLI workflow → Google Cloud storage: stores backup blobs
- CLI workflow → Gzip compression: compresses backups
DatabaseBackupUtility/Program.cs - CLI workflow → Notifications: sends completion alerts
DatabaseBackupUtility/Program.cs - CLI workflow → Null notifications: uses optional fallback
DatabaseBackupUtility/Program.cs - CLI workflow → MongoDB chain restore: applies restore chain
- Chain resolution → Chain manifest: reads chain records
DatabaseBackupUtility/Services/BackupChainService.cs - CLI workflow → Chain manifest: persists sidecars
DatabaseBackupUtility/Program.cs - MySQL operations → External process runner: runs database tools
DatabaseBackupUtility/Services/MySqlConnectionService.cs - PostgreSQL operations → External process runner: runs database tools
DatabaseBackupUtility/Services/PostgreSqlConnectionService.cs - MongoDB operations → External process runner: runs database tools
DatabaseBackupUtility/Services/MongoDbConnectionService.cs - MySQL operations → SQL table filtering: uses table filter
DatabaseBackupUtility/Services/MySqlConnectionService.cs - PostgreSQL operations → SQL table filtering: uses table filter
DatabaseBackupUtility/Services/PostgreSqlConnectionService.cs - PostgreSQL operations → WAL translation: translates WAL changes
DatabaseBackupUtility/Services/PostgreSqlConnectionService.cs - MongoDB operations → Backup context: uses chain checkpoint
DatabaseBackupUtility/Services/MongoDbConnectionService.cs