diff options
Diffstat (limited to 'plugins/org.eclipse.osee.framework.database')
11 files changed, 770 insertions, 770 deletions
diff --git a/plugins/org.eclipse.osee.framework.database/OSGI-INF/uri.connection.contributor.xml b/plugins/org.eclipse.osee.framework.database/OSGI-INF/uri.connection.contributor.xml index d1cec1995b6..b50e6ee81d4 100644 --- a/plugins/org.eclipse.osee.framework.database/OSGI-INF/uri.connection.contributor.xml +++ b/plugins/org.eclipse.osee.framework.database/OSGI-INF/uri.connection.contributor.xml @@ -1,7 +1,7 @@ -<?xml version="1.0"?>
-<component name="uri.connection.contributor">
- <implementation class="org.eclipse.osee.framework.database.internal.UriDbConnectionInfo"/>
- <service>
- <provide interface="org.eclipse.osee.framework.database.core.IDbConnectionInformationContributor"/>
- </service>
+<?xml version="1.0"?> +<component name="uri.connection.contributor"> + <implementation class="org.eclipse.osee.framework.database.internal.UriDbConnectionInfo"/> + <service> + <provide interface="org.eclipse.osee.framework.database.core.IDbConnectionInformationContributor"/> + </service> </component>
\ No newline at end of file diff --git a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/AbstractJoinQuery.java b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/AbstractJoinQuery.java index e1d7b221582..3651486d020 100644 --- a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/AbstractJoinQuery.java +++ b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/AbstractJoinQuery.java @@ -1,118 +1,118 @@ -/*******************************************************************************
- * Copyright (c) 2004, 2007 Boeing.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- * Boeing - initial API and implementation
- *******************************************************************************/
-package org.eclipse.osee.framework.database.core;
-
-import java.sql.Timestamp;
-import java.util.ArrayList;
-import java.util.Collection;
-import java.util.HashSet;
-import java.util.List;
-import java.util.Set;
-import org.eclipse.osee.framework.core.exception.OseeCoreException;
-import org.eclipse.osee.framework.core.exception.OseeDataStoreException;
-import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem;
-import org.eclipse.osee.framework.jdk.core.util.time.GlobalTime;
-
-/**
- * @author Roberto E. Escobar
- */
-public abstract class AbstractJoinQuery {
-
- protected static interface IJoinRow {
- Object[] toArray();
-
- @Override
- String toString();
- }
-
- private final IJoinAccessor joinAccessor;
- private final JoinItem joinItem;
- private final int queryId;
-
- private final Timestamp insertTime;
- protected final Set<IJoinRow> entries = new HashSet<IJoinRow>();
-
- private boolean wasStored;
- private int storedSize;
-
- protected AbstractJoinQuery(IJoinAccessor joinAccessor, JoinItem joinItem, int queryId) {
- this.joinAccessor = joinAccessor;
- this.joinItem = joinItem;
- this.queryId = queryId;
- this.insertTime = GlobalTime.GreenwichMeanTimestamp();
- this.storedSize = -1;
- this.wasStored = false;
- }
-
- public boolean isEmpty() {
- return this.wasStored != true ? entries.isEmpty() : this.storedSize > 0;
- }
-
- public int size() {
- return this.wasStored != true ? entries.size() : this.storedSize;
- }
-
- public int getQueryId() {
- return queryId;
- }
-
- public Timestamp getInsertTime() {
- return insertTime;
- }
-
- public String getJoinTableName() {
- return joinItem.getJoinTableName();
- }
-
- public boolean wasStored() {
- return wasStored;
- }
-
- public void store(OseeConnection connection) throws OseeCoreException {
- if (this.wasStored != true) {
- List<Object[]> data = new ArrayList<Object[]>();
- for (IJoinRow joinArray : entries) {
- data.add(joinArray.toArray());
- }
- joinAccessor.store(connection, joinItem, getQueryId(), data);
- this.storedSize = this.entries.size();
- this.wasStored = true;
- this.entries.clear();
- } else {
- throw new OseeDataStoreException("Cannot store query id twice");
- }
- }
-
- public int delete(OseeConnection connection) throws OseeCoreException {
- return joinAccessor.delete(connection, joinItem, getQueryId());
- }
-
- public void store() throws OseeCoreException {
- store(null);
- }
-
- public int delete() throws OseeCoreException {
- return delete(null);
- }
-
- public Collection<Integer> getAllQueryIds(OseeConnection connection) throws OseeCoreException {
- return joinAccessor.getAllQueryIds(connection, joinItem);
- }
-
- public Collection<Integer> getAllQueryIds() throws OseeCoreException {
- return joinAccessor.getAllQueryIds(null, joinItem);
- }
-
- @Override
- public String toString() {
- return String.format("id: [%s] entrySize: [%d]", getQueryId(), size());
- }
+/******************************************************************************* + * Copyright (c) 2004, 2007 Boeing. + * All rights reserved. This program and the accompanying materials + * are made available under the terms of the Eclipse Public License v1.0 + * which accompanies this distribution, and is available at + * http://www.eclipse.org/legal/epl-v10.html + * + * Contributors: + * Boeing - initial API and implementation + *******************************************************************************/ +package org.eclipse.osee.framework.database.core; + +import java.sql.Timestamp; +import java.util.ArrayList; +import java.util.Collection; +import java.util.HashSet; +import java.util.List; +import java.util.Set; +import org.eclipse.osee.framework.core.exception.OseeCoreException; +import org.eclipse.osee.framework.core.exception.OseeDataStoreException; +import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem; +import org.eclipse.osee.framework.jdk.core.util.time.GlobalTime; + +/** + * @author Roberto E. Escobar + */ +public abstract class AbstractJoinQuery { + + protected static interface IJoinRow { + Object[] toArray(); + + @Override + String toString(); + } + + private final IJoinAccessor joinAccessor; + private final JoinItem joinItem; + private final int queryId; + + private final Timestamp insertTime; + protected final Set<IJoinRow> entries = new HashSet<IJoinRow>(); + + private boolean wasStored; + private int storedSize; + + protected AbstractJoinQuery(IJoinAccessor joinAccessor, JoinItem joinItem, int queryId) { + this.joinAccessor = joinAccessor; + this.joinItem = joinItem; + this.queryId = queryId; + this.insertTime = GlobalTime.GreenwichMeanTimestamp(); + this.storedSize = -1; + this.wasStored = false; + } + + public boolean isEmpty() { + return this.wasStored != true ? entries.isEmpty() : this.storedSize > 0; + } + + public int size() { + return this.wasStored != true ? entries.size() : this.storedSize; + } + + public int getQueryId() { + return queryId; + } + + public Timestamp getInsertTime() { + return insertTime; + } + + public String getJoinTableName() { + return joinItem.getJoinTableName(); + } + + public boolean wasStored() { + return wasStored; + } + + public void store(OseeConnection connection) throws OseeCoreException { + if (this.wasStored != true) { + List<Object[]> data = new ArrayList<Object[]>(); + for (IJoinRow joinArray : entries) { + data.add(joinArray.toArray()); + } + joinAccessor.store(connection, joinItem, getQueryId(), data); + this.storedSize = this.entries.size(); + this.wasStored = true; + this.entries.clear(); + } else { + throw new OseeDataStoreException("Cannot store query id twice"); + } + } + + public int delete(OseeConnection connection) throws OseeCoreException { + return joinAccessor.delete(connection, joinItem, getQueryId()); + } + + public void store() throws OseeCoreException { + store(null); + } + + public int delete() throws OseeCoreException { + return delete(null); + } + + public Collection<Integer> getAllQueryIds(OseeConnection connection) throws OseeCoreException { + return joinAccessor.getAllQueryIds(connection, joinItem); + } + + public Collection<Integer> getAllQueryIds() throws OseeCoreException { + return joinAccessor.getAllQueryIds(null, joinItem); + } + + @Override + public String toString() { + return String.format("id: [%s] entrySize: [%d]", getQueryId(), size()); + } }
\ No newline at end of file diff --git a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/ArtifactJoinQuery.java b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/ArtifactJoinQuery.java index 2ba4510fd72..35232fe0922 100644 --- a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/ArtifactJoinQuery.java +++ b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/ArtifactJoinQuery.java @@ -1,65 +1,65 @@ -/*******************************************************************************
- * Copyright (c) 2004, 2007 Boeing.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- * Boeing - initial API and implementation
- *******************************************************************************/
-package org.eclipse.osee.framework.database.core;
-
-import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem;
-
-/**
- * @author Roberto E. Escobar
- */
-public final class ArtifactJoinQuery extends AbstractJoinQuery {
-
- private final class Entry implements IJoinRow {
- private final int artId;
- private final int branchId;
-
- private Entry(Integer artId, Integer branchId) {
- this.artId = artId;
- this.branchId = branchId;
- }
-
- @Override
- public Object[] toArray() {
- return new Object[] {getQueryId(), getInsertTime(), artId, branchId};
- }
-
- @Override
- public String toString() {
- return String.format("art_id=%s, branch_id=%s", artId, branchId);
- }
-
- @Override
- public boolean equals(Object obj) {
- if (obj == this) {
- return true;
- }
- if (!(obj instanceof Entry)) {
- return false;
- }
- Entry other = (Entry) obj;
- return other.artId == this.artId && other.branchId == this.branchId;
- }
-
- @Override
- public int hashCode() {
- return 37 * artId * branchId;
- }
- }
-
- protected ArtifactJoinQuery(IJoinAccessor joinAccessor, int queryId) {
- super(joinAccessor, JoinItem.ARTIFACT, queryId);
- }
-
- public void add(Integer art_id, Integer branchId) {
- entries.add(new Entry(art_id, branchId));
- }
-
+/******************************************************************************* + * Copyright (c) 2004, 2007 Boeing. + * All rights reserved. This program and the accompanying materials + * are made available under the terms of the Eclipse Public License v1.0 + * which accompanies this distribution, and is available at + * http://www.eclipse.org/legal/epl-v10.html + * + * Contributors: + * Boeing - initial API and implementation + *******************************************************************************/ +package org.eclipse.osee.framework.database.core; + +import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem; + +/** + * @author Roberto E. Escobar + */ +public final class ArtifactJoinQuery extends AbstractJoinQuery { + + private final class Entry implements IJoinRow { + private final int artId; + private final int branchId; + + private Entry(Integer artId, Integer branchId) { + this.artId = artId; + this.branchId = branchId; + } + + @Override + public Object[] toArray() { + return new Object[] {getQueryId(), getInsertTime(), artId, branchId}; + } + + @Override + public String toString() { + return String.format("art_id=%s, branch_id=%s", artId, branchId); + } + + @Override + public boolean equals(Object obj) { + if (obj == this) { + return true; + } + if (!(obj instanceof Entry)) { + return false; + } + Entry other = (Entry) obj; + return other.artId == this.artId && other.branchId == this.branchId; + } + + @Override + public int hashCode() { + return 37 * artId * branchId; + } + } + + protected ArtifactJoinQuery(IJoinAccessor joinAccessor, int queryId) { + super(joinAccessor, JoinItem.ARTIFACT, queryId); + } + + public void add(Integer art_id, Integer branchId) { + entries.add(new Entry(art_id, branchId)); + } + }
\ No newline at end of file diff --git a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/CharJoinQuery.java b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/CharJoinQuery.java index 7ab05345bd6..62e5102052a 100644 --- a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/CharJoinQuery.java +++ b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/CharJoinQuery.java @@ -1,83 +1,83 @@ -/*******************************************************************************
- * Copyright (c) 2004, 2007 Boeing.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- * Boeing - initial API and implementation
- *******************************************************************************/
-package org.eclipse.osee.framework.database.core;
-
-import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem;
-
-/**
- * @author Roberto E. Escobar
- */
-public final class CharJoinQuery extends AbstractJoinQuery {
-
- private final class CharJoinEntry implements IJoinRow {
- private final String value;
-
- private CharJoinEntry(String value) {
- this.value = value;
- }
-
- @Override
- public Object[] toArray() {
- return new Object[] {getQueryId(), value};
- }
-
- @Override
- public boolean equals(Object obj) {
- if (this == obj) {
- return true;
- }
- if (obj == null) {
- return false;
- }
- if (getClass() != obj.getClass()) {
- return false;
- }
- CharJoinEntry other = (CharJoinEntry) obj;
- if (!getOuterType().equals(other.getOuterType())) {
- return false;
- }
- if (value == null) {
- if (other.value != null) {
- return false;
- }
- } else if (!value.equals(other.value)) {
- return false;
- }
- return true;
- }
-
- @Override
- public int hashCode() {
- final int prime = 31;
- int result = 1;
- result = prime * result + getOuterType().hashCode();
- result = prime * result + ((value == null) ? 0 : value.hashCode());
- return result;
- }
-
- @Override
- public String toString() {
- return value;
- }
-
- private CharJoinQuery getOuterType() {
- return CharJoinQuery.this;
- }
- }
-
- protected CharJoinQuery(IJoinAccessor joinAccessor, int queryId) {
- super(joinAccessor, JoinItem.CHAR_ID, queryId);
- }
-
- public void add(String value) {
- entries.add(new CharJoinEntry(value));
- }
+/******************************************************************************* + * Copyright (c) 2004, 2007 Boeing. + * All rights reserved. This program and the accompanying materials + * are made available under the terms of the Eclipse Public License v1.0 + * which accompanies this distribution, and is available at + * http://www.eclipse.org/legal/epl-v10.html + * + * Contributors: + * Boeing - initial API and implementation + *******************************************************************************/ +package org.eclipse.osee.framework.database.core; + +import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem; + +/** + * @author Roberto E. Escobar + */ +public final class CharJoinQuery extends AbstractJoinQuery { + + private final class CharJoinEntry implements IJoinRow { + private final String value; + + private CharJoinEntry(String value) { + this.value = value; + } + + @Override + public Object[] toArray() { + return new Object[] {getQueryId(), value}; + } + + @Override + public boolean equals(Object obj) { + if (this == obj) { + return true; + } + if (obj == null) { + return false; + } + if (getClass() != obj.getClass()) { + return false; + } + CharJoinEntry other = (CharJoinEntry) obj; + if (!getOuterType().equals(other.getOuterType())) { + return false; + } + if (value == null) { + if (other.value != null) { + return false; + } + } else if (!value.equals(other.value)) { + return false; + } + return true; + } + + @Override + public int hashCode() { + final int prime = 31; + int result = 1; + result = prime * result + getOuterType().hashCode(); + result = prime * result + ((value == null) ? 0 : value.hashCode()); + return result; + } + + @Override + public String toString() { + return value; + } + + private CharJoinQuery getOuterType() { + return CharJoinQuery.this; + } + } + + protected CharJoinQuery(IJoinAccessor joinAccessor, int queryId) { + super(joinAccessor, JoinItem.CHAR_ID, queryId); + } + + public void add(String value) { + entries.add(new CharJoinEntry(value)); + } }
\ No newline at end of file diff --git a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/ExportImportJoinQuery.java b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/ExportImportJoinQuery.java index 9109688c0c5..c2407f77331 100644 --- a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/ExportImportJoinQuery.java +++ b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/ExportImportJoinQuery.java @@ -1,64 +1,64 @@ -/*******************************************************************************
- * Copyright (c) 2004, 2007 Boeing.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- * Boeing - initial API and implementation
- *******************************************************************************/
-package org.eclipse.osee.framework.database.core;
-
-import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem;
-
-/**
- * @author Roberto E. Escobar
- */
-public final class ExportImportJoinQuery extends AbstractJoinQuery {
-
- private final class ExportImportEntry implements IJoinRow {
- private final long id1;
- private final long id2;
-
- private ExportImportEntry(Long id1, Long id2) {
- this.id1 = id1;
- this.id2 = id2;
- }
-
- @Override
- public Object[] toArray() {
- return new Object[] {getQueryId(), getInsertTime(), id1, id2};
- }
-
- @Override
- public boolean equals(Object obj) {
- if (obj == this) {
- return true;
- }
- if (!(obj instanceof ExportImportEntry)) {
- return false;
- }
- ExportImportEntry other = (ExportImportEntry) obj;
- return this.id1 == other.id1 && this.id2 == other.id2;
- }
-
- @Override
- public int hashCode() {
- return Long.valueOf(37 * id1 * id2).hashCode();
- }
-
- @Override
- public String toString() {
- return String.format("id1=%s id2=%s", id1, id2);
- }
- }
-
- protected ExportImportJoinQuery(IJoinAccessor joinAccessor, int queryId) {
- super(joinAccessor, JoinItem.EXPORT_IMPORT, queryId);
- }
-
- public void add(Long id1, Long id2) {
- entries.add(new ExportImportEntry(id1, id2));
- }
+/******************************************************************************* + * Copyright (c) 2004, 2007 Boeing. + * All rights reserved. This program and the accompanying materials + * are made available under the terms of the Eclipse Public License v1.0 + * which accompanies this distribution, and is available at + * http://www.eclipse.org/legal/epl-v10.html + * + * Contributors: + * Boeing - initial API and implementation + *******************************************************************************/ +package org.eclipse.osee.framework.database.core; + +import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem; + +/** + * @author Roberto E. Escobar + */ +public final class ExportImportJoinQuery extends AbstractJoinQuery { + + private final class ExportImportEntry implements IJoinRow { + private final long id1; + private final long id2; + + private ExportImportEntry(Long id1, Long id2) { + this.id1 = id1; + this.id2 = id2; + } + + @Override + public Object[] toArray() { + return new Object[] {getQueryId(), getInsertTime(), id1, id2}; + } + + @Override + public boolean equals(Object obj) { + if (obj == this) { + return true; + } + if (!(obj instanceof ExportImportEntry)) { + return false; + } + ExportImportEntry other = (ExportImportEntry) obj; + return this.id1 == other.id1 && this.id2 == other.id2; + } + + @Override + public int hashCode() { + return Long.valueOf(37 * id1 * id2).hashCode(); + } + + @Override + public String toString() { + return String.format("id1=%s id2=%s", id1, id2); + } + } + + protected ExportImportJoinQuery(IJoinAccessor joinAccessor, int queryId) { + super(joinAccessor, JoinItem.EXPORT_IMPORT, queryId); + } + + public void add(Long id1, Long id2) { + entries.add(new ExportImportEntry(id1, id2)); + } }
\ No newline at end of file diff --git a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/IdJoinQuery.java b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/IdJoinQuery.java index 5bd47720bda..a76f0616c05 100644 --- a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/IdJoinQuery.java +++ b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/IdJoinQuery.java @@ -1,62 +1,62 @@ -/*******************************************************************************
- * Copyright (c) 2004, 2007 Boeing.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- * Boeing - initial API and implementation
- *******************************************************************************/
-package org.eclipse.osee.framework.database.core;
-
-import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem;
-
-/**
- * @author Roberto E. Escobar
- */
-public final class IdJoinQuery extends AbstractJoinQuery {
-
- private final class TempIdEntry implements IJoinRow {
- private final int id;
-
- private TempIdEntry(Integer id) {
- this.id = id;
- }
-
- @Override
- public Object[] toArray() {
- return new Object[] {getQueryId(), getInsertTime(), id};
- }
-
- @Override
- public boolean equals(Object obj) {
- if (obj == this) {
- return true;
- }
- if (!(obj instanceof TempIdEntry)) {
- return false;
- }
- TempIdEntry other = (TempIdEntry) obj;
- return other.id == this.id;
- }
-
- @Override
- public int hashCode() {
- return 37 * id;
- }
-
- @Override
- public String toString() {
- return "id = " + id;
- }
- }
-
- protected IdJoinQuery(IJoinAccessor joinAccessor, int queryId) {
- super(joinAccessor, JoinItem.ID, queryId);
- }
-
- public void add(Integer id) {
- entries.add(new TempIdEntry(id));
- }
+/******************************************************************************* + * Copyright (c) 2004, 2007 Boeing. + * All rights reserved. This program and the accompanying materials + * are made available under the terms of the Eclipse Public License v1.0 + * which accompanies this distribution, and is available at + * http://www.eclipse.org/legal/epl-v10.html + * + * Contributors: + * Boeing - initial API and implementation + *******************************************************************************/ +package org.eclipse.osee.framework.database.core; + +import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem; + +/** + * @author Roberto E. Escobar + */ +public final class IdJoinQuery extends AbstractJoinQuery { + + private final class TempIdEntry implements IJoinRow { + private final int id; + + private TempIdEntry(Integer id) { + this.id = id; + } + + @Override + public Object[] toArray() { + return new Object[] {getQueryId(), getInsertTime(), id}; + } + + @Override + public boolean equals(Object obj) { + if (obj == this) { + return true; + } + if (!(obj instanceof TempIdEntry)) { + return false; + } + TempIdEntry other = (TempIdEntry) obj; + return other.id == this.id; + } + + @Override + public int hashCode() { + return 37 * id; + } + + @Override + public String toString() { + return "id = " + id; + } + } + + protected IdJoinQuery(IJoinAccessor joinAccessor, int queryId) { + super(joinAccessor, JoinItem.ID, queryId); + } + + public void add(Integer id) { + entries.add(new TempIdEntry(id)); + } }
\ No newline at end of file diff --git a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/SearchTagJoinQuery.java b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/SearchTagJoinQuery.java index c367bd80205..db52a011533 100644 --- a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/SearchTagJoinQuery.java +++ b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/SearchTagJoinQuery.java @@ -1,62 +1,62 @@ -/*******************************************************************************
- * Copyright (c) 2004, 2007 Boeing.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- * Boeing - initial API and implementation
- *******************************************************************************/
-package org.eclipse.osee.framework.database.core;
-
-import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem;
-
-/**
- * @author Roberto E. Escobar
- */
-public final class SearchTagJoinQuery extends AbstractJoinQuery {
-
- private final class TagEntry implements IJoinRow {
- private final long value;
-
- private TagEntry(Long value) {
- this.value = value;
- }
-
- @Override
- public Object[] toArray() {
- return new Object[] {getQueryId(), getInsertTime(), value};
- }
-
- @Override
- public boolean equals(Object obj) {
- if (obj == this) {
- return true;
- }
- if (!(obj instanceof TagEntry)) {
- return false;
- }
- TagEntry other = (TagEntry) obj;
- return this.value == other.value;
- }
-
- @Override
- public int hashCode() {
- return Long.valueOf(37 * value).hashCode();
- }
-
- @Override
- public String toString() {
- return String.format("tag=%s", value);
- }
- }
-
- protected SearchTagJoinQuery(IJoinAccessor joinAccessor, int queryId) {
- super(joinAccessor, JoinItem.SEARCH_TAGS, queryId);
- }
-
- public void add(Long tag) {
- entries.add(new TagEntry(tag));
- }
+/******************************************************************************* + * Copyright (c) 2004, 2007 Boeing. + * All rights reserved. This program and the accompanying materials + * are made available under the terms of the Eclipse Public License v1.0 + * which accompanies this distribution, and is available at + * http://www.eclipse.org/legal/epl-v10.html + * + * Contributors: + * Boeing - initial API and implementation + *******************************************************************************/ +package org.eclipse.osee.framework.database.core; + +import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem; + +/** + * @author Roberto E. Escobar + */ +public final class SearchTagJoinQuery extends AbstractJoinQuery { + + private final class TagEntry implements IJoinRow { + private final long value; + + private TagEntry(Long value) { + this.value = value; + } + + @Override + public Object[] toArray() { + return new Object[] {getQueryId(), getInsertTime(), value}; + } + + @Override + public boolean equals(Object obj) { + if (obj == this) { + return true; + } + if (!(obj instanceof TagEntry)) { + return false; + } + TagEntry other = (TagEntry) obj; + return this.value == other.value; + } + + @Override + public int hashCode() { + return Long.valueOf(37 * value).hashCode(); + } + + @Override + public String toString() { + return String.format("tag=%s", value); + } + } + + protected SearchTagJoinQuery(IJoinAccessor joinAccessor, int queryId) { + super(joinAccessor, JoinItem.SEARCH_TAGS, queryId); + } + + public void add(Long tag) { + entries.add(new TagEntry(tag)); + } }
\ No newline at end of file diff --git a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/TagQueueJoinQuery.java b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/TagQueueJoinQuery.java index b1c996a5792..c662d9124ac 100644 --- a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/TagQueueJoinQuery.java +++ b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/TagQueueJoinQuery.java @@ -1,62 +1,62 @@ -/*******************************************************************************
- * Copyright (c) 2004, 2007 Boeing.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- * Boeing - initial API and implementation
- *******************************************************************************/
-package org.eclipse.osee.framework.database.core;
-
-import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem;
-
-/**
- * @author Roberto E. Escobar
- */
-public final class TagQueueJoinQuery extends AbstractJoinQuery {
-
- private final class GammaEntry implements IJoinRow {
- private final long gammaId;
-
- private GammaEntry(Long gammaId) {
- this.gammaId = gammaId;
- }
-
- @Override
- public Object[] toArray() {
- return new Object[] {getQueryId(), getInsertTime(), gammaId};
- }
-
- @Override
- public boolean equals(Object obj) {
- if (obj == this) {
- return true;
- }
- if (!(obj instanceof GammaEntry)) {
- return false;
- }
- GammaEntry other = (GammaEntry) obj;
- return this.gammaId == other.gammaId;
- }
-
- @Override
- public int hashCode() {
- return Long.valueOf(37 * gammaId).hashCode();
- }
-
- @Override
- public String toString() {
- return String.format("gammaId=%s", gammaId);
- }
- }
-
- protected TagQueueJoinQuery(IJoinAccessor joinAccessor, int queryId) {
- super(joinAccessor, JoinItem.TAG_GAMMA_QUEUE, queryId);
- }
-
- public void add(Long gammaId) {
- entries.add(new GammaEntry(gammaId));
- }
+/******************************************************************************* + * Copyright (c) 2004, 2007 Boeing. + * All rights reserved. This program and the accompanying materials + * are made available under the terms of the Eclipse Public License v1.0 + * which accompanies this distribution, and is available at + * http://www.eclipse.org/legal/epl-v10.html + * + * Contributors: + * Boeing - initial API and implementation + *******************************************************************************/ +package org.eclipse.osee.framework.database.core; + +import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem; + +/** + * @author Roberto E. Escobar + */ +public final class TagQueueJoinQuery extends AbstractJoinQuery { + + private final class GammaEntry implements IJoinRow { + private final long gammaId; + + private GammaEntry(Long gammaId) { + this.gammaId = gammaId; + } + + @Override + public Object[] toArray() { + return new Object[] {getQueryId(), getInsertTime(), gammaId}; + } + + @Override + public boolean equals(Object obj) { + if (obj == this) { + return true; + } + if (!(obj instanceof GammaEntry)) { + return false; + } + GammaEntry other = (GammaEntry) obj; + return this.gammaId == other.gammaId; + } + + @Override + public int hashCode() { + return Long.valueOf(37 * gammaId).hashCode(); + } + + @Override + public String toString() { + return String.format("gammaId=%s", gammaId); + } + } + + protected TagQueueJoinQuery(IJoinAccessor joinAccessor, int queryId) { + super(joinAccessor, JoinItem.TAG_GAMMA_QUEUE, queryId); + } + + public void add(Long gammaId) { + entries.add(new GammaEntry(gammaId)); + } }
\ No newline at end of file diff --git a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/TransactionJoinQuery.java b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/TransactionJoinQuery.java index 77c6520897e..2c1ff595afc 100644 --- a/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/TransactionJoinQuery.java +++ b/plugins/org.eclipse.osee.framework.database/src/org/eclipse/osee/framework/database/core/TransactionJoinQuery.java @@ -1,85 +1,85 @@ -/*******************************************************************************
- * Copyright (c) 2004, 2007 Boeing.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- * Boeing - initial API and implementation
- *******************************************************************************/
-package org.eclipse.osee.framework.database.core;
-
-import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem;
-
-/**
- * @author Roberto E. Escobar
- */
-public final class TransactionJoinQuery extends AbstractJoinQuery {
-
- private final class TempTransactionEntry implements IJoinRow {
- private final long gammaId;
- private final int transactionId;
-
- private TempTransactionEntry(Long gammaId, Integer transactionId) {
- this.gammaId = gammaId;
- this.transactionId = transactionId;
- }
-
- @Override
- public Object[] toArray() {
- return new Object[] {getQueryId(), getInsertTime(), gammaId, transactionId};
- }
-
- @Override
- public int hashCode() {
- final int prime = 31;
- int result = 1;
- result = prime * result + getOuterType().hashCode();
- result = prime * result + (int) (gammaId ^ (gammaId >>> 32));
- result = prime * result + transactionId;
- return result;
- }
-
- @Override
- public boolean equals(Object obj) {
- if (this == obj) {
- return true;
- }
- if (obj == null) {
- return false;
- }
- if (getClass() != obj.getClass()) {
- return false;
- }
- TempTransactionEntry other = (TempTransactionEntry) obj;
- if (!getOuterType().equals(other.getOuterType())) {
- return false;
- }
- if (gammaId != other.gammaId) {
- return false;
- }
- if (transactionId != other.transactionId) {
- return false;
- }
- return true;
- }
-
- @Override
- public String toString() {
- return String.format("gamma_id=%s, tx_id=%s", gammaId, transactionId);
- }
-
- private TransactionJoinQuery getOuterType() {
- return TransactionJoinQuery.this;
- }
- }
-
- protected TransactionJoinQuery(IJoinAccessor joinAccessor, int queryId) {
- super(joinAccessor, JoinItem.TRANSACTION, queryId);
- }
-
- public void add(Long gammaId, Integer transactionId) {
- entries.add(new TempTransactionEntry(gammaId, transactionId));
- }
+/******************************************************************************* + * Copyright (c) 2004, 2007 Boeing. + * All rights reserved. This program and the accompanying materials + * are made available under the terms of the Eclipse Public License v1.0 + * which accompanies this distribution, and is available at + * http://www.eclipse.org/legal/epl-v10.html + * + * Contributors: + * Boeing - initial API and implementation + *******************************************************************************/ +package org.eclipse.osee.framework.database.core; + +import org.eclipse.osee.framework.database.core.DatabaseJoinAccessor.JoinItem; + +/** + * @author Roberto E. Escobar + */ +public final class TransactionJoinQuery extends AbstractJoinQuery { + + private final class TempTransactionEntry implements IJoinRow { + private final long gammaId; + private final int transactionId; + + private TempTransactionEntry(Long gammaId, Integer transactionId) { + this.gammaId = gammaId; + this.transactionId = transactionId; + } + + @Override + public Object[] toArray() { + return new Object[] {getQueryId(), getInsertTime(), gammaId, transactionId}; + } + + @Override + public int hashCode() { + final int prime = 31; + int result = 1; + result = prime * result + getOuterType().hashCode(); + result = prime * result + (int) (gammaId ^ (gammaId >>> 32)); + result = prime * result + transactionId; + return result; + } + + @Override + public boolean equals(Object obj) { + if (this == obj) { + return true; + } + if (obj == null) { + return false; + } + if (getClass() != obj.getClass()) { + return false; + } + TempTransactionEntry other = (TempTransactionEntry) obj; + if (!getOuterType().equals(other.getOuterType())) { + return false; + } + if (gammaId != other.gammaId) { + return false; + } + if (transactionId != other.transactionId) { + return false; + } + return true; + } + + @Override + public String toString() { + return String.format("gamma_id=%s, tx_id=%s", gammaId, transactionId); + } + + private TransactionJoinQuery getOuterType() { + return TransactionJoinQuery.this; + } + } + + protected TransactionJoinQuery(IJoinAccessor joinAccessor, int queryId) { + super(joinAccessor, JoinItem.TRANSACTION, queryId); + } + + public void add(Long gammaId, Integer transactionId) { + entries.add(new TempTransactionEntry(gammaId, transactionId)); + } }
\ No newline at end of file diff --git a/plugins/org.eclipse.osee.framework.database/support/dbrelease.xml b/plugins/org.eclipse.osee.framework.database/support/dbrelease.xml index 84fd5bb354d..91863b01f87 100644 --- a/plugins/org.eclipse.osee.framework.database/support/dbrelease.xml +++ b/plugins/org.eclipse.osee.framework.database/support/dbrelease.xml @@ -1,88 +1,88 @@ -<project name="DBRelease" default="dbrelease" basedir="..">
-
- <property name="ECLIPSE_HOME" value="C:\Program Files\OSEE" />
- <property name="release" value="dbrelease/" />
- <property name="targetzip" value="${release}../oseeDatabase.zip" />
- <property name="manifestname" value="RELEASE.MF" />
- <property name="antdir" value="ant/" />
- <property name="derby" value="${ECLIPSE_HOME}\plugins\org.apache.derby.core_10.1.2.1" />
-
- <property name="eclipseruntimejar" value="org.eclipse.core.runtime_3.1.2.jar"/>
- <property name="eclipseJFacejar" value="org.eclipse.jface_3.1.1.jar" />
- <property name="eclipseRuntime" value="${ECLIPSE_HOME}\plugins\${eclipseruntimejar}" />
- <property name="eclipseJFace" value="${ECLIPSE_HOME}\plugins\${eclipseJFacejar}" />
-
- <property name="oseecore" value="osee.jdk.core/bin/" />
- <property name="oseedb" value="osee.database/bin/" />
- <property name="oseejini" value="osee.jini/bin/" />
- <property name="oseeats2" value="osee.ats2/bin/" />
- <property name="oseedefine" value="osee.define/bin/" />
-
- <target name="clean">
- <delete file="${manifestname}" />
- <delete dir="${release}" />
- </target>
-
- <target name="createrelease">
- <echo message="createrelease PATH=${PATH}" />
- <mkdir dir="${PATH}" />
- <manifest file="RELEASE.MF">
- <attribute name="Main-Class" value="osee/database/core/OseeDbLauncher" />
- <attribute name="Class-Path" value="oseecore.jar oseejini.jar oseedefine.jar oseeats2.jar derby.jar derbyclient.jar derbynet.jar derbytools.jar ${eclipseruntimejar} ${eclipseJFacejar}" />
- <section name="common">
- <attribute name="Specification-Title" value="Example" />
- <attribute name="Specification-Version" value="${version}" />
- <attribute name="Specification-Vendor" value="Example Organization" />
- <attribute name="Implementation-Title" value="common" />
- <attribute name="Implementation-Version" value="${version} ${TODAY}" />
- <attribute name="Implementation-Vendor" value="Example Corp." />
- </section>
- </manifest>
-
- <jar jarfile="${PATH}/oseedb.jar" basedir="../${oseedb}" manifest="RELEASE.MF" />
- <jar jarfile="${PATH}/oseecore.jar" basedir="../${oseecore}" />
- <jar jarfile="${PATH}/oseejini.jar" basedir="../${oseejini}" />
- <jar jarfile="${PATH}/oseeats2.jar" basedir="../${oseeats2}" />
- <jar jarfile="${PATH}/oseedefine.jar" basedir="../${oseedefine}" />
-
- <copy toDir="${PATH}/">
- <fileset file="${eclipseRuntime}"/>
- <fileset file="${eclipseJFace}" />
- </copy>
-
- <copy toDir="${PATH}/">
- <fileset dir="${derby}" includes="*.jar" />
- </copy>
-
- <copy toDir="${PATH}/DatabaseSchemaDump">
- <fileset dir="DatabaseSchemaDump"/>
- </copy>
-
- <copy toDir="${PATH}/excelFiles">
- <fileset dir="excelFiles"/>
- </copy>
-
- <copy toDir="${PATH}/support/">
- <fileset file="../${oseecore}/../support/oseeSiteConfig.xml" />
- </copy>
- <delete file="${manifestname}" />
- </target>
-
- <target name="dbrelease">
- <antcall target="createrelease">
- <param name="PATH" value="dbrelease/" />
- </antcall>
- </target>
-
- <target name="dbreleasezip">
- <antcall target="createrelease">
- <param name="PATH" value="temp/" />
- </antcall>
- <zip destfile="${targetzip}">
- <fileset dir="temp/" />
- </zip>
-
- <delete dir="temp/" />
- </target>
-
+<project name="DBRelease" default="dbrelease" basedir=".."> + + <property name="ECLIPSE_HOME" value="C:\Program Files\OSEE" /> + <property name="release" value="dbrelease/" /> + <property name="targetzip" value="${release}../oseeDatabase.zip" /> + <property name="manifestname" value="RELEASE.MF" /> + <property name="antdir" value="ant/" /> + <property name="derby" value="${ECLIPSE_HOME}\plugins\org.apache.derby.core_10.1.2.1" /> + + <property name="eclipseruntimejar" value="org.eclipse.core.runtime_3.1.2.jar"/> + <property name="eclipseJFacejar" value="org.eclipse.jface_3.1.1.jar" /> + <property name="eclipseRuntime" value="${ECLIPSE_HOME}\plugins\${eclipseruntimejar}" /> + <property name="eclipseJFace" value="${ECLIPSE_HOME}\plugins\${eclipseJFacejar}" /> + + <property name="oseecore" value="osee.jdk.core/bin/" /> + <property name="oseedb" value="osee.database/bin/" /> + <property name="oseejini" value="osee.jini/bin/" /> + <property name="oseeats2" value="osee.ats2/bin/" /> + <property name="oseedefine" value="osee.define/bin/" /> + + <target name="clean"> + <delete file="${manifestname}" /> + <delete dir="${release}" /> + </target> + + <target name="createrelease"> + <echo message="createrelease PATH=${PATH}" /> + <mkdir dir="${PATH}" /> + <manifest file="RELEASE.MF"> + <attribute name="Main-Class" value="osee/database/core/OseeDbLauncher" /> + <attribute name="Class-Path" value="oseecore.jar oseejini.jar oseedefine.jar oseeats2.jar derby.jar derbyclient.jar derbynet.jar derbytools.jar ${eclipseruntimejar} ${eclipseJFacejar}" /> + <section name="common"> + <attribute name="Specification-Title" value="Example" /> + <attribute name="Specification-Version" value="${version}" /> + <attribute name="Specification-Vendor" value="Example Organization" /> + <attribute name="Implementation-Title" value="common" /> + <attribute name="Implementation-Version" value="${version} ${TODAY}" /> + <attribute name="Implementation-Vendor" value="Example Corp." /> + </section> + </manifest> + + <jar jarfile="${PATH}/oseedb.jar" basedir="../${oseedb}" manifest="RELEASE.MF" /> + <jar jarfile="${PATH}/oseecore.jar" basedir="../${oseecore}" /> + <jar jarfile="${PATH}/oseejini.jar" basedir="../${oseejini}" /> + <jar jarfile="${PATH}/oseeats2.jar" basedir="../${oseeats2}" /> + <jar jarfile="${PATH}/oseedefine.jar" basedir="../${oseedefine}" /> + + <copy toDir="${PATH}/"> + <fileset file="${eclipseRuntime}"/> + <fileset file="${eclipseJFace}" /> + </copy> + + <copy toDir="${PATH}/"> + <fileset dir="${derby}" includes="*.jar" /> + </copy> + + <copy toDir="${PATH}/DatabaseSchemaDump"> + <fileset dir="DatabaseSchemaDump"/> + </copy> + + <copy toDir="${PATH}/excelFiles"> + <fileset dir="excelFiles"/> + </copy> + + <copy toDir="${PATH}/support/"> + <fileset file="../${oseecore}/../support/oseeSiteConfig.xml" /> + </copy> + <delete file="${manifestname}" /> + </target> + + <target name="dbrelease"> + <antcall target="createrelease"> + <param name="PATH" value="dbrelease/" /> + </antcall> + </target> + + <target name="dbreleasezip"> + <antcall target="createrelease"> + <param name="PATH" value="temp/" /> + </antcall> + <zip destfile="${targetzip}"> + <fileset dir="temp/" /> + </zip> + + <delete dir="temp/" /> + </target> + </project>
\ No newline at end of file diff --git a/plugins/org.eclipse.osee.framework.database/support/sqlAnt.xml b/plugins/org.eclipse.osee.framework.database/support/sqlAnt.xml index 9363f690fc2..96fb53be7d0 100644 --- a/plugins/org.eclipse.osee.framework.database/support/sqlAnt.xml +++ b/plugins/org.eclipse.osee.framework.database/support/sqlAnt.xml @@ -1,84 +1,84 @@ -<project name="SQLAnt" default="query" basedir=".">
-
- <!-- LOCAL DERBY PROPERTIES -->
- <property name="driver" value="org.apache.derby.jdbc.ClientDriver"/>
- <property name="url" value="jdbc:derby://localhost:1621/DerbyDatabase;create=true"/>
- <property name="userid" value="osee"/>
- <property name="password" value="osee"/>
- <property name="driverpath" value="C:\Program Files\OSEE\plugins\org.apache.derby.core_10.1.2.1\derbyclient.jar" />
-
- <target name="query" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- select * from OSEE_DEFINE_ATTRIBUTE_TYPE
- </sql>
- </target>
-
- <target name="getAllOseeInfo" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- select * from OSEE_INFO
- </sql>
- </target>
-
- <target name="insertderbyTestScriptOutputFalse" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- insert into OSEE_INFO (OSEE_VALUE, OSEE_KEY) values ('FALSE', 'SAVE_OUTFILE_IN_DB')
- </sql>
- </target>
-
- <target name="saveTestScriptOutputTrue" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- UPDATE OSEE_INFO SET OSEE_VALUE = 'TRUE'
- WHERE OSEE_KEY = 'SAVE_OUTFILE_IN_DB'
- </sql>
- </target>
-
- <target name="saveTestScriptOutputFalse" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- UPDATE OSEE_INFO SET OSEE_VALUE = 'FALSE'
- WHERE OSEE_KEY = 'SAVE_OUTFILE_IN_DB'
- </sql>
- </target>
-
- <target name="testskynet" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- SELECT attr_type_id FROM OSEE_DEFINE_valid_attributes WHERE art_type_id = 20 AND gamma_id <= 100000
- </sql>
- </target>
-
-
- <target name="testskynet2" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- SELECT OSEE_DEFINE_attr_base_type.attribute_class,
- OSEE_DEFINE_attribute_type.attr_type_id,
- OSEE_DEFINE_attribute_type.name,
- OSEE_DEFINE_attribute_type.default_value,
- OSEE_DEFINE_attribute_type.validity_xml,
- OSEE_DEFINE_attribute_type.min_occurence,
- OSEE_DEFINE_attribute_type.max_occurence,
- OSEE_DEFINE_attribute_type.user_viewable,
- OSEE_DEFINE_attribute_type.tip_text
- FROM OSEE_DEFINE_attribute_type, OSEE_DEFINE_attr_base_type,transaction_gamma_view
- WHERE OSEE_DEFINE_attr_base_type.attr_base_type_id=OSEE_DEFINE_attribute_type.attr_base_type_id
- AND transaction_gamma_view.transaction_id=179
- AND OSEE_DEFINE_attribute_type.gamma_id<=transaction_gamma_view.largest_gamma_id
- </sql>
- </target>
-
-
- <target name="getseqtable" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- SELECT * FROM OSEE_DEFINE_SEQUENCE
- </sql>
- </target>
-
-</project>
-
-
+<project name="SQLAnt" default="query" basedir="."> + + <!-- LOCAL DERBY PROPERTIES --> + <property name="driver" value="org.apache.derby.jdbc.ClientDriver"/> + <property name="url" value="jdbc:derby://localhost:1621/DerbyDatabase;create=true"/> + <property name="userid" value="osee"/> + <property name="password" value="osee"/> + <property name="driverpath" value="C:\Program Files\OSEE\plugins\org.apache.derby.core_10.1.2.1\derbyclient.jar" /> + + <target name="query" > + <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" > + <classpath><pathelement location="${driverpath}"/></classpath> + select * from OSEE_DEFINE_ATTRIBUTE_TYPE + </sql> + </target> + + <target name="getAllOseeInfo" > + <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" > + <classpath><pathelement location="${driverpath}"/></classpath> + select * from OSEE_INFO + </sql> + </target> + + <target name="insertderbyTestScriptOutputFalse" > + <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" > + <classpath><pathelement location="${driverpath}"/></classpath> + insert into OSEE_INFO (OSEE_VALUE, OSEE_KEY) values ('FALSE', 'SAVE_OUTFILE_IN_DB') + </sql> + </target> + + <target name="saveTestScriptOutputTrue" > + <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" > + <classpath><pathelement location="${driverpath}"/></classpath> + UPDATE OSEE_INFO SET OSEE_VALUE = 'TRUE' + WHERE OSEE_KEY = 'SAVE_OUTFILE_IN_DB' + </sql> + </target> + + <target name="saveTestScriptOutputFalse" > + <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" > + <classpath><pathelement location="${driverpath}"/></classpath> + UPDATE OSEE_INFO SET OSEE_VALUE = 'FALSE' + WHERE OSEE_KEY = 'SAVE_OUTFILE_IN_DB' + </sql> + </target> + + <target name="testskynet" > + <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" > + <classpath><pathelement location="${driverpath}"/></classpath> + SELECT attr_type_id FROM OSEE_DEFINE_valid_attributes WHERE art_type_id = 20 AND gamma_id <= 100000 + </sql> + </target> + + + <target name="testskynet2" > + <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" > + <classpath><pathelement location="${driverpath}"/></classpath> + SELECT OSEE_DEFINE_attr_base_type.attribute_class, + OSEE_DEFINE_attribute_type.attr_type_id, + OSEE_DEFINE_attribute_type.name, + OSEE_DEFINE_attribute_type.default_value, + OSEE_DEFINE_attribute_type.validity_xml, + OSEE_DEFINE_attribute_type.min_occurence, + OSEE_DEFINE_attribute_type.max_occurence, + OSEE_DEFINE_attribute_type.user_viewable, + OSEE_DEFINE_attribute_type.tip_text + FROM OSEE_DEFINE_attribute_type, OSEE_DEFINE_attr_base_type,transaction_gamma_view + WHERE OSEE_DEFINE_attr_base_type.attr_base_type_id=OSEE_DEFINE_attribute_type.attr_base_type_id + AND transaction_gamma_view.transaction_id=179 + AND OSEE_DEFINE_attribute_type.gamma_id<=transaction_gamma_view.largest_gamma_id + </sql> + </target> + + + <target name="getseqtable" > + <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" > + <classpath><pathelement location="${driverpath}"/></classpath> + SELECT * FROM OSEE_DEFINE_SEQUENCE + </sql> + </target> + +</project> + + |