Skip to content

RobbieLD/useful-scripts

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

24 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Index of Scripts

This is a list and brief description of scripts which are contain useful examples of how to do common things in a variety of languages.

Node

parser-data.js - Reads and writes large CSV files using pipes.

parser-headings.js - Reads large cvs files and creates unique list of values using pipes.

test-case-converter.js - Parses CSV files and creates C# test case class using pipes.

extract-text-from-lines.js - Parses a file line by line and extracts values from each line based on a test. Uses node readline in an async self executing function.

log-analyser.js - Extracts information from a log file.

Powershell

Invoke-Coverage.ps1 - Runs dotnet test with coverage using Coverlet.MSBuild or Coverlet.Collector and merges the results into a report using ReportGenerator.

New-PullRequest.ps1 - Opens your browser to the new pull request page for the current checked out branch. Currently supports Azure DevOps and BitBucket.

New-Sln.ps1 - Creates a new .sln file for the csproj projects in the current directory matching the directory structure with solution directories.

String-Split-Extractor.ps1 - Example usage of using String-Split to find lines in a file and then piping that into String-Split again to use regex to extract values from the selected lines.

Photo-Import.ps1 - Copies photos from a memory card to a hard drive. Also creates a destination folder with the current date and optional name tag.

Upload-Strava-Activities.ps1 - Performs the Strava OAuth flow and uploads activities from a garmin device.

Git-Log-Parse.ps1 - Parses the git log for specific messages and outputs a mark down table derived from the git log.

Template-Replacer.ps1 - Opens a template file and replaces the tokens from a variable dictionary.

Get-Pod-Logs.ps1 - Gets all the pod logs form a k8s cluster based on supplied parameters.

SQL

Current_Sessions.sql - Selects the sessions currently logged in to the database.

Max_By_Order - Selects records which have a max value of a grouping using a partition over clause.

Table_Size.sql - Returns the sizes of the tables in the database.

Users.sql - Creates a login and user and grants it permissions for a table. Also includes scripts to remove user and login.

About

Useful Scripts

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors