com.atlassian.jira.database.DbConnection |
Known Indirect Subclasses |
A handle to a Database Connection obtained from JIRA's connection pool.
Public Methods | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Starts an delete statement on the given DB Table.
| |||||||||||
Returns the JDBC connection wrapped by this object.
| |||||||||||
Starts an insert statement on the given DB Table.
| |||||||||||
Starts a SELECT statement on this connection.
| |||||||||||
Starts an update statement on the given DB Table.
|
Starts an delete statement on the given DB Table.
Example usage:
dbConnection.delete(QIssueLink.ISSUE_LINK) .where(QIssueLink.ISSUE_LINK.id.eq(issueLink.getId())) .execute();
entity | The DB entity you want to delete from eg ISSUE |
---|
Returns the JDBC connection wrapped by this object.
Starts an insert statement on the given DB Table.
Example 1 usage:
dbConnection.insert(QIssueLink.ISSUE_LINK) .set(QIssueLink.ISSUE_LINK.linktype, newIssueLinkTypeId) .set(QIssueLink.ISSUE_LINK.sequence, sequence) .execute();
Example 2 usage:
dbConnection.insert(QIssueLink.ISSUE_LINK) .populate(issueLinkDTO) .execute();
entity | The DB entity you want to insert into eg ISSUE |
---|
Starts a SELECT statement on this connection.
Example usage:
QVersion v = new QVersion("v"); final Listversions = dbConnection.newSqlQuery() .from(v) .where(v.project.eq(projectId)) .orderBy(v.sequence.asc()) .list(v);
Starts an update statement on the given DB Table.
Example usage:
dbConnection.update(QIssueLink.ISSUE_LINK) .set(QIssueLink.ISSUE_LINK.linktype, newIssueLinkTypeId) .where(QIssueLink.ISSUE_LINK.id.eq(issueLink.getId())) .execute();
entity | The DB entity you want to update eg ISSUE |
---|