import 'package:test/test.dart'; import 'package:mockito/mockito.dart'; import 'package:dart_appwrite/models.dart' as models; import 'package:dart_appwrite/enums.dart' as enums; import 'package:dart_appwrite/src/enums.dart'; import 'package:dart_appwrite/src/response.dart'; import 'dart:typed_data'; import 'package:dart_appwrite/dart_appwrite.dart'; class MockClient extends Mock implements Client { Map config = {'project': 'testproject'}; String endPoint = 'https://localhost/v1'; @override Future call( HttpMethod? method, { String? path = '', Map? headers = const {}, Map? params = const {}, ResponseType? responseType, }) async { return super.noSuchMethod( Invocation.method(#call, [method], { #path: path, #headers: headers, #params: params, #responseType: responseType, }), returnValue: Response(), ); } @override Future webAuth(Uri? url) async { return super.noSuchMethod( Invocation.method(#webAuth, [url]), returnValue: 'done', ); } @override Future chunkedUpload({ String? path, Map? params, String? paramName, String? idParamName, Map? headers, Function(UploadProgress)? onProgress, ResponseType? responseType, HttpMethod? method = HttpMethod.post, }) async { return super.noSuchMethod( Invocation.method(#chunkedUpload, [], { #path: path, #params: params, #paramName: paramName, #idParamName: idParamName, #headers: headers, #method: method, }), returnValue: Response(data: {}), ); } } void main() { group('Postgresql test', () { late MockClient client; late Postgresql postgresql; setUp(() { client = MockClient(); postgresql = Postgresql(client); }); test('test method list()', () async { final Map data = { 'total': 5, 'databases': [], }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.list( queries: [], total: false, ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "queries": isA(), "total": false, }); expect(response, isA()); }); test('test method create()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", '\$updatedAt': "2020-10-15T06:38:00.000+00:00", 'projectId': "5e5ea5c16897e", 'name': "My Production Database", 'version': "16", 'specification': "s-2vcpu-2gb", 'backend': "edge", 'hostname': "db-myproject-mydb.fra.appwrite.center", 'connectionUser': "appwrite_user", 'connectionPassword': "••••••••", 'connectionString': "postgresql://user:pass@db-myproject-mydb.fra.appwrite.center:5432/postgres?sslmode=require", 'ssl': true, 'status': "ready", 'containerStatus': "active", 'lifecycleState': "active", 'idleTimeoutMinutes': 15, 'cpu': 2000, 'memory': 4096, 'storage': 100, 'storageStatus': "resizing", 'storageTargetGb': 120, 'storageClass': "ssd", 'storageMaxGb': 100, 'nodePool': "db-pool-4vcpu-8gb", 'replicas': 2, 'syncMode': "async", 'networkMaxConnections': 500, 'networkIdleTimeoutSeconds': 900, 'networkIPAllowlist': [], 'backupEnabled': true, 'pitr': true, 'pitrRetentionDays': 14, 'storageAutoscaling': true, 'storageAutoscalingThresholdPercent': 85, 'storageAutoscalingMaxGb': 30, 'maintenanceWindowDay': "sun", 'maintenanceWindowHourUtc': 3, 'metricsEnabled': true, 'sqlApiEnabled': true, 'sqlApiAllowedStatements': [], 'sqlApiMaxRows': 10000, 'sqlApiMaxBytes': 10485760, 'sqlApiTimeoutSeconds': 30, 'error': "", }; when( client.call( HttpMethod.post, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.create( databaseId: "", name: "", version: "17", specification: "", replicas: 1, syncMode: "async", networkIdleTimeoutSeconds: 1, networkIPAllowlist: [], idleTimeoutMinutes: 1, pitr: false, pitrRetentionDays: 1, storageAutoscaling: false, storageAutoscalingThresholdPercent: 1, storageAutoscalingMaxGb: 1, ); final Map params = verify( client.call( HttpMethod.post, path: "/postgresql", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "databaseId": "", "name": "", "version": "17", "specification": "", "replicas": 1, "syncMode": "async", "networkIdleTimeoutSeconds": 1, "networkIPAllowlist": isA(), "idleTimeoutMinutes": 1, "pitr": false, "pitrRetentionDays": 1, "storageAutoscaling": false, "storageAutoscalingThresholdPercent": 1, "storageAutoscalingMaxGb": 1, }); expect(response, isA()); }); test('test method listSpecifications()', () async { final Map data = { 'specifications': [], 'total': 9, }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.listSpecifications(); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/specifications", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method get()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", '\$updatedAt': "2020-10-15T06:38:00.000+00:00", 'projectId': "5e5ea5c16897e", 'name': "My Production Database", 'version': "16", 'specification': "s-2vcpu-2gb", 'backend': "edge", 'hostname': "db-myproject-mydb.fra.appwrite.center", 'connectionUser': "appwrite_user", 'connectionPassword': "••••••••", 'connectionString': "postgresql://user:pass@db-myproject-mydb.fra.appwrite.center:5432/postgres?sslmode=require", 'ssl': true, 'status': "ready", 'containerStatus': "active", 'lifecycleState': "active", 'idleTimeoutMinutes': 15, 'cpu': 2000, 'memory': 4096, 'storage': 100, 'storageStatus': "resizing", 'storageTargetGb': 120, 'storageClass': "ssd", 'storageMaxGb': 100, 'nodePool': "db-pool-4vcpu-8gb", 'replicas': 2, 'syncMode': "async", 'networkMaxConnections': 500, 'networkIdleTimeoutSeconds': 900, 'networkIPAllowlist': [], 'backupEnabled': true, 'pitr': true, 'pitrRetentionDays': 14, 'storageAutoscaling': true, 'storageAutoscalingThresholdPercent': 85, 'storageAutoscalingMaxGb': 30, 'maintenanceWindowDay': "sun", 'maintenanceWindowHourUtc': 3, 'metricsEnabled': true, 'sqlApiEnabled': true, 'sqlApiAllowedStatements': [], 'sqlApiMaxRows': 10000, 'sqlApiMaxBytes': 10485760, 'sqlApiTimeoutSeconds': 30, 'error': "", }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.get( databaseId: "", ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/%3CDATABASE_ID%3E", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method update()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", '\$updatedAt': "2020-10-15T06:38:00.000+00:00", 'projectId': "5e5ea5c16897e", 'name': "My Production Database", 'version': "16", 'specification': "s-2vcpu-2gb", 'backend': "edge", 'hostname': "db-myproject-mydb.fra.appwrite.center", 'connectionUser': "appwrite_user", 'connectionPassword': "••••••••", 'connectionString': "postgresql://user:pass@db-myproject-mydb.fra.appwrite.center:5432/postgres?sslmode=require", 'ssl': true, 'status': "ready", 'containerStatus': "active", 'lifecycleState': "active", 'idleTimeoutMinutes': 15, 'cpu': 2000, 'memory': 4096, 'storage': 100, 'storageStatus': "resizing", 'storageTargetGb': 120, 'storageClass': "ssd", 'storageMaxGb': 100, 'nodePool': "db-pool-4vcpu-8gb", 'replicas': 2, 'syncMode': "async", 'networkMaxConnections': 500, 'networkIdleTimeoutSeconds': 900, 'networkIPAllowlist': [], 'backupEnabled': true, 'pitr': true, 'pitrRetentionDays': 14, 'storageAutoscaling': true, 'storageAutoscalingThresholdPercent': 85, 'storageAutoscalingMaxGb': 30, 'maintenanceWindowDay': "sun", 'maintenanceWindowHourUtc': 3, 'metricsEnabled': true, 'sqlApiEnabled': true, 'sqlApiAllowedStatements': [], 'sqlApiMaxRows': 10000, 'sqlApiMaxBytes': 10485760, 'sqlApiTimeoutSeconds': 30, 'error': "", }; when( client.call( HttpMethod.patch, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.update( databaseId: "", name: "", status: "ready", specification: "", replicas: 1, syncMode: "async", networkIdleTimeoutSeconds: 1, networkIPAllowlist: [], idleTimeoutMinutes: 1, pitr: false, pitrRetentionDays: 1, storageAutoscaling: false, storageAutoscalingThresholdPercent: 1, storageAutoscalingMaxGb: 1, metricsTraceSampleRate: 1.0, metricsSlowQueryLogThresholdMs: 1, sqlApiEnabled: false, sqlApiAllowedStatements: [], sqlApiMaxRows: 1, sqlApiMaxBytes: 1, sqlApiTimeoutSeconds: 1, ); final Map params = verify( client.call( HttpMethod.patch, path: "/postgresql/%3CDATABASE_ID%3E", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "name": "", "status": "ready", "specification": "", "replicas": 1, "syncMode": "async", "networkIdleTimeoutSeconds": 1, "networkIPAllowlist": isA(), "idleTimeoutMinutes": 1, "pitr": false, "pitrRetentionDays": 1, "storageAutoscaling": false, "storageAutoscalingThresholdPercent": 1, "storageAutoscalingMaxGb": 1, "metricsTraceSampleRate": 1.0, "metricsSlowQueryLogThresholdMs": 1, "sqlApiEnabled": false, "sqlApiAllowedStatements": isA(), "sqlApiMaxRows": 1, "sqlApiMaxBytes": 1, "sqlApiTimeoutSeconds": 1, }); expect(response, isA()); }); test('test method delete()', () async { final data = ''; when( client.call( HttpMethod.delete, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.delete( databaseId: "", ); final Map params = verify( client.call( HttpMethod.delete, path: "/postgresql/%3CDATABASE_ID%3E", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); }); test('test method listBackups()', () async { final Map data = { 'total': 5, 'backups': [], }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.listBackups( databaseId: "", queries: [], total: false, ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/%3CDATABASE_ID%3E/backups", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "queries": isA(), "total": false, }); expect(response, isA()); }); test('test method createBackup()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", 'databaseId': "5e5ea5c16897e", 'projectId': "5e5ea5c16897e", 'policyId': "5e5ea5c16897e", 'trigger': "schedule", 'type': "full", 'requestedType': "incremental", 'fallbackReason': "PostgreSQL incremental backups are not offered because they cannot be restored: archived WAL is physical and cannot replay onto a logically-restored base. A full backup was taken instead; use a point-in-time restore (targetTime) to recover to a moment between fulls.", 'status': "completed", 'sizeBytes': 1073741824, 'error': "", }; when( client.call( HttpMethod.post, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.createBackup( databaseId: "", type: "full", ); final Map params = verify( client.call( HttpMethod.post, path: "/postgresql/%3CDATABASE_ID%3E/backups", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "type": "full", }); expect(response, isA()); }); test('test method listBackupPolicies()', () async { final Map data = { 'total': 5, 'policies': [], }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.listBackupPolicies( databaseId: "", queries: [], total: false, ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/%3CDATABASE_ID%3E/backups/policies", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "queries": isA(), "total": false, }); expect(response, isA()); }); test('test method createBackupPolicy()', () async { final Map data = { '\$id': "5e5ea5c16897e", 'name': "Hourly backups", '\$createdAt': "2020-10-15T06:38:00.000+00:00", '\$updatedAt': "2020-10-15T06:38:00.000+00:00", 'services': [], 'resources': [], 'retention': 7, 'schedule': "0 * * * *", 'type': "full", 'enabled': true, }; when( client.call( HttpMethod.post, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.createBackupPolicy( databaseId: "", policyId: "", name: "", schedule: "schedule", retention: 1, type: "full", enabled: false, ); final Map params = verify( client.call( HttpMethod.post, path: "/postgresql/%3CDATABASE_ID%3E/backups/policies", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "policyId": "", "name": "", "schedule": "schedule", "retention": 1, "type": "full", "enabled": false, }); expect(response, isA()); }); test('test method getBackupPolicy()', () async { final Map data = { '\$id': "5e5ea5c16897e", 'name': "Hourly backups", '\$createdAt': "2020-10-15T06:38:00.000+00:00", '\$updatedAt': "2020-10-15T06:38:00.000+00:00", 'services': [], 'resources': [], 'retention': 7, 'schedule': "0 * * * *", 'type': "full", 'enabled': true, }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.getBackupPolicy( databaseId: "", policyId: "", ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/%3CDATABASE_ID%3E/backups/policies/%3CPOLICY_ID%3E", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method updateBackupPolicy()', () async { final Map data = { '\$id': "5e5ea5c16897e", 'name': "Hourly backups", '\$createdAt': "2020-10-15T06:38:00.000+00:00", '\$updatedAt': "2020-10-15T06:38:00.000+00:00", 'services': [], 'resources': [], 'retention': 7, 'schedule': "0 * * * *", 'type': "full", 'enabled': true, }; when( client.call( HttpMethod.patch, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.updateBackupPolicy( databaseId: "", policyId: "", name: "", schedule: "schedule", retention: 1, enabled: false, ); final Map params = verify( client.call( HttpMethod.patch, path: "/postgresql/%3CDATABASE_ID%3E/backups/policies/%3CPOLICY_ID%3E", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "name": "", "schedule": "schedule", "retention": 1, "enabled": false, }); expect(response, isA()); }); test('test method deleteBackupPolicy()', () async { final data = ''; when( client.call( HttpMethod.delete, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.deleteBackupPolicy( databaseId: "", policyId: "", ); final Map params = verify( client.call( HttpMethod.delete, path: "/postgresql/%3CDATABASE_ID%3E/backups/policies/%3CPOLICY_ID%3E", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); }); test('test method updateBackupStorage()', () async { final Map data = { 'provider': "s3", 'bucket': "my-backup-bucket", 'region': "us-east-1", 'prefix': "backups/", 'endpoint': "https://minio.example.com", }; when( client.call( HttpMethod.put, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.updateBackupStorage( databaseId: "", provider: "s3", bucket: "", accessKey: "", secretKey: "", region: "", prefix: "", endpoint: "https://example.com", ); final Map params = verify( client.call( HttpMethod.put, path: "/postgresql/%3CDATABASE_ID%3E/backups/storage", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "provider": "s3", "bucket": "", "region": "", "prefix": "", "endpoint": "https://example.com", "accessKey": "", "secretKey": "", }); expect(response, isA()); }); test('test method getBackup()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", 'databaseId': "5e5ea5c16897e", 'projectId': "5e5ea5c16897e", 'policyId': "5e5ea5c16897e", 'trigger': "schedule", 'type': "full", 'requestedType': "incremental", 'fallbackReason': "PostgreSQL incremental backups are not offered because they cannot be restored: archived WAL is physical and cannot replay onto a logically-restored base. A full backup was taken instead; use a point-in-time restore (targetTime) to recover to a moment between fulls.", 'status': "completed", 'sizeBytes': 1073741824, 'error': "", }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.getBackup( databaseId: "", backupId: "", ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/%3CDATABASE_ID%3E/backups/%3CBACKUP_ID%3E", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method deleteBackup()', () async { final data = ''; when( client.call( HttpMethod.delete, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.deleteBackup( databaseId: "", backupId: "", ); final Map params = verify( client.call( HttpMethod.delete, path: "/postgresql/%3CDATABASE_ID%3E/backups/%3CBACKUP_ID%3E", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); }); test('test method listBranches()', () async { final Map data = { 'total': 2, 'branches': [], }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.listBranches( databaseId: "", ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/%3CDATABASE_ID%3E/branches", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method createBranch()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", '\$updatedAt': "2020-10-15T06:38:00.000+00:00", 'projectId': "5e5ea5c16897e", 'name': "My Production Database", 'version': "16", 'specification': "s-2vcpu-2gb", 'backend': "edge", 'hostname': "db-myproject-mydb.fra.appwrite.center", 'connectionUser': "appwrite_user", 'connectionPassword': "••••••••", 'connectionString': "postgresql://user:pass@db-myproject-mydb.fra.appwrite.center:5432/postgres?sslmode=require", 'ssl': true, 'status': "ready", 'containerStatus': "active", 'lifecycleState': "active", 'idleTimeoutMinutes': 15, 'cpu': 2000, 'memory': 4096, 'storage': 100, 'storageStatus': "resizing", 'storageTargetGb': 120, 'storageClass': "ssd", 'storageMaxGb': 100, 'nodePool': "db-pool-4vcpu-8gb", 'replicas': 2, 'syncMode': "async", 'networkMaxConnections': 500, 'networkIdleTimeoutSeconds': 900, 'networkIPAllowlist': [], 'backupEnabled': true, 'pitr': true, 'pitrRetentionDays': 14, 'storageAutoscaling': true, 'storageAutoscalingThresholdPercent': 85, 'storageAutoscalingMaxGb': 30, 'maintenanceWindowDay': "sun", 'maintenanceWindowHourUtc': 3, 'metricsEnabled': true, 'sqlApiEnabled': true, 'sqlApiAllowedStatements': [], 'sqlApiMaxRows': 10000, 'sqlApiMaxBytes': 10485760, 'sqlApiTimeoutSeconds': 30, 'error': "", }; when( client.call( HttpMethod.post, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.createBranch( databaseId: "", branchId: "", ttl: 1, ); final Map params = verify( client.call( HttpMethod.post, path: "/postgresql/%3CDATABASE_ID%3E/branches", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "branchId": "", "ttl": 1, }); expect(response, isA()); }); test('test method deleteBranch()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", '\$updatedAt': "2020-10-15T06:38:00.000+00:00", 'projectId': "5e5ea5c16897e", 'name': "My Production Database", 'version': "16", 'specification': "s-2vcpu-2gb", 'backend': "edge", 'hostname': "db-myproject-mydb.fra.appwrite.center", 'connectionUser': "appwrite_user", 'connectionPassword': "••••••••", 'connectionString': "postgresql://user:pass@db-myproject-mydb.fra.appwrite.center:5432/postgres?sslmode=require", 'ssl': true, 'status': "ready", 'containerStatus': "active", 'lifecycleState': "active", 'idleTimeoutMinutes': 15, 'cpu': 2000, 'memory': 4096, 'storage': 100, 'storageStatus': "resizing", 'storageTargetGb': 120, 'storageClass': "ssd", 'storageMaxGb': 100, 'nodePool': "db-pool-4vcpu-8gb", 'replicas': 2, 'syncMode': "async", 'networkMaxConnections': 500, 'networkIdleTimeoutSeconds': 900, 'networkIPAllowlist': [], 'backupEnabled': true, 'pitr': true, 'pitrRetentionDays': 14, 'storageAutoscaling': true, 'storageAutoscalingThresholdPercent': 85, 'storageAutoscalingMaxGb': 30, 'maintenanceWindowDay': "sun", 'maintenanceWindowHourUtc': 3, 'metricsEnabled': true, 'sqlApiEnabled': true, 'sqlApiAllowedStatements': [], 'sqlApiMaxRows': 10000, 'sqlApiMaxBytes': 10485760, 'sqlApiTimeoutSeconds': 30, 'error': "", }; when( client.call( HttpMethod.delete, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.deleteBranch( databaseId: "", branchId: "", ); final Map params = verify( client.call( HttpMethod.delete, path: "/postgresql/%3CDATABASE_ID%3E/branches/%3CBRANCH_ID%3E", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method updateCredentials()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", 'databaseId': "5e5ea5c16897e", 'type': "update", 'status': "completed", 'attempts': 1, 'errorCode': "Interrupted", 'errorMessage': "", }; when( client.call( HttpMethod.patch, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.updateCredentials( databaseId: "", ); final Map params = verify( client.call( HttpMethod.patch, path: "/postgresql/%3CDATABASE_ID%3E/credentials", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method createExecution()', () async { final Map data = { 'rows': [], 'rowCount': 1, 'columns': [], 'durationMs': 12, 'truncated': true, 'bytes': 1024, }; when( client.call( HttpMethod.post, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.createExecution( databaseId: "", sql: "", bindings: {}, timeoutSeconds: 1, ); final Map params = verify( client.call( HttpMethod.post, path: "/postgresql/%3CDATABASE_ID%3E/executions", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "sql": "", "bindings": isA(), "timeoutSeconds": 1, }); expect(response, isA()); }); test('test method listExtensions()', () async { final Map data = { 'installed': [], 'available': [], 'metadata': [], }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.listExtensions( databaseId: "", ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/%3CDATABASE_ID%3E/extensions", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method createExtension()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", '\$updatedAt': "2020-10-15T06:38:00.000+00:00", 'projectId': "5e5ea5c16897e", 'name': "My Production Database", 'version': "16", 'specification': "s-2vcpu-2gb", 'backend': "edge", 'hostname': "db-myproject-mydb.fra.appwrite.center", 'connectionUser': "appwrite_user", 'connectionPassword': "••••••••", 'connectionString': "postgresql://user:pass@db-myproject-mydb.fra.appwrite.center:5432/postgres?sslmode=require", 'ssl': true, 'status': "ready", 'containerStatus': "active", 'lifecycleState': "active", 'idleTimeoutMinutes': 15, 'cpu': 2000, 'memory': 4096, 'storage': 100, 'storageStatus': "resizing", 'storageTargetGb': 120, 'storageClass': "ssd", 'storageMaxGb': 100, 'nodePool': "db-pool-4vcpu-8gb", 'replicas': 2, 'syncMode': "async", 'networkMaxConnections': 500, 'networkIdleTimeoutSeconds': 900, 'networkIPAllowlist': [], 'backupEnabled': true, 'pitr': true, 'pitrRetentionDays': 14, 'storageAutoscaling': true, 'storageAutoscalingThresholdPercent': 85, 'storageAutoscalingMaxGb': 30, 'maintenanceWindowDay': "sun", 'maintenanceWindowHourUtc': 3, 'metricsEnabled': true, 'sqlApiEnabled': true, 'sqlApiAllowedStatements': [], 'sqlApiMaxRows': 10000, 'sqlApiMaxBytes': 10485760, 'sqlApiTimeoutSeconds': 30, 'error': "", }; when( client.call( HttpMethod.post, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.createExtension( databaseId: "", name: "", ); final Map params = verify( client.call( HttpMethod.post, path: "/postgresql/%3CDATABASE_ID%3E/extensions", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "name": "", }); expect(response, isA()); }); test('test method deleteExtension()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", '\$updatedAt': "2020-10-15T06:38:00.000+00:00", 'projectId': "5e5ea5c16897e", 'name': "My Production Database", 'version': "16", 'specification': "s-2vcpu-2gb", 'backend': "edge", 'hostname': "db-myproject-mydb.fra.appwrite.center", 'connectionUser': "appwrite_user", 'connectionPassword': "••••••••", 'connectionString': "postgresql://user:pass@db-myproject-mydb.fra.appwrite.center:5432/postgres?sslmode=require", 'ssl': true, 'status': "ready", 'containerStatus': "active", 'lifecycleState': "active", 'idleTimeoutMinutes': 15, 'cpu': 2000, 'memory': 4096, 'storage': 100, 'storageStatus': "resizing", 'storageTargetGb': 120, 'storageClass': "ssd", 'storageMaxGb': 100, 'nodePool': "db-pool-4vcpu-8gb", 'replicas': 2, 'syncMode': "async", 'networkMaxConnections': 500, 'networkIdleTimeoutSeconds': 900, 'networkIPAllowlist': [], 'backupEnabled': true, 'pitr': true, 'pitrRetentionDays': 14, 'storageAutoscaling': true, 'storageAutoscalingThresholdPercent': 85, 'storageAutoscalingMaxGb': 30, 'maintenanceWindowDay': "sun", 'maintenanceWindowHourUtc': 3, 'metricsEnabled': true, 'sqlApiEnabled': true, 'sqlApiAllowedStatements': [], 'sqlApiMaxRows': 10000, 'sqlApiMaxBytes': 10485760, 'sqlApiTimeoutSeconds': 30, 'error': "", }; when( client.call( HttpMethod.delete, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.deleteExtension( databaseId: "", extensionName: "", ); final Map params = verify( client.call( HttpMethod.delete, path: "/postgresql/%3CDATABASE_ID%3E/extensions/%3CEXTENSION_NAME%3E", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method createFailover()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", '\$updatedAt': "2020-10-15T06:38:00.000+00:00", 'projectId': "5e5ea5c16897e", 'name': "My Production Database", 'version': "16", 'specification': "s-2vcpu-2gb", 'backend': "edge", 'hostname': "db-myproject-mydb.fra.appwrite.center", 'connectionUser': "appwrite_user", 'connectionPassword': "••••••••", 'connectionString': "postgresql://user:pass@db-myproject-mydb.fra.appwrite.center:5432/postgres?sslmode=require", 'ssl': true, 'status': "ready", 'containerStatus': "active", 'lifecycleState': "active", 'idleTimeoutMinutes': 15, 'cpu': 2000, 'memory': 4096, 'storage': 100, 'storageStatus': "resizing", 'storageTargetGb': 120, 'storageClass': "ssd", 'storageMaxGb': 100, 'nodePool': "db-pool-4vcpu-8gb", 'replicas': 2, 'syncMode': "async", 'networkMaxConnections': 500, 'networkIdleTimeoutSeconds': 900, 'networkIPAllowlist': [], 'backupEnabled': true, 'pitr': true, 'pitrRetentionDays': 14, 'storageAutoscaling': true, 'storageAutoscalingThresholdPercent': 85, 'storageAutoscalingMaxGb': 30, 'maintenanceWindowDay': "sun", 'maintenanceWindowHourUtc': 3, 'metricsEnabled': true, 'sqlApiEnabled': true, 'sqlApiAllowedStatements': [], 'sqlApiMaxRows': 10000, 'sqlApiMaxBytes': 10485760, 'sqlApiTimeoutSeconds': 30, 'error': "", }; when( client.call( HttpMethod.post, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.createFailover( databaseId: "", targetReplicaId: "", ); final Map params = verify( client.call( HttpMethod.post, path: "/postgresql/%3CDATABASE_ID%3E/failovers", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "targetReplicaId": "", }); expect(response, isA()); }); test('test method updateMaintenance()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", '\$updatedAt': "2020-10-15T06:38:00.000+00:00", 'projectId': "5e5ea5c16897e", 'name': "My Production Database", 'version': "16", 'specification': "s-2vcpu-2gb", 'backend': "edge", 'hostname': "db-myproject-mydb.fra.appwrite.center", 'connectionUser': "appwrite_user", 'connectionPassword': "••••••••", 'connectionString': "postgresql://user:pass@db-myproject-mydb.fra.appwrite.center:5432/postgres?sslmode=require", 'ssl': true, 'status': "ready", 'containerStatus': "active", 'lifecycleState': "active", 'idleTimeoutMinutes': 15, 'cpu': 2000, 'memory': 4096, 'storage': 100, 'storageStatus': "resizing", 'storageTargetGb': 120, 'storageClass': "ssd", 'storageMaxGb': 100, 'nodePool': "db-pool-4vcpu-8gb", 'replicas': 2, 'syncMode': "async", 'networkMaxConnections': 500, 'networkIdleTimeoutSeconds': 900, 'networkIPAllowlist': [], 'backupEnabled': true, 'pitr': true, 'pitrRetentionDays': 14, 'storageAutoscaling': true, 'storageAutoscalingThresholdPercent': 85, 'storageAutoscalingMaxGb': 30, 'maintenanceWindowDay': "sun", 'maintenanceWindowHourUtc': 3, 'metricsEnabled': true, 'sqlApiEnabled': true, 'sqlApiAllowedStatements': [], 'sqlApiMaxRows': 10000, 'sqlApiMaxBytes': 10485760, 'sqlApiTimeoutSeconds': 30, 'error': "", }; when( client.call( HttpMethod.patch, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.updateMaintenance( databaseId: "", day: "sun", hourUtc: 1, ); final Map params = verify( client.call( HttpMethod.patch, path: "/postgresql/%3CDATABASE_ID%3E/maintenance", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "day": "sun", "hourUtc": 1, }); expect(response, isA()); }); test('test method createMigration()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", '\$updatedAt': "2020-10-15T06:38:00.000+00:00", 'projectId': "5e5ea5c16897e", 'name': "My Production Database", 'version': "16", 'specification': "s-2vcpu-2gb", 'backend': "edge", 'hostname': "db-myproject-mydb.fra.appwrite.center", 'connectionUser': "appwrite_user", 'connectionPassword': "••••••••", 'connectionString': "postgresql://user:pass@db-myproject-mydb.fra.appwrite.center:5432/postgres?sslmode=require", 'ssl': true, 'status': "ready", 'containerStatus': "active", 'lifecycleState': "active", 'idleTimeoutMinutes': 15, 'cpu': 2000, 'memory': 4096, 'storage': 100, 'storageStatus': "resizing", 'storageTargetGb': 120, 'storageClass': "ssd", 'storageMaxGb': 100, 'nodePool': "db-pool-4vcpu-8gb", 'replicas': 2, 'syncMode': "async", 'networkMaxConnections': 500, 'networkIdleTimeoutSeconds': 900, 'networkIPAllowlist': [], 'backupEnabled': true, 'pitr': true, 'pitrRetentionDays': 14, 'storageAutoscaling': true, 'storageAutoscalingThresholdPercent': 85, 'storageAutoscalingMaxGb': 30, 'maintenanceWindowDay': "sun", 'maintenanceWindowHourUtc': 3, 'metricsEnabled': true, 'sqlApiEnabled': true, 'sqlApiAllowedStatements': [], 'sqlApiMaxRows': 10000, 'sqlApiMaxBytes': 10485760, 'sqlApiTimeoutSeconds': 30, 'error': "", }; when( client.call( HttpMethod.post, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.createMigration( databaseId: "", targetType: "shared", specification: "", ); final Map params = verify( client.call( HttpMethod.post, path: "/postgresql/%3CDATABASE_ID%3E/migrations", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "targetType": "shared", "specification": "", }); expect(response, isA()); }); test('test method listOperations()', () async { final Map data = { 'total': 5, 'operations': [], }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.listOperations( databaseId: "", status: "queued", limit: 1, offset: 1, ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/%3CDATABASE_ID%3E/operations", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "status": "queued", "limit": 1, "offset": 1, }); expect(response, isA()); }); test('test method getPitr()', () async { final Map data = { 'earliest': "2020-10-15T06:38:00.000+00:00", 'latest': "2020-10-15T06:38:00.000+00:00", }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.getPitr( databaseId: "", ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/%3CDATABASE_ID%3E/pitr", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method getPooler()', () async { final Map data = { 'enabled': true, 'mode': "transaction", 'maxConnections': 200, 'defaultPoolSize': 25, 'port': 6432, 'readWriteSplitting': true, 'poolerCpuRequest': "100m", 'poolerCpuLimit': "200m", 'poolerMemoryRequest': "64Mi", 'poolerMemoryLimit': "128Mi", }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.getPooler( databaseId: "", ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/%3CDATABASE_ID%3E/pooler", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method updatePooler()', () async { final Map data = { 'enabled': true, 'mode': "transaction", 'maxConnections': 200, 'defaultPoolSize': 25, 'port': 6432, 'readWriteSplitting': true, 'poolerCpuRequest': "100m", 'poolerCpuLimit': "200m", 'poolerMemoryRequest': "64Mi", 'poolerMemoryLimit': "128Mi", }; when( client.call( HttpMethod.patch, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.updatePooler( databaseId: "", mode: "transaction", maxConnections: 1, defaultPoolSize: 1, readWriteSplitting: false, poolerCpuRequest: "", poolerCpuLimit: "", poolerMemoryRequest: "", poolerMemoryLimit: "", ); final Map params = verify( client.call( HttpMethod.patch, path: "/postgresql/%3CDATABASE_ID%3E/pooler", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "mode": "transaction", "maxConnections": 1, "defaultPoolSize": 1, "readWriteSplitting": false, "poolerCpuRequest": "", "poolerCpuLimit": "", "poolerMemoryRequest": "", "poolerMemoryLimit": "", }); expect(response, isA()); }); test('test method getReplicas()', () async { final Map data = { 'replicas': 2, 'syncMode': "async", 'syncDegraded': true, 'syncAcknowledgements': 1, 'syncStandbyCount': 2, 'members': [], }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.getReplicas( databaseId: "", ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/%3CDATABASE_ID%3E/replicas", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method listRestorations()', () async { final Map data = { 'total': 5, 'restorations': [], }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.listRestorations( databaseId: "", status: "pending", type: "backup", limit: 1, offset: 1, ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/%3CDATABASE_ID%3E/restorations", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "status": "pending", "type": "backup", "limit": 1, "offset": 1, }); expect(response, isA()); }); test('test method createRestoration()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", 'databaseId': "5e5ea5c16897e", 'projectId': "5e5ea5c16897e", 'type': "backup", 'restoreMode': "clone", 'status': "completed", 'error': "", }; when( client.call( HttpMethod.post, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.createRestoration( databaseId: "", type: "backup", backupId: "", targetDatabaseId: "", targetTime: "2020-10-15T06:38:00.000+00:00", restoreMode: "in_place", targetName: "", autoPromote: false, ); final Map params = verify( client.call( HttpMethod.post, path: "/postgresql/%3CDATABASE_ID%3E/restorations", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "type": "backup", "backupId": "", "targetDatabaseId": "", "targetTime": "2020-10-15T06:38:00.000+00:00", "restoreMode": "in_place", "targetName": "", "autoPromote": false, }); expect(response, isA()); }); test('test method getRestoration()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", 'databaseId': "5e5ea5c16897e", 'projectId': "5e5ea5c16897e", 'type': "backup", 'restoreMode': "clone", 'status': "completed", 'error': "", }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.getRestoration( databaseId: "", restorationId: "", ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/%3CDATABASE_ID%3E/restorations/%3CRESTORATION_ID%3E", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method promoteRestoration()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", 'databaseId': "5e5ea5c16897e", 'projectId': "5e5ea5c16897e", 'type': "backup", 'restoreMode': "clone", 'status': "completed", 'error': "", }; when( client.call( HttpMethod.post, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.promoteRestoration( databaseId: "", restorationId: "", ); final Map params = verify( client.call( HttpMethod.post, path: "/postgresql/%3CDATABASE_ID%3E/restorations/%3CRESTORATION_ID%3E/promotions", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method getStatus()', () async { final Map data = { 'health': "healthy", 'ready': true, 'engine': "postgresql", 'version': "17", 'uptime': 86400, 'syncMode': "async", 'syncDegraded': true, 'syncAcknowledgements': 1, 'syncStandbyCount': 2, 'replicas': [], 'volumes': [], }; when( client.call( HttpMethod.get, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.getStatus( databaseId: "", ); final Map params = verify( client.call( HttpMethod.get, path: "/postgresql/%3CDATABASE_ID%3E/status", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, isEmpty); expect(response, isA()); }); test('test method createUpgrade()', () async { final Map data = { '\$id': "5e5ea5c16897e", '\$createdAt': "2020-10-15T06:38:00.000+00:00", '\$updatedAt': "2020-10-15T06:38:00.000+00:00", 'projectId': "5e5ea5c16897e", 'name': "My Production Database", 'version': "16", 'specification': "s-2vcpu-2gb", 'backend': "edge", 'hostname': "db-myproject-mydb.fra.appwrite.center", 'connectionUser': "appwrite_user", 'connectionPassword': "••••••••", 'connectionString': "postgresql://user:pass@db-myproject-mydb.fra.appwrite.center:5432/postgres?sslmode=require", 'ssl': true, 'status': "ready", 'containerStatus': "active", 'lifecycleState': "active", 'idleTimeoutMinutes': 15, 'cpu': 2000, 'memory': 4096, 'storage': 100, 'storageStatus': "resizing", 'storageTargetGb': 120, 'storageClass': "ssd", 'storageMaxGb': 100, 'nodePool': "db-pool-4vcpu-8gb", 'replicas': 2, 'syncMode': "async", 'networkMaxConnections': 500, 'networkIdleTimeoutSeconds': 900, 'networkIPAllowlist': [], 'backupEnabled': true, 'pitr': true, 'pitrRetentionDays': 14, 'storageAutoscaling': true, 'storageAutoscalingThresholdPercent': 85, 'storageAutoscalingMaxGb': 30, 'maintenanceWindowDay': "sun", 'maintenanceWindowHourUtc': 3, 'metricsEnabled': true, 'sqlApiEnabled': true, 'sqlApiAllowedStatements': [], 'sqlApiMaxRows': 10000, 'sqlApiMaxBytes': 10485760, 'sqlApiTimeoutSeconds': 30, 'error': "", }; when( client.call( HttpMethod.post, path: anyNamed('path'), headers: anyNamed('headers'), params: anyNamed('params'), responseType: anyNamed('responseType'), ), ).thenAnswer((_) async => Response(data: data)); final response = await postgresql.createUpgrade( databaseId: "", targetVersion: "", ); final Map params = verify( client.call( HttpMethod.post, path: "/postgresql/%3CDATABASE_ID%3E/upgrades", headers: anyNamed('headers'), params: captureAnyNamed('params'), responseType: anyNamed('responseType'), ), ).captured.single; expect(params, { "targetVersion": "", }); expect(response, isA()); }); }); }