KeyHelp Community

Code: Select all

#!/bin/bash

DATE=`date +%Y-%m-%d`
BACKUPPATHBASE=""/__databasebackup""
BACKUPPATH=""${BACKUPPATHBASE}/${DATE}""

#DBNAME_STARTS_WITH=""HIER DBPREFIX""
MHOST=""HIER DATENBANKSERVER IP""
MUSER=""HIER USERNAME""
MPWD=""HIER PASSWORT""
MYSQL=""mysql""


mkdir -p ${BACKUPPATH}

DBS="$($MYSQL -h${MHOST} -u$MUSER -p$MPWD -Bse 'show databases')"
for dbname in $DBS; do

#if [[ "${dbname}" =~ ^"${DBNAME_STARTS_WITH}".* ]]; then

echo "Preparing dump for ${dbname}"
mysqldump --default-character-set=utf8 --no-tablespaces -h${MHOST} ${dbname} -u${MUSER} -p${MPWD} > ${BACKUPPATH}/${dbname}.sql

#fi

done

find /__databasebackup/* -mtime +30 -exec rm {} \;

Code: Select all

[
  {
    "id": 8,
    "status": 1,
    "username": "alex",
    "language": "de",
    "email": "me@example.com",
    "notes": "Any comments about this client account.",
    "created_at": "2019-08-15T11:29:13+02:00",
"document_root": "/home/users/alex/",
    "is_suspended": false,
    "suspend_on": null,
    "delete_on": null,
    "contact_data": {
      "first_name": "Alex",
      "last_name": "Mahr",
      "company": "Keyweb AG",
      "telephone": "555-Nase",
      "address": "Neuwerkstraße 45/46",
      "city": "Erfurt",
      "zip": "99084",
      "state": "Thuringia",
      "country": "DE",
      "client_id": "ID-12345"
    },
    "password_hash": "$2a$10$fF3npQ.jS/KL8Nr6zecPke8IUsuB1oGXxY7w4aa...\"",
    "password_hash_os": "$6$rounds=100000$tn0.24Y/EWkV8gjA$VkYdo/1X23dW...\""
  }
]

Code: Select all

<?php

//https://app.swaggerhub.com/apis-docs/keyhelp/api/2.1#/client

KeyHelpAPI::listKeyHelpObjects("clients"); 	 print KeyHelpAPI::$newLine;
KeyHelpAPI::listKeyHelpObjects("domains"); 	 print KeyHelpAPI::$newLine;
KeyHelpAPI::listKeyHelpObjects("databases");     print KeyHelpAPI::$newLine;  

class KeyHelpAPI
{

	public static $apiUrl="https://184.111.111.211/api/v2/";
	public static $apiKey="kR8asdf.sBd3eK7F439ijfkmilkjmdioj09fujdsfjkdsf90u430rjhfoldjü09432u5rfjadlskfjklsdfjkasjdflksafd";
	public static $apiMethod="GET";
	public static $genFile="/home/users/pm/www/testdomain.de/cachedApiResults";
	public static $newLine="\n";

	public static function listKeyHelpObjects($objectEndpoint){
		$arrObjects 	= json_decode(self::CallAPI($objectEndpoint,$data = false), true);
		//use this to understand what data there is!
		//print_r($arrObjects);
		
		
		switch ($objectEndpoint)
		{
			case "clients":
				//print $object[0]["username"];	
				self::initializeCachedAPICalls($objectEndpoint);
				foreach ($arrObjects as $object) {
				  print $object["username"]. self::$newLine;
				  self::writeCachedAPICalls($objectEndpoint,$object["username"]);
				  
				}
			break;
			case "domains":
				self::initializeCachedAPICalls($objectEndpoint);
				foreach ($arrObjects as $object) {
				  print $object["domain"]. self::$newLine;
				  self::writeCachedAPICalls($objectEndpoint,$object["domain"]);
				}
			break;
			case "databases":
				self::initializeCachedAPICalls($objectEndpoint);
				foreach ($arrObjects as $object) {
				  print $object["database_name"].":".$object["database_username"]. self::$newLine;
				  self::writeCachedAPICalls($objectEndpoint,$object["database_name"]);
				}
			break;
		}

	}


	private static function initializeCachedAPICalls($objectEndpoint)
	{
		//Filename: 
		//print self::$genFile.'_'.$objectEndpoint.'.txt';
		$h = fopen(self::$genFile.'_'.$objectEndpoint.'.txt', 'w');
		fwrite($h, "");
	}

	private static function writeCachedAPICalls($objectEndpoint,$txtData)
	{
		$h = fopen(self::$genFile.'_'.$objectEndpoint.'.txt', 'a+');
		fwrite($h, $txtData.PHP_EOL);
		//fwrite($h, var_export($arrData, true)); //in case you want to write array directly
	}
	
	private static function CallAPI($objectEndpoint, $data = false)
	{
		$curl = curl_init();
		$url  = self::$apiUrl.$objectEndpoint;
		$method = self::$apiMethod;

		switch ($method)
		{
			case "POST":
				curl_setopt($curl, CURLOPT_POST, 1);

				if ($data)
					curl_setopt($curl, CURLOPT_POSTFIELDS, $data);
				break;
			case "PUT":
				curl_setopt($curl, CURLOPT_PUT, 1);
				break;
			default:
				if ($data)
					$url = sprintf("%s?%s", $url, http_build_query($data));
		}

		curl_setopt($curl, CURLOPT_URL, $url);
		curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);

		curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, '0'); // 1 on Live-Systems
		curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, '0'); // 1 on Live-Systems
		
		curl_setopt($curl, CURLOPT_URL, $url);
		curl_setopt($curl, CURLOPT_HTTPHEADER, array(
			'X-API-Key: '.self::$apiKey,
			'accept: application/json',
			'Content-Type: application/json',
		));

		$result = curl_exec($curl);

		curl_close($curl);

		return $result;
	}
}

?>

Code: Select all

#!/bin/bash

cat cachedApiResults_clients.txt | while read line || [[ -n $line ]];
do
   # do something with $line here
done