/
snssetup.php
106 lines (89 loc) · 2.68 KB
/
snssetup.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
<?php
session_start();
require 'vendor/autoload.php';
//create topic
$rds = new Aws\Rds\RdsClient([
'version' => 'latest',
'region' => 'us-west-2'
]);
$result = $rds->describeDBInstances(['DBInstanceIdentifier' => 'itmo-544-sukanya']);
//echo "No error as of now";
//print_r($result);
$endpoint = $result['DBInstances'][0]['Endpoint']['Address'];
// print "============\n". $endpoint . "================";
//echo "endpoint is available";
$link = mysqli_connect($endpoint,"SukanyaN","SukanyaNDB","itmo544SNDB") or die("Error " . mysqli_error($link));
//print_r($link);
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$sql1 = "SELECT topicarn,topicname FROM topic ";
$result = mysqli_query($link, $sql1);
if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
if ($row["topicname"] == 'Mp2-S3Upload1')
{
echo "";
}
else
{
$sns= new Aws\Sns\SnsClient([
'version' => 'latest',
'region' => 'us-east-1'
]);
$topicName = 'Mp2-S3Upload1';
$result = $sns->createTopic([
'Name' => $topicName, // REQUIRED
]);
$topicarn = $result['TopicArn'];
// echo "topic arn value is ----------- $topicarn";
//set topic attributes
$result = $sns->setTopicAttributes([
'AttributeName' => 'DisplayName', // REQUIRED
'AttributeValue' => 'S3Upload',
'TopicArn' => $topicarn, // REQUIRED
]);
$sql_insert = "INSERT INTO topic (topicarn,topicname) VALUES (?,?)";
if (!($stmt = $link->prepare($sql_insert))) {
echo "Prepare failed: (" . $link->errno . ") " . $link->error;
}
$stmt->bind_param("ss",$topicarn,$topicName);
if (!$stmt->execute()) {
print "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
}
// printf("%d Row inserted.\n", $stmt->affected_rows);
$stmt->close();
}
}
}
else {
$sns= new Aws\Sns\SnsClient([
'version' => 'latest',
'region' => 'us-east-1'
]);
$topicName = 'Mp2-S3Upload1';
$result = $sns->createTopic([
'Name' => $topicName, // REQUIRED
]);
$topicarn = $result['TopicArn'];
// echo "topic arn value is ----------- $topicarn";
//set topic attributes
$result = $sns->setTopicAttributes([
'AttributeName' => 'DisplayName', // REQUIRED
'AttributeValue' => 'S3Upload',
'TopicArn' => $topicarn, // REQUIRED
]);
$sql_insert = "INSERT INTO topic (topicarn,topicname) VALUES (?,?)";
if (!($stmt = $link->prepare($sql_insert))) {
echo "Prepare failed: (" . $link->errno . ") " . $link->error;
}
$stmt->bind_param("ss",$topicarn,$topicName);
if (!$stmt->execute()) {
print "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
}
$stmt->close();
}
$link->close();
?>