sampleData/tikiwiki/SampleTikiwiki-ExpectedAll.txt

There will be a file here...

Monospace 
{{mono}}

No wiki formatting
{noformat}__No__ formatting{noformat}

Italicise text
_italic_

Bold text
*bold*

Bold and italic
*_bold & italic_*

Internal link (within Wikipedia)
[name of page]
[display text|name of page]
[label in this page|#section in this page]

External link (to other websites)
[http://www.example.com]
[display text|http://www.example.com]
[display text|http://www.example.com]
[Secure|https://security.com]

Applies only at the beginning of the line
Headings
of different sizes

h1. Level 1
h2. Level 2
h3. Level 3
h4. Level 4

Bullet list

* one
* two
** two point one
* three

Numbered list

# one
# two
## two point one
# three

Thumbnail image

!hobbespounce.gif!
!Wiki.png!

{toc:type=list|outline=true|printable=false}

Tables

|| Header1 || Header2 || Header3 ||
| r1c1 | r1c2 | r1c3 |
| r2c1 | r2c2 | r2c3 |

|| Header1 || Header2 || Header3 ||
|| Row1 Header | r1c2 | r1c3 |
|| Row2 Header | r2c2 | r2c3 |


No headers:

| r1c1 | r1c2 |
| r2c1 | r2c2 |

Row and Col spans:

| row1-column1 | row1-column2 | row1-column3 |
| row2-columns123 | | |
| row3-column1 | row3-columns23 | |

Preformatted:
{noformat}This __might__ have some ((Wiki syntax)). That's ignored.{noformat}

Code:
{code}
System.out.println("This is code");
{code}


{panel}
{{And what does this white-space starting line mean?}}
{{Is this like a pre tag?}}
{{How does it treat [Wiki syntax]?}}
{panel}

Colored text:
{color:#FFEE33}some text{color}

Underlined:
+underlined+

Title bar:
h1. title

Centered text
Centered

{panel}
Just a panel?
{panel}

{anchor:section in this page}

Mostly from [WikiSyntax|http://tikiwiki.org/tiki-index.php?page=WikiSyntax]

----
Attachments

!hobbespounce.gif!
!Wiki.png!
!Wiki.png!

Importance of quotes
!hobbespounce.gif!
!Wiki.png!

Importance of space
!hobbespounce.gif!
!hobbespounce.gif!
!Wiki.png!

[MySQL|http://www.mysql.com] is an open-source RDBMS that's very easy to set up and use.  We sometimes use MySQL in the development phase of projects when we need a database we can administer ourselves because of frequent schema changes.  [Hypersonic] is another nice RDBMS for this purpose.  Recently, getting an [Oracle] instance made and administering it ourselves has become easier, so we're relying less on MySQL.

----
h1. Reference

Here's a quick list of common MySQL commands (most of these are just plain SQL, actually).

List of databases:
{{SHOW DATABASES;}}
Switch to database:
{{USE dbname;}}
List of tables in database:
{{SHOW TABLES;}}
Table details:
{{DESCRIBE tblname;}}
Create database:
{{CREATE DATABASE dbname;}}
Grant privileges on database:
{{GRANT ALL ON dbname.* TO username;}}

Add table:
{{CREATE TABLE tblname (colname type, colname type, ...);}}
Remove table:
{{DROP TABLE tblname;}}

Add column:
{{ALTER TABLE tblname ADD colname type \[NOT NULL\] \[DEFAULT value\];}}
Remove column:
{{ALTER TABLE tblname DROP colname;}}
Rename column:
{{ALTER TABLE tblname CHANGE colname newcolname (same type);}}

Insert row:
{{INSERT tblname (colname,...) VALUES (expr,...);}}
Update rows:
{{UPDATE tblname SET colname=expr, ... \[WHERE where_expr\];}}
Remove rows:
{{DELETE FROM tblname \[WHERE where_expr\];}}

Compare with NULL:
{{colname IS \[NOT\] NULL}}


----
Alternate Monospace Syntax:

{{Should Be Monospace}}


----
CamelCase Not a Link Syntax:

NotALink

This [should be a link] but this needs to be cleaned


----
Enforce List Whitespace

* listitem
** listitem

# numbereditem
## numbereditem
### numbereditem

* already has the whitespace
** already has the whitespace
# already has the whitespace
## already has the whitespace
### already has the whitespace

----
This is to test converting and attaching image syntax that uses URLs

This image is located on my local apache server

!http://localhost:8081/tikiwiki-1.9.5/img/wiki_up/hobbespounce.gif!

Does it convert and attach?

----
This is to test Code blocks bug uwc-97 (maybe this is a list context issue?)

Before
* Listone
** {code}
This is a code block
{code}
** Some stuff
** {code}
Another code block!
{code}

Another possibility is that this stuff is getting munged by the panel:

{panel}
Starting a panel here

{code}
Non list context code block
{code}
Something else
{code}
This is different?
{code}

* list context!
** {code}
Something
{code}
** still list
** {code}
Something else
{code}

About to end the panel
{panel}

download syntax: (this is a local test - change the url to your tikiwiki location)
!cow.jpg!
!cow.jpg!

Color
{color:#FF0000}Should be red{color}
{color:red}Should be red{color}
{color:red}Should be red
multiline
coloration
{color}

Tables with dashes
| r1c1 | \- |
| r2c1 | r2c2 |

Tables with newline delimiters

| A | B | C | D | E |
| abc | def | ghi | jkl | \- |
| abc | def | ghi | jkl | |
| abc | def | ghi | | |

Multiple Tables with Newline Delimiters

{panel}
Pre text: ABC, DEFs.
|| ABC || DEF || GHI JKL || MNO PQR ||
| http://www.google.com/ | Ac | 11/29/2005 | 11/29/2005 |
| http://www.google.com/ | Ac | 1/6/2006 | 1/6/2006 |
{panel}


*header*
{panel}
Home Site:[http://www.google-google.com/|http://www.google-google.com/]
Download Link:[http://www.google-google.com/download.shtml|http://www.google-google.com/download.shtml]

| Date: | 1/4/2006 |
| Version: | 1.0 |
| Purchase URL: | http://www.google-google.com/buynow.shtml |
| Purchase Price: | $19.99 |
| Functionality: | Time Limit (15 day trial version) |
| Rabc: | ABC |
| Common Components: | |
| To Adds: | installer |
| Notes: | |

{panel}

Tables Back to Back (uwc-115)
| A | B |
| a | b |

| C | D |
| c | d |

Tables with Colspans that can be pruned (uwc-133)
| A | B |
| a | b |

Tables starting with an empty cell (uwc-118)
| A | B |
| | b |

Horizontal Rules:
----

Getting out of List Context
* item 1
* item 2

Should not be indented like a list item.

This is for testing the stripping away of unnecessary newlines between nested list items

* item a
** item a1
** item a2 (this should only have the inner bullet, not both bullets)


But! These should be considered seperate lists:
* item c

* item d

This is for testing adding empty cells to pad out shorter rows that would otherwise have been colspans

| A | B | |
| a | b | c |

File Gallery Images with whitespace in the filename
!ed copy.jpeg!

Code blocks that might be interfered with by uwc-106 (illegal name handling)
{code}
blah [[blah]] blah
{code}

----
XXX Add more conversions here.