Base de données
Créer une base de données
Créez une instance de base de données hébergée sur Square Cloud.
POST
/
v2
/
databases
Créer une base de données
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 clé d’API de votre compte. Vous pouvez la trouver dans les paramètres de votre compte.
Paramètres
Le nom de la base de données. 1 à 32 caractères — lettres, chiffres, tirets bas (
_), tirets (-) et espaces — et doit contenir au moins une lettre, un chiffre ou un tiret bas.La RAM qui lui est allouée. Le minimum pour Redis est 512 et pour Mongo, 1024.
Le type de base de données : mongo, redis, postgres, mysql.
La version de la base de données.\
Postgres 17.6, MySQL 9.5, Mongo 8.0.11, Redis 7.4.5.
Réponse
Indique si l’appel a réussi.
success en cas de succès, error sinon.Le contenu de la réponse.
Afficher Afficher l'objet
Afficher Afficher l'objet
L’ID de la base de données.
Le nom que vous avez choisi pour la base de données
La mémoire allouée à la base de données
Le nombre de vCPU alloués à la base de données
Le type de la base de données.
Le mot de passe de la base de données.
Le certificat nécessaire pour s’y connecter. Vous pouvez l’enregistrer dans un fichier
.pem.L’url de connexion à la base de données.
{
"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"
}
}
Précédent
Obtenir les informations d'une base de donnéesRécupérer des informations détaillées sur une base de données spécifique.
Suivant
⌘I
Créer une base de données
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"
}
}

