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

 

 

版权声明:本文为博主原创文章,未经博主允许不得转载。

相关文章推荐

Berkeley DB——Java and .Net and Some Applications

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

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...

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...

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...

C#连接Access、SQL Server、Oracle、MySQL、DB2和SyBase数据库的代码集

C#连接六类数据库的代码集 本文列出了C#连接Access、SQL Server、Oracle、MySQL、DB2和SyBase六种不同数据库的程序源码

Access和sql server的语法区别 (包括db2 oracle)

Access和sql server的语法区别 (包括db2 oracle) 收藏 Access和sql server的语法区别 一、有区别的函数及解决方案 以下所示的解决方案中的函数定义在untDat...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

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