takegue takegue

## 0post.md

      
              4 files
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                takegue
                / 0post.md
            
            
              Last active
              November 6, 2022 12:18
            
              
                SQLのためのテンプレートエンジン再考
              
          
    テンプレートエンジンののコードをコードとして管理したくない


テンプレート化されたコードを読み解くコストは高い

コードは書くよりも読まれる時間の方が長い


テンプレートのコードは lint/formatter/コード補完などの静的解析ツールの相性が悪い


## git-sparse-checkout-for-circleci.sh
#!/bin/bash -e

CIRCLE_WORKING_DIRECTORY="${CIRCLE_WORKING_DIRECTORY/#\~/$HOME}"
[[ ! -d $CIRCLE_WORKING_DIRECTORY ]] && mkdir -p $CIRCLE_WORKING_DIRECTORY
cd $CIRCLE_WORKING_DIRECTORY

git init
git remote add origin $CIRCLE_REPOSITORY_URL
git config core.sparsecheckout true

## 2017-05-02-091531.sql
SELECT *
FROM `sitemap_acp_tree_fixed_to_xml`
WHERE `tree` = '1002'
ORDER BY RAND()
LIMIT 50

## picaro.py
#!/usr/bin/env python2
# -*- coding:utf-8 -*-
#
# Picaro: An simple command-line alignment visualization tool.
#
# picaro.py
# Visualize alignments between sentences in a grid format.
#
# Jason Riesa <riesa@isi.edu>
# version: 01-16-2010

## N行より+10行を表示する
sed -sn 'N,+10p' *

## file0.txt
$ cat text.txt | mecab-all
IPADIC  :私大 ファン な ん です
JUMAN   :私大 ファン な んです
JUMANDIC:私大 ファン な んです
JUMANPP :私大 ファン な んです
KYTEA   :私大 ファン な ん で す
NEOLOG  :私大 ファン な ん です
SNOW    :私大ファン な ん です
UNIDIC  :私大 ファン な ん です

## zbell.zsh
#!/usr/bin/env zsh

# This script prints a bell character when a command finishes
# if it has been running for longer than $zbell_duration seconds.
# If there are programs that you know run long that you don't
# want to bell after, then add them to $zbell_ignore.
#
# This script uses only zsh builtins so its fast, there's no needless
# forking, and its only dependency is zsh and its standard modules
#

## dsp.py
#!/usr/bin/env python3
# -*- coding: utf-8 -*-

from tornado import ioloop, httpserver, web, httpclient

import json
import urllib.parse
import logging

import time

## 2015-07-31-121816.py
#!/usr/bin/env python
# -*- coding: utf-8 -*-

"""
NLP 主要会議のGoogle Calendar日程作成用のscript
http://www.cs.rochester.edu/~tetreaul/conferences.html
"""

import pandas as pd
import dateutil as du

## 2015-01-25-005613.py
#!/usr/bin/env python
# -*- coding:utf-8 -*-

import subprocess
import itertools as itt


class MeCab():

    def __init__(self, opts=[]):
	#!/bin/bash -e

	CIRCLE_WORKING_DIRECTORY="${CIRCLE_WORKING_DIRECTORY/#\~/$HOME}"
	[[ ! -d $CIRCLE_WORKING_DIRECTORY ]] && mkdir -p $CIRCLE_WORKING_DIRECTORY
	cd $CIRCLE_WORKING_DIRECTORY

	git init
	git remote add origin $CIRCLE_REPOSITORY_URL
	git config core.sparsecheckout true
	SELECT *
	FROM `sitemap_acp_tree_fixed_to_xml`
	WHERE `tree` = '1002'
	ORDER BY RAND()
	LIMIT 50
	#!/usr/bin/env python2
	# -- coding:utf-8 --
	#
	# Picaro: An simple command-line alignment visualization tool.
	#
	# picaro.py
	# Visualize alignments between sentences in a grid format.
	#
	# Jason Riesa <riesa@isi.edu>
	# version: 01-16-2010
	$ cat text.txt \| mecab-all
	IPADIC :私大ファンなんです
	JUMAN :私大ファンなんです
	JUMANDIC:私大ファンなんです
	JUMANPP :私大ファンなんです
	KYTEA :私大ファンなんです
	NEOLOG :私大ファンなんです
	SNOW :私大ファンなんです
	UNIDIC :私大ファンなんです
	#!/usr/bin/env zsh

	# This script prints a bell character when a command finishes
	# if it has been running for longer than $zbell_duration seconds.
	# If there are programs that you know run long that you don't
	# want to bell after, then add them to $zbell_ignore.
	#
	# This script uses only zsh builtins so its fast, there's no needless
	# forking, and its only dependency is zsh and its standard modules
	#
	#!/usr/bin/env python3
	# -- coding: utf-8 --

	from tornado import ioloop, httpserver, web, httpclient

	import json
	import urllib.parse
	import logging

	import time
	#!/usr/bin/env python
	# -- coding: utf-8 --

	"""
	NLP 主要会議のGoogle Calendar日程作成用のscript
	http://www.cs.rochester.edu/~tetreaul/conferences.html
	"""

	import pandas as pd
	import dateutil as du
	#!/usr/bin/env python
	# -- coding:utf-8 --

	import subprocess
	import itertools as itt


	class MeCab():

	def __init__(self, opts=[]):