Skip to content

Instantly share code, notes, and snippets.

View daisukenishino2's full-sized avatar

daisuke nishino daisukenishino2

44 followers · 261 following
View GitHub Profile
@daisukenishino2
daisukenishino2 / instnwnd2.sql
Last active June 8, 2020 10:01
Open棟梁のサンプルが使用するNorthwindのDBを作成するスクリプト（SQL Server 2012以降で）
/*
** Copyright Microsoft, Inc. 1994 - 2000
** All Rights Reserved.
*/
SET NOCOUNT ON
GO
USE master
GO
@daisukenishino2
daisukenishino2 / common.js
Last active March 19, 2020 09:28
Open棟梁、モダンブラウザのダイアログ表示機能の「制限事項 1」の解除方法
//**********************************************************************************
//* Copyright (C) 2007,2016 Hitachi Solutions,Ltd.
//**********************************************************************************
// Apache License
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
@daisukenishino2
daisukenishino2 / hogehoge.txt
Last active February 25, 2020 04:23
汎用認証サイトのAuthorization Code Flowをキャプチャする。
ほげほげ
@daisukenishino2
daisukenishino2 / api_json_Delete Request
Last active November 27, 2019 02:58
FrontendとResourceServerとの通信
POST http://localhost:8888/api/json/Delete HTTP/1.1
Host: localhost:8888
Connection: keep-alive
Content-Length: 136
Accept: application/json
Origin: http://localhost:3000
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36
Content-Type: application/json
Sec-Fetch-Site: same-site
Sec-Fetch-Mode: cors
@daisukenishino2
daisukenishino2 / DaoShippers_D1_Insert.xml
Last active July 26, 2019 02:55
stackoverflow対策コードのテストケース（https://github.com/OpenTouryoProject/OpenTouryo/issues/341
<?xml version="1.0" encoding="UTF-8" ?>
<ROOT>
-- DaoShippers_D1_Insert
INSERT INTO
[Shippers]
(
<DELCMA>
<INSCOL name="ShipperID">[ShipperID],</INSCOL>
<INSCOL name="CompanyName">[CompanyName],</INSCOL>
<INSCOL name="Phone">[Phone],</INSCOL>
@daisukenishino2
daisukenishino2 / 性能測定用の動的パラメタライズド・クエリのサンプル.xml
Last active May 17, 2019 01:37
Open棟梁：動的パラメタライズド・クエリの性能測定に使用した、各種リソース情報と、その測定結果。
<?xml version="1.0"?>
<ROOT>
SELECT * FROM SHIPPERS
<WHERE>
WHERE
<IF>SHIPPERID = @p1</IF>
<IF>hoge1 = @hoge1</IF>
・・・
<IF>hoge1 = @hogeN</IF> → ここの「N」を、10, 20, 50, 100, 200, 500, 1000 タグと増やしていって性能を測定。
</WHERE>
@daisukenishino2
daisukenishino2 / SigningTest.cs
Last active May 1, 2019 08:36
ネストしたXMLの署名・検証処理の問題の確認用コード。https://github.com/AndersAbel/DualXmlDsigBug
using System;
using System.Security.Cryptography;
using System.Security.Cryptography.X509Certificates;
using System.Security.Cryptography.Xml;
using System.Xml;
namespace DualXmlDsigBug
{
public static class SigningTest
{
@daisukenishino2
daisukenishino2 / Web.config
Last active April 23, 2019 09:31
Open棟梁（MVC版）の *.config ファイル内の設定の説明 https://github.com/OpenTouryoProject/OpenTouryoDocuments/blob/master/documents/1_User_Guide/ja-JP/1b_config_parameter_list.xls に記載がないモノ。
<?xml version="1.0" encoding="utf-8"?>
<!--
ASP.NET アプリケーションを構成する方法の詳細については、
http://go.microsoft.com/fwlink/?LinkId=152368 を参照してください
-->
<configuration>
<configSections>
<sectionGroup name="system.web.webPages.razor" type="System.Web.WebPages.Razor.Configuration.RazorWebSectionGroup, System.Web.WebPages.Razor, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
<section name="host" type="System.Web.WebPages.Razor.Configuration.HostSection, System.Web.WebPages.Razor, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" />
<section name="pages" type="System.Web.WebPages.Razor.Configuration.RazorPagesSection, System.Web.WebPages.Razor, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" />
@daisukenishino2
daisukenishino2 / Summary.txt
Last active April 15, 2019 04:34
Feedback to https://github.com/abergs/fido2-net-lib.
MultiPurposeAuthSite is implemented webauthn using fido2-net-lib.
And, summarized the feedback in this page.
@daisukenishino2
daisukenishino2 / 1. Response from makeCredentialOptions WebAPI.json
Last active April 15, 2019 03:29
fido2-net-lib https://github.com/abergs/fido2-net-lib を分析している (2018/08/29) 。
{
"status": "ok",
"errorMessage": "",
"rp": {
"id": "localhost",
"name": "Fido2 test"
},
"user": {
"name": "aaa@example.com",
"id": "YWFhQGV4YW1wbGUuY29t",