Следует кратко указать имя сервиса в имени раздела.
Например, https://partners.delivery-club.ru это партнёрское API Delivery Club. Значит папка будет называться partners_delivery_club.
| # Globally enable gpg signing. | |
| # Now you will be forced to decide should you disable or enable gpg signing feature for each repo. | |
| # If you don't do anything, making a commit will be impossible. | |
| git config --global commit.gpgsign true | |
| # Disable GPG-signing for this repo only | |
| git config --local commit.gpgsign false | |
| # Enable GPG-signing for this repo only by setting the GPG key id | |
| git config --local user.signingkey $KEY_ID |
| -- Контроль целостности торгового каталога Битрикса: найти отсутствующие сущности "продукт" | |
| SELECT E.IBLOCK_ID AS IblockId, | |
| E.ID AS ElementId, | |
| E.NAME AS ElementName, | |
| E.ACTIVE AS ElementActive, | |
| CP.ID, | |
| CP.TYPE | |
| FROM b_catalog_iblock AS CI | |
| INNER JOIN b_iblock_element AS E ON E.IBLOCK_ID = CI.IBLOCK_ID |
| -- Собрать id пользователей, данные которых требуется сохранить. | |
| -- (вместо "ID not in(6)" следует описать условие выборки групп пользователей для сохранения) | |
| create temporary table if not exists `tmp_keep_users_id_list` (`ID` int(18) NOT NULL); | |
| truncate `tmp_keep_users_id_list`; | |
| insert into `tmp_keep_users_id_list` ( | |
| select U.ID | |
| from b_user as U | |
| inner join b_user_group as UG | |
| on U.ID = UG.USER_ID | |
| where |
| # WARNING!!! This is VERY DANGEROUS command! | |
| # Deletes ALL TABLES in $DBNAME database QUICKLY and IRREVERSIBLY! | |
| mysql -h $DBHOST -u $DBUSER $DBNAME -p \ | |
| -BNe 'show tables' \ | |
| | tr '\n' ',' \ | |
| | sed -e 's#,$##' \ | |
| | sed -e 'i\/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;' \ | |
| -e 'i\DROP TABLE IF EXISTS ' \ | |
| -e 'a\;' \ | |
| -e 'a\/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;' \ |
| # Должен быть установлен GnuPG | |
| # GnuPG must be installed | |
| # Импортировать мой публичный ключ с сервера | |
| # Import my public key from the server | |
| gpg --auto-key-locate hkps://keys.openpgp.org --locate-keys [email protected] | |
| # Получить список всех публичных ключей с идентификаторами. | |
| # List all public keys with IDs | |
| gpg --list-public-keys --keyid-format LONG |
| # Find | |
| ("[^"]+":)\s+("[^"]+")\n | |
| # Replace(with the space at the end!) | |
| $1$2 | |
| # Example | |
| # Before: |
| # Terminal Tab #1 (with privileges inside container) | |
| # ============= | |
| cd "/the/dir/you/want/to/work/with/php8" | |
| docker run --name php8 \ | |
| -it \ | |
| -v $PWD:/var/php:rw \ | |
| php:8.0-cli-alpine3.12 \ | |
| ash | |
| cd /tmp |
| # Write local | |
| git config --local commit.gpgsign false | |
| # Read local (if never set, can be an empty value) | |
| git config --local commit.gpgsign |