access mantis db and some sql for inquiry

原创 2005年03月02日 16:20:00

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

 

 

dplyr do: Some Tips for Using and Programming

This post was originally posted on Quantide blog. Read the full article here. If you want to comp...

Berkeley DB——Java and .Net and Some Applications

berkeley db——java and .net and some applications introduction berkeley db在c/c++环境下使用是十分方便的,尤其是使用c时...

American Idioms and Some Phrases Just For Fun

  • 2008年12月29日 16:39
  • 2.67MB
  • 下载

Data access between different DBMS and other txt/csv data source by DB Query Analyzer

In this essay, I will show you an example about data access between different DBMS and other txt/csv...

How to configure ODBC DSN in Client to access remote DB2 for Windows

This article introduces how to configure ODBC DSN in Client to access remote DB2 for windows in deta...

C#连接Access,Sql Server,Oracle,Mysql,IBM DB2,Sybase

1.C#连接Access 程序代码: ------------------------------------------------------------------------------...

C#连接各种数据库代码Access,Sql Server,Oracle,Mysql,IBM DB2,Sybase

C#连接连接Access 程序代码:  ------------------------------------------------------------------------------...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:access mantis db and some sql for inquiry
举报原因:
原因补充:

(最多只允许输入30个字)