sagar290

-- Table Statistics
SELECT
    relname AS table_name,
    seq_scan,
    seq_tup_read,
    idx_scan,
    idx_tup_fetch,
    n_tup_ins,
    n_tup_upd,

sagar290

name: Build and Push Docker Image

on:
  push:
    branches:
      - master  # Specify the branches that should trigger the workflow

jobs:
  build-and-push:
    runs-on: ubuntu-latest

sagar290

<?php

namespace App\DTO;

use App\Interfaces\ActionServiceDTOInterface;
use Illuminate\Support\Str;

class BaseDto
{
    public function __construct(?array $data = null)

sagar290

# Add secret

apiVersion: v1
kind: Secret
metadata:
  name: mysql-secret
type: Opaque
data:
  MYSQL_ROOT_PASSWORD: bXlwYXNzd29yZAo=

sagar290

version: '3.8'

services:
  app:
    image: nginx
    volumes:
      - "./docker/nginx/sites/:/etc/nginx/conf.d"
    ports:
      - "80:80" 
    networks:

sagar290

upstream authUpstream {
    server auth:9090 max_fails=0 fail_timeout=10s;
    keepalive 512;
}

 upstream service1Upstream {
     server services1:9091 max_fails=0 fail_timeout=10s;
     keepalive 512;
 }

sagar290

# for select duplicate
SELECT * FROM `lb` t1, `users` t2 WHERE t1.user_id = t2.id AND t2.dff_stm = 1 ;

# for delete duplicate
DELETE t1 FROM `lb` t1, `users` t2 WHERE t1.user_id > t2.id AND t2.dff_stm = 1

sagar290

version: '3.1'

services:
  db_mysql:
    image: mysql
    command: 
      - --default-authentication-plugin=caching_sha2_password
    restart: always
    environment:

sagar290

DO
$$
DECLARE
    rec RECORD;
    lastId INT;
BEGIN
    FOR rec IN (SELECT table_name
                FROM information_schema.tables
                WHERE table_schema = (SELECT current_schema())
                  AND table_type = 'BASE TABLE')

sagar290

function power(base, exponent) {
  let result = 1;
  for (let i = 0; i < Math.floor(exponent); i++) {
    result *= base;
  }
  if (exponent % 1 !== 0) {
    result *= base ** (exponent % 1);
  }
  return result;
}