<commit_before><?php

require '/var/www/html/vendor/autoload.php';
$rds = new Aws\Rds\RdsClient([
    'version' => 'latest',
    'region'  => 'us-east-1'
]);

$result = $rds->describeDBInstances([
    'DBInstanceIdentifier' => 'mp1-fabdelsa',
]);

$endpoint = $result['DBInstances'][0]['Endpoint']['Address'];
print "============\n". $endpoint . "================\n";
$link = mysqli_connect($endpoint,"fabdelsa","fabdelsa","farah") or die("Error " . mysqli_error($link)); 
echo "Here is the result: " . $link;
$sql = "CREATE TABLE Table 
(
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(20),
email VARCHAR(20),
phone VARCHAR(20), 
file VARCHAR(256),
raws3url VARCHAR(256),
finisheds3url VARCHAR(256),
state TINYINT(3),
datetime TIMESTAMP   
)";

shell-exec("chmod 600 setup.php");
?><commit_msg>added sns topic creation and subscribe field in te table<commit_after><?php
require '/var/www/html/vendor/autoload.php';
$rds = new Aws\Rds\RdsClient([
    'version' => 'latest',
    'region'  => 'us-east-1'
]);
$result = $rds->describeDBInstances([
    'DBInstanceIdentifier' => 'fabdelsa-mp1',
]);
$endpoint = $result['DBInstances'][0]['Endpoint']['Address'];
print "============\n". $endpoint . "================\n";
$link = mysqli_connect($endpoint,"fabdelsa","fabdelsa","farah") or die("Error " . mysqli_error($link));
$sql = "CREATE TABLE users 
(
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(20),
email VARCHAR(20),
phone VARCHAR(20), 
file VARCHAR(256),
raws3url VARCHAR(256),
finisheds3url VARCHAR(256),
state TINYINT(3),
subscibe TINYINT(2),
datetime VARCHAR(256)  
)";
$link->query($sql);
shell-exec("chmod 600 setup.php");

#creating the sns topic
$sns = new Aws\Sns\SnsClient([
'version' => 'latest',
'region' => 'us-east-1'
]);

$result = $sns->createTopic([
'Name' => 'mp2',
]);


?>
{'fraction_non_alphanumeric': 0.2236914600550964, 'fraction_numerical': 0.02975206611570248, 'mean_word_length': 5.676470588235294, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 18, 'https://': 0, 'lorem ipsum': 0, 'www.': 2, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7602041', 'n_tokens_mistral': 707, 'n_tokens_neox': 667, 'n_words': 143}