实际应用中会出现需要减少导出的备份体积，然后在本地导入再开发，可以大幅缩短导入等待时间,方法如下

sed '/INSERT INTO `tablelog1`/d' xxxx.sql | sed '/INSERT INTO `tablelog2`/d' | sed '/INSERT INTO `tablelog3`/d' | sed '/INSERT INTO `tablelog4`/d' | sed '/INSERT INTO `tablelog5`/d' > reduced.sql

更好的方法

grep -vE 'INSERT INTO `(tablelog1|tablelog2|tablelog3|tablelog4)`' xxxx.sql > reduced.sql

原文链接: http://www.jiliuke.com/index.html

版权声明: 转载请注明出处.

1.nginx http://nginx.org/en/docs/configure.html

1
2
3
4
5
6
7
8
9
10
11

sudo apt update
sudo apt-get install build-essential libpcre3 libpcre3-dev zlib1g zlib1g-dev libssl-dev libgd-dev libxml2 libxml2-dev uuid-dev

cd ~
wget https://nginx.org/download/nginx-1.26.3.tar.gz
tar -zxvf nginx-1.26.3.tar.gz
cd nginx-1.26.3
./configure --prefix=/var/www/html --sbin-path=/usr/sbin/nginx --conf-path=/etc/nginx/nginx.conf --http-log-path=/var/log/nginx/access.log --error-log-path=/var/log/nginx/error.log --with-pcre  --lock-path=/var/lock/nginx.lock --pid-path=/var/run/nginx.pid --with-http_ssl_module --with-http_image_filter_module=dynamic --modules-path=/etc/nginx/modules --with-http_v2_module --with-stream=dynamic --with-http_addition_module --with-http_mp4_module
sudo make -j 4
sudo make install
nginx -V

安装nginx service

1

sudo deepin-editor /lib/systemd/system/nginx.service

粘贴以下代码并保存

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

[Unit]
Description=The NGINX HTTP and reverse proxy server
After=syslog.target network-online.target remote-fs.target nss-lookup.target
Wants=network-online.target

[Service]
Type=forking
PIDFile=/var/run/nginx.pid
ExecStartPre=/usr/sbin/nginx -t
ExecStart=/usr/sbin/nginx
ExecReload=/usr/sbin/nginx -s reload
ExecStop=/bin/kill -s QUIT $MAINPID
PrivateTmp=true

[Install]
WantedBy=multi-user.target

开启自启动

1

sudo systemctl enable nginx

2.php http://php.net/manual/en/install.unix.nginx.php

3.cmake http://www.cmake.org/download/

4.mysql

/lnmp/cmake/bin/cmake
-DCMAKE_INSTALL_PREFIX=/lnmp/mysql
-DMYSQL_DATADIR=/lnmp/mysql/data
-DSYSCONFDIR=/lnmp/mysql/etc
-DWITH_MYISAM_STORAGE_ENGINE=1
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_MEMORY_STORAGE_ENGINE=1
-DWITH_READLINE=1
-DMYSQL_UNIX_ADDR=/lnmp/mysql/mysql.sock
-DMYSQL_TCP_PORT=3306
-DENABLED_LOCAL_INFILE=1
-DWITH_PARTITION_STORAGE_ENGINE=1
-DEXTRA_CHARSETS=all
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci

make && make install

yum -y install ncurses-devel

新安装的mysql如果需要密码，查看cat /root/.mysql_secret中即为mysql的默认root密码

进入后set password=”123456”;

安装完成后需要添加php扩展，先cd到php安装源文件ext/gd(以安装gd为例)

/php路径/bin/phpize 生成configure文件

./configure –with-php-config=/php路径/bin/php-config

php查看安装的模块php -m

加入环境变量例子(环境变量地址：/etc/profile)

PATH=/lnmp/mysql/bin:$PATH

export PATH

source /etc/profile

原文链接: http://www.jiliuke.com/index.html

版权声明: 转载请注明出处.

Docker 安装rabbitmq

management的意思是带有UI的rabbitmq，如果需要web gui，安装带-management的版本，然后通过浏览器访问http://localhost:15672即可访问web gui，访问密钥默认是guest/guest.

1

docker run -d --name rabbitmq -p 5672:5672 -p 15672:15672 rabbitmq:3.12-management

原文链接: http://www.jiliuke.com/index.html

版权声明: 转载请注明出处.

Debian buster生命周期已结束， 可离线打包本地的包

安装 dpkg-repack 工具：

1
2

sudo apt-get update
sudo apt-get install dpkg-repack

列出已安装的软件包：
你可以使用 dpkg -l 命令列出系统上已安装的软件包，找到你想要重新打包的软件包名称。

1

dpkg -l | grep <package-name>

使用 dpkg-repack 重新打包：
运行以下命令，将 替换为你想要重新打包的软件包名称：

1

sudo dpkg-repack <package-name>

deb.sury.org 不再提供包，本地打包以便后续继续使用

1

dpkg -l|grep php8.2 | awk '/^ii/ {print $2}'| xargs -I {} sudo dpkg-repack {}

原文链接: http://www.jiliuke.com/index.html

版权声明: 转载请注明出处.

如果 docker ps -a 中太多，一次性删除方法

docker rm `docker ps -a -q --filter 'status=exited'`

debian apparmor linux内核安全模块影响docker运行，本地操作系统可以直接移除此包

sudo apt-get purge apparmor

docker使用代理获取镜像

某些原因docker被封禁，使用以下方法可以绕过

修改 daemon.json 文件

sudo vi /etc/docker/daemon.json
添加如下内容，使用官方镜像

{
 "registry-mirrors": [
    "https://hub.docker.com/"]
}

新建 proxy.conf 文件

mkdir -p /etc/systemd/system/docker.service.d
cd /etc/systemd/system/docker.service.d
touch proxy.conf
sudi vi /etc/systemd/system/docker.service.d/proxy.conf
添加如下内容：

[Service]
Environment="HTTP_PROXY=http://127.0.0.1:8889"
Environment="HTTPS_PROXY=http://127.0.0.1:8889"
重启 docker 服务

#加载变更的配置
systemctl daemon-reload
#重启docker服务
systemctl restart docker
查看配置是否生效

systemctl show --property=Environment docker

可用的docker镜像加速器，配置到daemon.json中

"https://docker.m.daocloud.io",
"https://docker.xuanyuan.me"

原文链接: http://www.jiliuke.com/index.html

版权声明: 转载请注明出处.

局域网远程开机(WOL)

前置条件，主板需要支持wakonlan，Deepin 20.9 为例

1.查看lan网卡是否开启WOL

1

sudo ethtool enp3s0

如果 Wake-on: d 表示未开启

2.设置 wake-on: g 开启WOL

1

sudo ethtool -s enp3s0 wol g

3.设置开机自启动

添加rc.local文件
sudo vim /etc/rc.local

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

#!/bin/bash
#
# rc.local
#
# This script is executed at the end of each multiuser runlevel.
# Make sure that the script will "exit 0" on success or any other
# value on error.
#
# In order to enable or disable this script just change the execution
# bits.
#
# By default this script does nothing.

/usr/sbin/ethtool -s enp3s0 wol g

exit 0

1
2

sudo chmod +x /etc/rc.local
sudo systemctl enable rc-local

然后重启计算机

4.另外一台局域网电脑安装wakeonlan

1

sudo apt-get install etherwake

5.发送数据包到上面配置的电脑的MAC地址启动

1

wakeonlan {MAC Address}

原文链接: http://www.jiliuke.com/index.html

版权声明: 转载请注明出处.

1.PHP Unit Testing

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46

<?php

namespace DYL\Test\Test\Unit\Plugin\Framework\DB;

use PHPUnit\Framework\TestCase;
use DYL\Test\Plugin\Framework\DB\FieldDataConverter;
use Magento\Framework\DB\Query\BatchRangeIteratorFactory;

class FieldDataConverterTest extends TestCase
{
    public function setUp(): void
    {
        $test1 = $this->createMock(\DYL\Test\Model\Test1::class);
        $selectFactory = $this->createMock(\Magento\Framework\DB\SelectFactory::class);
        $test2 = $this->createMock(\DYL\Test\Helper\Test2::class);
        $batchRangeIteratorFactory = $this->createMock(BatchRangeIteratorFactory::class);
        $this->fieldDataConverter = new FieldDataConverter(
            $test1,
            $selectFactory,
            $test2,
            $batchRangeIteratorFactory
        );
    }

    /**
     * @dataProvider getExampleKeys
     * @return void
     */
    public function testGetExampleKey($key, $expected)
    {
        $result = $this->fieldDataConverter->getExampleKey($key);
        $this->assertEquals($expected, $result);
    }

    /**
     * Get example values
     * @return array[]
     */
    public function getExampleKeys()
    {
        return [
            ['test1-test2-test3', 'test3'],
        ];
    }
}

2.JavaScript testing

首先需要进入项目目录
使用最新的package.json

1
2

cp package.json.sample package.json
npm install

启动testing，添加参数-v可以看到更多调试信息

1

node /home/dyl/.config/nvm/versions/node/v20.12.1/bin/grunt spec:luma --file="dev/tests/js/jasmine/tests/app/code/Magento/Ui/base/js/grid/columns/actions.test.js"

调试启动

1

node --inspect-brk /home/dyl/.config/nvm/versions/node/v20.12.1/bin/grunt spec:luma --file="dev/tests/js/jasmine/tests/app/code/Magento/Ui/base/js/grid/columns/actions.test.js"

chrome浏览器输入chrome://inspect，应该能看到监听的node请求

原文链接: http://www.jiliuke.com/index.html

版权声明: 转载请注明出处.

1.同步生产站点的静态内容数据

例如首页幻灯片，contact-us页面内容等,需要同步的表如下

1
2
3
4
5
6
7
8

cms_block
cms_block_store
cms_page
cms_page_store
sequence_cms_block
sequence_cms_page
staging_update
flag //其中的staging的值必须在staging_update中存在

原文链接: http://www.jiliuke.com/index.html

版权声明: 转载请注明出处.

1.在自定义dom上显示数据loading状态

define 引用 loader 组件并初始化为loader变量，接着设置加载icon，然后调用show显示加载中，调用hide隐藏加载中。

1
2
3
4
5
6
7
8
9
10
11
12
13

define([
    ...
    'loader',
    ...
],function(...,loader,...){
    let overviewContent = $(this).parent().find('.overview-content');
    
    overviewContent.loader({icon: self.options.loadingImg});
    overviewContent.loader('show');//显示loader
    ...
    overviewContent.loader('hide');//数据加载完成后隐藏loader

})

参考链接
https://developer.adobe.com/commerce/frontend-core/javascript/jquery-widgets/loader/

2.在Magento2 Js 中再加载js组件

1
2
3
4
5
6
7

define([
    ...
    'mage/apply/main',
    ...
],function(...,main,...){
    main.applyFor('.content-card','{}','swiperOverviewImages');
})

参考链接
https://fishpig.co.uk/magento/tutorials/manually-load-js-component-magento-2/

原文链接: http://www.jiliuke.com/index.html

版权声明: 转载请注明出处.

最新的 XHGUI 用法

https://github.com/michaeldyl520/xhgui

最新的自修改xhgui搭配mongodb用法如下

1. 在程序入口index.php添加以下代码即可开始分析

   1 2 3 4 5

   require_once '/path/to/xhgui/vendor/perftools/php-profiler/autoload.php'; $config = require_once '/path/to/xhgui/config/config.php'; $profiler = new \Xhgui\Profiler\Profiler($config); $profiler->start();

   1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

   <?php /** * Default configuration for PHP Profiler. * * config.php * To change these, create a file called `config.php` file in the same directory * and return an array from there with your overriding settings. */ use Xhgui\Profiler\Profiler; use Xhgui\Profiler\ProfilingFlags; return array( 'save.handler' => Profiler::SAVER_STACK, 'save.handler.stack' => array( 'savers' => array( Profiler::SAVER_UPLOAD ), 'saveAll' => false, ), 'save.handler.upload' => array( 'url' => 'https://www.xhgui.local/run/import', // The timeout option is in seconds and defaults to 3 if unspecified. 'timeout' => 3, // the token must match 'upload.token' config in XHGui 'token' => '', ), 'profiler.enable' => function () { return true; }, 'profiler.flags' => array( ProfilingFlags::CPU, ProfilingFlags::MEMORY, ProfilingFlags::NO_BUILTINS, ProfilingFlags::NO_SPANS, ), 'profiler.options' => array(), 'profiler.exclude-env' => array(), 'profiler.simple_url' => function ($url) { return preg_replace('/=\d+/', '', $url); }, 'profiler.replace_url' => null, );

原文链接: http://www.jiliuke.com/index.html

版权声明: 转载请注明出处.