KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > daffodilwoods > daffodildb > server > sql99 > ddl > schemamanipulation > dropsequencestatement


1 package com.daffodilwoods.daffodildb.server.sql99.ddl.schemamanipulation;
2
3 import com.daffodilwoods.daffodildb.server.serversystem.*;
4 import com.daffodilwoods.daffodildb.server.sql99.ddl.descriptors.*;
5 import com.daffodilwoods.daffodildb.server.sql99.ddl.utility.*;
6 import com.daffodilwoods.daffodildb.server.sql99.dql.tableexpression.fromclause.*;
7 import com.daffodilwoods.daffodildb.server.sql99.token.*;
8 import com.daffodilwoods.database.general.*;
9 import com.daffodilwoods.database.resource.*;
10
11 public class dropsequencestatement implements SQLschemamanipulationstatement {
12    public localorschemaqualifiedname _localorschemaqualifiedname0;
13    public SRESERVEDWORD1206543922 _SRESERVEDWORD12065439221;
14    public SRESERVEDWORD1206543922 _SRESERVEDWORD12065439222;
15
16    public Object JavaDoc run(Object JavaDoc object) throws DException {
17       _ServerSession currentSession = (_ServerSession) object;
18       SequenceNumberDescriptor sequenceDescriptor = new SequenceNumberDescriptor();
19       setSequenceName(currentSession, sequenceDescriptor);
20       sequenceDescriptor.load(currentSession);
21       String JavaDoc schemaOwner = GeneralUtility.getSchemaOwner(sequenceDescriptor.
22           sequence_catalog, sequenceDescriptor.sequence_schema, currentSession);
23       GeneralUtility.validateUserRights(schemaOwner, currentSession);
24       dropSequence(currentSession, sequenceDescriptor);
25
26       refreshServerSystem(currentSession, sequenceDescriptor.getQualifiedName());
27       return null;
28    }
29
30    public void dropSequence(_ServerSession currentSession,
31                             SequenceNumberDescriptor sequenceDescriptor) throws
32        DException {
33       /** @todo
34        * Revoke Privileges when privielges provided
35        * */

36       sequenceDescriptor.delete(currentSession);
37    }
38
39    public void refreshServerSystem(_ServerSession currentSession,
40                                    QualifiedIdentifier sequenceName) throws
41        DException {
42       currentSession.getSequenceManager().removeSequence(sequenceName);
43    }
44
45    /* initializes the sequence name in the sequenceNumbersDescriptor */
46    private void setSequenceName(_ServerSession currentSession,
47                                 SequenceNumberDescriptor sequenceDescriptor) throws DException {
48       sequenceDescriptor.sequence_catalog = _localorschemaqualifiedname0.
49           getCatalogName();
50       sequenceDescriptor.sequence_schema = _localorschemaqualifiedname0.
51           getSchemaName();
52       if (sequenceDescriptor.sequence_catalog == null) {
53          sequenceDescriptor.sequence_catalog = currentSession.getCurrentCatalog();
54       }
55       if (sequenceDescriptor.sequence_schema == null) {
56          sequenceDescriptor.sequence_schema = currentSession.getCurrentSchema();
57       }
58       sequenceDescriptor.sequence_name = _localorschemaqualifiedname0.
59           getIdentifierName();
60    }
61
62    public Object JavaDoc clone() throws CloneNotSupportedException JavaDoc {
63       return this;
64    }
65
66    public String JavaDoc toString() {
67       StringBuffer JavaDoc sb = new StringBuffer JavaDoc();
68       sb.append(" ");
69       sb.append(_SRESERVEDWORD12065439222);
70       sb.append(" ");
71       sb.append(_SRESERVEDWORD12065439221);
72       sb.append(" ");
73       sb.append(_localorschemaqualifiedname0);
74       return sb.toString();
75    }
76 }
77
Popular Tags