Takashi SASAKI TakashiSasaki

## .gitignore
*.encrypted
*.cleartext

## Moodleのコースにおけるユーザーへのロール割り当てに基づいた学生数と教員数の集計.sql
SELECT コースID AS courseid, コース名, コース省略名 AS 省略名,
(SELECT SUM(人数) FROM 集計_参加者数 WHERE コースID=courseid GROUP BY コースID) AS `参加者数`,
ifnull((SELECT 人数 FROM 集計_参加者数 WHERE ロール="Student" AND コースID=courseid),0) AS `学生権限の人数`,
ifnull((SELECT 人数 FROM 集計_参加者数 WHERE ロール="Teacher" AND コースID=courseid),0) AS `教員権限の人数`
FROM 集計_参加者数
GROUP BY courseid

## Tags-labels-folders.md

      
              7 files
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                TakashiSasaki
                / Tags-labels-folders.md
            
            
              Last active
              December 23, 2015 02:39
            
              
                A JSON schema to describe tags, labels and folders for generic document organizing
              
          
    A JSON schema to describe tags, labels and folders for generic document organizing.
It should be validated by http://jsonschemalint.com/ .

  
## safedd
#!/bin/sh
if [ ! -e /etc/safedd.conf ]; then
  echo /etc/safedd.conf is not found.
  echo Each line should be regex for forbidden '"'of'"' parameter.
  echo Example of /etc/safedd.conf :
  echo '    .*dev/sda.*'
  echo '    .*dev/md[0-9].*'
  exit -1
fi

## item.schema.json
{
    "$schema": "http://json-schema.org/draft-03/schema",
    "id": "https://gist.github.com/TakashiSasaki/5420814/raw/schema.json",
    "title": "root",
    "title-authority": [
        "http://json-schema.org/latest/json-schema-validation.html#anchor97",
        "http://json-schema.org/latest/json-schema-core.html#anchor7"
    ],
    "title-description": "Title is a metadata keyword and will preferrably be short.",
    "description": null,
	SELECT コースID AS courseid, コース名, コース省略名 AS 省略名,
	(SELECT SUM(人数) FROM 集計_参加者数 WHERE コースID=courseid GROUP BY コースID) AS `参加者数`,
	ifnull((SELECT 人数 FROM 集計_参加者数 WHERE ロール="Student" AND コースID=courseid),0) AS `学生権限の人数`,
	ifnull((SELECT 人数 FROM 集計_参加者数 WHERE ロール="Teacher" AND コースID=courseid),0) AS `教員権限の人数`
	FROM 集計_参加者数
	GROUP BY courseid
	#!/bin/sh
	if [ ! -e /etc/safedd.conf ]; then
	echo /etc/safedd.conf is not found.
	echo Each line should be regex for forbidden '"'of'"' parameter.
	echo Example of /etc/safedd.conf :
	echo ' .dev/sda.'
	echo ' .dev/md[0-9].'
	exit -1
	fi
	{
	"$schema": "http://json-schema.org/draft-03/schema",
	"id": "https://gist.github.com/TakashiSasaki/5420814/raw/schema.json",
	"title": "root",
	"title-authority": [
	"http://json-schema.org/latest/json-schema-validation.html#anchor97",
	"http://json-schema.org/latest/json-schema-core.html#anchor7"
	],
	"title-description": "Title is a metadata keyword and will preferrably be short.",
	"description": null,