|
Table DB
Topics |
Table DB Design NotesInitial requirements: Webteam/TableDB(approve sites) June 27, 2009 - JB I created a usage manual since I was forgetting how to use the markup myself. The sqlite database routines have been written. ToDo:
put the tables from memory into the sqlite database (which is also memory based) establish sqlite-like attrbutes that will be added to the tabledb markup
The sqlite database requires that I create tables. The tables must have a name. I can make each table name a single entity based on the pagename and the table number and the anchor April 19, 2009 - JB After PHP gets upgraded to the newest version we have a great advantage. PHP 5 has SQLite database engine built into it. That means we can run real SQL queries on table data after it is read into memory. With SQLite we do not have to use any database, we can do it all in memory. There will not even be a file on the hard disk for the database. This is clearly the best way to get this working. The PMWiki page source query information will go through a 'filter' that I will write in PHP that will make sure the system is safe from things like SQL injection attacks. I already have the table data in a memory structure so putting it into the SQLite memory tables will be easy, we can then run real SQL queries, that would be able to do anything in SQL that my filters would allow - including joins as complicated as you would please! My filters will also make the syntax easier to use. Oct 11, 2008 - JB I felt like documenting the way TableDB stores Tables in memory global $TDBTables; $TDBTables[$PageName][<Table Number>] = <num> $TDBTables[$PageName][<Table Number>]['TableItemType'][<num>] = <data> $TDBTables[$PageName][<Table Number>]['TableItemRow'][<num>] = <num>
May 10, 2007 - JB http://gnuzoo.org/tabledb/Test4 The link above shows that tables can be read into the table array and written back out to pmwiki. May 5, 2007 - SED Just a question, does PmWiki have a function that reads tables already that we could utilise, perhaps if PM exposed it as an API that could be used for recipe writers? Similary for generating a table?
May 4, 2007 - JB AnalysisI am finding myself confused by the structure of the data I am storing inside "the array" It happened upon my thoughts today that I need to have a single unified way of storing information for both table types. A new intermediate structure will make it easier to get and store table data and to extract data from it. Then routines which just want to get data can connect to this table data structure to extract data into their own structure. This will be better than going straight from page source because there is one single structure instead of two table types in page source. Pipe TablesPipe tables do not have to start with table attributes ("|| attributes"), they can start with caption or head or cell. If a new pipe table does not have table attributes but a previously defined pipe table on the same page did have them, new table will assume the same attributes. The beginning of a pipe table is determined by "||" at the start of a line that is at the top of the code or that is following a line that does not start with "||". The end of a pipe table is determined by a line that does not start with "||". Table attributes ("|| attributes") do not create a table but just set a variable that is what a table will use for attributes if it contains a caption, a head cell or cell. A caption line by itself will define a table, but it will not have any rows or cells. A row is designated by a newline between head or cell lines Caption, Head, and Cells can be all one one line. Table DirectivesTable directives require Data StructuresTable Infomation StructureStores table information and make it easier to redisplay and extract data.
Table Elements
Variable Definition StructureStore table data in array so order of occurence of items are preserved TableType$Tables[ 'PipeTable' or 'TableDirective'
Type$Tables[ Pipe Tables - 'ptable', 'pcaption', 'phead', 'pcell', 'prow', 'ptableend'
Table Directives - 'table', 'cellnr', 'cell', 'tableend'
Attr$Tables[ Pipe Tables - ptable, pcaption, phead, pcell
Table Directives - table, cellnr, cell
Data$Tables[ Pipe Tables - pcaption, phead, pcell - attribute whitepsace removed
Table Directives - cellnr, cell
Memory BufferFor a memory buffer table data will be simplified $TableData[$tablenumber][$rownum][$colnum] = $data;
May 3, 2007 - JB Page Test1 shows a table directives table being read and being displayed with table directives. Page Test2 shows an ordinary table being read and it is displayed with table directives! I did not get into processing colspan yet. I need to add a table type to the array so I can write a table out the same way I read it in. We need a set of default table attributes - that would be used for when a new table is created or perhaps when we are only a smaller displaying part of a table.
May 2, 2007 - JB Currently the recipe markup syntax is (is being) setup with table input/output syntax.
This will be used in the core of the recipe. Later when SQL-like syntax is developed
these markups/commands might only be used internally. Suggestion: could also
develop a second markup syntax such as "
April 30, 2007
|
tahi Page last modified on 2016 Jul 26 19:12
Edit - History - Recent Changes - WikiHelp - Search - email page as link -> mailto:?Subject="KiwiWiki: Table DB Design Notes"&Body=