CheatSheets

HTML

mkdir %userprofile%\Documents\MyProjects\project_name
cd %userprofile%\Documents\MyProjects\project_name
mkdir dest
mkdir docs
mkdir src
cd src
##mkdir assets\_coffee
##mkdir assets\_ts
##mkdir assets\_sass
##mkdir assets\_sass\lib
mkdir assets\vendor
mkdir assets\js
mkdir assets\css
mkdir assets\css\img
mkdir assets\img

Starter Html copy

<!DOCTYPE html>
<html lang="ja">
 
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>

<!-- CSS -->
<!-- https://getbootstrap.com/docs/4.3/getting-started/introduction/ -->

<!-- CSS -->
<link rel="stylesheet" href="./assets/css/xxx.css">

<!-- CSS -->
<style type="text/css">
/*ここにCSSを記述*/
body {
padding-top: 70px;
}
</style>
</head>
 
<body>
<header></header>
<main role="main"></main>
<footer></footer>

<!-- Script CDN -->
<!-- http://code.jquery.com/ -->
<!-- https://getbootstrap.com/docs/4.3/getting-started/introduction/ -->
<!-- https://github.com/google/code-prettify -->

<!-- Script -->
<script src="./assets/js/xxx.js"></script>

<!-- Script -->
<script>
//ここにjavascriptを記述
</script>
</body>
</html>

コード表示 copy

<div>
<a>title</a>
<pre class="prettyprint linenums"></pre>
</div>

javascript

自己実行型関数 copy

(function(){
    //TODO
    })();

名前空間 copy

var namespace = (function(){
    //TODO
    }());

jQuery

Starter jquery copy

$(function(){
// TODO:処理
});

copy

$(function($){
// TODO:処理
})(jQuery);

click copy

$('#id').on('click', function(evt) {
evt.preventDefault();
//TODO:処理
});

each copy

$('.class').each(function(){
//TODO:処理
//let value = $(this).val();
});

非同期処理: $.ajax() copy

const url = "";
$.ajax({
url: "",
type: "get",
dataType: "jsonp",
success: function(data){
//TODO:処理
}
});

Family Tree の探索

up 1 level copy

const $value = $('#id').parent('filter');

up multi levels copy

const $value = $('#id').parents('filter');

down 1 level copy

const $value = $('#id').children('filter');

down multi levels copy

const $value = $('#id').find('filter');

兄弟 copy

const $value = $('#id').siblings('filter');

1つ年下の弟 copy

const $value = $('#id').next();

1つ年上の兄 copy

const $value = $('#id').prev();

該当するDOM要素の 1つ目 copy

const $value = $('.class').first();

DOMへの操作

クラスの追加と削除 copy

$('.class').toggleClass('class2'); // 引数の class名にコンマ不要
$('.class').addClass('class2');
$('.class').removeClass('class2');

attribute: class, id, ... copy

const value = $('.class').attr('name');
$('.class').attr('name', value);

css style copy

const value = $('.class').css('name');
$('.class').css('name', value);

text with /w tag copy

const $value = $('.class').html();
$('.class').html($value);

text with /wo tag copy

const value = $('.class').text();
$('.class').text(value);

value copy

const value = $('.class').val();
$('.class').val(value);

remove DOM copy

$('.class').remove();
$('.class').remove('selector');

DOM要素の追加

自分の子要素としてDOMを最後尾に追加 copy

$('.class').append('<img src="url">');

自分の子要素としてDOMを最前列に追加 copy

$('.class').prepend('<img src="url">');

1つ兄のsiblingとしてDOMを追加 copy

$('.class').before('<img src="url">');

1つ弟のsiblingとしてDOMを追加 copy

$('.class').after('<img src="url">');

Markdown

markdown チートシート

Plant UML

Starter Plant UML シーケンス図 copy

@startuml name
hide footbox
actor "ユーザー" as user
participant "Browser" as client
participant "サーバー" as server
participant "Web API" as api
participant "DB" as db
title:title

user->client:処理
activate client
    client->server:処理
    activate server
        server->api:処理
        activate api
            api->db:処理
            activate db
            return response
        return response
    return response
deactivate client
@enduml

同期処理(client~server) copy

client->server:処理
activate server
TODO:
return response

同期処理(server~api) copy

server->api:処理
activate api
TODO:
return response

同期処理(api~db) copy

api->db:処理
activate db
return response

SQL Server

エンティティ定義 copy

declare @table_name as varchar(max) = '';
select TABLE_NAME from INFORMATION_SCHEMA.TABLES
where 1=1
and table_name = @table_name
;
select
--TABLE_NAME,
COLUMN_NAME,
DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH,
IS_NULLABLE
--,CONCAT('declare @',column_name,' as ',data_type,' = null;')
--,CONCAT('new { ', 'no=', ORDINAL_POSITION, ', ', 'name="', COLUMN_NAME, '", ', 'type="', DATA_TYPE, '" },')
from INFORMATION_SCHEMA.COLUMNS
where 1=1
and table_name = @table_name
order by ORDINAL_POSITION
;

テーブル一覧 copy

select
*
from
INFORMATION_SCHEMA.tables
where 1=1
and table_name <> 'sysdiagrams'
;

ユーザ一覧 copy

select
princ.name
,princ.type_desc
,perm.permission_name
,perm.state_desc
,perm.class_desc
,object_name(perm.major_id)
from
sys.database_permissions perm
join sys.server_principals princ
on perm.grantee_principal_id = princ.principal_id
;