https://ja.wiki.hidekisaito.com/wiki/index.php?title=HSLProcessor&feed=atom&action=history
HSLProcessor - 版の履歴
2024-03-28T16:28:37Z
このウィキのこのページに関する変更履歴
MediaWiki 1.31.1
https://ja.wiki.hidekisaito.com/wiki/index.php?title=HSLProcessor&diff=1709&oldid=prev
2017年9月6日 (水) 07:54にHsaitoによる
2017-09-06T07:54:13Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="ja">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← 古い版</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">2017年9月6日 (水) 07:54時点における版</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l6" >6行目:</td>
<td colspan="2" class="diff-lineno">6行目:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== HSL.dbの全リストSQL構文==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== HSL.dbの全リストSQL構文==</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><pre></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><pre></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>SELECT Title, Artists.Name, Sources.Name, Series.Name FROM main.Songs</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>SELECT Title, Artists.Name <ins class="diffchange diffchange-inline">AS "Artist"</ins>, Sources.Name <ins class="diffchange diffchange-inline">AS "Source"</ins>,  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">INNER </del>JOIN Artists ON Songs.ArtistId = Artists.ArtistId</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">  </ins>Series.Name <ins class="diffchange diffchange-inline">AS "Series" </ins>FROM main.Songs</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">INNER </del>JOIN Sources <del class="diffchange diffchange-inline">on </del>Songs.SourceId = Sources.SourceId</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>JOIN Artists ON Songs.ArtistId = Artists.ArtistId</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">INNER </del>JOIN Series ON Sources.SeriesId = Series.SeriesId</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>JOIN Sources <ins class="diffchange diffchange-inline">ON </ins>Songs.SourceId = Sources.SourceId</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>JOIN Series ON Sources.SeriesId = Series.SeriesId</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>ORDER BY Title</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>ORDER BY Title</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td></tr>
</table>
Hsaito
https://ja.wiki.hidekisaito.com/wiki/index.php?title=HSLProcessor&diff=1702&oldid=prev
2017年9月5日 (火) 10:29にHsaitoによる
2017-09-05T10:29:54Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="ja">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← 古い版</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">2017年9月5日 (火) 10:29時点における版</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l13" >13行目:</td>
<td colspan="2" class="diff-lineno">13行目:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[Category:HSLProcessor|*]]</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:HSLBase]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:HSLBase]]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:.NET Core]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:.NET Core]]</div></td></tr>
</table>
Hsaito
https://ja.wiki.hidekisaito.com/wiki/index.php?title=HSLProcessor&diff=1700&oldid=prev
Hsaito: ページの作成:「[https://github.com/hsaito/HSLBase HSLProcessor]はHSLBaseのコンポーネントで[https://songs.hidekisaito.com Hideki's Songlist]の基盤技術システム。...」
2017-09-05T10:25:02Z
<p>ページの作成:「[https://github.com/hsaito/HSLBase HSLProcessor]は<a href="/wiki/index.php?title=HSLBase&action=edit&redlink=1" class="new" title="HSLBase (存在しないページ)">HSLBase</a>のコンポーネントで[https://songs.hidekisaito.com Hideki's Songlist]の基盤技術システム。...」</p>
<p><b>新規ページ</b></p><div>[https://github.com/hsaito/HSLBase HSLProcessor]は[[HSLBase]]のコンポーネントで[https://songs.hidekisaito.com Hideki's Songlist]の基盤技術システム。<br />
データベース機能を提供する静的ページ生成システムとして機能する。<br />
<br />
.NET CoreとEntityFramework Coreにより機能。<br />
<br />
== HSL.dbの全リストSQL構文==<br />
<pre><br />
SELECT Title, Artists.Name, Sources.Name, Series.Name FROM main.Songs<br />
INNER JOIN Artists ON Songs.ArtistId = Artists.ArtistId<br />
INNER JOIN Sources on Songs.SourceId = Sources.SourceId<br />
INNER JOIN Series ON Sources.SeriesId = Series.SeriesId<br />
ORDER BY Title<br />
</pre><br />
<br />
[[Category:HSLBase]]<br />
[[Category:.NET Core]]<br />
[[Category:ソフトウェア]]<br />
[[Category:コンピューティング]]<br />
[[Category:技術]]<br />
[[Category:プロジェクト]]<br />
[[Category:オープンソース]]</div>
Hsaito