SQLite Testing

As of 6.2, WackoWiki introduces a flexible markup for data tables. Any kind of tables allowed by HTML5 can be created using this markup, from the most basic examples (e.g. simple rows of cells) to complex tables with full support for accessibility options.

Table basics: cells, rows, columns

As soon as you create slightly more complex data tables, you will need to specify column and row headings. Headings are special cells that specify what kind of data rows and columns contain. The most basic way of creating a heading is by using ^| as a delimiter.
The following is an example of a simple table with column headings:
Row headings are created in the same way. Since they are usually followed by normal cells, they must be terminated with the || standard delimiter if the next element in the row is a simple cell:
?| Fruit production in 2006 |?
?| Fruit production in 2006 |?
|| 12-1 | | | ||
|| 1-2 | | | ||
|| 2-3 |(y=3) CSCI 102 | CSCI 101 | CSCI 101 ||
|| 3-4 | | || <-- reduced by one column
|| 4-5 | | ||
|| 12-1 | | | ||
|| 1-2 | | | ||
|| 2-3 |(y=3) CSCI 102 | CSCI 101 | CSCI 101 ||
|| 3-4 | | ||
|| 4-5 | | ||
*| | 2005 | 2006 | 2005 | 2006 |*
*| | 2005 | 2006 | 2005 | 2006 |*
|| Forced links: | [[HomePage main]] ||
|| Image links: | file:/IMG_20250615_134454_135-min.jpg?600 ||
|| Forced links: | [[HomePage main]] ||
|| Image links: | file:/IMG_20250615_134454_135-min.jpg?600 ||
You can also use embedded HTML in table elements:
id attributes are used to refer to unique elements in a page and to provide an anchor for styling and linking. You can specify an id for any table element by using the (i:''id'') parameter.
||(i:cell_1)This cell can be referred to by using the ##cell_1## id||
||(i:cell_2)This cell can be referred to by using the ##cell_2## id||
||(i:cell_1)This cell can be referred to by using the ##cell_1## id||
||(i:cell_2)This cell can be referred to by using the ##cell_2## id||
Any table element can be given a title attribute to enhance its accessibility. Titles are typically displayed in graphical browsers by hovering over the corresponding element and are useful to display unobtrusive descriptions about specific elements. You can specify a title for any table element by using the (t:''title'') parameter.
!|(t:Comparative figures for fruit production in the last year){width: 350px}|!
?|Fruit production in 2006|?
*| |(t:yearly production of apples)Apples|(t:yearly production of pears)Pears|*
^|(t:Mary's contribution to 2006 production)Mary|(t:Mary's production of apples in 2006){text-align:center}300Kg|(t:Mary's production of pears in 2006){text-align:center}320Kg||
^|(t:John's contribution to 2006 production)John|(t:John's production of apples in 2006){text-align:center}400Kg|(t:John's production of pears in 2006){text-align:center}630Kg||
!|(t:Comparative figures for fruit production in the last year){width: 350px}|!
?|Fruit production in 2006|?
*| |(t:yearly production of apples)Apples|(t:yearly production of pears)Pears|*
^|(t:Mary's contribution to 2006 production)Mary|(t:Mary's production of apples in 2006){text-align:center}300Kg|(t:Mary's production of pears in 2006){text-align:center}320Kg||
^|(t:John's contribution to 2006 production)John|(t:John's production of apples in 2006){text-align:center}400Kg|(t:John's production of pears in 2006){text-align:center}630Kg||

Adding a summary

Tables can take an optional summary attribute to describe the purpose and/or structure of the table. The description provided by the summary attribute is particularly helpful to users of non-visual browsers. You can specify a summary by adding a (u:''Summary'') parameter in the table global attributes.
For example, the following line:
!|(u:This is a summary)|!
will add to the table a summary attribute with the value This is a summary.
!|(u:A table with summary, caption, head, foot and body){width: 400px}|!
!|(u:A table with summary, caption, head, foot and body){width: 400px}|!

• Column heading scopes can be specified using the (o:col) parameter in the corresponding column heading;
• Row heading scopes can be specified using the (o:row) parameter in the corresponding row heading;

*| |(o:col)Employees|(o:col)Founded|*
^|(o:row)ACME Inc|1000|1947||
^|(o:row)XYZ Corp|2000|1973||
*| |(o:col)Employees|(o:col)Founded|*
^|(o:row)ACME Inc|1000|1947||
^|(o:row)XYZ Corp|2000|1973||