NaserKhoshfetrat

# Monthly CSV Combiner
Write-Host "Monthly CSV Combiner" -ForegroundColor Cyan

# -------------------- FUNCTION DEFINITIONS --------------------

function New-OutputFolder {
    <#
    .SYNOPSIS
    Creates the output folder if it doesn't exist
    #>

NaserKhoshfetrat

function G2J(gDates) {
  // Handle arrays and single values
  if (Array.isArray(gDates)) {
    return gDates.map(row => row.map(cell => convertToJalaliSafe(cell)));
  }
  return convertToJalaliSafe(gDates);
}

function convertToJalaliSafe(gDate) {
  // Normalize input to a JS Date

NaserKhoshfetrat

#change user in terminal to postgres user
sudo -i -u postgres

#interact with psql
psql

#Create a new database user (role with login privileges) named 'backup_user'. This user is specifically intended for backup operations or read-only access. WARNING: change password
#Grant the built-in 'pg_read_all_data' system role to the user. This gives the user permission to SELECT/read data from ALL tables, views, and sequences. across the ENTIRE PostgreSQL cluster (all databases), without needing per-object grants.
#Grant the user permission to establish a connection (CONNECT) specifically. to the database named 'change_db_name'. Without this, the user cannot log into that database.
CREATE USER backup_user WITH PASSWORD 'change_me';

NaserKhoshfetrat

#check sign version v1 and v2
java -jar .\apksigner.jar verify --verbose --print-certs .\test-app.apk 

#check sign version v1, v2, v3, v4 which set by enableV3Signing, enableV4Signing 
java -jar .\apksigner.jar verify -v -v4-signature-file .\test-app.apk.idsig .\test-app.apk

NaserKhoshfetrat

#######################################################################################################
##os-centos-7##

#get centos version
$cat /etc/centos-release

#get system info
$hostnamectl

#get kernel

NaserKhoshfetrat

SWITCHOFFSET(CONVERT(datetimeoffset, [CreatedAt]), DATENAME(TzOffset, SYSDATETIMEOFFSET())) 

NaserKhoshfetrat

git clean -xdf --dry-run //to remove absolutely every file on the .gitignore list

dotnet new gitignore //touch .gitignore

NaserKhoshfetrat

-- sys.dm_os_performance_counters is a system Dynamic Management View (DMV) that returns one row for each SQL Server performance counter. It's useful for obtaining information about current performance counter values.
declare @cntr_value bigint
Select @cntr_value=cntr_value
from sys.dm_os_performance_counters
where instance_name='Fabrics' and
counter_name='Write Transactions/sec'

waitfor delay '00:00:01'

Select cntr_value -@cntr_value

NaserKhoshfetrat

--<sys.sp_MSforeachtable>: execute sp_spaceused for all of database table
--<sp_spaceused>: return rows, index size and data size of table
EXEC sys.sp_MSforeachtable 'sp_spaceused ''?''';
--or as table

USE [Fabrics]
GO
CREATE TABLE #TableSpaceUsed(
[name] [nvarchar](120) NULL,
[rows] [nvarchar](120) NULL,

NaserKhoshfetrat

-- Fabrics V1.2 
-- Creating a SQL database from scratch
USE Fabrics
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_Fabrics]') AND type in (N'P', N'PC'))
    DROP PROCEDURE usp_Fabrics
GO
CREATE PROCEDURE [dbo].usp_Fabrics
    (@CreateClients INT = 2500,
    @CreateOrders INT = 5000)