Dedunu Dhananjaya dedunumax
dedunumax
/ grafana_postgresql_schema.sql
Last active
June 14, 2025 08:50
DB schema of Grafana 12.0.1 (PostgreSQL)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- PostgreSQL database dump | |
| -- | |
| -- Dumped from database version 16.9 (Ubuntu 16.9-0ubuntu0.24.04.1) | |
| -- Dumped by pg_dump version 16.9 (Ubuntu 16.9-0ubuntu0.24.04.1) | |
| SET statement_timeout = 0; | |
| SET lock_timeout = 0; | |
| SET idle_in_transaction_session_timeout = 0; |
dedunumax
/ organizational_policy.tf
Created
February 18, 2024 22:14
https://tech.dedunu.info/2024/02/04/aws-backup-policies-with-terraform/
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| resource "aws_organizations_policy" "plan_1_policy" { | |
| name = "dedunu-info-backup-plan-1-policy" | |
| type = "BACKUP_POLICY" | |
| content = jsonencode(local.plan1) | |
| } | |
| resource "aws_organizations_policy_attachment" "plan_1_policy_attachment" { | |
| policy_id = aws_organizations_policy.plan_1_policy.id | |
| target_id = "<account-id>" |
dedunumax
/ grep_test.sh
Last active
June 24, 2023 17:06
https://askubuntu.com/questions/1474170/compare-new-txt-file-with-old-txt-file-and-remove-all-data-that-matches/1474183
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| printf 'a\na\nb\nc\nd\nd' > file1 | |
| printf 'b\nd' > file2 | |
| echo 'Test Case 1, without sort command:' | |
| grep -F -f file2 -v file1 | uniq | |
| echo 'Test Case 1, with sort command:' | |
| grep -F -f file2 -v file1 | sort |uniq |
dedunumax
/ blogger-theme.xml
Last active
August 24, 2020 12:01
Theme used in https://travel.dedunu.info
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="UTF-8" ?> | |
| <!DOCTYPE html> | |
| <html b:version='2' class='v2' expr:dir='data:blog.languageDirection' expr:lang='data:blog.locale' xmlns='http://www.w3.org/1999/xhtml' xmlns:b='http://www.google.com/2005/gml/b' xmlns:data='http://www.google.com/2005/gml/data' xmlns:expr='http://www.google.com/2005/gml/expr'> | |
| <head> | |
| <meta content='width=device-width, initial-scale=1.0' name='viewport'/> | |
| <meta content='A travel blog.' name='description'/> | |
| <b:include data='blog' name='all-head-content'/> | |
| <link href='{{ site.baseurl }}/favicon.png' rel='shortcut icon'/> | |
| <link href='https://cdn.rawgit.com/dreampulse/computer-modern-web-font/master/fonts.css' rel='stylesheet' type='text/css'/> | |
| <title>travel - Dedunu Dhananjaya</title> |
dedunumax
/ aws_rds_unused_lambda_function.py
Last active
July 16, 2023 15:48
This AWS Lambda function will scan for RDS instances with no connections for last 14 days using boto3 and stop them. -https://github.com/dedunu/blog/blob/main/2020/2020-07-04-unused-rds-lambda.md
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| """RDS-Unused AWS Lambda Function | |
| It will go through the REGION's RDS instances and check on CloudWatch for the unused | |
| instances and will stop them. | |
| """ | |
| import json | |
| from datetime import datetime, timedelta | |
| from multiprocessing import Process, Pipe | |
| import boto3 |
dedunumax
/ create_privatebin.py
Last active
July 16, 2023 16:09
Sample program to create PrivateBin notes using Python 3. It might come handy in automation. Code is based on https://github.com/r4sas/PBinCLI repository. Thanks a lot @r4sas! https://github.com/dedunu/blog/blob/main/2020/2020-06-19-create-privatebin-using-python-3.md
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| """ | |
| This script creates a PrivateBin using Python 3. | |
| Code is based on https://github.com/r4sas/PBinCLI repository. | |
| Thanks a lot @r4sas! | |
| Below modules should be installed in the environment. | |
| requests | |
| base58 | |
| pycryptodome | |
| """ |
dedunumax
/ virtual.sh
Created
April 20, 2020 21:27
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function virt() { | |
| osascript -e "tell application \"Terminal\" to set current settings of front window to settings set \"Ubuntu\"" | |
| ssh -Ap 5001 vuser@virtual-server | |
| osascript -e "tell application \"Terminal\" to set current settings of front window to settings set \"One Dark\"" | |
| } |
dedunumax
/ production_bridge.sh
Last active
April 20, 2020 21:28
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function prod() { | |
| ssh -A luser@laptop -C 'osascript -e "tell application \"Terminal\" to set current settings of front window to settings set \"Red Alert\""' | |
| ssh -A buser@bridge.company.org | |
| ssh -A luser@laptop -C 'osascript -e "tell application \"Terminal\" to set current settings of front window to settings set \"Ubuntu\""' | |
| } |
dedunumax
/ pg_loader_sample.load
Created
March 5, 2020 10:43
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| LOAD DATABASE | |
| FROM mysql://root:Password123@mysqldb.example.com/real_db | |
| INTO pgsql://postgres:Password456@pgserver101.example.com/adventure_db | |
| WITH include drop, create tables | |
| SET search_path to 'public' | |
| INCLUDING ONLY TABLE NAMES MATCHING 'user' |
dedunumax
/ pg_loader_example.load
Created
March 5, 2020 10:40
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| LOAD DATABASE | |
| FROM mysql://<mysql_user>:<mysql_password>@<mysql_host>/<source_databases> | |
| INTO pgsql://<postgres_user>:<postgres_password>@<postgres_host>/<target_database> | |
| WITH INCLUDE DROP, CREATE TABLES | |
| SET search_path to 'public' | |
| INCLUDING ONLY TABLE NAMES MATCHING 'sample_table' |
NewerOlder