コード例 #1
0
 @Test
 public void testCreateSQLQuery() {
   assertEquals(
       "select distinct doc.space, doc.name from XWikiDocument as doc",
       store.createSQLQuery("select distinct doc.space, doc.name", ""));
   assertEquals(
       "select distinct doc.space, doc.name, doc.date from XWikiDocument as doc "
           + "where 1=1 order by doc.date desc",
       store.createSQLQuery(
           "select distinct doc.space, doc.name", "where 1=1 order by doc.date desc"));
 }
コード例 #2
0
  /**
   * Save an XClass that has a Number property whose type has changed and there is an instance of
   * this class that has no value set for that Number property.
   *
   * @see <a href="http://jira.xwiki.org/browse/XWIKI-8649">XWIKI-8649: Error when changing the
   *     number type of a field from an application</a>
   */
  @Test
  public void saveXWikiDocWithXClassAndNumberPropertyTypeChange() throws Exception {
    // The number property whose type has changed from Double to Integer.
    IntegerProperty integerProperty = mock(IntegerProperty.class);
    NumberClass numberField = mock(NumberClass.class);
    when(numberField.newProperty()).thenReturn(integerProperty);
    when(numberField.getNumberType()).thenReturn("integer");

    // The XClass that has only the number property.
    List<NumberClass> fieldList = Collections.singletonList(numberField);
    BaseClass baseClass = mock(BaseClass.class);
    when(baseClass.getFieldList()).thenReturn(fieldList);

    // The document that is being saved.
    XWikiDocument document = mock(XWikiDocument.class);
    when(document.getXClass()).thenReturn(baseClass);

    // Assume there are two objects of the XClass previously defined: one that has no value set for
    // the number
    // property and one that has a value.
    Query query = mock(Query.class);
    DoubleProperty doubleProperty = mock(DoubleProperty.class);
    when(doubleProperty.getValue()).thenReturn(3.5);
    DoubleProperty doublePropertyUnset = mock(DoubleProperty.class, "unset");
    List<DoubleProperty> properties = Arrays.asList(doublePropertyUnset, doubleProperty);
    when(session.createQuery(anyString())).thenReturn(query);
    when(query.setString(anyInt(), anyString())).thenReturn(query);
    when(query.list()).thenReturn(properties);

    store.saveXWikiDoc(document, context);

    // 4 times, for each number type (Integer, Long, Double and Float).
    verify(integerProperty, times(4)).setValue(3);
  }
コード例 #3
0
  @Test
  public void executeDeleteWikiStatementForPostgreSQLWhenInSchemaMode() throws Exception {
    HibernateSessionFactory sessionFactory = mocker.getInstance(HibernateSessionFactory.class);
    when(sessionFactory.getConfiguration().getProperty("xwiki.virtual_mode")).thenReturn("schema");

    Statement statement = mock(Statement.class);
    DatabaseProduct databaseProduct = DatabaseProduct.POSTGRESQL;

    store.executeDeleteWikiStatement(statement, databaseProduct, "schema");

    verify(statement).execute("DROP SCHEMA schema CASCADE");
  }
コード例 #4
0
  @Test
  public void executeDeleteWikiStatementForPostgreSQLWhenInDatabaseMode() throws Exception {
    HibernateSessionFactory sessionFactory = mocker.getInstance(HibernateSessionFactory.class);
    when(sessionFactory.getConfiguration().getProperty("xwiki.virtual_mode"))
        .thenReturn("database");

    Statement statement = mock(Statement.class);
    DatabaseProduct databaseProduct = DatabaseProduct.POSTGRESQL;

    store.executeDeleteWikiStatement(statement, databaseProduct, "schema");

    verify(mocker.getMockedLogger())
        .warn("Subwiki deletion not yet supported in Database mode for PostgreSQL");
    verify(statement, never()).execute(any(String.class));
  }
コード例 #5
0
 @Test
 public void testGetColumnsForSelectStatement() throws Exception {
   assertEquals(
       ", doc.date", store.getColumnsForSelectStatement("where 1=1 order by doc.date desc"));
   assertEquals(
       ", doc.date", store.getColumnsForSelectStatement("where 1=1 order by doc.date asc"));
   assertEquals(", doc.date", store.getColumnsForSelectStatement("where 1=1 order by doc.date"));
   assertEquals(
       ", description", store.getColumnsForSelectStatement("where 1=1 order by description desc"));
   assertEquals(
       ", ascendent", store.getColumnsForSelectStatement("where 1=1 order by ascendent asc"));
   assertEquals(
       ", doc.date, doc.name",
       store.getColumnsForSelectStatement("where 1=1 order by doc.date, doc.name"));
   assertEquals(
       ", doc.date, doc.name",
       store.getColumnsForSelectStatement("where 1=1 order by doc.date ASC, doc.name DESC"));
   assertEquals(
       "", store.getColumnsForSelectStatement(", BaseObject as obj where obj.name=doc.fullName"));
 }
コード例 #6
0
  @Test
  public void testEndTransactionWhenSQLBatchUpdateExceptionThrown() throws Exception {
    SQLException sqlException2 = new SQLException("sqlexception2");
    sqlException2.setNextException(new SQLException("nextexception2"));

    SQLException sqlException1 = new SQLException("sqlexception1");
    sqlException1.initCause(sqlException2);
    sqlException1.setNextException(new SQLException("nextexception1"));

    // Assume the transaction is already created.
    when(context.get("hibtransaction")).thenReturn(transaction);
    doThrow(new HibernateException("exception1", sqlException1)).when(transaction).commit();

    try {
      store.endTransaction(context, true);
      fail("Should have thrown an exception here");
    } catch (HibernateException e) {
      assertEquals(
          "Failed to commit or rollback transaction. Root cause [\n"
              + "SQL next exception = [java.sql.SQLException: nextexception1]\n"
              + "SQL next exception = [java.sql.SQLException: nextexception2]]",
          e.getMessage());
    }
  }