from latitudesh_python_sdk import Latitudesh
import os


with Latitudesh(
    bearer=os.getenv("LATITUDESH_BEARER", ""),
) as latitudesh:

    res = latitudesh.managed_databases.update_managed_database(id="<id>", data={
        "attributes": {
            "trusted_sources": [
                "203.0.113.0/24",
                "198.51.100.0/24",
            ],
            "parameters": {
                "shared_buffers": "256MB",
                "work_mem": "16MB",
                "effective_cache_size": "1GB",
            },
            "pooler": {
                "enabled": True,
                "default_pool_size": 30,
                "max_client_conn": 200,
            },
            "backup": {
                "enabled": True,
                "schedule": "0 0 0 * * *",
                "s3Endpoint": "https://s3.amazonaws.com",
                "bucketName": "my-db-backups",
                "path": "prod/postgres",
                "retentionPolicy": "7",
            },
            "access_credentials": {
                "access_key_id": "AKIAIOSFODNN7EXAMPLE",
                "secret_access_key": "wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY",
            },
            "supabase": True,
        },
    })

    # Handle response
    print(res)

package main

import(
	"context"
	"os"
	latitudeshgosdk "github.com/latitudesh/latitudesh-go-sdk"
	"github.com/latitudesh/latitudesh-go-sdk/models/components"
	"log"
)

func main() {
    ctx := context.Background()

    s := latitudeshgosdk.New(
        latitudeshgosdk.WithSecurity(os.Getenv("LATITUDESH_BEARER")),
    )

    res, err := s.ManagedDatabases.UpdateManagedDatabase(ctx, "<id>", components.ManagedDatabaseUpdatePayload{
        Data: &components.ManagedDatabaseUpdatePayloadData{
            Attributes: &components.ManagedDatabaseUpdatePayloadAttributes{
                TrustedSources: []string{
                    "203.0.113.0/24",
                    "198.51.100.0/24",
                },
                Parameters: map[string]any{
                    "shared_buffers": "256MB",
                    "work_mem": "16MB",
                    "effective_cache_size": "1GB",
                },
                Pooler: map[string]any{
                    "enabled": true,
                    "default_pool_size": 30,
                    "max_client_conn": 200,
                },
                Backup: map[string]any{
                    "enabled": true,
                    "schedule": "0 0 0 * * *",
                    "s3Endpoint": "https://s3.amazonaws.com",
                    "bucketName": "my-db-backups",
                    "path": "prod/postgres",
                    "retentionPolicy": "7",
                },
                AccessCredentials: &components.AccessCredentials{
                    AccessKeyID: latitudeshgosdk.Pointer("AKIAIOSFODNN7EXAMPLE"),
                    SecretAccessKey: latitudeshgosdk.Pointer("wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY"),
                },
                Supabase: latitudeshgosdk.Pointer(true),
            },
        },
    })
    if err != nil {
        log.Fatal(err)
    }
    if res.ManagedDatabase != nil {
        // handle response
    }
}

import { Latitudesh } from "latitudesh-typescript-sdk";

const latitudesh = new Latitudesh({
  bearer: process.env["LATITUDESH_BEARER"] ?? "",
});

async function run() {
  const result = await latitudesh.managedDatabases.updateManagedDatabase({
    id: "<id>",
    managedDatabaseUpdatePayload: {
      data: {
        attributes: {
          trustedSources: [
            "203.0.113.0/24",
            "198.51.100.0/24",
          ],
          parameters: {
            "shared_buffers": "256MB",
            "work_mem": "16MB",
            "effective_cache_size": "1GB",
          },
          pooler: {
            "enabled": true,
            "default_pool_size": 30,
            "max_client_conn": 200,
          },
          backup: {
            "enabled": true,
            "schedule": "0 0 0 * * *",
            "s3Endpoint": "https://s3.amazonaws.com",
            "bucketName": "my-db-backups",
            "path": "prod/postgres",
            "retentionPolicy": "7",
          },
          accessCredentials: {
            accessKeyId: "AKIAIOSFODNN7EXAMPLE",
            secretAccessKey: "wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY",
          },
          supabase: true,
        },
      },
    },
  });

  console.log(result);
}

run();

curl --request PATCH \
  --url https://api.latitude.sh/managed_databases/{id} \
  --header 'Authorization: <api-key>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "data": {
    "type": "managed_databases",
    "attributes": {
      "trusted_sources": [
        "203.0.113.0/24",
        "198.51.100.0/24"
      ],
      "parameters": {
        "shared_buffers": "256MB",
        "work_mem": "16MB",
        "effective_cache_size": "1GB"
      },
      "pooler": {
        "enabled": true,
        "default_pool_size": 30,
        "max_client_conn": 200
      },
      "backup": {
        "enabled": true,
        "schedule": "0 0 0 * * *",
        "s3Endpoint": "https://s3.amazonaws.com",
        "bucketName": "my-db-backups",
        "path": "prod/postgres",
        "retentionPolicy": "7"
      },
      "access_credentials": {
        "accessKeyId": "AKIAIOSFODNN7EXAMPLE",
        "secretAccessKey": "wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY"
      },
      "supabase": true
    }
  }
}
'

const options = {
  method: 'PATCH',
  headers: {Authorization: '<api-key>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    data: {
      type: 'managed_databases',
      attributes: {
        trusted_sources: ['203.0.113.0/24', '198.51.100.0/24'],
        parameters: {shared_buffers: '256MB', work_mem: '16MB', effective_cache_size: '1GB'},
        pooler: {enabled: true, default_pool_size: 30, max_client_conn: 200},
        backup: {
          enabled: true,
          schedule: '0 0 0 * * *',
          s3Endpoint: 'https://s3.amazonaws.com',
          bucketName: 'my-db-backups',
          path: 'prod/postgres',
          retentionPolicy: '7'
        },
        access_credentials: {
          accessKeyId: 'AKIAIOSFODNN7EXAMPLE',
          secretAccessKey: 'wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY'
        },
        supabase: true
      }
    }
  })
};

fetch('https://api.latitude.sh/managed_databases/{id}', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://api.latitude.sh/managed_databases/{id}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "PATCH",
  CURLOPT_POSTFIELDS => json_encode([
    'data' => [
        'type' => 'managed_databases',
        'attributes' => [
                'trusted_sources' => [
                                '203.0.113.0/24',
                                '198.51.100.0/24'
                ],
                'parameters' => [
                                'shared_buffers' => '256MB',
                                'work_mem' => '16MB',
                                'effective_cache_size' => '1GB'
                ],
                'pooler' => [
                                'enabled' => true,
                                'default_pool_size' => 30,
                                'max_client_conn' => 200
                ],
                'backup' => [
                                'enabled' => true,
                                'schedule' => '0 0 0 * * *',
                                's3Endpoint' => 'https://s3.amazonaws.com',
                                'bucketName' => 'my-db-backups',
                                'path' => 'prod/postgres',
                                'retentionPolicy' => '7'
                ],
                'access_credentials' => [
                                'accessKeyId' => 'AKIAIOSFODNN7EXAMPLE',
                                'secretAccessKey' => 'wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY'
                ],
                'supabase' => true
        ]
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: <api-key>",
    "Content-Type: application/json"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

HttpResponse<String> response = Unirest.patch("https://api.latitude.sh/managed_databases/{id}")
  .header("Authorization", "<api-key>")
  .header("Content-Type", "application/json")
  .body("{\n  \"data\": {\n    \"type\": \"managed_databases\",\n    \"attributes\": {\n      \"trusted_sources\": [\n        \"203.0.113.0/24\",\n        \"198.51.100.0/24\"\n      ],\n      \"parameters\": {\n        \"shared_buffers\": \"256MB\",\n        \"work_mem\": \"16MB\",\n        \"effective_cache_size\": \"1GB\"\n      },\n      \"pooler\": {\n        \"enabled\": true,\n        \"default_pool_size\": 30,\n        \"max_client_conn\": 200\n      },\n      \"backup\": {\n        \"enabled\": true,\n        \"schedule\": \"0 0 0 * * *\",\n        \"s3Endpoint\": \"https://s3.amazonaws.com\",\n        \"bucketName\": \"my-db-backups\",\n        \"path\": \"prod/postgres\",\n        \"retentionPolicy\": \"7\"\n      },\n      \"access_credentials\": {\n        \"accessKeyId\": \"AKIAIOSFODNN7EXAMPLE\",\n        \"secretAccessKey\": \"wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY\"\n      },\n      \"supabase\": true\n    }\n  }\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.latitude.sh/managed_databases/{id}")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Patch.new(url)
request["Authorization"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"data\": {\n    \"type\": \"managed_databases\",\n    \"attributes\": {\n      \"trusted_sources\": [\n        \"203.0.113.0/24\",\n        \"198.51.100.0/24\"\n      ],\n      \"parameters\": {\n        \"shared_buffers\": \"256MB\",\n        \"work_mem\": \"16MB\",\n        \"effective_cache_size\": \"1GB\"\n      },\n      \"pooler\": {\n        \"enabled\": true,\n        \"default_pool_size\": 30,\n        \"max_client_conn\": 200\n      },\n      \"backup\": {\n        \"enabled\": true,\n        \"schedule\": \"0 0 0 * * *\",\n        \"s3Endpoint\": \"https://s3.amazonaws.com\",\n        \"bucketName\": \"my-db-backups\",\n        \"path\": \"prod/postgres\",\n        \"retentionPolicy\": \"7\"\n      },\n      \"access_credentials\": {\n        \"accessKeyId\": \"AKIAIOSFODNN7EXAMPLE\",\n        \"secretAccessKey\": \"wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY\"\n      },\n      \"supabase\": true\n    }\n  }\n}"

response = http.request(request)
puts response.read_body

{
  "data": {
    "id": "db_a1b2c3d4",
    "type": "managed_databases",
    "attributes": {
      "name": "<string>",
      "engine": "<string>",
      "status": "<string>",
      "namespace": "<string>",
      "created_at": "<string>",
      "specs": {
        "cpu": 123,
        "memory": 123,
        "storage": 123,
        "shards": 123,
        "replicas": 123,
        "iops": "<string>"
      },
      "region": {
        "city": "<string>",
        "country": "<string>",
        "site": {
          "id": "<string>",
          "name": "<string>",
          "slug": "<string>",
          "facility": "<string>"
        }
      },
      "plan": {
        "id": "<string>",
        "name": "<string>",
        "slug": "<string>",
        "billing": "<string>"
      },
      "team": {
        "id": "<string>",
        "name": "<string>",
        "slug": "<string>",
        "description": "<string>",
        "address": "<string>",
        "currency": {
          "id": "<string>",
          "code": "<string>",
          "name": "<string>",
          "currency_id": 123
        },
        "status": "<string>",
        "feature_flags": [
          "<string>"
        ],
        "limits": {
          "bare_metal": 123,
          "bare_metal_gpu": 123,
          "virtual_machine": 123,
          "virtual_machine_gpu": 123,
          "elastic_ip": 123,
          "bgp_session_per_ip": 123,
          "public_network": 123,
          "virtual_network": 123,
          "database": 123,
          "filesystem": 123,
          "block_storage": 123
        }
      },
      "project": {
        "id": "<string>",
        "name": "<string>",
        "slug": "<string>",
        "description": "<string>",
        "billing_type": "<string>",
        "provisioning_type": "<string>",
        "billing_method": "<string>",
        "bandwidth_alert": true,
        "environment": "<string>",
        "billing": {
          "subscription_id": "<string>",
          "type": "<string>",
          "method": "<string>"
        },
        "stats": {
          "databases": 123,
          "ip_addresses": 123,
          "prefixes": 123,
          "servers": 123,
          "storages": 123,
          "virtual_machines": 123,
          "vlans": 123
        }
      },
      "trusted_sources": [
        "<string>"
      ],
      "play_url": "<string>",
      "credentials": {
        "host": "<string>",
        "http_port": 123,
        "tcp_port": 123,
        "port": 123,
        "database": "<string>",
        "url": "<string>",
        "username": "<string>",
        "password": "<string>"
      },
      "parameters": {},
      "pooler": {},
      "backup": {},
      "recovery": {
        "enabled": true
      },
      "supabase": {
        "enabled": true
      }
    }
  }
}