Examples with MySQLClusterNDBDialect org.alfresco.repo.domain.dialect.MySQLClusterNDBDialect used on opensource projects

Example 6 with MySQLClusterNDBDialect

use of org.alfresco.repo.domain.dialect.MySQLClusterNDBDialect in project alfresco-repository by Alfresco.

the class FileFolderServiceImplTest method testMoveCopyLotsOfFiles.

public void testMoveCopyLotsOfFiles() throws FileNotFoundException {
    final String CONTAINING_FOLDER = "CONTAINING FOLDER " + GUID.generate(), FOLDER_1 = "FOLDER 1 " + GUID.generate(), FOLDER_2 = "FOLDER 2 " + GUID.generate();
    FileInfo containingFolder = fileFolderService.create(workingRootNodeRef, CONTAINING_FOLDER, ContentModel.TYPE_FOLDER), folder1 = fileFolderService.create(containingFolder.getNodeRef(), FOLDER_1, ContentModel.TYPE_FOLDER), folder2 = fileFolderService.create(containingFolder.getNodeRef(), FOLDER_2, ContentModel.TYPE_FOLDER);
    // create thousand(s) of files within the folder
    int COUNT = 3000;
    Dialect dialect = (Dialect) ctx.getBean("dialect");
    if (dialect instanceof MySQLClusterNDBDialect) {
        // note: to increase the file count on NDB, may need to further bump-up NDB cluster config
        // eg. DataMemory, IndexMemory, MaxNoOfConcurrentOperations, ...
        // also consider splitting into separate txns (eg. after each bulk create, move, delete, copy, ...)
        COUNT = 1000;
    }
    for (int index = 0; index < COUNT; index++) {
        fileFolderService.create(folder1.getNodeRef(), "Name " + index, ContentModel.TYPE_CONTENT);
    }
    assertEquals(COUNT, fileFolderService.listFiles(folder1.getNodeRef()).size());
    assertEquals(0, fileFolderService.list(folder2.getNodeRef()).size());
    // move the folder
    fileFolderService.move(folder1.getNodeRef(), folder2.getNodeRef(), null);
    assertEquals(COUNT, fileFolderService.listFiles(folder1.getNodeRef()).size());
    assertEquals(1, fileFolderService.list(folder2.getNodeRef()).size());
    // move it back
    fileFolderService.move(folder1.getNodeRef(), containingFolder.getNodeRef(), null);
    assertEquals(0, fileFolderService.list(folder2.getNodeRef()).size());
    assertEquals(2, fileFolderService.list(containingFolder.getNodeRef()).size());
    // lets copy it
    fileFolderService.copy(folder1.getNodeRef(), folder2.getNodeRef(), null);
    assertEquals(2, fileFolderService.list(containingFolder.getNodeRef()).size());
    List<FileInfo> folders = fileFolderService.listFolders(folder2.getNodeRef());
    assertEquals(1, folders.size());
    assertEquals(COUNT, fileFolderService.listFiles(folders.get(0).getNodeRef()).size());
    fileFolderService.delete(folder1.getNodeRef());
    assertEquals(1, fileFolderService.list(containingFolder.getNodeRef()).size());
    folder1 = folders.get(0);
    // copy back
    FileInfo newFolder = fileFolderService.copy(folder1.getNodeRef(), containingFolder.getNodeRef(), null);
    assertEquals(2, fileFolderService.list(containingFolder.getNodeRef()).size());
    assertEquals(COUNT, fileFolderService.list(newFolder.getNodeRef()).size());
}

Example 7 with MySQLClusterNDBDialect

use of org.alfresco.repo.domain.dialect.MySQLClusterNDBDialect in project alfresco-repository by Alfresco.

the class DbNodeServiceImplTest method testMySQLInnoDBNodeStringLengthWorker.

/**
 * Check that the maximum string lengths can be adjusted up and down.
 * Note that this test ONLY works for MySQL because the other databases cannot support more than 1024 characters
 * in the string_value column and the value may not be set to less than 1024.
 *
 * @see SchemaBootstrap#DEFAULT_MAX_STRING_LENGTH
 */
@SuppressWarnings("deprecation")
public void testMySQLInnoDBNodeStringLengthWorker() throws Exception {
    TestTransaction.flagForCommit();
    TestTransaction.end();
    // Skip of the dialect if not MySQL (also skip for MySQL Cluster NDB)
    Dialect dialect = (Dialect) applicationContext.getBean("dialect");
    if ((dialect instanceof MySQLClusterNDBDialect) || (!(dialect instanceof MySQLInnoDBDialect))) {
        return;
    }
    SchemaBootstrap schemaBootstrap = (SchemaBootstrap) applicationContext.getBean("schemaBootstrap");
    assertEquals("Expected max string length to be MAX", Integer.MAX_VALUE, SchemaBootstrap.getMaxStringLength());
    NodeStringLengthWorker worker = (NodeStringLengthWorker) applicationContext.getBean("nodeStringLengthWorker");
    // If we run this worker just to get everything into the correct starting state.
    // If it does not work, then that will be detected later anyway
    NodeStringLengthWorkResult result = worker.execute();
    assertTrue(result.getPropertiesProcessed() > 0);
    assertEquals(0, result.getErrors());
    // Now set the max string length to DEFAULT_MAX_STRING_LENGTH characters
    schemaBootstrap.setMaximumStringLength(SchemaBootstrap.DEFAULT_MAX_STRING_LENGTH);
    schemaBootstrap.onApplicationEvent(new ContextRefreshedEvent(applicationContext));
    // Move any values persisted before the test
    result = worker.execute();
    int firstPassChanged = result.getPropertiesChanged();
    StringBuilder sb = new StringBuilder();
    for (int i = 0; i < SchemaBootstrap.DEFAULT_MAX_STRING_LENGTH + 1; i++) {
        sb.append("A");
    }
    final String longString = sb.toString();
    // Persist the property using the default MAX_VALUE so that it goes into the string_value
    schemaBootstrap.setMaximumStringLength(Integer.MAX_VALUE);
    schemaBootstrap.onApplicationEvent(new ContextRefreshedEvent(applicationContext));
    txnService.getRetryingTransactionHelper().doInTransaction(new RetryingTransactionCallback<Void>() {

        @Override
        public Void execute() throws Throwable {
            nodeService.setProperty(rootNodeRef, PROP_QNAME_STRING_VALUE, longString);
            return null;
        }
    });
    // The worker should do nothing
    result = worker.execute();
    assertEquals(firstPassChanged, result.getPropertiesChanged());
    // Now bring the limit down to the match for other DBs
    schemaBootstrap.setMaximumStringLength(SchemaBootstrap.DEFAULT_MAX_STRING_LENGTH);
    schemaBootstrap.onApplicationEvent(new ContextRefreshedEvent(applicationContext));
    result = worker.execute();
    assertEquals(firstPassChanged + 1, result.getPropertiesChanged());
    // Put the limit back to the MySQL default and all the large values should go back into MySQL's TEXT field
    schemaBootstrap.setMaximumStringLength(Integer.MAX_VALUE);
    schemaBootstrap.onApplicationEvent(new ContextRefreshedEvent(applicationContext));
    result = worker.execute();
    assertEquals(firstPassChanged + 1, result.getPropertiesChanged());
    // Check that our string is still OK
    String checkLongString = txnService.getRetryingTransactionHelper().doInTransaction(new RetryingTransactionCallback<String>() {

        @Override
        public String execute() throws Throwable {
            return (String) nodeService.getProperty(rootNodeRef, PROP_QNAME_STRING_VALUE);
        }
    });
    assertEquals("String manipulation corrupted the long string value. ", longString, checkLongString);
}