Takuya Shimabukuro stk132

stk132 / cv.md

Last active August 2, 2020 17:58

職務経歴書

プロフィール

2020年11末〜12月初旬の退職を目処として、転職先を検討中

stk132 / readGZIP.scala

Last active April 14, 2020 18:54

scala2.12で呼び出し元でstream closedになるケース

	def readGZIPFile[A](filePath: String, proc: String => Option[A]): Either[Throwable, Seq[A]] = {
	val gs = new GZIPInputStream(new FileInputStream(filePath))
	val ss = Source.fromInputStream(gs, "UTF-8")
	try {
	val ret = ss.getLines().flatMap(line => proc(line)).toSeq
	Right(ret)
	} catch {
	case NonFatal(t) => Left(t)
	} finally {
	ss.close()

stk132 / MySQLSyntaxSupport.scala

Created January 26, 2019 08:30

scalikejdbc back-quoted syntax

	import scalikejdbc._

	object MySQLSyntaxSupport {

	implicit class RichInsertSQLBuilder(val self: InsertSQLBuilder) extends AnyVal {

	def quotedNamedValues(columnsAndValues: (SQLSyntax, ParameterBinder)*): InsertSQLBuilder = {
	val (cs, vs) = columnsAndValues.unzip
	val quotedCs = cs.map {column => sqls"`$column`"}
	val quotedColumnsAndValues = quotedCs zip vs

stk132 / build.sbt

Created December 11, 2018 16:54

block.fmのトラックリストを取得するサンプル

stk132 / generated_function.go

Created July 10, 2016 06:17

	VUsers.N() // output "users"
	VUsers.Name.N() // output "name"
	VUsers.ID.N() // output "id"
	VUsers.A("hoge").N() // output "hoge"
	VUsers.A("hoge").Name.N() // output "hoge.name"
	VUsers.A("hoge").ID.N() // output "hoge.id"

stk132 / using_tsg_generated_code.go

Created July 9, 2016 20:33

dbr.Select(VUsers.Name.N()).From(VUsers.N()).Load(&m)

stk132 / tsg_output_sample.go

Created July 9, 2016 20:31

stk132 / tsg_sample.sh

Last active July 10, 2016 06:21

tsg -u username --pass=password -d database_name

stk132 / dbr_sample.go

Created July 9, 2016 20:06

	var ret []string
	sess.Select("id").From("users").Load(&ret)

stk132 / test.txt

Created July 9, 2016 19:54

	これはテストなので、無視してください。
	this is test. please ignore.