Category Archives: 工具軟體

[Postman] Upload file to s3 in pre-request script

Posted on 2024 年 08 月 07 日 by cowman.chiang

First, select binary in the body settings, and assign a file at will. Then the real file path will be obtained through the syntax in pre-script. In some cases, you may need to set the file directory to Postman’s working … Continue reading →

Posted in Postman | Comments Off on [Postman] Upload file to s3 in pre-request script

AES decrypt in postman

Posted on 2023 年 05 月 31 日 by cowman.chiang

sample code: var CryptoJS = require(“crypto-js”); let secretKey = ‘yourSecretKey’; function decrypt(aesStr, key) { return CryptoJS.AES.decrypt( aesStr, CryptoJS.enc.Utf8.parse(padding(key)), { mode: CryptoJS.mode.ECB, padding: CryptoJS.pad.Pkcs7 } ).toString(CryptoJS.enc.Utf8) } function padding(key) { return key.padEnd(32, ‘\0’); } //decrypt(“encryptedData”, secretKey) Here we choose AES-256 to … Continue reading →

Posted in JavaScript, Postman | Comments Off on AES decrypt in postman

Line breaks issue

Posted on 2023 年 02 月 03 日 by cowman.chiang

When we use command “ssh” with auto-completion, we get this error result. This is because we used the editor “sublime text” to edit the config before, which used the line endings of Windows. Then we can edit the setting of … Continue reading →

Posted in Mac, Sublime Text 2, Sublime Text 3 | Comments Off on Line breaks issue

[VirtualBox] Host-only network is not working.

Posted on 2023 年 01 月 09 日 by cowman.chiang

We can usually find the information about connecting to the Guest machine in VirtualBox. Most of the practices are performed using the Host-only setting method. But in version 7.0.4 of VirtualBox, the same setting does not work. This is because … Continue reading →

Posted in Virtualbox | Comments Off on [VirtualBox] Host-only network is not working.

[Docker] Common commands

Posted on 2019 年 06 月 24 日 by cowman.chiang

show all containers: docker ps -a stop all containers: docker kill $(docker ps -q) remove all containers: docker rm $(docker ps -a -q) remove all docker images: docker rmi $(docker images -q) enter docker container: docker exec -it $(container id) … Continue reading →

Posted in Docker | Leave a comment

[Intellij] Checkstyle and Code Style

Posted on 2018 年 10 月 17 日 by cowman.chiang

Checkstyle 介紹 根據定義好的規則對程式碼進行檢查，以確保程式碼的 Style 是一致的 (盡力…) Checkstyle GitHub 有提供兩種規則範例，後續套用的規則即是使用 “Google Checks” 進行修改 Sun Checks Google Checks 安裝 Checkstyle Preferences.. ➔ Plugins ➔ Browse repositories.. -> 搜尋 “CheckStyle” 安裝 “CheckStyle-IDEA” Checkstyle 規則文件說明 checkstyle/qmi_checks.xml 為 Checkstyle 主規則檔案 定義檢查的檔案格式、範圍 定義排除的規則檔案位置 (通常為 suppressions.xml) 定義檢查的項目，每一個項目可定義的屬性不固定，需檢視 … Continue reading →

Posted in Intellij | Leave a comment

open external program from java for mac os x

Posted on 2017 年 03 月 24 日 by cowman.chiang

String[] cmds = {“open”, tempFile.getAbsolutePath(), “-a”, “/Applications/Microsoft Office 2011/Microsoft Excel.app”}; Runtime.getRuntime().exec(cmds);

Posted in Java, Mac, Office | Leave a comment

protect data validation to fail while copy and paste data

Posted on 2017 年 01 月 25 日 by cowman.chiang

Private Sub Worksheet_Change(ByVal Target As Range) ‘Does the validation range still have validation? Set range1 = Range(“B2:B6500”) If HasValidation(range1) Then Exit Sub Else Application.Undo MsgBox “您的操作將會被取消, ” & vbCrLf & “請使用下拉選單進行選擇”, vbCritical End If End Sub Private Function HasValidation(r) As … Continue reading →

Posted in Excel | Leave a comment

Add SublimeText 2 context menu to windows explorer

Posted on 2016 年 05 月 13 日 by cowman.chiang

Ref. Github: iaian/sublimeText2_contextMenu.reg Replace the Sublime Text Directory’s path.

Posted in Sublime Text 2, Sublime Text 3 | Leave a comment

[Sublime Text3] Enable package control

Posted on 2015 年 11 月 03 日 by cowman.chiang

Use ctrl + ` to open console. (or View->Show console) Paste the appropriate code to enable package control function. import urllib.request,os,hashlib; h = ‘2915d1851351e5ee549c20394736b442’ + ‘8bc59f460fa1548d1514676163dafc88’; pf = ‘Package Control.sublime-package’; ipp = sublime.installed_packages_path(); urllib.request.install_opener( urllib.request.build_opener( urllib.request.ProxyHandler()) ); by = urllib.request.urlopen( … Continue reading →

Posted in Sublime Text 3 | Leave a comment