Module: Wlog::IssueSql

Included in:

Issue

Defined in:

lib/wlog/domain/sql_modules/issue_sql.rb

Overview

Author:

• Simon Symeonidis

Constant Summary

TableName =

The table name of the log entries table

"issues"

InsertSql =

Standard insert

"INSERT INTO #{TableName} "\
"(description, reported_date, due_date, status, timelog,"\
"long_description) "\
"values (?,?,?,?,0,?);"

DeleteSql =

Standard delete

"DELETE FROM #{TableName} WHERE id = ? ;"

UpdateSql =

Standard update

"UPDATE #{TableName} SET "\
"description = ? , reported_date = ? , due_date = ? , status = ?, "\
"timelog = ? "\
"WHERE id = ?;"

SelectSql =

Select by id

"SELECT * FROM #{TableName} WHERE id = ? ;"

SelectAllSql =

Select all the issues (which are not archived)

"SELECT * FROM #{TableName} WHERE status <> 3; "

SelectFinishedSql =

Select issues that are finished

"SELECT * FROM #{TableName} WHERE status = 2"

SelectTimeRange =

Select issues given a time range

"SELECT * FROM #{TableName}"\
" WHERE reported_date >= ? AND reported_date <= ?"