This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH RECURSIVE | |
-- どの倍数でどのワードに置き換えるかを定義 | |
fizzbuzz(multiple, word) AS ( | |
SELECT 3, 'fizz' UNION ALL SELECT 5, 'buzz' | |
), | |
-- 3 or 5 の倍数であれば fizz と buzz にそれぞれ置き換える。 | |
results(seq_no, might_be_replaced, multiple_opt) AS ( | |
SELECT 1, CAST(1 AS CHAR(256)), 0 | |
UNION | |
SELECT seq_no + 1, COALESCE(word, seq_no + 1), multiple |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# If you have not yet installed HtmlAgilityPack(HAP), try to run these commands. | |
# | |
# Register-PackageSource -Name Nuget -Location "http://www.nuget.org/api/v2" –ProviderName Nuget -Trusted | |
# Install-Package HtmlAgilityPack -RequiredVersion 1.11.20 -Scope CurrentUser -SkipDependencies | |
Add-Type -AssemblyName "$env:LOCALAPPDATA\PackageManagement\NuGet\Packages\HtmlAgilityPack.1.11.20\lib\netstandard2.0\HtmlAgilityPack.dll" | |
# If your XPath does not work, and it contains tbody or something like that, remove these tags, because web brawzer automatically added. | |
# 時刻表ページから平日・土日祝で運航されるタイムラインIDを取得する。 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
product_code | product_name | price | |
---|---|---|---|
POSH00001 | 鉛筆 | 100 | |
POSH00002 | 消しゴム | 50 | |
POSH00003 | ノート | 110 | |
POSH00004 | 定規 | 90 | |
POSH00005 | 蛍光ペン | 70 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[core] | |
autoCRLF = false | |
editor = code --wait | |
pager = less -m | |
[alias] | |
st = status | |
stt = status | |
difff = diff | |
cm = commit | |
graph = log --graph --date=short --decorate=short --pretty=format:'%Cgreen%h %Creset%cd %Cblue%cn %Cred%d %Creset%s' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# -- Modules -------------------------------------------------- | |
Import-Module posh-git | |
Import-Module oh-my-posh | |
Set-Theme Agnoster | |
Import-Module DockerCompletion | |
Import-Module scoop-completion | |
Import-Module PSColor | |
# ZLocation alternates your prompt function to track the location. | |
# If you have a custom prompt function in $profile, you should place Import-Module ZLocation after the prompt customization. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package com.qiita.nimzo6689.snippet.qrgen.schema; | |
import net.glxn.qrgen.core.scheme.EMail; | |
import net.glxn.qrgen.javase.QRCode; | |
import java.io.File; | |
import java.nio.file.Files; | |
import java.nio.file.Paths; | |
import java.nio.file.StandardCopyOption; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# https://qiita.com/nimzo6689/items/e3ae6280f34539bb8680 用です。 | |
function replaceFileContentWithoutBOM($path, $regex, $replacement) { | |
Get-Content -Encoding UTF8 $path ` | |
| % {$_ -replace $regex, $replacement}` | |
| Out-String ` | |
| % { [Text.Encoding]::UTF8.GetBytes($_) } ` | |
| Set-Content -Path $path -Encoding Byte | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 参考 | |
# https://www.peyarogu.com/entry/php_xampp_vscode | |
# Scoop, VS Codeはインストール済みを想定 | |
scoop php php-xdebug apache composer | |
@' | |
{ | |
"require": { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Scoopの環境構築 | |
Set-ExecutionPolicy RemoteSigned -scope CurrentUser | |
iex (new-object net.webclient).downloadstring('https://get.scoop.sh') | |
scoop install git | |
# CUIツールをインストール | |
scoop install nodejs-lts yarn | |
# GUIツールをインストール | |
scoop bucket add extras |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Array.from($x('//*[@id="root"]/div/div/nav/ul/li/a[./h3[contains(text(), "conditional")]]/@href')) | |
.map(e => `${e.textContent}, title: ${e.ownerElement.textContent}`) |
NewerOlder