Skip to content

Instantly share code, notes, and snippets.

View dedunumax's full-sized avatar

Dedunu Dhananjaya dedunumax

20 followers · 0 following
View GitHub Profile
@dedunumax
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
View grep_test.sh
#!/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
dedunumax / blogger-theme.xml
Last active August 24, 2020 12:01
Theme used in https://travel.dedunu.info
View blogger-theme.xml
<?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
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
View aws_rds_unused_lambda_function.py
"""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
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
View create_privatebin.py
"""
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
dedunumax / virtual.sh
Created April 20, 2020 21:27
View virtual.sh
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
dedunumax / production_bridge.sh
Last active April 20, 2020 21:28
View production_bridge.sh
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
dedunumax / pg_loader_sample.load
Created March 5, 2020 10:43
View pg_loader_sample.load
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
dedunumax / pg_loader_example.load
Created March 5, 2020 10:40
View pg_loader_example.load
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'
@dedunumax
dedunumax / terraform_err.tf
Created February 26, 2020 18:50
View terraform_err.tf
Acquiring state lock. This may take a few moments...
Error: Error locking state: Error acquiring the state lock: ConditionalCheckFailedException: The conditional request failed
status code: 400, request id: L2CH7KK3QCAEHSC1TJ1VLBMNBRVV4CQNSO5AEMVJY66Q9ASUAAJN
Lock Info:
ID: 21e2b2bb-c123-2383-eece-7a5eaab4f645
Path: s3/path/to/the/state/file
Operation: OperationTypePlan
Who: username@hostname
Version: 0.11.14
@dedunumax
dedunumax / current_trx.sql
Last active February 26, 2020 18:42
View current_trx.sql
SELECT *
FROM information_schema.innodb_trx
WHERE trx_mysql_thread_id = CONNECTION_ID()\G