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

Next revision
Previous revision
plugin:dbtables [2010-09-29 11:57] – created 99.235.196.241plugin: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 
-depends    : None +tags       : data, database, tables
-conflicts  : None +
-similar    :  +
-tags       : db, database, tables+
  
 downloadurl: http://ginger.gotdns.com/public/wiki/download/dbtables.zip downloadurl: http://ginger.gotdns.com/public/wiki/download/dbtables.zip
Line 18: 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]] 
 +
 +Demo [[http://ginger.gotdns.com/public/wiki/doku.php?id=stephens:development:dbtables|here]]
 ===== Syntax and Usage ===== ===== Syntax and Usage =====
  
Line 31: Line 31:
  
 <code> <code>
-<dbtables groups=4;cols=4;c1=Col1;c2=Col2;c3=Col3;c4=Col4;fdelim=:;thead="_">+<dbtables groups=4;cols=4;c1=Col1;c2=Col2;c3=Col3;c4=Col4;fdelim=:;thead=_>
 </code> </code>
  
 ==== Options ==== ==== Options ====
-^Option^Description^Default^ 
-|groups|How many horizontal DW-tables are displayed|4| 
-|cols|How many columns per DW-table are rendered|4| 
-|c{#}|Name of DW-table field, where # the field number|c1=Field;c2=Type;c3=Relation;c4=Desc| 
-|fdelim|Field Delimeter - Character representing how each DW-DB field is seperated|:| 
-|thead|Table Heading - Character representing the line in which a table name is defined|_ {Underscore}| 
-|twidth|Width of the HTML table|Undefined - Dokuwiki decides| 
-|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| 
  
-===== Example =====+^  Option    Description                                                                          Default                              ^ 
 +| groups    | How many horizontal DW-tables are displayed                                          | 4                                     | 
 +| cols      | How many columns per DW-table are rendered                                           | 4                                     | 
 +| c{#}      | Name of DW-table field, where # the field number                                     | c1=Field;c2=Type;c3=Relation;c4=Desc  | 
 +| fdelim    | Field Delimeter - Character representing how each DW-DB field is seperated           | :                                     | 
 +| thead     | Table Heading - Character representing the line in which a table name is defined     | _ {Underscore}                        | 
 +| twidth    | Width of the HTML table                                                              | Undefined - Dokuwiki decides          | 
 +| 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''
 + 
 +===== Examples ===== 
 + 
 +==== 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 ====
 +
 +<code>
 +<dbtables groups=2;cols=3;c1=Field;c2=Type;c3=Desc;twidth=95%>
 +_Customers
 +CustomerID:int:Primary Key
 +FirstName:varchar(50)
 +LastName:varchar(50)
 +Address:text:Populated via TEXTAREA
 +
 +_Orders
 +OrderID:int:Primary Key
 +CustomerID:int:FK->Customers.CustomerID
 +DateSumbitted:datetime
 +DateFilled:datetime
 +DateShipped:datetime
 +Shipper:varchar(50)
 +
 +_OrderDetails
 +OrderID:int:FK->Orders.OrderID
 +ProductID:int:FK->Products.ProductID
 +Units:int
 +Price:money
 +
 +_Products
 +ProductID:int:Primary Key
 +Name:varchar(50)
 +VolumeInStock:int
 +CurrentPrice:money
 +Photo:blob
 +Description:text
 +
 +</dbtables></code>
 +
plugin/dbtables.1285754249.txt.gz · Last modified: 2010-09-29 11:57 by 99.235.196.241

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