wavezhang

Sub 合并相同的单元格()

Dim ln%, a%, b%

Application.DisplayAlerts = False

ln = [A65536].End(xlUp).Row

For b = 1 To 5 Step 1

wavezhang

#!/bin/bash

file=$1
part=$2
dest=$3

if [[ -z $part || -z $file || -z $dest ]];then
  echo "usage $0 file part dest"
  exit 1
fi

wavezhang

#!/bin/bash

POD_CIDR="100.64.0.0\/14"
CTL_MGR_CFG=/etc/kubernetes/manifests/kube-controller-manager.yaml 

kubectl apply -f  https://docs.projectcalico.org/v3.1/getting-started/kubernetes/installation/hosted/calicoctl.yaml

echo "Updating kube controller manager params..."
sed -i "s/--cluster-cidr=.*/--cluster-cidr=$POD_CIDR/g" $CTL_MGR_CFG

wavezhang

yum install -y expect
chmod +x ssh-copy-id.exp
for i in `seq 12 25`; do 
  ./ssh-copy-id 192.168.1.$i root 'password'
done

wavezhang

apiVersion: extensions/v1beta1
kind: PodSecurityPolicy
metadata:
  name: restricted
  annotations:
    seccomp.security.alpha.kubernetes.io/allowedProfileNames: 'docker/default'
    apparmor.security.beta.kubernetes.io/allowedProfileNames: 'runtime/default'
    seccomp.security.alpha.kubernetes.io/defaultProfileName:  'docker/default'
    apparmor.security.beta.kubernetes.io/defaultProfileName:  'runtime/default'
spec:

wavezhang

setcap 'cap_net_bind_service=+ep' /usr/lib/jvm/jre/bin/java

wavezhang

wget -c --no-cookies --no-check-certificate --header "Cookie: oraclelicense=accept-securebackup-cookie"  https://download.oracle.com/otn-pub/java/jdk/12.0.2+10/e482c34c86bd4bf8b56c0b35558996b9/jdk-12.0.2_linux-x64_bin.tar.gz

wavezhang

#! /usr/bin/perl
#
# based on https://stackoverflow.com/a/87531/5742651
# usage: sqlite3 .dump database_name.sqlite3 | perl sqlite2mysql.pl | mysql -u root -p $import_database_name
#
# ignore follow lines:
#   BEGIN TRANSACTION 
#   COMMIT 
#   sqlite_sequence 
#   CREATE UNIQUE INDEX