Kirill Korveld

## Ternary operator multiple conditions
var foo = (
  bar === 'a' ? 1 : // if
  bar === 'b' ? 2 : // else if
  bar === 'c' ? 3 : // else if
  null // else
);

## MySql cheat sheet
SELECT * FROM `wp_posts` ORDER BY `wp_posts`.`post_date` DESC

Drop column
ALTER TABLE wp_posts DROP COLUMN Created;

Add column
ALTER TABLE wp_posts ADD COLUMN post_author INT DEFAULT 1 AFTER ID;

Rename column
ALTER TABLE wp_posts CHANGE COLUMN LastEdited post_date DATETIME;

## "fatal: unable to create threaded lstat" error when run "git status" command
If the resource limit can't be removed by the hosting provider, you could consider using git config to disable preloading of the index (threaded lstat).

git config core.preloadIndex false

If you need that setting when cloning the initial repository, then you will need to set it globally.

git config --global core.preloadIndex false

## Remove a folder from git tracking
Step 1. Add the folder path to your repo's root .gitignore file.
path_to_your_folder/

Step 2. Remove the folder from your local git tracking, but keep it on your disk.
git rm -r --cached path_to_your_folder/

Step 3. Push your changes to your git repo.

## Mac usb boot create commands
sudo /Applications/Install\ macOS\ Ventura.app/Contents/Resources/createinstallmedia --volume /Volumes/123

sudo killall Finder

sudo lsof +D "/Volumes/123”

mdutil -i off -d /Volumes/123/

rm -r /Volumes/123/.Spotlight-V100/Store-V2/

## Yarn: unable to verify the first certificate
navigate to C:\Users\\ and open .yarnrc and manually update it as follows:

# THIS IS AN AUTOGENERATED FILE. DO NOT EDIT THIS FILE DIRECTLY.
# yarn lockfile v1
strict-ssl false

## countdown.tsx
import React, { useEffect, useState } from 'react'
import classes from './index.module.scss'

const Countdown = () => {
  const [time, setTime] = useState({
    days: 0,
    hours: 0,
    minutes: 0,
    seconds: 0,
  })

## dateRangeSort.js
// Define the array of objects
const data = [
    { id: 1, date: '2023-05-15' },
    { id: 2, date: '2023-05-10' },
    { id: 3, date: '2023-05-20' },
    // Add more objects as needed
];

// Function to sort and filter the array by date range
function sortAndFilterByDateRange(array, startDate, endDate) {

## Redux Saga callback function
Reducer file (reducer.ts)
postFiatDepositRequest: (state, { payload }: PayloadAction<IPostFiatDepositWorker>) => {
  state.fiatTransactionsLoading = true;
},

Redux Saga file (saga.ts)
function* postFiatDepositWorker({ payload }: PayloadAction<IPostFiatDepositWorker>) {
  const { apiParams, onFinally } = payload;
  let hasError = false;
  try {

## mime.html
<html>
<head>
    <script type="text/javascript" src="/jquery.min.js"></script>
    <title>Mime type checker</title>
    <script>
        $(function () {
            var result = $('div#result');
            if (window.FileReader && window.Blob) {
                $('span#submit').click(function () {
                    var files = $('input#file').get(0).files;
	var foo = (
	bar === 'a' ? 1 : // if
	bar === 'b' ? 2 : // else if
	bar === 'c' ? 3 : // else if
	null // else
	);
	SELECT * FROM `wp_posts` ORDER BY `wp_posts`.`post_date` DESC

	Drop column
	ALTER TABLE wp_posts DROP COLUMN Created;

	Add column
	ALTER TABLE wp_posts ADD COLUMN post_author INT DEFAULT 1 AFTER ID;

	Rename column
	ALTER TABLE wp_posts CHANGE COLUMN LastEdited post_date DATETIME;
	If the resource limit can't be removed by the hosting provider, you could consider using git config to disable preloading of the index (threaded lstat).

	git config core.preloadIndex false

	If you need that setting when cloning the initial repository, then you will need to set it globally.

	git config --global core.preloadIndex false
	sudo /Applications/Install\ macOS\ Ventura.app/Contents/Resources/createinstallmedia --volume /Volumes/123

	sudo killall Finder

	sudo lsof +D "/Volumes/123”

	mdutil -i off -d /Volumes/123/

	rm -r /Volumes/123/.Spotlight-V100/Store-V2/
	navigate to C:\Users\\ and open .yarnrc and manually update it as follows:

	# THIS IS AN AUTOGENERATED FILE. DO NOT EDIT THIS FILE DIRECTLY.
	# yarn lockfile v1
	strict-ssl false
	import React, { useEffect, useState } from 'react'
	import classes from './index.module.scss'

	const Countdown = () => {
	const [time, setTime] = useState({
	days: 0,
	hours: 0,
	minutes: 0,
	seconds: 0,
	})
	// Define the array of objects
	const data = [
	{ id: 1, date: '2023-05-15' },
	{ id: 2, date: '2023-05-10' },
	{ id: 3, date: '2023-05-20' },
	// Add more objects as needed
	];

	// Function to sort and filter the array by date range
	function sortAndFilterByDateRange(array, startDate, endDate) {
	Reducer file (reducer.ts)
	postFiatDepositRequest: (state, { payload }: PayloadAction<IPostFiatDepositWorker>) => {
	state.fiatTransactionsLoading = true;
	},

	Redux Saga file (saga.ts)
	function* postFiatDepositWorker({ payload }: PayloadAction<IPostFiatDepositWorker>) {
	const { apiParams, onFinally } = payload;
	let hasError = false;
	try {
	<html>
	<head>
	<script type="text/javascript" src="/jquery.min.js"></script>
	<title>Mime type checker</title>
	<script>
	$(function () {
	var result = $('div#result');
	if (window.FileReader && window.Blob) {
	$('span#submit').click(function () {
	var files = $('input#file').get(0).files;