Differences

This shows you the differences between two versions of the page.

--- plugin:sqlraw [2013-11-15 01:52] – Remove Tableplot plugin from example tom_c
+++ plugin:sqlraw [2018-06-05 23:59] (current) – [Installation] Klap-in
@@ Line 1: / Line 1: @@
-====== sqlraw Plugin ======
+====== SQLRaw Plugin ======
 ---- plugin ----
@@ Line 6: / Line 6: @@
 email      : tcafferty@glocalfocal.com
 type       : syntax
-lastupdate : 2013-11-14
+lastupdate : 2013-11-17
-compatible : Adora Belle, Weatherwax
+compatible : Adora Belle, Weatherwax, Binky
 depends    :
 conflicts  :
@@ Line 29: / Line 29: @@
 I recommend creating a user account and granting database specific privilege to that account, specifying a database external from your other databases. That user account information will be specified in the plugin software and the user will not need to know the login information.
-Install the plugin using the [[plugin:plugin|Plugin Manager]] and the download URL above, which points to latest version of the plugin. Refer to [[:Plugins]] on how to install plugins manually.
+Search and install the plugin using the [[plugin:extension|Extension Manager]]. Refer to [[:Plugins]] on how to install plugins manually.
 Update the configuration data for the user account login information for the database.
@@ Line 40: / Line 40: @@
 ===== Examples/Usage =====
+Examples can be seen at <del>[[http://clean.glocalfocal.com/doku.php?id=start|Plugin Examples Site]]</del>
   * The following is data from a scrape of a US Employment data table. (Note that column headings have no spaces when a new line is started. Otherwise use an underscore for spaces. Eg: Oct_2013). This example uses the fixTable='1' option to correct issues with the table.
@@ Line 82: / Line 84: @@
 {{keywords>sqlRawSort}}
 </code>
-  * Set the class as 'sortable"
+Set the class as 'sortable". Use the keywords plugin to pull in the sorting javascript code. Clicking on a column header will sort the table one way (ASC, DESC) and clicking again will sort the table the other direction.
-  * Use the keywords plugin to pull in the sorting javascript code.
-  * Clicking on a column header will sort the table one way (ASC, DESC) and clicking again will sort the table the other direction.
+  * The following example gets the data from an online csv file. The source option is now set to csvfile. The url link points to a downloadable csv file.
+<code>
+  <sqlraw id="earthquakes" source="csvfile" title="Large Recent Earthquakes" link="http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/4.5_week.csv">SELECT time, mag, depth, place FROM temptable WHERE mag > 5.0 AND depth < 70;</sqlraw>
+</code>
 ===== Syntax =====