My Groovy HelloScript contribution to community

Here goes my contribution to HelloScript project by Praseed Pai.

GitHub: https://github.com/praseedpai/HelloScript_files/blob/master/Groovy/HelloScript.groovy

Source Code:

001 /**
002  * HelloScript.groovy
003  */
004
005 //  A Simple Console Output
006
007     println "Hello World"
008
009 //  Some more
010     print ("Hello World")
011     System.out.println("K-Mug"); // Java style also works
012
013 // Declare variables
014     def a 100 // a number, def is about scope
015     100// another number
016     year "Twenty Twenty" // a string
017
018 // String formatting & interpolation
019     println "This is ${a}${b}, and " year;
020
021 // Reassign a variable
022     year 2008// dynamic typing
023
024 // if-else
025     if (year 2008)
026         println "Welcome to the future - yes, we have flying cars!"
027     else if (year 2008)
028         printLN "The past - please don't change anything. Don't step on any butterflies. And for the sake of all thats good and holy, stay away from your parents!"
029     else
030         println "Anything wrong with your time machine? You have not gone anywhere, kiddo."
031
032
033 // Range based for loop
034 for (i in 0..3) {
035     println "$i Hi there!"
036 }
037
038 // Copying range value to a variable
039     range_array = (0..10)
040     print range_array;
041
042 // Array demo
043     rules = ['Do no harm','Obey','Continue Living']
044     println rules;
045
046     rules << "Be Honest" // add one more item
047     println rules
048
049 // Array demo, with mixed types
050     more_rules = ['Do no harm','Obey','Continue Living'404403500100f]
051     println more_rules;
052
053 // Loop through Array
054     0
055     while (rules.size()) {
056         print "Rule " + (1) + " : " rules[i]
057         += 1
058     }
059
060     println() // just a newline
061
062 // Associating array
063     associated = [
064         'hello'    :    'world',
065         'foo'    :    'bar',
066         'lorem'    :    'ipsum'
067     ]
068
069     for (ele in associated) {
070         print ele.key " : " ele.value
071     }
072
073     println() // just a newline
074
075 // Example of a Nested Loop
076 // To calculate Pythagorean Triplets
077     10
078     println "-------------------------------------"
079     for (va in (1..n)) {
080         for (vb in (va..n)) {
081             Integer c_square va**vb**2
082             Integer vc Math.sqrt(c_square)
083             if ((c_square vc**2) == 0) {
084                 println va " " vb " " vc
085             }
086         }
087     }
088     println "----------------------------------"
089
090 // Iterating over a list using range and size
091     println "-------------------------------------"
092     fibonacci = [0,1,1,2,3,5,8,13,21]
093     for (i in (0..fibonacci.size()-1)) {
094         println i " " fibonacci[i]
095     }
096     println "---------------------------------------"
097
098 // Parsing a line - split and join
099     csv_values "hello,world,how,are,you".split(",")
100     println csv_values;
101     println csv_values.join(":")
102
103 // A Single Argument Function
104     def hello(name) {
105         return "Hello ${name}!"
106     }
107     println hello("Praveen")
108
109 // A simple class
110     class Movie {
111         String name ""
112         Integer rating 0
113
114         def Movie(movieName) {
115             this.name movieName
116             this.rateMovie()
117         }
118
119         def rateMovie() {
120             this.rating = (this.name.length() % 10) + 1     // IMDBs rating algorithm. True story!
121         }
122         def printMovieDetails() {
123             println "Movie : " +   this.name
124             println "Rating : " '*'.multiply(this.rating)  +  "(" this.rating +")"
125         }
126     }
127
128 // Create the Object
129     ncfom = new Movie("New Country for Old Men");     // It's a sequel!
130     ncfom.printMovieDetails()
131
132 // Closures in action
133     myList = ["Hello","My","World","What's","Up"]
134     myList.each {
135         print it "-" // it is special
136     }
137
138 // Multiplication table
139     (1..10).each {
140         println "${it} x 2 = ${it*2}"
141     }
142
143     println() // just a newline
144
145 // Tuples
146     myTuple = new Tuple(1'two'3'four')
147     println myTuple
148
149 // File IO - Create a new file
150     myFile = new File("myfile.txt");
151     myFile.text "Hello World! - from the file"
152     myFile.createNewFile()
153
154 // File IO - Read from file
155     println myFile.text
156
157 // File IO - With closure
158     myFile.eachLine {
159         -> println l.toUpperCase()
160     }
161
162 // Regular Expressions
163     import java.util.regex.Pattern
164     Pattern pattern = ~/World/
165     str "Hello World, this is Universe, not your World!"
166     println "Found " pattern.matcher(str).size() + " mathes."

View in GitHub | Made with wp-showgithubfile plugin [Code generated by wp-ShowGithubFile plugin]

WordPress plugin – Show your source code directly from GitHub in your blog/website

Show a file, preferably source code file content in a WordPress blog post or page.  This plugin shows always the latest code from GitHub.

Visit my GitHub repository to download the plugin for free – https://github.com/ninethsense/wp-ShowGithubFile

screenshot

Source Code: (Live Example directly from GitHub 🙂

001 <?php
002 /**
003  * Plugin Name: wp-ShowGithubFile
004  * Description:       Show a file, preferably source code file content in a WordPress blog post or page
005  * Version:           1.0.0
006  * Author:            NinethSense
007  * Author URI:        https://blog.ninethsense.com/
008  * License:           GPL v2 or later
009  */
010
011
012     add_shortcode"GitHub""ShowGitHub" );
013     function ShowGitHub($atts) {
014         if (!isset($atts["file"]) && !strpos(strtolower($atts["file"]), "https://raw.githubusercontent.com/" )) {
015             // Also, I want only files from GitHub. Modify this to show file from any URL
016             return "[Invalid GitHub Raw file]";
017         }
018         
019         $fh = @get_headers($atts["file"]);
020         
021         if (strpos($fh[0],"200") == 0) {
022             return "[Invalid file]";
023         }
024         
025         $fcontents file_get_contents(trim($atts["file"]));
026         $notphp false;
027         
028         if (strpos($fcontents"?php") == false) {
029             $fcontents "<?php ".$fcontents;
030             $notphp true;
031         }
032         
033         // Make use of PHP syntax highlighing. Something is better than nothing.
034         $fcontents highlight_string($fcontentsTRUE);
035         
036         if ($notphp) {
037             $fcontents str_replace("&lt;?php&nbsp;""",$fcontents);
038             $notphp false;
039         }
040
041         $fcontents str_replace(["<code>""</code>"], "",$fcontents);
042         
043         $fcontents explode("<br />",$fcontents);
044         
045         $style = (isset($atts["style"])) ?$atts["style"]:"";
046         $ret "<div style='font-family:monospace;background-color:#dcd7ca;width:100%;overflow:auto;white-space:nowrap;border:solid 1px #aaa;font-size:10pt;$style'>";
047         for ($i=0;$i<sizeof($fcontents);$i++) {
048             $line $fcontents[$i];
049             $ret .= "<span style='font-size:10pt;display:block;width:40px;background-color:#aaa;float:left'>" 
050                 str_pad($i+13,'0',STR_PAD_LEFT) ." </span><span style='margin-left:10px;width:100%;inline-block'>" $line "</span><br />";
051         }
052         $ret .= "</div>";
053        
054         file_put_contents("D:\\test.txt"$ret);
055         return $ret;
056
057         
058     }
059 ?>

View in GitHub | Made with wp-showgithubfile plugin

PHP PortPing script – check host connectivity

Here is a script in PHP I wrote to check if a remote host and port are open for you to connect. Do not mistake this as an equivalent to ping command because ping uses ICMP and I used TCP using PHP’s famous fsockopen() function, and a small piece of AJAX.

PortPing

You can get the latest source code from my GitHub code share page – https://github.com/ninethsense/code-share/

PHP:

function ping($host, $port) {
         $startTime = time();
         if ($fs = fsockopen($host, $port, $errCode, $errStr, 1)) {
             $timeTaken = (time()-$startTime)/1000;
         echo "Reply from $host:$port time={$timeTaken}ms";
             fclose($fs);
         } else {   
             echo "Request timed out.";
         }
         echo "<br>";
     }

JavaScript:

var count = 0;
             var intervalID = setInterval(function PortPing() {
                 var xhttp = new XMLHttpRequest();
                 xhttp.onreadystatechange = function() {
                     if (this.readyState == 4 && this.status == 200) {
                         document.getElementById("console").innerHTML += this.responseText;
                     }
                 };
                 xhttp.open("GET", "PortPing.php?source=self&host=<?=$host?>&port=<?=$port?>", true);
                 xhttp.send();
                 if (++count > <?=$t-1?>) {
                     clearInterval(intervalID);
                 }
             },2);

A simple Folder Watcher for windows

Here is a simple file system watcher for windows. I wrote a script to monitor a folder for a specific purpose, but then thought to make this a generic tool so someone will benefit if I host in GitHub.

FolderWatcher

 

Find full project at https://github.com/ninethsense/FolderWatcher

 

Source Code:

private void Form1_Load(object sender, EventArgs e)
{
    toolStripLabel.Text = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);

    StartMonitoring();
}

private void StartMonitoring()
{
    watcher = new FileSystemWatcher(toolStripLabel.Text)
    {
        IncludeSubdirectories = true,
        EnableRaisingEvents = true
    };
    watcher.Created += Watcher_Handler;
    watcher.Deleted += Watcher_Handler;
    watcher.Renamed += Watcher_Handler;
    watcher.Changed += Watcher_Handler;
}

private void Watcher_Handler(object sender, FileSystemEventArgs e)
{
    Invoke(new Action(() =>
    {
        listBoxLog.Items.Add($"[{DateTime.Now}][{e.ChangeType}] {e.FullPath}");
    }));
}

private void ToolStripClearButton_Click(object sender, EventArgs e)
{
    listBoxLog.Items.Clear();
}

private void ToolStripChooseFolderButton_Click(object sender, EventArgs e)
{
    watcher.EnableRaisingEvents = false;
    folderBrowserDialog.SelectedPath = toolStripLabel.Text;
    var dlg = folderBrowserDialog.ShowDialog();

    if (dlg == DialogResult.OK)
    {
        string OldPath = toolStripLabel.Text;

        try
        {
            watcher.Path = folderBrowserDialog.SelectedPath;
            watcher.EnableRaisingEvents = true;
        } catch (FileNotFoundException ex)
        {
            toolStripLabel.Text = OldPath;
            watcher.Path = OldPath;

            MessageBox.Show($"Seems you don't have permission to access folder        {folderBrowserDialog.SelectedPath}. Try starting this app as Administrator\n\nDetails:\n{ex.Message}", "Error", MessageBoxButtons.OK);
            watcher.EnableRaisingEvents = true;
        }
            toolStripLabel.Text = watcher.Path;

    }

}

Create AWS Lambda function with .NET Core / C# and create a HTTP API Gateway trigger | Part #2

In this Part #2 of blog I will be creating a new .NET Core function in local machine and will upload to AWS using console interface. There are different ways you can develop and deploy but I will be talking in this blog only about the CLI way.

I am assuming you know how to create a Lambda function in AWS console already and if not, please read the Part #1 first.

Open the Command prompt and follow below steps:

Step 1: Install Lambda Templates for .NET Core

dotnet new -i Amazon.Lambda.Templates

Step 2: Create an empty function

dotnet new lambda.EmptyFunction –name MyTestLambdaFun


You should be able to see a folder structure like this is created.

image

under src\projectname you can see a Function.cs file which is our starting point.

Code will look like this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

using Amazon.Lambda.Core;

// Assembly attribute to enable the Lambda function's JSON input to be converted into a .NET class.
[assembly: LambdaSerializer(typeof(Amazon.Lambda.Serialization.SystemTextJson.DefaultLambdaJsonSerializer))]

namespace MyTestLambdaFun
{
     public class Function
     {
        
         /// <summary>
         /// A simple function that takes a string and does a ToUpper
         /// </summary>
         /// <param name="input"></param>
         /// <param name="context"></param>
         /// <returns></returns>
         public string FunctionHandler(string input, ILambdaContext context)
         {
             return input?.ToUpper();
         }
     }
}

Step 3 – Modify the code to return HTTP 200 status code.

It is necessary for lambda functions to return 200 status code, or else the function will work in AWS console when you “Test”, but the API Gateway endpoint will not.

After adding the StatusCode property, the function will look like this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

using Amazon.Lambda.Core;

using Amazon.Lambda.APIGatewayEvents;

// Assembly attribute to enable the Lambda function's JSON input to be converted into a .NET class.
[assembly: LambdaSerializer(typeof(Amazon.Lambda.Serialization.SystemTextJson.DefaultLambdaJsonSerializer))]

namespace MyTestLambdaFun
{
     public class Function
     {
        
         /// <summary>
         /// A simple function that takes a string and does a ToUpper
         /// </summary>
         /// <param name="input"></param>
         /// <param name="context"></param>
         /// <returns></returns>
         public APIGatewayProxyResponse FunctionHandler(ILambdaContext context)
         {
             return new APIGatewayProxyResponse
             {
                 Body = "Hello Lambda, from Praveen",
                 StatusCode = 200
             };

            
         }
     }
}

Do:

dotnet build


Now, if you are getting an error on APIGatewayProxyResponse, then you will have to install the dependency. Below command will help you:


dotnet add package Amazon.Lambda.APIGatewayEvents 

(Refer to nuget page)

Try again dotnet build, and I am expecting to have the build succeeded.

image

Step 4 – Package the function

If you have not installed Lambda tools, then install it first:

dotnet tool install -g Amazon.Lambda.Tools

Then use the command:

dotnet lambda package

image

Notice the last line, you will get path to a zip file which you have to upload to AWS Lambda.

Step 5 – Upload the package to AWS console

Login to AWS Console and navigate to your lambda function. In this example I am going to use the same function we created in Part #1.

Scroll up and you should see a “Function Code” section like this:

image

Upload your ZIP file by clicking the upload button.

Next, you have to do one important task. Go to the source code folder again and open a file named “aws-lambda-tools-defaults.json”.  You will have to copy the function-handler property value to the “Handler” textbox in “Function code” section.

image

image

image

Then click “Save” button.

Step 6 – Test the function

Click “Test”. You should see the test result like this: (Our function is not expecting an input parameter so you can create a dummy test event)

image

As a bonus, let us see how we can create a HTTP endpoint to this function.

Step 7 – Create API Gateway

Click “Trigger” button:

image

In the next screen, make these selections and click “Add”:

image

You will be redirected back to the dashboard. Scroll up and you will see a new section “API Gateway” with a new API endpoint URL. Use the link in browser to test.

image

image

Happy Lambda development!

You have noticed that I was rushing to finish the blog by not explaining in detail each step. I am leaving the rest to you as home work intentionally.

Refer to official .NET Core CLI documentation here.

Clone/Copy SQL Server Database with timestamp in name

This script works on Azure SQL Database also.

 DECLARE @cmd nvarchar(255) SET @cmd = N'CREATE DATABASE ' + CONCAT('MyDB_', REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(16), GETDATE(), 120), '-', ''),':',''),' ','_')) + ' AS COPY OF MyDB' EXECUTE sp_executesql @cmd 

Loop multiple videos in HTML5 video tag

<video id="v" autoplay>
       <source src="1.mp4" type="video/mp4">
     </video>

    <script>
         var c = 0;
         f = [
                 "1.mp4",
                 "2.mp4",
                 "3.webm"
             ];
         var v = document.getElementById('v');
         v.addEventListener('ended', function(e) {
             c = (c < f.length-1)?++c:0;
             v.src = f[c];
             v.play();
         });
     </script>

Ajax file uploader using jQuery

Here is a sample code to upload multiple files using ajax, and without using the traditional <form> tags. Find the full source code in GitHub – https://github.com/ninethsense/code-share/tree/master/jQuery-File-Upload .

<body>
    <input type="button" value="Choose file" id="fup" />

    <script src="https://code.jquery.com/jquery-3.4.1.min.js"></script>    

    <script>
            $(function() {

                // Show file upload dialog on click of button
                $("#fup").click(function(){

                    //Create File component
                    var fu = document.createElement("input");
                    fu.type = "file";
                    fu.id="fuc";
                    $(fu).attr("multiple","");

                    // Trigger file selection event
                    $(fu).change(function(){
                        var fd = new FormData();
                        $.each($(fu)[0].files, function(i, file){
                            fd.append('file[]', file);
                        });

                        // Send fd to server
                        $.ajax({
                            url:"FileUpload.php",
                            type: 'POST',
                            data:fd,
                            cache: false,
                            contentType: false,
                            processData: false,
                            success: function(d) {
                                console.log(d);
                            }
                        });
                    });

                    // To invoke the file selection dialog box
                    $(fu).click();

                });
            });
    </script>
</body>

Sample server code in PHP for the reference:

foreach ($_FILES['file']['tmp_name'] as $k => $v) {
move_uploaded_file(
$_FILES['file']['tmp_name'][$k],
$_FILES['file']['name'][$k]
);
}

Join two XML files using XSL Transformation

This blog demonstrates how you can JOIN (yes, like in SQL) two xml (datasets) to one using a common ID (relationship).

shop.xml


<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type='text/xsl' href='main.xsl'?>
<shop>
<product>
<id>100</id>
<title>hello</title>
</product>

<product>
<id>101</id>
<title>world</title>
</product>
<product>
<id>102</id>
<title>praveen</title>
</product>
</shop>

price.xml

<?xml version="1.0" encoding="UTF-8"?>
<shop>
<product>
<id>100</id>
<price>10.0</price>
</product>
<product>
<id>101</id>
<price>10.1</price>
</product>
<product>
<id>102</id>
<price>10.2</price>
</product>
<product>
<id>103</id>
<price>10.3</price>
</product>

</shop>

main.xsl


<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes" />

<xsl:param name="fileName" select="'price.xml'" />

<xsl:variable name="updateItems" select="document($fileName)/shop/product" />

<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()" />
<xsl:copy-of select="$updateItems[id=current()/id]/price" />
</xsl:copy>
</xsl:template>
</xsl:stylesheet>

Resulting XML, after transformation should look like:


<?xml version="1.0" encoding="utf-8"?>
<?xml-stylesheet type='text/xsl' href='main.xsl'?>
<shop>
<product>
<id>100</id>
<title>hello</title>
<price>10.0</price>
</product>
<product>
<id>101</id>
<title>world</title>
<price>10.1</price>
</product>
<product>
<id>102</id>
<title>praveen</title>
<price>10.2</price>
</product>
</shop>

Bonus code, if some .net developers want a transformation code:


XslTransform xslt = new XslTransform();
xslt.Load(@"D:\Websites\xmltest\main.xsl");
xslt.Transform(@"D:\Websites\xmltest\shop.xml", @"D:\Websites\xmltest\out.xml");
textBox1.Text = System.IO.File.ReadAllText(@"D:\Websites\xmltest\out.xml");

Programming Puzzle #2 – Leet Converter

Write a program in a computer language of your choice to convert any given text to “leet format” in real time.

Leet (or “1337”), is a system of modified spellings used primarily on the Internet.

Input: “Translator” Output:”Tr4nsl4t0r”
Input: “leet”, Output: “l33t”
Input: “Good Morning”, Output: “G00d M0rn1ng”

Evaluation criteria:

  1. Code Quality Standards
  2. OOAD/Object-Oriented Analysis & Design
  3. Application Logic
  4. Exception Handling
  5. Simplicity and Effectiveness of code

Time: 0-30 minutes max.