Skip to content

Instantly share code, notes, and snippets.


Suresh Raju Pilli psrdotcom

View GitHub Profile
psrdotcom /
Created Oct 5, 2020
Convert JSON object array to CSV File
import json
import csv
# Read JSON File
with open('users.json') as json_file:
data = json.load(json_file)
user_data = data['users']
# Prepare CSV file
psrdotcom / GeoLocationTest.html
Created Jan 6, 2020
Geo Location Test using Leaflet JavaScript
View GeoLocationTest.html
<TITLE>PSR Geo Location Test</TITLE>
<link rel="stylesheet" href=""
<script src=""
psrdotcom / truecryptMountUnmount.bat
Created Aug 8, 2019
Truecrypt Mount and Unmount in Windows Batch file
View truecryptMountUnmount.bat
@echo off
set TrueSource=E:\ProgramFiles\TrueCrypt\truecrypt
set Source=E:\ProgramFiles\TrueCrypt\test
set Drive=P:
set KeyFile=E:\ProgramFiles\TrueCrypt\keyfile1
set Password=abcd1234ABCD!@#$
set BrowserPath="C:\Program Files (x86)\Internet Explorer\iexplore.exe"
set WebSite=ELS
set URL="http://localhost:86"
psrdotcom /
Last active Jul 23, 2019
Postgre SQL Connection Testing with Java
* This Java source file was to test the database connection.
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
psrdotcom /
Created Apr 5, 2017
Java command injection example
* Assuming user has folder "Important" -> C:/Important
* The folder has confidential data
* In this example, we are trying to show the command injection attack
public class CommandInjectionExample {
public static void main(String[] args) {
psrdotcom / ConvertCurrencyToEnglish.txt
Created Mar 31, 2017
Conver Number to Textual (English) representation - Microsoft Excel Macro - (Supports only Rupees and Euros)
View ConvertCurrencyToEnglish.txt
Function ConvertRupeesToEnglish(ByVal MyNumber)
Dim Temp
Dim Rupees, Paise
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " lakh "
Place(4) = " Crore "
psrdotcom / deleteAllUserObjects.sql
Last active Mar 2, 2017
Oracle DB: Delete all user objects (Tables, Views, Procedures, Functions, Sequences, Types, Packages)
View deleteAllUserObjects.sql
FOR record IN (SELECT object_name, object_type
FROM user_objects
WHERE object_type IN
View dos2unixfolder.bat
for /f "tokens=* delims=" %%a in ('dir . /s /b') do (
"dos2unix.exe" %%a