Skip to content

Instantly share code, notes, and snippets.

@OdaShinsuke
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
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;";
<?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
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
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
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
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
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
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
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))