access mantis db and some sql for inquiry

最新推荐文章于 2024-10-05 00:24:42 发布

innolux

最新推荐文章于 2024-10-05 00:24:42 发布

阅读量917

点赞数

分类专栏： Database 文章标签： access sql download mysql table database

本文链接：https://blog.csdn.net/innolux/article/details/307993

版权

Database 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

The mantis is an open source project for bug tracking. In our project, the db for mantis is mysql.

We can read the bug information from mantis through browser.

But you might hope to access the mantis db for more advance operation if you need do some complex operation for them.

The steps:

1. Download a mysql client tools. ( I recommend you to use toad for mysql, you can download it from http://www.quest.com/toad_for_mysql/index.asp, and it's totally free)

2. Submit a request to Vincent ( HP network Admin in Innolux project) to register your pc for access the mantis db. The only information you need sumbit is your pc name. If you really need access mantis db in your job, pls let me know your pc name, I will do it for you.

3. Connect to mantisdb with the following information

Host: 172.16.22.32

Database: bugtracker

Username: luke

Pwd: BLANK

4. Execute your SQL in your mysql client tool

Additionally, you can download myODBC from http://dev.mysql.com/doc/mysql/en/installing-myodbc.html

It can help you to create a ODBC DNS to access mysql database if you wanna write some vb program to access it. E.G. I made a VBA macro to get bug detail information according to bugid in excel file.

Here is a chinese mysql manual: http://netlab.cse.yzu.edu.tw/~statue/cfc/docs/mysqldoc_big5/manual_toc.html

The following sqls is used to query bug detail by date.

SELECT
a.id, a.severity, a.summary, a.category, a.status,
a.date_submitted, a.last_updated,b.value,IFNULL(c2.username,'') as assigner,
  c1.username as reporter, a.duplicate_id, prj.name,
  (TO_DAYS(now()) - TO_DAYS(a.last_updated)) as notfollowed
FROM
mantis_bug_table a left join mantis_user_table c2 on a.handler_id = c2.id,
bugtracker.mantis_custom_field_string_table b,mantis_user_table c1, mantis_project_table prj
WHERE
    a.ID = b.bug_id
     AND a.reporter_id = c1.id
    AND prj.id = a.project_id
    AND prj.name in ('Beluga MES','Production_Array','Production_Cell','Production_CF')
    AND a.status NOT in (80,85,90)
   AND DATE_FORMAT(a.date_submitted, '%Y-%m-%d') < '2005-01-01'
ORDER by
a.id desc