Gaurav Sharma gauravds

First run this command into adonisJS => node ace data:migrate > output.txt
You got output.txt with all commands that has to run. test this script on local system using backups of old and new, and finally you will get the exact order of execution regarding internal foreign key refernce.
Now let's do this on production db. generate a temp db as source_db and run this command with ofcource change the actual db names(source_db and dest_db).

P.S.:: I know one branch which is accidentally deleted was const branchId = 345 on const mainTable = 'branches' write your init logic according to that.

CSS Layout Debugger

A tweet-sized debugger for visualizing your CSS layouts. Outlines every DOM element on your page a random (valid) CSS hex color.

One-line version to paste in your DevTools

Use $$ if your browser aliases it:

~ 108 byte version

Local AWS lambda service call via sam / aws sam cli, you can also attach debugger to VSCode via configuration settings.json

$ sam local invoke --profile=dev MyServiceName1 -e events/events-MyServiceName1.json -n env/env-MyServiceName1.json

	package main

	import (
	"bytes"
	"encoding/json"
	"flag"
	"io"
	"log"
	"net/http"
	"os"

	version: '3.6'
	services:
	postgres:
	image: postgres
	restart: always
	platform: linux/amd64
	ports:
	- '5432:5432'
	environment:
	POSTGRES_PASSWORD: password

	version: '3.8'

	services:
	mysql:
	container_name: mysql-espo
	image: mysql:8.0.28
	command: --default-authentication-plugin=mysql_native_password
	restart: always
	platform: linux/amd64
	environment:

	version: '3.1'
	services:
	redis:
	image: redis:5-alpine
	platform: linux/amd64
	restart: unless-stopped
	container_name: redis
	ports:
	- '6379:6379'

	SELECT @@sql_mode;
	SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';
	SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION';

	-- other commands
	SELECT @@sql_mode;

	SET GLOBAL sql_mode=(SELECT CONCAT(@@sql_mode,',ONLY_FULL_GROUP_BY'));

	SET GLOBAL sql_mode = 'ONLY_FULL_GROUP_BY';

	const moment = require('moment')
	/**
	* Get time for next round off 10 minutes in epoch form.
	* @returns { number } epoch time
	*
	* if time is 17:23:32 => 17:30:00
	* if time is 17:53:32 => 18:00:00
	* if time is 23 Oct, 2023 23:53:32 => 24 Oct, 2023 00:00:00
	*/
	function getNextTimeClickFor10Minutes() {

	SHOW VARIABLES LIKE 'sql_mode';
	SET global sql_mode = 'NO_ENGINE_SUBSTITUTION';