Doxygen-like for .sql files in a php application -

-

we using doxygen document our php application , it's working have problem database structure: document .sql file using create tables (arround 60 tables far).

no sql procedures (might in future).

what have describe role of each table , meaning of each column. found hypersql (http://projects.izzysoft.de/trac/hypersql/) found little verbose:

008: /** logging messages 009:  *  (here log our actions) 010:  * @table iz_logging 011:  * @col number id id sorting purposes 012:  * @col date log_time time entry made 013:  * @col char(1) log_level logging level. here: "!" errors, "*" main (job start/end), "+" sub (e.g. switch next owner), "-" minor 014:  * @col varchar2(4000) log_entry log message 015:  * @author andreas itzchak rehberg 016:  */ 017: create table iz_logging ( 018:   id         number, 019:   log_time   date, 020:   log_level  char(1), 021:   log_entry  varchar2(4000) 022: );

is there tool wouldn't ask me repeat column type (date,char...) ? using document php/mysql projects ?

functionnality :

  • automatic detection of column's type
  • possibility group tables in categories (like in doxygen functions inside class)
  • html output : way, insert links php doc sql doc

thanks !

i have written input filter doxygen translates sql tables, procedures , functions c structs , c functions doxygen parse it. can use doxygen style comments in normal way translated too.

this implemented powershell script , examples aimed @ t-sql (i.e. sql server) should adapted other dialect. called sql2doxygen , here example of output , there manual here.

for me stop gap until doxygen natively supports sql. discovered doxygen branch in travels called sqldoxygen may provide goods.


Comments

Post a Comment

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

-
ho can set spacing beween stars? thats ratingbar: ratingbar = (ratingbar) inflater.inflate(r.layout.ratingbar, null); ratingbar.setlayoutparams(new layoutparams(layoutparams.wrap_content, layoutparams.wrap_content)); the layout: <?xml version="1.0" encoding="utf-8"?> <ratingbar xmlns:android="http://schemas.android.com/apk/res/android" style="@style/mystyle" android:layout_alignparentright="true" android:layout_height="19dp" android:layout_width="wrap_content" android:numstars="5"> </ratingbar> the style: <style name="mystyle" parent="@android:style/widget.ratingbar"> <item name="android:progressdrawable">@drawable/android_r2_ratingstar_yellow</item> <item name="android:indeterminatedrawable">@drawable/android_r2_ratingstar_grey</item> </style> thanks, cheers you have ...
Read more

html - Instapaper-like algorithm -

-
does of algorithm extracts contents webpage? instapaper ? there 2 steps instapaper does: find main content block on page (excluding headers, footers, menus etc) from content block extract , format text to find content block (typically html block element, div containing key page text content) instapaper uses algorithm 1 used readability . can @ source of readability.js see what's going on, @ core tries find area on page highest text/link ratio, although has other simple scoring metrics (e.g. off top of head, things ratio of text commas, para elements etc) go heuristics. once have identified root node element, relevant content, you'll need format it, if want can pull node element containing text out of source document , insert yours, in reality you'll want remove existing styles , apply own, standard , feel. if want output nice text-only can use jericho's renderer . update1 : should mention else instapaper - follow 'pagination' links (...
Read more

c# - How to execute a particular part of code asynchronously in a class -

-
i creating speech recognition engine that's going respond user commands.i have created button enable , disable speech recognition per user convenience.i have used dispose() of speech engine disable speech recoginition.here code private void button1_click(object sender, routedeventargs e) { engineon = !engineon; if (engineon) { speechengine = speech.createspeechengine(); //speech class creates , returns new speech engine. speechengine.audiolevelupdated += new eventhandler<audiolevelupdatedeventargs>(speechengine_audiolevelupdated); // use system's default microphone speechengine.setinputtodefaultaudiodevice(); speechengine.loadgrammar(new dictationgrammar()); // start listening speechengine.recognizeasync(recognizemode.multiple); } else { speechclass.myengine.dispose(); } } but disposal of speech obj...
Read more