Package de.chris_soft.nanoarchive

Examples of de.chris_soft.nanoarchive.DB

28
29
30
31
32
33
34
35
   * @throws ClassNotFoundException
   */
  @Test
  public void testCreateNewDatabase() throws SQLException, ClassNotFoundException {
    FileUtils.deleteAll(new File(DB_PATH));
    DB db = new DB(DB_PATH);
    db.close();
  }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
   * @throws SQLException
   * @throws ClassNotFoundException
   */
  // @Test
  public void _testListAllTables() throws SQLException, ClassNotFoundException {
    DB db = new DB(DB_PATH);
    db.printSelection("select * from SYS.SYSTABLES");
    db.printSelection("select * from SYS.SYSCOLUMNS");
    db.printSelection("select * from SYS.SYSCONGLOMERATES");
    db.close();
  }
View Full Code Here
52
53
54
55
56
57
58
59
60
61
   * @throws ClassNotFoundException
   * @throws IOException
   */
  @Test
  public void testCreateDocument() throws SQLException, ClassNotFoundException, IOException {
    DB db = new DB(DB_PATH);
    db.addDocument(333, 4711, SAMPLE_DOCUMENT_FILE);
    db.addDocument(334, 4712, SAMPLE_DOCUMENT_FILE);
    db.close();
  }
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
   * @throws ClassNotFoundException
   * @throws IOException
   */
  @Test
  public void testCreateDocumentTwice() throws SQLException, ClassNotFoundException, IOException {
    DB db = new DB(DB_PATH);
    long documentID = db.addDocument(-1, 4711, SAMPLE_DOCUMENT_FILE);
    try {
      db.addDocument(documentID, 4711, SAMPLE_DOCUMENT_FILE);
      throw new RuntimeException("Documents with identical documentID created!");
    } catch (SQLException e) {
      // Okay.
    }
    db.close();
  }
View Full Code Here
83
84
85
86
87
88
89
90
91
92
   * @throws ClassNotFoundException
   * @throws IOException
   */
  @Test
  public void testRetrieveDocument() throws SQLException, ClassNotFoundException, IOException {
    DB db = new DB(DB_PATH);
    byte[] ba = db.readDocument(333);
    assertEquals(ba.length, SAMPLE_DOCUMENT_FILE.length());
    db.close();
  }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
   * @throws SQLException
   * @throws ClassNotFoundException
   */
  @Test
  public void testGetDocumentsFromPath() throws ClassNotFoundException, SQLException {
    DB db = new DB(DB_PATH);
    List<Long> docs = db.getDocumentsFromPath(4712);
    assertEquals(docs.size(), 1);
    assertEquals(docs.get(0).longValue(), 334);
    docs = db.getDocumentsFromPath(4711);
    Collections.sort(docs);
    assertEquals(docs.size(), 2);
    assertEquals(docs.get(0).longValue(), 333);
    db.close();
  }
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
122
123
  /**
   * @throws ClassNotFoundException
   * @throws SQLException
   */
  public void testDeleteDocument() throws ClassNotFoundException, SQLException {
    DB db = new DB(DB_PATH);
    db.deleteDocument(333);
    List<Long> docs = db.getDocumentsFromPath(4711);
    Collections.sort(docs);
    assertEquals(docs.size(), 1);
    assertNotSame(docs.get(0).longValue(), 333);
    db.close();
  }
View Full Code Here
126
127
128
129
130
131
132
133
134
   * @throws SQLException
   * @throws ClassNotFoundException
   */
  @Test
  public void testCountDocuments() throws SQLException, ClassNotFoundException {
    DB db = new DB(DB_PATH);
    assertEquals(2, db.getDocumentCount());
    db.close();
  }
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
   * @throws ClassNotFoundException
   * @throws SQLException
   */
  @Test
  public void testUpdateDocumentPath() throws ClassNotFoundException, SQLException {
    DB db = new DB(DB_PATH);
    List<Long> docs = db.getDocumentsFromPath(4712);
    assertEquals(docs.size(), 1);
    docs = db.getDocumentsFromPath(4711);
    assertEquals(docs.size(), 1);
    db.changeDocumentPath(docs.get(0), 4712);
    docs = db.getDocumentsFromPath(4712);
    assertEquals(docs.size(), 2);
    assertEquals(2, db.getDocumentCount());
    db.close();
  }
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
166
167
   * @throws ClassNotFoundException
   * @throws SQLException
   */
  @Test
  public void testDocumentProperties() throws ClassNotFoundException, SQLException {
    DB db = new DB(DB_PATH);
    assertNull(db.getDocumentProperty(334, "name"));
    db.setDocumentProperty(334, "name", "Wumpel Putz");
    assertEquals("Wumpel Putz", db.getDocumentProperty(334, "name"));
    db.deleteDocumentProperty(334, "name");
    assertNull(db.getDocumentProperty(334, "name"));
    db.close();
  }
View Full Code Here
TOP

Related Classes of de.chris_soft.nanoarchive.DB

  • de.chris_soft.database.DbTest
  • java.sql.ResultSetMetaData
  • java.io.File
  • java.sql.Blob
  • java.io.FileInputStream
  • java.sql.DatabaseMetaData
  • java.util.Properties
  • java.io.InputStream
  • java.sql.Statement
  • java.sql.ResultSet
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.