??????? 很多關(guān)心CowNew的朋友紛紛給我發(fā)email或者qq留言，說看到最近CowNew開源項目沒有動靜了，問我是不是虎頭蛇尾死掉了。謝謝大家的關(guān)心，CowNew沒有停止進步的步伐，最近一段時間沒有動靜是因為我們在悶頭做產(chǎn)品的開發(fā)。經(jīng)過一個多月的努力，在kingchou、紫龍等隊友的團結(jié)奮斗下，SQL解析引擎和JDBMonitor都已經(jīng)取得了階段性的成果。
??????? SQL解析引擎已經(jīng)可以生成完整的異構(gòu)SQLAST，除有少數(shù)小bug之外已經(jīng)基本達(dá)到了預(yù)期的目標(biāo)。另外在SQL解析引擎基礎(chǔ)上開發(fā)的CowNewSQL翻譯器也可以實現(xiàn)了基本的功能。可以翻譯大部分主流的sql語句，比如：
（1）可以將符合CowNewSQL語法的select now()翻譯成對應(yīng)如下的特定平臺sql：
mssql:Select GETDATE()
mysql:Select NOW()
oracle8i:Select SYSDATE FROM DUAL
oracle9i:Select SYSDATE FROM DUAL
（2）可以將符合CowNewSQL語法的
update T2 set fid=t1.fid from (select * from t2
left join t3 on t3.fid=t2.fid union select * from t5)
翻譯成對應(yīng)如下的特定平臺sql：
mssql:UPDATE T2 SET fid = t1.fid
FROM(
Select *
From t2 left join t3 on t3.fid = t2.fid
union Select *
From t5
)
mysql:UPDATE T2 SET fid = t1.fid
FROM(
Select *
From t2 left join t3 on t3.fid = t2.fid
union Select *
From t5
)
oracle8i:UPDATE T2 SET fid = t1.fid
FROM(
Select *
From t2,t3 WHERE t3.fid = t2.fid(+)
union Select *
From t5
)
oracle9i:UPDATE T2 SET fid = t1.fid
FROM(
Select *
From t2 left join t3 on t3.fid = t2.fid
union Select *
From t5
)
（2）可以將符合CowNewSQL語法的
select top 20 ABS(-1),lcase(trim(name)),tochar(now()), ADD_SECONDS(now(),22),t2.name,DateAdd(Year,now(),3) from T_Table
,(select * from T_MD where FID=2222222222) as tmd
left join T_T4 on tmd.id>T_Table.id
left join T_T2 as t2 on T_T2.id=T_Table.id
right join T_T3 as t3 on t2.id=t3.id
翻譯成對應(yīng)如下的特定平臺sql：
mssql:Select? top 20
?ABS(-1) , LOWER(LTRIM(RTRIM(name)) ,CONVERT(VARCHAR, GETDATE()),DATEADD(second,GETDATE(),22),t2.name,DATEADD(Year, GETDATE(), 3)
From T_Table,
Select *
From T_MD
Where FID = 2222222222 as tmd
?left join T_T4 on tmd.id > T_Table.id left join T_T2 as t2 on T_T2.id = T_Table.id right join T_T3 as t3 on t2.id = t3.id
mysql:Select? ABS(-1) , LOWER(LTRIM(RTRIM(name)) ,CONCAT('', NOW()),DATE_ADD(NOW(), INTERVAL 22 SECOND),t2.name,DATE_ADD(3, INTERVAL NOW() YEAR)
From T_Table,
Select *
From T_MD
Where FID = 2222222222 as tmd
?left join T_T4 on tmd.id > T_Table.id left join T_T2 as t2 on T_T2.id = T_Table.id right join T_T3 as t3 on t2.id = t3.id limit 0, 20
oracle8i:Select? ABS(-1) , LOWER(LTRIM(RTRIM(name)) , TO_CHAR(SYSDATE) ,(SYSDATE + 22/86400),t2.name,add_months(3, TRUNC(SYSDATE) * 12)
From T_Table,
Select *
From T_MD
Where FID = 2222222222 as tmd
,T_T4,T_T2 as t2,T_T3 as t3 WHERE ROWNUM <= 20
?AND tmd.id > T_Table.id(+) AND T_T2.id = T_Table.id(+) AND t2.id(+) = t3.id
oracle9i:Select? ABS(-1) , LOWER(LTRIM(RTRIM(name)) , TO_CHAR(SYSDATE) ,(SYSDATE + 22/86400),t2.name,add_months(3, TRUNC(SYSDATE) * 12)
From T_Table,
Select *
From T_MD
Where FID = 2222222222 as tmd
?left join T_T4 on tmd.id > T_Table.id left join T_T2 as t2 on T_T2.id = T_Table.id right join T_T3 as t3 on t2.id = t3.id WHERE ROWNUM <= 20
??????? 但是這些sql翻譯只是按照語法手冊進行的翻譯，還沒有經(jīng)過正式數(shù)據(jù)庫環(huán)境的測試，還需要進一步的測試。
??????? 目前僅支持MSSQLSERVER,MYSQL,Oracle8i,Oracle9i，我們計劃進一步支持DB2UDB,FireBird、ACCESS等數(shù)據(jù)庫。而且SQL解析引擎是用JDK5開發(fā)的，我們將是用Retrotranslator將其轉(zhuǎn)換個以保證可以在JDK1.4上運行。
??????? JDBMonitor的需求已經(jīng)基本完成，但是新增的功能目前只能運行在MSSQLSERVER上，我們準(zhǔn)備等COWNEWSQL翻譯器開發(fā)完畢后，將JDBMonitor涉及到數(shù)據(jù)庫操作的地方是用COWNEWSQL翻譯器來完成多數(shù)據(jù)庫支持，所以我們將會推遲JDBMonitor的原計劃的發(fā)版日期。
??????? 目前我們的項目還是很缺乏高手，比如CowNewSQL這塊就缺乏對各種數(shù)據(jù)庫比較熟悉的朋友，還有能對CowNewSQL進行全面測試的朋友，希望對這方面開發(fā)比較感興趣的能加入到我們的開發(fā)中來，共同打造優(yōu)秀的開源產(chǎn)品。可以直接給我發(fā)送郵件about521 at 163.com