To Do A.11 - Integrate API status into WineHQ

[hatky]

It looks complicated but it's all 3 mysql commands to
get a complete table 
with whatever data you want from the winapi stats data
in a nice table...

Take the attached file (it just strips some text) , 
create user as mysql user that has a db called winapi
with CREATE TEMPORARY 
TABLE and select rights 
then run:

./tools/winapi/winapi_extract --pseudo-stub-statistics
--no-verbose 
--no-progress >winapi_stats.txt
php winapi_stats.php > winapi_stats,dat

mysql --execute='
CREATE TEMPORARY TABLE `winapi` (
 `module` VARCHAR( 255 ) NOT NULL ,
 `stubs` INT NOT NULL ,
 `total_func` INT NOT NULL ,
 `real_stub` INT NOT NULL ,
 `psedo_stubs` INT NOT NULL ,
 `forwards` INT NOT NULL ,
 PRIMARY KEY ( `module` ) 
);

LOAD DATA LOCAL INFILE "winapi_stats,dat" REPLACE INTO
TABLE winapi
FIELDS TERMINATED BY "~"
LINES TERMINATED BY "\n";

SELECT "Total" "Library", sum(total_func) "API Count",

(sum(total_func) - sum(stubs)) / sum(total_func) *100
"% implemented", 
sum(stubs) "Total Stubs", sum(real_stub),
sum(psedo_stubs)
FROM winapi
UNION ALL
SELECT module "Library", total_func "API Count", (
total_func - stubs
) / total_func *100 "% implemented", stubs "Total
Stubs", real_stub, 
psedo_stubs
FROM winapi;
' -u user -D winapi -H
>/lostwages/templates/en/winapi_stats.html


comments?

p.s. sorry for the yahoo and the linewrap mess my mail
dosn't send latly...
-- 
Hatky,
Worshiper of wine (http://www.winehq.org/ or
http://hatky.myz.info/wine/),
Impossible is only an opinion.

__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winapi_stats.php
Type: application/x-php
Size: 563 bytes
Desc: winapi_stats.php
Url : http://www.winehq.org/pipermail/wine-devel/attachments/20040324/3cd9bc0d/winapi_stats.bin