Skip to content

Instantly share code, notes, and snippets.

View rambabusaravanan's full-sized avatar

Andro Babu rambabusaravanan

  • Singapore
View GitHub Profile
@rambabusaravanan
rambabusaravanan / utils.php
Created April 1, 2017 17:20
PHP Utility Functions - Arrays
<?php
function array_table_innerjoin(Array $leftArr, Array $rightArr, String $key) {
$mergeArray = [];
foreach($leftArr as $leftRow) {
foreach($rightArr as $rightRow) {
if(isset($leftRow[$key]) && isset($rightRow[$key]) && $leftRow[$key] == $rightRow[$key]) {
$mergeArray[] = array_merge($leftRow, $rightRow);
}
}
@rambabusaravanan
rambabusaravanan / apache-stat.sh
Created April 30, 2017 02:51
Apache Log Stat Analyser
// Daily
awk '{print $4}' /var/log/apache2/$1/access.log | cut -d: -f1 | uniq -c
// Hourly
grep "`date +%d/%b/%Y`" /var/log/apache2/$1/access.log | cut -d[ -f2 | cut -d] -f1 | awk -F: '{print $2":00"}' | sort -n | uniq -c
// IP-Based
grep 'text' /var/log/apache2/$1/access.log | cut -d' ' -f1 | sort | uniq -c | sort -r
@rambabusaravanan
rambabusaravanan / archive-backup.s3.sh
Last active May 11, 2017 16:32
Backup MySQL Database, Archive, Filesystem Sync to Amazon S3
#!/bin/sh
# src details
SRCPATH='/path/of/target'
SRCFILE='file-or-directory'
# s3 details
S3BUCKET='bucketname'
S3PATH='path/in/bucket'
S3REGION='us-east-1'
TMPDIR='/tmp/s3'
@rambabusaravanan
rambabusaravanan / s3-bucket-access.json
Last active August 24, 2017 14:03
AWS Policies - Bucket Policy
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:ListBucket"
],
"Resource": [
"arn:aws:s3:::example.com"
@rambabusaravanan
rambabusaravanan / image-bucket.hosting-redirection-rules.xml
Created January 14, 2018 05:03
S3 Bucket image on-demand compression and conversion using AWS Lambda
<RoutingRules>
<RoutingRule>
<Condition>
<KeyPrefixEquals/>
<HttpErrorCodeReturnedEquals>404</HttpErrorCodeReturnedEquals>
</Condition>
<Redirect>
<Protocol>https</Protocol>
<HostName>xxx1x11xxx.execute-api.us-east-1.amazonaws.com</HostName>
<ReplaceKeyPrefixWith>prod/convert?key=</ReplaceKeyPrefixWith>
@rambabusaravanan
rambabusaravanan / readme.md
Created March 17, 2018 22:07
Upload Service

The various approach followed for upload service

@rambabusaravanan
rambabusaravanan / utils.sh
Last active October 26, 2018 19:04
Shell Utils
# Schema Spy
java -jar /usr/local/bin/schemaSpy_5.0.0.jar -dp /home/androbabu/softwares/jar/mysql-connector-java-5.1.28.jar -t mysql -host localhost -db $1 -u root -p password -o .schema
# Git Tree Log
git log --graph --all --pretty=format:"%C(auto)%h%d %s %C(dim)(%an) %aD"
git config --global alias.tree 'log --graph --all --pretty=format:"%C(auto)%h%d %s %C(dim)(%an) %aD"'
git tree
@rambabusaravanan
rambabusaravanan / serverless.s3-website.yml
Last active January 29, 2019 22:31
Serverless Framework CloudFormation Templates
resources:
Resources:
TestOneBucket:
Type: AWS::S3::Bucket
Properties:
BucketName: ${self:service}-${self:provider.region}-test-one
CorsConfiguration:
CorsRules:
- AllowedOrigins: ['*']
AllowedHeaders: ['*']
@rambabusaravanan
rambabusaravanan / jquery.serializeObject.js
Last active September 30, 2019 10:40
jQuery Serialize Object (JSON)
/**
* Usage: var json = $('#form-login').serializeObject();
* Output: {username: "admin", password: "123456"}
* Output: {username: "admin", password: "123456", subscription: ["news","offer"]}
* */
$.fn.serializeObject = function() {
var obj = {};
var arr = this.serializeArray();
arr.forEach(function(item, index) {
@rambabusaravanan
rambabusaravanan / directory-index.js
Last active May 9, 2020 20:22
get S3 Directory Index as JSON
// source: https://gist.github.com/chinchang/8106a82c56ad007e27b1#file-xmltojson-js
function xmlToJson(xml) {
if (typeof xml === 'string') {
parser = new DOMParser();
xml = parser.parseFromString(xml, 'text/xml');
}
// Create the return object
var obj = {};