pfrozi’s gists

pfrozi / sql.sql

Created July 7, 2020 17:44

[SQLServer]Consultas úteis para pesquisas

pfrozi / test.cs

Created July 7, 2020 17:47

test StringBuilder

	int size = 100000;
	long start;

	List<string> list = new List<string>(size);

	for(var i = 0; i < size; i++)
	list.Add($"string_{i}");

	Console.WriteLine("Aggregate string:");
	start = DateTime.Now.Ticks;

pfrozi / porextenso.cs

Last active May 27, 2021 13:57

Escrever numero por extenso

	using System;

	namespace PorExtenso
	{
	public class Program {

	public static void Main(){

	decimal x = 10011.56m;
	Console.WriteLine(x.PorExtenso());

pfrozi / gist:83b49674b82cd8bce792c253fa1b7d7e

Created July 7, 2020 17:52

[dotnet] Pattern dataAnnotation to FluentApi

	\[Column$\"(.+)\".+\"(.+)\"$\]\n.+public.+\s(.+)\s\{.+\}

	modelBuilder.Property(e => e.$3)\n .HasColumnName("$1")\n .HasColumnType("$2");

pfrozi / install_forticlient_linux.sh

Created August 27, 2020 13:24 — forked from PieterScheffers/install_forticlient_linux.sh

Install Forticlient on Linux

	# install ubuntu in virtual machine

	# https://ubuntuforums.org/showthread.php?t=1481300
	# Get arch type of ubuntu
	# i686 = 32 bit
	# x86_64 = 64 bit
	uname -m

	# download forticlient
	https://hadler.me/linux/forticlient-sslvpn-deb-packages

pfrozi / create_complete.sh

Last active September 23, 2020 13:18

Create a SQL Server script with all new .sql files from branch_with_new_scripts

	#!/bin/bash

	script=scripts_complete.sql

	rm -f $script

	for item in $(git diff-tree --name-only --no-commit-id -r master branch_with_new_scripts \| grep ".sql"); do
	cat $item >> $script
	echo >> $script
	echo GO >> $script

pfrozi / find-and-move.sh

Last active November 18, 2020 13:34

Replace filename, foldername and file content from a path.

	#!/usr/bin/env bash
	# $1: base path
	# $2: vendor name (lowercase)
	# $3: new vendor name (lowercase)

	# Sample: bash find-and-move.sh ~/workspace/company company company2

	path=$1

	vendor=$2

pfrozi / template.sh

Created February 12, 2021 03:55

Bash program template

	#!/usr/bin/env bash

	set -Eeuo pipefail
	trap cleanup SIGINT SIGTERM ERR EXIT

	script_dir=$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd -P)

	usage() {
	cat <<EOF
	Usage: $(basename "${BASH_SOURCE[0]}") [-h] [-v] [-f] -p param_value arg1 [arg2...]

pfrozi / changechset.sh

Last active February 12, 2021 21:51

Change the charset of a file

	#!/usr/bin/env bash

	set -Eeuo pipefail
	trap cleanup SIGINT SIGTERM ERR EXIT

	script_dir=$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd -P)

	usage() {
	cat <<EOF
	Usage: $(basename "${BASH_SOURCE[0]}") [-h] [-v] [-f] -i INPUT_FILE -e OUTPUT_CHARSET -o OUTPUT_FILE

pfrozi / create_job.sql

Created February 18, 2021 15:17

Create a new job on SQLServer

	EXEC dbo.sp_add_job
	@job_name = N'NameOfJob' ;
	GO
	EXEC sp_add_jobstep
	@job_name = N'NameOfJob',
	@step_name = N'Description of job step.',
	@subsystem = N'TSQL',
	@command = N'EXEC SP_MYJOB ''A'',''B'',''C'' ',
	@retry_attempts = 5,
	@retry_interval = 5 ;

	\[Column\(\"(.+)\".+\"(.+)\"\)\]\n.+public.+\s(.+)\s\{.+\}

	modelBuilder.Property(e => e.$3)\n .HasColumnName("$1")\n .HasColumnType("$2");

pfrozi pfrozi