datatable.html revision 76c9fe1d50dff2736aa35ed3e81acaf8cdf48588
126N/A<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
126N/A<html>
126N/A<head>
126N/A<title>Datatable Tests</title>
371N/A<link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/3.2.0/build/cssreset/reset-min.css">
126N/A<link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/3.2.0/build/cssbase/base-min.css">
126N/A<script type="text/javascript" src="/build/yui/yui-debug.js"></script>
126N/A
126N/A<style>
126N/A html {
126N/A font-family: sans-serif;
126N/A font-size: smaller;
126N/A }
126N/A
126N/A .message {
126N/A padding: 5px;
126N/A font-size:120%;
126N/A background: #FFFCB6;
126N/A border:1px solid #C9C675;
126N/A }
126N/A
126N/A #results dt {
126N/A font-weight:bold;
126N/A padding:3px;
126N/A display:block;
126N/A }
126N/A #results dd {
126N/A font-weight:normal;
126N/A color:grey;
126N/A }
126N/A #results dd span {
126N/A color: red;
493N/A font-weight:bold;
126N/A }
126N/A</style>
126N/A</head>
493N/A
126N/A<body class="yui3-skin-sam">
126N/A<h1>Datatable Tests</h1>
493N/A
126N/A<p>To test the performance of various datatables, look at the following sections in the code:
126N/A
126N/A <pre>
126N/A//large or small dataset.
126N/Adata: large,
126N/A
126N/A//---------------------------------------------
126N/A// Special instructions
126N/A//---------------------------------------------
126N/A
493N/A_should: {
126N/A ignore: {
126N/A //ignore following tests (good to do if you are doing a large dataset)
493N/A testBaseDatatable: true,
126N/A testXYDatatable: true,
126N/A testXDatatable: true,
493N/A testYDatatable_FixedCol: true,
126N/A testYDatatable_AutoCol: true,
126N/A testXYDatatable_BigHeaders: false
493N/A }
126N/A}
126N/A </pre>
126N/A
126N/A Toggle <code>data</code> from <code>large</code> to <code>small</code> to get a different sized dataset. The <code>ignore</code> object determines which table to load. If testing performance, it is recommended that you only enable 1 table at a time.</p>
126N/A <hr>
<p><input type="button" value="Run Tests" id="btnRun" disabled=true></p>
<hr>
<div id="results">
<h3>Test Results</h3>
</div>
<h3>Base Datatable</h3>
<div id="base"></div>
<h3>Scrolling XY Datatable (Set columnwidths)</h3>
<P>A general XY scrolling datatable. Column widths are provided for all columns, table width and height is provided.</p>
<div id="scrolling-xy"></div>
<h3>Scrolling X Datatable (Auto Columns)</h3>
<p>A X-scrolling datatable. Column A and B have specified widths. The rest of the columns do not have any widths specified. Only a height of 200px is specified.</p>
<div id="scrolling-x"></div>
<h3>Scrolling Y Datatable</h3>
<p>A Y-scrolling datatable. Column widths are provided for all columns, table height is provided. Since all cols have specified width, you may see this table overflowing past its container div (the blue div in the background). </p>
<div id="scrolling-y"></div>
<h3>Scrolling Datatable with no ColumnWidth</h3>
<p>A Y-scrolling datatable, where only the first 2 columns have a specified width. Only the table height is provided.</p>
<div id="scrolling-colwidth"></div>
<h3>Scrolling Datatable with Big Headers</h3>
<p>A XY-scrolling datatable, where only the first 2 columns have a specified width. Table height and width is provided. The table headers are of larger width than the table contents</p>
<div id="scrolling-bigcols"></div>
<h3>Scrolling Datatable with no width or height set</h3>
<p>A scrolling datatable with no width or height values passed in will result in a base datatable being created with auto width and height.</p>
<div id="scrolling-noscroll"></div>
<script type="text/javascript">
(function() {
YUI({
base: "/build/",
filter: "debug",
logInclude:{"TestRunner":true},
useConsole: true
}).use("console", "test", "dump", "datatable", "profiler","node","json-parse", function(Y) {
// Set up the page
var ASSERT = Y.Assert,
ARRAYASSERT = Y.ArrayAssert,
BTNRUN = Y.one("#btnRun"),
TestRunner = Y.Test.Runner;
BTNRUN.set("disabled", false);
TestRunner.subscribe(TestRunner.TEST_CASE_COMPLETE_EVENT, testCompleted);
Y.on("click", function(e){
TestRunner.run();
BTNRUN.set("value", 'Running...');
BTNRUN.set("disabled", true);
}, BTNRUN);
function testCompleted() {
BTNRUN.set("value", 'Test Completed');
Y.log('Test Completed');
}
var myConsole = new Y.Console().render();
//large data set
var large = [];
for (var i=0; i<500; i++) {
large[i] = {a: i+1, b:i+2, c:i+3, d: i+4, e: i+5, f: i+6, g:i+7};
}
//small data set
var small = [{a:3, b:2, c:1, d:6, e:7, f:2, g:0}, {a:9, b:8, c:7, d:6, e:7, f:2, g:0}, {a:1, b:2, c:3, d:6, e:7, f:2, g:0},
{a:3, b:2, c:1, d:6, e:7, f:2, g:0}, {a:9, b:8, c:7, d:6, e:7, f:2, g:0}, {a:1, b:2, c:3, d:6, e:7, f:2, g:0},
{a:3, b:2, c:1, d:6, e:7, f:2, g:0}, {a:9, b:8, c:7, d:6, e:7, f:2, g:0}, {a:1, b:2, c:3, d:6, e:7, f:2, g:0},
{a:3, b:2, c:1, d:6, e:7, f:2, g:0}, {a:9, b:8, c:7, d:6, e:7, f:2, g:0}, {a:1, b:2, c:3, d:6, e:7, f:2, g:0}];
var testBasic = new Y.Test.Case({
name: "API Tests",
nestedcols: [
{label:"Grandparent", children:[
{key: "a"},
{label:"Parent", children: [
{key:"b"},
{key:"c"}
]}
]}
],
cols: [{key:"a", field:"a", label:"AAA", sortable:true, className: ["oneClass", "anotherClass"], width:'75px'},{key:"b", abbr:"bbb", className:"myClass", width: '120px'},{key:"c", width:'75px'},{key:"d", width:'150px'},{key:"3", width:'75px'},{key:"f", width:'150px'},{key:"g", width:'75px'}],
cols2: [{key:"a", field:"a", label:"AAA", sortable:true, className: ["oneClass", "anotherClass"], width:'75px'},{key:"b", abbr:"bbb", className:"myClass", width:'75px'},{key:"c"},{key:"d"},{key:"e"},{key:"f"},{key:"g"}],
cols3: [{key:"a", field:"a", label:"Lorem Ipsum Dolor SIt Amet", sortable:true, className: ["oneClass", "anotherClass"], width:'5px'},{key:"b", abbr:"Lorem Ipsum Dolor SIt Amet", className:"myClass", width:'75px'},{key:"Lorem Ipsum Dolor SIt Amet"},{key:"Lorem Ipsum Dolor SIt Amet"},{key:"Lorem Ipsum Dolor SIt Amet"},{key:"Lorem Ipsum Dolor SIt Amet"},{key:"Lorem Ipsum Dolor SIt Amet"}],
//large or small dataset.
data: small,
//---------------------------------------------
// Special instructions
//---------------------------------------------
_should: {
ignore: {
//ignore following tests (good to do if you are doing a large dataset)
testBaseDatatable: true,
testXYDatatable: false,
testXDatatable: false,
testYDatatable_FixedCol: false,
testYDatatable_AutoCol: false,
testXYDatatable_BigHeaders: false,
testNoScrollDatatablekey: false
}
},
//---------------------------------------------
// Setup and tear down
//---------------------------------------------
setUp : function () {
//create recordset
//this.rs = new Y.Recordset({records:this.initialData});
//Some Ways to access recordset properties
//Y.log(rs.getRecordByIndex(0).getValue('a'));
//Y.log(rs.get('records').length);
},
tearDown : function () {
delete this.dt;
},
/////////////////////////////////////////////////////////////////////////////
//
// Displaying Report
//
/////////////////////////////////////////////////////////////////////////////
displayReport: function(data) {
var dl = Y.Node.create('<dl></dl>'),
results = Y.one('#results');
Y.each(data, function(v,k,o) {
var dt = Y.Node.create('<dt>'+k+'</dt>');
var dd = Y.Node.create('<dd>' + v.calls + ' call(s) at ' + v.avg + ' ms/call = <span>' + Math.round(v.avg*v.calls) + '</span> ms total</dd>');
dt.appendChild(dd);
dl.appendChild(dt);
});
results.appendChild(dl);
},
reportParser: function(report) {
return (report.calls > 0 && report.avg > 0.2);
},
/////////////////////////////////////////////////////////////////////////////
//
// Tests
//
/////////////////////////////////////////////////////////////////////////////
testBaseDatatable: function() {
var sel = "#base";
Y.Profiler.start('dtBase');
this.dt = new Y.DataTable.Base({columnset:this.cols, recordset:this.data, caption:"Base"});
Y.Profiler.registerObject('dt', this.dt);
this.dt.render(sel);
Y.Profiler.stop('dtBase');
var msg = Y.Profiler.getAverage('dtBase') + 'ms taken to display';
var report = Y.Profiler.getFullReport(this.reportParser);
this.displayReport(report);
Y.Profiler.unregisterObject('dt');
Y.log(msg, "time");
Y.one(sel).appendChild('<p class="message">'+msg+'</p>');
},
testXYDatatable: function() {
var sel = '#scrolling-xy';
Y.Profiler.start('dtXY');
this.dt = new Y.DataTable.Base({columnset:this.cols, recordset:this.data, tdValueTemplate:"plug then render {value}", caption: "ScrollingDataTable"});
Y.Profiler.registerObject('dt', this.dt);
this.dt.plug(Y.Plugin.DataTableScroll, {width:"200px", height:"300px"});
this.dt.render(sel);
Y.Profiler.stop('dtXY');
var msg = Y.Profiler.getAverage('dtXY') + 'ms taken to display';
var report = Y.Profiler.getFullReport(this.reportParser);
this.displayReport(report);
Y.Profiler.unregisterObject('dt');
Y.log(msg, "time");
Y.one(sel).appendChild('<p class="message">'+msg+'</p>');
},
testXDatatable: function() {
var sel = "#scrolling-x";
Y.Profiler.start('dtX');
this.dt = new Y.DataTable.Base({columnset:this.cols2, recordset:this.data, caption:"ScrollingDataTable"});
Y.Profiler.registerObject('dt', this.dt);
this.dt.plug(Y.Plugin.DataTableScroll, {width:"150px"});
this.dt.render(sel);
Y.Profiler.stop('dtX');
var msg = Y.Profiler.getAverage('dtX') + 'ms taken to display';
var report = Y.Profiler.getFullReport(this.reportParser);
this.displayReport(report);
Y.Profiler.unregisterObject('dt');
Y.log(msg, "time");
Y.one(sel).appendChild('<p class="message">'+msg+'</p>');
},
testYDatatable_FixedCol: function() {
var sel = "#scrolling-y";
Y.Profiler.start('dtY1');
this.dt = new Y.DataTable.Base({columnset:this.cols, recordset:this.data, tdValueTemplate:"plug then render {value}", caption:"ScrollingDataTable"});
Y.Profiler.registerObject('dt', this.dt);
this.dt.plug(Y.Plugin.DataTableScroll, {height:"300px"});
this.dt.render(sel);
Y.Profiler.stop('dtY1');
var msg = Y.Profiler.getAverage('dtY1') + 'ms taken to display';
var report = Y.Profiler.getFullReport(this.reportParser);
this.displayReport(report);
Y.Profiler.unregisterObject('dt');
Y.log(msg, 'time');
Y.one(sel).appendChild('<p class="message">'+msg+'</p>');
},
testYDatatable_AutoCol: function() {
var sel = "#scrolling-colwidth";
Y.Profiler.start('dtY2');
this.dt = new Y.DataTable.Base({columnset:this.cols2, recordset:this.data, tdValueTemplate:"plug then render {value}", caption:"ScrollingDataTable"});
Y.Profiler.registerObject('dt', this.dt);
this.dt.plug(Y.Plugin.DataTableScroll, {height:"250px"});
this.dt.render(sel);
Y.Profiler.stop('dtY2');
var msg = Y.Profiler.getAverage('dtY2') + 'ms taken to display';
var report = Y.Profiler.getFullReport(this.reportParser);
this.displayReport(report);
Y.Profiler.unregisterObject('dt');
Y.log(msg, 'time');
Y.one(sel).appendChild('<p class="message">'+msg+'</p>');
},
testXYDatatable_BigHeaders: function() {
var sel = "#scrolling-bigcols";
Y.Profiler.start('dtHeaders');
this.dt = new Y.DataTable.Base({columnset:this.cols3, recordset:this.data, tdValueTemplate:"plug then render {value}", caption:"ScrollingDataTable"});
Y.Profiler.registerObject('dt', this.dt);
this.dt.plug(Y.Plugin.DataTableScroll, {height:"250px", width:"400px"});
this.dt.render(sel);
Y.Profiler.stop('dtHeaders');
var msg = Y.Profiler.getAverage('dtHeaders') + 'ms taken to display';
var report = Y.Profiler.getFullReport(this.reportParser);
this.displayReport(report);
Y.Profiler.unregisterObject('dt');
Y.log(msg, 'time');
Y.one(sel).appendChild('<p class="message">'+msg+'</p>');
},
testNoScrollDatatable: function() {
var sel = "#scrolling-noscroll";
Y.Profiler.start('dtNoScroll');
this.dt = new Y.DataTable.Base({columnset:this.cols3, recordset:this.data, tdValueTemplate:"plug then render {value}", caption:"ScrollingDataTable"});
Y.Profiler.registerObject('dt', this.dt);
this.dt.plug(Y.Plugin.DataTableScroll);
this.dt.render(sel);
Y.Profiler.stop('dtNoScroll');
var msg = Y.Profiler.getAverage('dtNoScroll') + 'ms taken to display';
var report = Y.Profiler.getFullReport(this.reportParser);
this.displayReport(report);
Y.Profiler.unregisterObject('dt');
Y.log(msg, 'time');
Y.one(sel).appendChild('<p class="message">'+msg+'</p>');
this.dt.scroll.set('width', '200px');
}
});
var suite = new Y.Test.Suite({name:"Datatable Test Suite"});
suite.add(testBasic);
Y.Test.Runner.setName("Datatable Test Runner");
Y.Test.Runner.add(suite);
//Y.Test.Runner.run();
});
})();
</script>
</body>
</html>