{"id":2062,"date":"2009-07-15T15:05:03","date_gmt":"2009-07-15T15:05:03","guid":{"rendered":"http:\/\/coalface.mcslp.com\/?p=259"},"modified":"2010-09-12T16:01:32","modified_gmt":"2010-09-12T16:01:32","slug":"dojo-examples-from-uc2009","status":"publish","type":"post","link":"https:\/\/planet.mcb.guru\/?p=2062","title":{"rendered":"Dojo examples from UC2009"},"content":{"rendered":"<p>I know, I know, loads of people have been waiting for these&#8230;<\/p>\n<p>So here we go, I&#8217;ve finally sorted a downloaded version of the Dojo examples from the presentation I provided at the MySQL Users Conference 2009. <\/p>\n<p>There are three examples: <\/p>\n<ul>\n<li>The auto-paging table example, which uses the functionality of the Dojo Toolkit and the QueryReadStore to automatically load content from a table.<br \/>\n<img src=\"http:\/\/coalface.mcslp.com\/wp-content\/uploads\/2009\/07\/picture-3-300x239.png\" alt=\"tableautopagesample\" title=\"tableautopagesample\" width=\"300\" height=\"239\" \/><\/li>\n<li>The basic graphing example, which loads data dynamically and plots a graph.<br \/>\n<img src=\"http:\/\/coalface.mcslp.com\/wp-content\/uploads\/2009\/07\/picture-4-300x236.png\" alt=\"graphexample\" title=\"graphexample\" width=\"300\" height=\"236\" \/><\/li>\n<li>And the zooming version of the same basic graph interface<\/li>\n<p>There&#8217;s a README in the download that contains instructions on getting everything up to speed, although it should be fairly obvious. It&#8217;s attached to the bottom of this post too.<\/p>\n<p>Any questions for getting this to work, please go ahead and ask!<\/p>\n<p>Download the package <a href=\"http:\/\/coalface.mcslp.com\/downloads\/dojoexuc2009v1.tar.bz2\">here<\/a><\/p>\n<p><code><br \/>\nUC2009 Working with MySQL and Dojo<br \/>\n==================================<\/code><\/p>\n<p>MC Brown, 2009, http:\/\/mcslp.com and http:\/\/coalface.mcslp.com<\/p>\n<p>Components:<\/p>\n<p>There are three examples here:<\/p>\n<p>- Dojo table with auto-paging<br \/>\n  (table_autopage.html and table_autopage.cgi)<\/p>\n<p>- Dojo Basic Graph<br \/>\n  (graph_basic.html and graph_ajax.cgi)<\/p>\n<p>- Dojo Zooming Graph<br \/>\n  (graph.html and graph_ajaz_zoom.cgi)<\/p>\n<p>You will also need the Dojo\/Dijit and DojoX toolkit package from here:<\/p>\n<p>http:\/\/www.dojotoolkit.org\/downloads<\/p>\n<p>Download the combined package, and then extract the contents and place in the same directory as the CGI scripts<\/p>\n<p>Intructions for use:<\/p>\n<p>For the Table example, you can create a table (or use an existing DB) from WordPress using the wp_posts tabls.<\/p>\n<p>In practice you need only create and populate a table with the following columns:<\/p>\n<p>id (int)<br \/>\nuser_nicename (char)<br \/>\npost_date (datetime)<br \/>\npost_title (char)<\/p>\n<p>To be compatible with the example without any more modifications.<\/p>\n<p>For the Graphing examples, you need a table as follows:<\/p>\n<p>CREATE TABLE `currencies` (<br \/>\n  `currencyid` bigint(20) unsigned NOT NULL auto_increment,<br \/>\n  `currency` char(20) default NULL,<br \/>\n  `value` float default NULL,<br \/>\n  `datetime` int(11) default NULL,<br \/>\n  `new` int(11) default NULL,<br \/>\n  PRIMARY KEY  (`currencyid`),<br \/>\n  UNIQUE KEY `currencyid` (`currencyid`),<br \/>\n  KEY `currencies_currency` (`currency`,`datetime`),<br \/>\n  KEY `currencies_datetime` (`datetime`)<br \/>\n) ENGINE=MyISAM AUTO_INCREMENT=170048 DEFAULT CHARSET=latin1<\/p>\n<p>And then populate with date\/value data according to the information you want to store.<\/p>\n<p>Once done, make sure you change the database information in the CGI scripts to populate the information correctly during operation.<br \/>\n<\/p>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>I know, I know, loads of people have been waiting for these&#8230; So here we go, I&#8217;ve finally sorted a downloaded version of the Dojo examples from the presentation I provided at the MySQL Users Conference 2009. There are three examples: The auto-paging table example, which uses the functionality of the Dojo Toolkit and the [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[56,36,57,58],"_links":{"self":[{"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=\/wp\/v2\/posts\/2062"}],"collection":[{"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2062"}],"version-history":[{"count":1,"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=\/wp\/v2\/posts\/2062\/revisions"}],"predecessor-version":[{"id":6750,"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=\/wp\/v2\/posts\/2062\/revisions\/6750"}],"wp:attachment":[{"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}