Database
Crea Database
Crea un’istanza di database ospitata su Square Cloud.
POST
/
v2
/
databases
Crea Database
curl --request POST \
--url https://api.squarecloud.app/v2/databases \
--header 'Authorization: <authorization>' \
--header 'Content-Type: application/json' \
--data '
{
"name": "<string>",
"memory": 123,
"type": "<string>",
"version": "<string>"
}
'import requests
url = "https://api.squarecloud.app/v2/databases"
payload = {
"name": "<string>",
"memory": 123,
"type": "<string>",
"version": "<string>"
}
headers = {
"Authorization": "<authorization>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: '<authorization>', 'Content-Type': 'application/json'},
body: JSON.stringify({name: '<string>', memory: 123, type: '<string>', version: '<string>'})
};
fetch('https://api.squarecloud.app/v2/databases', 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.squarecloud.app/v2/databases",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'name' => '<string>',
'memory' => 123,
'type' => '<string>',
'version' => '<string>'
]),
CURLOPT_HTTPHEADER => [
"Authorization: <authorization>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.squarecloud.app/v2/databases"
payload := strings.NewReader("{\n \"name\": \"<string>\",\n \"memory\": 123,\n \"type\": \"<string>\",\n \"version\": \"<string>\"\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Authorization", "<authorization>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.squarecloud.app/v2/databases")
.header("Authorization", "<authorization>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"<string>\",\n \"memory\": 123,\n \"type\": \"<string>\",\n \"version\": \"<string>\"\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.squarecloud.app/v2/databases")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = '<authorization>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"name\": \"<string>\",\n \"memory\": 123,\n \"type\": \"<string>\",\n \"version\": \"<string>\"\n}"
response = http.request(request)
puts response.read_body{
"status":"success",
"response": {
"id": "a14b8d5e1cb7405a851eb4c075506121",
"name": "test",
"memory": 1024,
"cpu": 2,
"type": "mongo",
"password": "PASSWORD",
"certificate": "CERTIFICATE_IN_BASE_64_FORMAT",
"connection_url": "mongodb://default:PASSWORD@square-cloud-db-ID.squareweb.app:PORT"
}
}
La chiave API del tuo account. Puoi trovarla nelle impostazioni del tuo account.
Parametri
Il nome del database. 1–32 caratteri — lettere, numeri, trattini bassi (
_), trattini (-) e spazi — e deve includere almeno una lettera, un numero o un trattino basso.La RAM assegnata. Il minimo per Redis è 512 e per Mongo, 1024.
Il tipo di database, mongo, redis, postgres, mysql.
La versione del database.\
Postgres 17.6, MySQL 9.5, Mongo 8.0.11, Redis 7.4.5.
Risposta
Indica se la chiamata è andata a buon fine.
success in caso di successo, error in caso contrario.Il contenuto della risposta.
Mostra Mostra oggetto
Mostra Mostra oggetto
L’ID del database.
Il nome che hai scelto per il database
La memoria assegnata al database
Il numero di vCPU assegnate al database
Il tipo di database.
La password del database.
Il certificato necessario per connettersi. Puoi salvarlo in un file
.pem.L’url per connettersi al database.
{
"status":"success",
"response": {
"id": "a14b8d5e1cb7405a851eb4c075506121",
"name": "test",
"memory": 1024,
"cpu": 2,
"type": "mongo",
"password": "PASSWORD",
"certificate": "CERTIFICATE_IN_BASE_64_FORMAT",
"connection_url": "mongodb://default:PASSWORD@square-cloud-db-ID.squareweb.app:PORT"
}
}
Precedente
Ottieni Info DatabaseRecupera informazioni dettagliate su un database specifico.
Successivo
⌘I
Crea Database
curl --request POST \
--url https://api.squarecloud.app/v2/databases \
--header 'Authorization: <authorization>' \
--header 'Content-Type: application/json' \
--data '
{
"name": "<string>",
"memory": 123,
"type": "<string>",
"version": "<string>"
}
'import requests
url = "https://api.squarecloud.app/v2/databases"
payload = {
"name": "<string>",
"memory": 123,
"type": "<string>",
"version": "<string>"
}
headers = {
"Authorization": "<authorization>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: '<authorization>', 'Content-Type': 'application/json'},
body: JSON.stringify({name: '<string>', memory: 123, type: '<string>', version: '<string>'})
};
fetch('https://api.squarecloud.app/v2/databases', 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.squarecloud.app/v2/databases",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'name' => '<string>',
'memory' => 123,
'type' => '<string>',
'version' => '<string>'
]),
CURLOPT_HTTPHEADER => [
"Authorization: <authorization>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.squarecloud.app/v2/databases"
payload := strings.NewReader("{\n \"name\": \"<string>\",\n \"memory\": 123,\n \"type\": \"<string>\",\n \"version\": \"<string>\"\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Authorization", "<authorization>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.squarecloud.app/v2/databases")
.header("Authorization", "<authorization>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"<string>\",\n \"memory\": 123,\n \"type\": \"<string>\",\n \"version\": \"<string>\"\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.squarecloud.app/v2/databases")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = '<authorization>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"name\": \"<string>\",\n \"memory\": 123,\n \"type\": \"<string>\",\n \"version\": \"<string>\"\n}"
response = http.request(request)
puts response.read_body{
"status":"success",
"response": {
"id": "a14b8d5e1cb7405a851eb4c075506121",
"name": "test",
"memory": 1024,
"cpu": 2,
"type": "mongo",
"password": "PASSWORD",
"certificate": "CERTIFICATE_IN_BASE_64_FORMAT",
"connection_url": "mongodb://default:PASSWORD@square-cloud-db-ID.squareweb.app:PORT"
}
}

