DokuWiki

It's better when it's simple

User Tools

Site Tools


plugin:dbtables

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
plugin:dbtables [2011-06-10 17:48] Aleksandrplugin:dbtables [2023-10-31 00:59] (current) Klap-in
Line 1: Line 1:
-====== dbtables plugin ======+====== DBTables Plugin ======
  
 ---- plugin ---- ---- plugin ----
-description: Render database schemas in Dokuwiki format.  Useful for DB Dev'rs+description: Render database schemas in DokuWiki format. Useful for DB Dev'rs.
 author     : Stephen C / Pontiac76 author     : Stephen C / Pontiac76
 email      : pontiac76@gmail.com email      : pontiac76@gmail.com
 type       : helper, render type       : helper, render
 lastupdate : 2010-09-29 lastupdate : 2010-09-29
-compatible : >= 2009-12-25+compatible : Lemming
 tags       : data, database, tables tags       : data, database, tables
  
Line 15: Line 15:
 ===== Download and Installation ===== ===== Download and Installation =====
  
-Download and install the plugin using the [[plugin:plugin|Plugin Manager]] using the URL given above. 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.
  
-Download the plugin from [[http://ginger.gotdns.com/public/wiki/download/dbtables.zip|here]] - Copy/Paste URL into UPLOAD in the [[plugin:plugin|Plugin Manager]]+Download the plugin from [[http://ginger.gotdns.com/public/wiki/download/dbtables.zip|here]] 
  
 Demo [[http://ginger.gotdns.com/public/wiki/doku.php?id=stephens:development:dbtables|here]] Demo [[http://ginger.gotdns.com/public/wiki/doku.php?id=stephens:development:dbtables|here]]
Line 35: Line 35:
  
 ==== Options ==== ==== Options ====
-^Option^Description^Default^ + 
-|groups|How many horizontal DW-tables are displayed|4| + Option    Description                                                                          Default                              
-|cols|How many columns per DW-table are rendered|4| +| groups    | How many horizontal DW-tables are displayed                                          | 4                                     
-|c{#}|Name of DW-table field, where # the field number|c1=Field;c2=Type;c3=Relation;c4=Desc| +| cols      | How many columns per DW-table are rendered                                           | 4                                     
-|fdelim|Field Delimeter - Character representing how each DW-DB field is seperated|:+| c{#}      | Name of DW-table field, where # the field number                                     | c1=Field;c2=Type;c3=Relation;c4=Desc  
-|thead|Table Heading - Character representing the line in which a table name is defined|_ {Underscore}| +| fdelim    | Field Delimeter - Character representing how each DW-DB field is seperated           | :                                     
-|twidth|Width of the HTML table|Undefined - Dokuwiki decides| +| thead     | Table Heading - Character representing the line in which a table name is defined     | _ {Underscore}                        
-|nosort|When assigned any value, does not sort the table names.  Sorting happens by default.|Undefined| +| twidth    | Width of the HTML table                                                              | Undefined - Dokuwiki decides          
-|norender|Outputs the DW-tables in Dokuwiki text format|Undefined|+| nosort    | When assigned any value, does not sort the table names. Sorting happens by default.  | Undefined                             
 +| norender  | Outputs the DW-tables in Dokuwiki text format                                        | Undefined                             |
  
 Note that with twidth, nosort, and norender, you must assign some sort of value, for example, ''norender=1''. Note that with twidth, nosort, and norender, you must assign some sort of value, for example, ''norender=1''.
 +
 ===== Examples ===== ===== Examples =====
 +
 ==== Example #1 ==== ==== Example #1 ====
 +
 <code> <code>
 <dbtables> <dbtables>
-_Table1+Table1
 TableID:int:PK:ID of Table TableID:int:PK:ID of Table
 TableName:varchar(50) TableName:varchar(50)
  
-_Table2+Table2
 TableID:int:PK TableID:int:PK
 TableParent:int:FK->Table1.TableID TableParent:int:FK->Table1.TableID
 TableDesc:varchar(50)::Description of Table:You won't see this rendered if cols=4 TableDesc:varchar(50)::Description of Table:You won't see this rendered if cols=4
  
-_Table3+Table3
 TableID:int:PK TableID:int:PK
-_Table4+Table4
 TableID:int:PK TableID:int:PK
-_Table5+Table5
 TableID:int:PK TableID:int:PK
-_Table6+Table6
 TableID:int:PK TableID:int:PK
 </dbtables> </dbtables>
 </code> </code>
- 
  
 ==== Example #2 ==== ==== Example #2 ====
 +
 <code> <code>
 <dbtables groups=2;cols=3;c1=Field;c2=Type;c3=Desc;twidth=95%> <dbtables groups=2;cols=3;c1=Field;c2=Type;c3=Desc;twidth=95%>
plugin/dbtables.1307720915.txt.gz · Last modified: 2011-06-10 17:48 by Aleksandr

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki