OdaShinsuke’s gists

OdaShinsuke / test.sql

Created May 21, 2020 01:32

T-SQL スキーマ(Schema)無しでの呼出しでどのスキーマのものが使われるのか

	use [master]
	create database [SchemaTest] containment=partial
	go
	use [SchemaTest]
	go

	-- スキーマ
	create schema [S1]
	go
	create schema [S2]

OdaShinsuke / netcore_Program.cs

Last active October 12, 2019 06:11

.NET Core SqlConnection ConnectRetryCount not work?

	using System;
	using System.Data.SqlClient;
	using System.Diagnostics;

	namespace NETCore
	{
	class Program
	{
	static string connstr = @"Data Source=localhost;Initial Catalog=master;Integrated Security=True;Connect Timeout=5;Encrypt=False;";

OdaShinsuke / Hello.csproj

Last active November 4, 2015 23:31

MSBuild 触ってみようのデモ (http://www.slideshare.net/odashinsuke/ms-build-50927955)

	<?xml version="1.0" encoding="utf-8"?>
	<Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="14.0">
	<PropertyGroup>
	<Param>Default</Param>
	</PropertyGroup>
	<Target Name="Hello">
	<Message Text="Hello $(Param) さん" />
	</Target>
	</Project>

OdaShinsuke / jenkins_job_update_jdk.groovy

Created April 17, 2015 04:14

Jenkins のスクリプトコンソールで、Job の JDK を一括変換

	jobs = jenkins.model.Jenkins.instance.items
	oldJDK = jenkins.model.Jenkins.instance.getJDK("JavaSE 8u40")
	newJDK = jenkins.model.Jenkins.instance.getJDK("JavaSE 8u45")

	jobs.each {
	if (it.JDK == oldJDK) {
	it.JDK = newJDK
	it.save()
	println "updated ${it.name}"
	}

OdaShinsuke / DefatultParameterWithBeamParamExtensions.java

Last active August 29, 2015 14:17

Swagger JAX-RS BeanParam 用 Extensions

	package com.wordnik.swagger.jaxrs;

	import java.lang.annotation.Annotation;
	import java.lang.reflect.Field;
	import java.lang.reflect.Type;
	import java.util.ArrayList;
	import java.util.Iterator;
	import java.util.List;
	import java.util.Set;

OdaShinsuke / AutoCompleteBean.java

Created March 17, 2015 11:09

Primefaces AutoComplete 日本語入力

	package sample;

	import java.io.Serializable;
	import java.util.Arrays;
	import java.util.List;

	import javax.faces.view.ViewScoped;
	import javax.inject.Named;

	@SuppressWarnings("serial")

OdaShinsuke / PreCondition.xtend

Last active December 19, 2015 08:39

Xtend ActiveAnnotation メソッドの事前条件埋めてみた

	package contracts

	import java.lang.annotation.ElementType
	import java.lang.annotation.Target
	import org.eclipse.xtend.lib.macro.AbstractMethodProcessor
	import org.eclipse.xtend.lib.macro.Active
	import org.eclipse.xtend.lib.macro.TransformationContext
	import org.eclipse.xtend.lib.macro.declaration.MutableMethodDeclaration
	import org.eclipse.xtend.lib.macro.declaration.Visibility

OdaShinsuke / OutputStyleCopReport.proj

Created November 27, 2012 10:53

MSBuild StyleCop Output XML => Jenkins Violation Plugin

	<UsingTask TaskName="ReplaceStyleCopResult" TaskFactory="CodeTaskFactory" AssemblyFile="$(MSBuildToolsPath)\Microsoft.Build.Tasks.v4.0.dll">
	<ParameterGroup>
	<PATH ParameterType="System.String" Required="true" />
	<WORKSPACE ParameterType="System.String" Required="true" />
	</ParameterGroup>
	<Task>
	<Code Type="Fragment" Language="cs"><![CDATA[
	var content = File.ReadAllText(PATH);
	File.WriteAllText(PATH, content.Replace(WORKSPACE, "../"));
	]]></Code>

OdaShinsuke / 自動販売機.cs

Created April 30, 2012 07:40

TDD Pre Camp 大阪

	using System;
	using System.Linq;

	namespace TDDPre {
	public class 自動販売機 {
	private static int[] 正規のお金 = new int[] { 10, 50, 100, 500, 1000 };
	public int 投入金額 { get; private set; }
	/// <summary>
	/// Command
	/// </summary>

OdaShinsuke / Working.ps1

Created April 12, 2012 03:35

作業してる感

	Write-Host "Backup!"

	Write-Host "0% * * * * * * * * * * 100%"
	while ($true) {
	Get-ChildItem \| % {
	$path = $_.FullName
	Write-Host "Backup File:$path starting ... "
	for ($count = 1; $count -le 20; ++$count) {
	$ran = Get-Random
	sleep -m ($count * ($ran % 30))

Oda Shinsuke OdaShinsuke