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;";
@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 / 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
<?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 / 自動販売機.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))
@OdaShinsuke
OdaShinsuke / calc
Created April 10, 2012 09:29
WEB+DB PRESS Vol.67 第2章 F#
let ret1 = List.zip [0..4] [10;20;30;40;50];;
let mul (i, x) = x * i;;
let ret2 = List.map mul ret1;;
let calc xs = List.fold (fun acc value -> acc + value) 0 (List.map mul (List.zip [0..4] xs));;
calc [10;20;30;40;50];;
@OdaShinsuke
OdaShinsuke / PageObjectTest.cs
Created March 4, 2012 04:06
PageObject パターンを実装してみた。多分こんな感じ
using NUnit.Framework;
using OpenQA.Selenium.IE;
using PageObjects;
namespace WebDriverTest {
[TestFixture]
public class PageObjectTest {
[Test]
public void 検索() {
var driver = new InternetExplorerDriver();
@OdaShinsuke
OdaShinsuke / BingSearch.java
Created February 19, 2012 03:37
BingSearch_WebDriver_java
package webdrivertest;
import static org.openqa.selenium.support.ui.ExpectedConditions.titleIs;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.remote.RemoteWebDriver;
import org.openqa.selenium.support.ui.Wait;
import org.openqa.selenium.support.ui.WebDriverWait;