TRAC顯示某里程碑中ticket進度

SELECT
owner AS __group__,
(CASE status WHEN 'closed' THEN 'color: #aaaaaa'
ELSE ''
END) AS __style__,
(CASE status WHEN 'assigned' THEN 4
ELSE 3
END) AS __color__,
id AS ticket,

(CASE status = 'closed'
WHEN 0 THEN
(CASE (round(julianday(substr(tc.value,7,4) ||
'-' || substr(tc.value,1,2) || '-' ||
substr(tc.value,4,2))) - round(julianday('now'))) < 0
WHEN 0 THEN (round(julianday(substr(tc.value,7,4) || '-' ||
substr(tc.value,1,2) || '-' || substr(tc.value,4,2)))
- round(julianday('now')))
ELSE '超時' || abs((round(julianday(substr(tc.value,7,4) || '-' ||
substr(tc.value,1,2) || '-' || substr(tc.value,4,2)))
- round(julianday('now')))) || '天'
END)
ELSE ''
END) AS '距截止天數',

tc.value AS '預估截止日',

status,
priority,
summary,
t.type AS type,
time AS created,
changetime AS _changetime,
description AS _description,
reporter AS _reporter,
tc2.value AS '_due assign',

date('now') as _nowdate,
julianday('now') AS _nowdate2

FROM ticket t,enum p, ticket_custom tc, ticket_custom tc2
where
t.id = tc.ticket AND
tc.name = "due_close" AND
t.id = tc2.ticket AND
tc2.name = "due_assign" AND
p.name=t.priority AND
p.type='priority' AND
t.milestone='**指定里程碑**'
ORDER BY owner, (status = 'closed') ,p.value, t.type, time

TRAC依使用者顯示所指定里程碑的工作狀況

以下指令可用在TRAC上建立一個「依使用者顯示所指定里程碑的工作狀況」的報告。

• 依使用者分群
• 依priority排序
  
• 已經closed的ticket會排到最後面，同時以灰色字顯示
• 已經assigned的以藍色底顯示
  

SELECT
owner AS __group__,
(CASE status WHEN 'closed' THEN 'color: #aaaaaa'
ELSE ''
END) AS __style__,
(CASE status WHEN 'assigned' THEN 4
ELSE 3
END) AS __color__,
id AS ticket,
status,
priority,
summary,
component,
t.type AS type,
time AS created,
changetime AS _changetime,
description AS _description,
reporter AS _reporter
FROM ticket t,enum p
where
p.name=t.priority AND
p.type='priority' AND
t.milestone='***里程碑***'
ORDER BY owner, (status = 'closed') ,p.value, t.type, time

sqlite使用筆記

• database檔案: *.db
• 連接db: sqlite3 foo.db
• 區分sqlite指令與SQL指令
• sqlite指令以「.」開頭，比如說「.tables」用來列出所有table。「.help」用來列出可用的sqlite指令。
• SQL指令按照一般方式直接下，以「;」結尾。
  

Compiler Features of VB9 and C# 3.0

Intel Go Parallel Videos

Intel Go Parallel Videos:
http://www.devx.com/go-parallel/Door/36013

Concurrency Learning Curve:
http://www.oreillynet.com/windows/blog/2007/11/concurrency_learning_curve.html

70%的程式碼都是多餘無用的

• 70%的程式碼都是?:
  http://www.infoq.com/news/2007/10/reducing-code-waste
  http://smoothspan.wordpress.com/2007/09/04/70-of-the-software-you-build-is-wasted-part-1-of-series-of-toolplatform-rants/
• C++程式碼並沒有比C程式碼來得具有重用性: http://paulspontifications.blogspot.com/2007/09/composability-and-productivity.html

使用SQL Server 2005執行遞迴查詢

SQL Server 2005的新功能Common Table Expressions (CTE)可以用來作遞迴的SQL查詢

;WITH MenuCTE(MenuKey, ParentMenuKey, MenuName) AS
(
-- Anchor Query
SELECT MenuKey, ParentMenuKey, MenuName FROM Menu WHERE MenuKey = 1
UNION ALL
-- Recursive Query
SELECT m.MenuKey, m.ParentMenuKey, m.MenuName FROM Menu m INNER JOIN MenuCTE r ON m.ParentMenuKey = r.MenuKey
)

SELECT MenuKey, ParentMenuKey, MenuName FROM MenuCTE


參考資料：http://www.infoq.com/news/2007/10/CTE