Skip to content

Instantly share code, notes, and snippets.

Avatar
♨️
470

ytnobody / satoshi azuma ytnobody

♨️
470
View GitHub Profile
@ytnobody
ytnobody / example.go
Last active May 26, 2020
こういうことをやりたい
View example.go
package main
import (
"database/sql"
_ "github.com/go-sql-driver/mysql"
"github.com/ytnobody/gomysqlerror"
"github.com/volatiletech/sqlboiler/boil"
)
@ytnobody
ytnobody / ecto-select-count-groupby.exs
Created Dec 2, 2019
[Ecto] SELECT bookshelf.id AS bookshelf_id, COUNT(book.id) AS books_count FROM bookshelf JOIN book ON bookshelf.id = book.bookshelf_id GROUP BY bookshelf.id
View ecto-select-count-groupby.exs
from(bookshelf in Bookshelf,
join: book in Book, on bookshelf.id == book.bookshelf_id,
group_by: bookshelf.id,
select: %{bookshelf_id: bookshelf.id, books_count: count(book.id)}
) |> Repo.all()
@ytnobody
ytnobody / iex.txt
Created Sep 2, 2019
failed etude of elixir mock server
View iex.txt
iex(5)> sv = MyMock.run()
11:35:22.016 [info] Added handler for /user
11:35:22.016 [info] Added handler for /user/:id
%Mock.MockServer{
name: :my_mock,
pid: #PID<0.765.0>,
port: 64400,
route: %{
@ytnobody
ytnobody / azure-func-migrate-node
Last active Nov 15, 2018
Azure functions v1 -> v2 for Node.js applications for MacOSX
View azure-func-migrate-node
#!/bin/bash
show_help () {
cat <<EOF
Run "npm -g install azure-functions-core-tools" first.
EOF
exit;
}
list_required_extensions () {
@ytnobody
ytnobody / git-bar
Created Nov 1, 2018
キーワードでcommit logを引っ掛けてきて、宛先のbranchにcherry-pickするための中間ブランチをつくる、野蛮な工具
View git-bar
#!/bin/sh
help () {
cat <<EOF
Usage:
git-bar [keyword] [Dest Branch]
EOF
exit;
@ytnobody
ytnobody / mishimapm-3.md
Created Jun 3, 2018
Why people says "Perl is guilty" - mishima.pm #3
View mishimapm-3.md

Why people says "Perl is guilty" ?

ytnobody


ytnobody

  • born: Hakodate
  • live: Ooi-machi
View cpanfile
###
### cpanfile for KH Coder
###
#
# usage:
# $ cd kh_coder/
# $ LANG=C cpanm --installdeps -n .
#
requires 'perl' => '5.008';
View BlobRestProxy.php
<?php
/**
* LICENSE: The MIT License (the "License")
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
* https://github.com/azure/azure-storage-php/LICENSE
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
@ytnobody
ytnobody / sent-event.pl
Created Feb 18, 2017
Net::Azure::EventHubsを使ってAzure EventHubs経由でAzure Functionsの関数を起動する事例
View sent-event.pl
use strict;
use warnings;
use utf8;
use Net::Azure::EventHubs;
### EventHubsの接続文字列をここに入れる
my $connection_string = '...';
### EventHubs向けにイベントを送るClientを作る
my $client = Net::Azure::EventHubs->new(
@ytnobody
ytnobody / azure_func.pl
Last active Feb 18, 2017
Azure Function向けのヘルパーライブラリもどきスニペット
View azure_func.pl
use strict;
use warnings;
use utf8;
use JSON::PP;
use Encode;
### タイムゾーン定義 / Azure Functionsでは必須。
BEGIN {
$ENV{TZ} = "JST-9";
};