Template:VerseRow: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
-{{#cargo_store: _table=NakhaStotra
+{{#cargo_store: _table=Verses
-| document_id    = {{{document_id|}}}
+| document_id  = {{{document_id|}}}
-| chapter_id     = {{{chapter_id|}}}
+| chapter_id   = {{{chapter_id|}}}
-| verse_id       = {{{verse_id|}}}
+| verse_id     = {{{verse_id|}}}
-| verse_type     = {{{verse_type|}}}
+| verse_type   = {{{verse_type|}}}
-| verse_text     = {{{verse_text|}}}
+| verse_text   = {{{verse_text|}}}
-| has_balabodhini  = {{{has_balabodhini|no}}}
+| verse_lines  = {{{verse_lines|}}}
-| has_mandabodhini = {{{has_mandabodhini|no}}}
+| commentaries = {{#if:{{{commentary1|}}}|{{{commentary1}}}}}{{#if:{{{commentary2|}}}|,{{{commentary2}}}}}{{#if:{{{commentary3|}}}|,{{{commentary3}}}}}{{#if:{{{commentary4|}}}|,{{{commentary4}}}}}{{#if:{{{commentary5|}}}|,{{{commentary5}}}}}
 }}<!--store only-->
+<noinclude>
+{{#cargo_declare: _table=Verses
+| document_id  = String
+| chapter_id   = String
+| verse_id     = String
+| verse_type   = String
+| verse_text   = Text
+| verse_lines  = List (;) of String
+| commentaries = List (,) of String
+}}
+'''All verses in a chapter:'''
+<pre>
+{{#cargo_query:
+  tables   = Verses
+| fields   = verse_id, verse_type, verse_text
+| where    = chapter_id = "NNS_C01"
+| order by = verse_id ASC
+| format   = table
+}}
+</pre>
+'''All verses that have a specific commentary:'''
+<pre>
+{{#cargo_query:
+  tables   = Verses
+| fields   = verse_id, commentaries
+| where    = document_id = "NNS"
+  AND commentaries HOLDS "balabodhini"
+| format   = table
+}}
+</pre>
+'''Count commentaries per document:'''
+<pre>
+{{#cargo_query:
+  tables   = Verses
+| fields   = document_id, COUNT(*) = total_verses
+| where    = commentaries HOLDS "shankarabhashya"
+| group by = document_id
+| format   = table
+}}
+</pre>
+[[Category:Cargo store templates]]
+</noinclude>