ezhov-da

В случае, если в БД были удалены таблицы, это удаление можно отменить. Для этого:

1. Получить список дропнутых таблиц, которые нужно восстановить:

SELECT 
  ORIGINAL_NAME, 
  DROPTIME 
FROM 
  user_recyclebin 
WHERE 

ezhov-da

<?xml version="1.0" encoding="UTF-8"?>
<!--https://github.com/liquibase/liquibase/blob/master/liquibase-standard/src/main/resources/www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.2.xsd-->
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
            targetNamespace="http://www.liquibase.org/xml/ns/dbchangelog"
            xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
            elementFormDefault="qualified">

    <xsd:simpleType name="propertyExpression" id="propertyExpression">
        <xsd:restriction base="xsd:string">
            <xsd:pattern value="$\{[\w\.]+\}"/>

ezhov-da

Function EXTRACT_CODE(cell)
    Dim result As String
    Dim allMatches As Object
    Dim RE As Object
    Set RE = CreateObject("vbscript.regexp")
    
    RE.Pattern = "[0-9]{6}"
    RE.Global = True
    RE.IgnoreCase = True
    Set allMatches = RE.Execute(cell)

ezhov-da

close, closes, closed, fix, fixes, fixed, resolve, resolves, resolved

Пример: close #48 #38

ezhov-da

https://confluence.atlassian.com/fishkb/unable-to-clone-git-repository-due-to-self-signed-certificate-376838977.html

git -c http.sslVerify=false clone <repository-name>

или

git config --global http.sslVerify false

ezhov-da

Sub DownloadAttachmentsOfSelectedEmails()
    Const XLSX_EXTENSION_PATTERN As String = "xlsx" 'расширение для вложения
    Const XLS_EXTENSION_PATTERN As String = "xls" 'расширение для вложения
    Const PATH As String = "C:\Users\DEzhov\Attachments\" 'папка для сохранения
 
    Dim myOlExp As Outlook.Explorer
    Dim myOlSel As Outlook.Selection
    Dim mySender As Outlook.AddressEntry
    Dim oMail As Outlook.MailItem
 

ezhov-da

import java.io.IOException;
import java.net.URISyntaxException;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.security.KeyFactory;
import java.security.NoSuchAlgorithmException;
import java.security.PrivateKey;
import java.security.interfaces.RSAPublicKey;
import java.security.spec.InvalidKeySpecException;
import java.security.spec.PKCS8EncodedKeySpec;

ezhov-da

FROM nginx:alpine

# https://thepracticalsysadmin.com/templated-nginx-configuration-with-bash-and-docker/
ENV LISTEN_PORT=80 \
  NGINX_ENV=production \
  SERVER_NAME=_ \
  RESOLVER=8.8.8.8 \
  UPSTREAM_API=api:3000 \
  UPSTREAM_API_PROTO=http \
  WORKDIR=/www \

ezhov-da

Use: for testing against email regex
ref: http://codefool.tumblr.com/post/15288874550/list-of-valid-and-invalid-email-addresses


List of Valid Email Addresses

email@example.com
firstname.lastname@example.com
email@subdomain.example.com
firstname+lastname@example.com

ezhov-da

Win + G