D'autres AWS SDK exemples sont disponibles dans le GitHub dépôt AWS Doc SDK Examples.
Les traductions sont fournies par des outils de traduction automatique. En cas de conflit entre le contenu d'une traduction et celui de la version originale en anglais, la version anglaise prévaudra.
Exemples de code pour Aurora à l'aide d'Aurora AWS SDKs
Les exemples de code suivants vous montrent comment utiliser Amazon Aurora avec un kit de développement AWS logiciel (SDK).
Les principes de base sont des exemples de code qui vous montrent comment effectuer les opérations essentielles au sein d'un service.
Les actions sont des extraits de code de programmes plus larges et doivent être exécutées dans leur contexte. Alors que les actions vous montrent comment appeler des fonctions de service individuelles, vous pouvez les visualiser dans leur contexte dans leurs scénarios associés.
Les scénarios sont des exemples de code qui vous montrent comment accomplir des tâches spécifiques en appelant plusieurs fonctions au sein d'un service ou en les combinant à d'autres Services AWS.
Ressources supplémentaires
Mise en route
Les exemples de code suivants montrent comment bien démarrer avec Aurora.
- .NET
-
- AWS SDK for .NET
-
using Amazon.RDS;
using Amazon.RDS.Model;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;
namespace AuroraActions;
public static class HelloAurora
{
static async Task Main(string[] args)
{
// Use the AWS .NET Core Setup package to set up dependency injection for the
// Amazon Relational Database Service (Amazon RDS).
// Use your AWS profile name, or leave it blank to use the default profile.
using var host = Host.CreateDefaultBuilder(args)
.ConfigureServices((_, services) =>
services.AddAWSService<IAmazonRDS>()
).Build();
// Now the client is available for injection. Fetching it directly here for example purposes only.
var rdsClient = host.Services.GetRequiredService<IAmazonRDS>();
// You can use await and any of the async methods to get a response.
var response = await rdsClient.DescribeDBClustersAsync(new DescribeDBClustersRequest { IncludeShared = true });
Console.WriteLine($"Hello Amazon RDS Aurora! Let's list some clusters in this account:");
foreach (var cluster in response.DBClusters)
{
Console.WriteLine($"\tCluster: database: {cluster.DatabaseName} identifier: {cluster.DBClusterIdentifier}.");
}
}
}
- C++
-
- SDKpour C++
-
Code du fichier CMakeLists CMake .txt.
# Set the minimum required version of CMake for this project.
cmake_minimum_required(VERSION 3.13)
# Set the AWS service components used by this project.
set(SERVICE_COMPONENTS rds)
# Set this project's name.
project("hello_aurora")
# Set the C++ standard to use to build this target.
# At least C++ 11 is required for the AWS SDK for C++.
set(CMAKE_CXX_STANDARD 11)
# Use the MSVC variable to determine if this is a Windows build.
set(WINDOWS_BUILD ${MSVC})
if (WINDOWS_BUILD) # Set the location where CMake can find the installed libraries for the AWS SDK.
string(REPLACE ";" "/aws-cpp-sdk-all;" SYSTEM_MODULE_PATH "${CMAKE_SYSTEM_PREFIX_PATH}/aws-cpp-sdk-all")
list(APPEND CMAKE_PREFIX_PATH ${SYSTEM_MODULE_PATH})
endif ()
# Find the AWS SDK for C++ package.
find_package(AWSSDK REQUIRED COMPONENTS ${SERVICE_COMPONENTS})
if (WINDOWS_BUILD AND AWSSDK_INSTALL_AS_SHARED_LIBS)
# Copy relevant AWS SDK for C++ libraries into the current binary directory for running and debugging.
# set(BIN_SUB_DIR "/Debug") # If you are building from the command line, you may need to uncomment this
# and set the proper subdirectory to the executables' location.
AWSSDK_CPY_DYN_LIBS(SERVICE_COMPONENTS "" ${CMAKE_CURRENT_BINARY_DIR}${BIN_SUB_DIR})
endif ()
add_executable(${PROJECT_NAME}
hello_aurora.cpp)
target_link_libraries(${PROJECT_NAME}
${AWSSDK_LINK_LIBRARIES})
Code pour le fichier source hello_aurora.cpp.
#include <aws/core/Aws.h>
#include <aws/rds/RDSClient.h>
#include <aws/rds/model/DescribeDBClustersRequest.h>
#include <iostream>
/*
* A "Hello Aurora" starter application which initializes an Amazon Relational Database Service (Amazon RDS) client
* and describes the Amazon Aurora (Aurora) clusters.
*
* main function
*
* Usage: 'hello_aurora'
*
*/
int main(int argc, char **argv) {
Aws::SDKOptions options;
// Optionally change the log level for debugging.
// options.loggingOptions.logLevel = Utils::Logging::LogLevel::Debug;
Aws::InitAPI(options); // Should only be called once.
int result = 0;
{
Aws::Client::ClientConfiguration clientConfig;
// Optional: Set to the AWS Region (overrides config file).
// clientConfig.region = "us-east-1";
Aws::RDS::RDSClient rdsClient(clientConfig);
Aws::String marker; // Used for pagination.
std::vector<Aws::String> clusterIds;
do {
Aws::RDS::Model::DescribeDBClustersRequest request;
Aws::RDS::Model::DescribeDBClustersOutcome outcome =
rdsClient.DescribeDBClusters(request);
if (outcome.IsSuccess()) {
for (auto &cluster: outcome.GetResult().GetDBClusters()) {
clusterIds.push_back(cluster.GetDBClusterIdentifier());
}
marker = outcome.GetResult().GetMarker();
} else {
result = 1;
std::cerr << "Error with Aurora::GDescribeDBClusters. "
<< outcome.GetError().GetMessage()
<< std::endl;
break;
}
} while (!marker.empty());
std::cout << clusterIds.size() << " Aurora clusters found." << std::endl;
for (auto &clusterId: clusterIds) {
std::cout << " clusterId " << clusterId << std::endl;
}
}
Aws::ShutdownAPI(options); // Should only be called once.
return 0;
}
- Go
-
- SDKpour Go V2
-
package main
import (
"context"
"fmt"
"github.com/aws/aws-sdk-go-v2/aws"
"github.com/aws/aws-sdk-go-v2/config"
"github.com/aws/aws-sdk-go-v2/service/rds"
)
// main uses the AWS SDK for Go V2 to create an Amazon Aurora client and list up to 20
// DB clusters in your account.
// This example uses the default settings specified in your shared credentials
// and config files.
func main() {
ctx := context.Background()
sdkConfig, err := config.LoadDefaultConfig(ctx)
if err != nil {
fmt.Println("Couldn't load default configuration. Have you set up your AWS account?")
fmt.Println(err)
return
}
auroraClient := rds.NewFromConfig(sdkConfig)
const maxClusters = 20
fmt.Printf("Let's list up to %v DB clusters.\n", maxClusters)
output, err := auroraClient.DescribeDBClusters(
ctx, &rds.DescribeDBClustersInput{MaxRecords: aws.Int32(maxClusters)})
if err != nil {
fmt.Printf("Couldn't list DB clusters: %v\n", err)
return
}
if len(output.DBClusters) == 0 {
fmt.Println("No DB clusters found.")
} else {
for _, cluster := range output.DBClusters {
fmt.Printf("DB cluster %v has database %v.\n", *cluster.DBClusterIdentifier,
*cluster.DatabaseName)
}
}
}
- Java
-
- SDKpour Java 2.x
-
import software.amazon.awssdk.regions.Region;
import software.amazon.awssdk.services.rds.RdsClient;
import software.amazon.awssdk.services.rds.paginators.DescribeDBClustersIterable;
public class DescribeDbClusters {
public static void main(String[] args) {
Region region = Region.US_EAST_1;
RdsClient rdsClient = RdsClient.builder()
.region(region)
.build();
describeClusters(rdsClient);
rdsClient.close();
}
public static void describeClusters(RdsClient rdsClient) {
DescribeDBClustersIterable clustersIterable = rdsClient.describeDBClustersPaginator();
clustersIterable.stream()
.flatMap(r -> r.dbClusters().stream())
.forEach(cluster -> System.out
.println("Database name: " + cluster.databaseName() + " Arn = " + cluster.dbClusterArn()));
}
}
- Python
-
- SDKpour Python (Boto3)
-
import boto3
# Create an RDS client
rds = boto3.client("rds")
# Create a paginator for the describe_db_clusters operation
paginator = rds.get_paginator("describe_db_clusters")
# Use the paginator to get a list of DB clusters
response_iterator = paginator.paginate(
PaginationConfig={
"PageSize": 50, # Adjust PageSize as needed
"StartingToken": None,
}
)
# Iterate through the pages of the response
clusters_found = False
for page in response_iterator:
if "DBClusters" in page and page["DBClusters"]:
clusters_found = True
print("Here are your RDS Aurora clusters:")
for cluster in page["DBClusters"]:
print(
f"Cluster ID: {cluster['DBClusterIdentifier']}, Engine: {cluster['Engine']}"
)
if not clusters_found:
print("No clusters found!")
- Ruby
-
- SDKpour Ruby
-
require 'aws-sdk-rds'
# Creates an Amazon RDS client for the AWS Region
rds = Aws::RDS::Client.new
puts 'Listing clusters in this AWS account...'
# Calls the describe_db_clusters method to get information about clusters
resp = rds.describe_db_clusters(max_records: 20)
# Checks if any clusters are found and prints the appropriate message
if resp.db_clusters.empty?
puts 'No clusters found!'
else
# Loops through the array of cluster objects and prints the cluster identifier
resp.db_clusters.each do |cluster|
puts "Cluster identifier: #{cluster.db_cluster_identifier}"
end
end
- Rust
-
- SDKpour Rust
-
use aws_sdk_rds::Client;
#[derive(Debug)]
struct Error(String);
impl std::fmt::Display for Error {
fn fmt(&self, f: &mut std::fmt::Formatter<'_>) -> std::fmt::Result {
write!(f, "{}", self.0)
}
}
impl std::error::Error for Error {}
#[tokio::main]
async fn main() -> Result<(), Error> {
tracing_subscriber::fmt::init();
let sdk_config = aws_config::from_env().load().await;
let client = Client::new(&sdk_config);
let describe_db_clusters_output = client
.describe_db_clusters()
.send()
.await
.map_err(|e| Error(e.to_string()))?;
println!(
"Found {} clusters:",
describe_db_clusters_output.db_clusters().len()
);
for cluster in describe_db_clusters_output.db_clusters() {
let name = cluster.database_name().unwrap_or("Unknown");
let engine = cluster.engine().unwrap_or("Unknown");
let id = cluster.db_cluster_identifier().unwrap_or("Unknown");
let class = cluster.db_cluster_instance_class().unwrap_or("Unknown");
println!("\tDatabase: {name}",);
println!("\t Engine: {engine}",);
println!("\t ID: {id}",);
println!("\tInstance: {class}",);
}
Ok(())
}