All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.datanucleus.store.odf.ODFSchemaHandler Maven / Gradle / Ivy

There is a newer version: 6.0.0-release
Show newest version
/**********************************************************************
Copyright (c) 2014 Andy Jefferson and others. All rights reserved.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.

Contributors:
    ...
**********************************************************************/
package org.datanucleus.store.odf;

import java.util.Iterator;
import java.util.List;
import java.util.Properties;
import java.util.Set;

import org.datanucleus.ClassLoaderResolver;
import org.datanucleus.exceptions.NucleusDataStoreException;
import org.datanucleus.metadata.AbstractClassMetaData;
import org.datanucleus.store.StoreData;
import org.datanucleus.store.StoreManager;
import org.datanucleus.store.connection.ManagedConnection;
import org.datanucleus.store.schema.AbstractStoreSchemaHandler;
import org.datanucleus.store.schema.table.Column;
import org.datanucleus.store.schema.table.CompleteClassTable;
import org.datanucleus.store.schema.table.Table;
import org.datanucleus.util.Localiser;
import org.datanucleus.util.NucleusLogger;
import org.odftoolkit.odfdom.doc.OdfSpreadsheetDocument;
import org.odftoolkit.odfdom.doc.table.OdfTable;
import org.odftoolkit.odfdom.doc.table.OdfTableCell;
import org.odftoolkit.odfdom.doc.table.OdfTableRow;
import org.odftoolkit.odfdom.dom.attribute.office.OfficeValueTypeAttribute;
import org.odftoolkit.odfdom.dom.style.OdfStyleFamily;
import org.odftoolkit.odfdom.incubator.doc.office.OdfOfficeAutomaticStyles;
import org.odftoolkit.odfdom.incubator.doc.style.OdfStyle;
import org.odftoolkit.odfdom.pkg.OdfFileDom;

/**
 * Handler for schema operations with ODF documents.
 */
public class ODFSchemaHandler extends AbstractStoreSchemaHandler
{
    public ODFSchemaHandler(StoreManager storeMgr)
    {
        super(storeMgr);
    }

    /* (non-Javadoc)
     * @see org.datanucleus.store.schema.AbstractStoreSchemaHandler#createSchemaForClasses(java.util.Set, java.util.Properties, java.lang.Object)
     */
    @Override
    public void createSchemaForClasses(Set classNames, Properties props, Object connection)
    {
        OdfSpreadsheetDocument spreadsheet = (OdfSpreadsheetDocument)connection;
        ManagedConnection mconn = null;
        try
        {
            if (spreadsheet == null)
            {
                mconn = storeMgr.getConnectionManager().getConnection(-1);
                spreadsheet = (OdfSpreadsheetDocument)mconn.getConnection();
            }

            Iterator classIter = classNames.iterator();
            ClassLoaderResolver clr = storeMgr.getNucleusContext().getClassLoaderResolver(null);
            while (classIter.hasNext())
            {
                String className = classIter.next();
                AbstractClassMetaData cmd = storeMgr.getMetaDataManager().getMetaDataForClass(className, clr);
                if (cmd != null)
                {
                    // Find/Create the sheet (table) appropriate for storing objects of this class
                    StoreData storeData = storeMgr.getStoreDataForClass(cmd.getFullClassName());
                    Table schemaTable = null;
                    if (storeData != null)
                    {
                        schemaTable = storeData.getTable();
                    }
                    else
                    {
                        schemaTable = new CompleteClassTable(storeMgr, cmd, null);
                    }

                    String sheetName = schemaTable.getName();
                    OdfTable table = spreadsheet.getTableByName(sheetName);
                    if (table == null)
                    {
                        // Table for this class doesn't exist yet so create
                        OdfFileDom contentDoc;
                        try
                        {
                            contentDoc = spreadsheet.getContentDom();
                        }
                        catch (Exception e)
                        {
                            throw new NucleusDataStoreException("Exception thrown adding worksheet " + schemaTable.getName(), e);
                        }
                        OdfOfficeAutomaticStyles styles = contentDoc.getAutomaticStyles();
                        OdfStyle headerStyle = styles.getStyle("DN_Headers", OdfStyleFamily.TableCell);

                        table = OdfTable.newTable(spreadsheet, 1, schemaTable.getNumberOfColumns());
                        table.setTableName(schemaTable.getName());

                        // Set the header row if required TODO Make this optional when ODFDOM allows tables with no rows/columns
                        if (true)
                        {
                            OdfTableRow headerRow = table.getRowByIndex(0);
                            headerRow.setDefaultCellStyle(headerStyle);
                            List schemaCols = schemaTable.getColumns(); // Columns are ordered already
                            for (Column schemaCol : schemaCols)
                            {
                                OdfTableCell cell = headerRow.getCellByIndex(schemaCol.getPosition());
                                cell.setValueType(OfficeValueTypeAttribute.Value.STRING.toString());
                                cell.setStringValue(schemaCol.getName());
                            }
                        }

                        if (NucleusLogger.DATASTORE_PERSIST.isDebugEnabled())
                        {
                            NucleusLogger.DATASTORE_PERSIST.debug(Localiser.msg("ODF.Insert.SheetCreated", schemaTable.getName()));
                        }
                    }
                }
            }
        }
        finally
        {
            if (mconn != null)
            {
                mconn.release();
            }
        }
    }

    /* (non-Javadoc)
     * @see org.datanucleus.store.schema.AbstractStoreSchemaHandler#deleteSchemaForClasses(java.util.Set, java.util.Properties, java.lang.Object)
     */
    @Override
    public void deleteSchemaForClasses(Set classNames, Properties props, Object connection)
    {
        OdfSpreadsheetDocument spreadsheet = (OdfSpreadsheetDocument)connection;
        ManagedConnection mconn = null;
        try
        {
            if (spreadsheet == null)
            {
                mconn = storeMgr.getConnectionManager().getConnection(-1);
                spreadsheet = (OdfSpreadsheetDocument)mconn.getConnection();
            }

            Iterator classIter = classNames.iterator();
            ClassLoaderResolver clr = storeMgr.getNucleusContext().getClassLoaderResolver(null);
            while (classIter.hasNext())
            {
                String className = classIter.next();
                AbstractClassMetaData cmd = storeMgr.getMetaDataManager().getMetaDataForClass(className, clr);
                if (cmd != null)
                {
                    // Find/Delete the sheet (table) appropriate for storing objects of this class
                    StoreData storeData = storeMgr.getStoreDataForClass(cmd.getFullClassName());
                    Table schemaTable = null;
                    if (storeData != null)
                    {
                        schemaTable = storeData.getTable();
                    }
                    else
                    {
                        schemaTable = new CompleteClassTable(storeMgr, cmd, null);
                    }

                    OdfTable table = spreadsheet.getTableByName(schemaTable.getName());
                    if (table != null)
                    {
                        table.remove();
                    }
                }
            }
        }
        finally
        {
            if (mconn != null)
            {
                mconn.release();
            }
        }
    }

    /* (non-Javadoc)
     * @see org.datanucleus.store.schema.AbstractStoreSchemaHandler#validateSchema(java.util.Set, java.util.Properties, java.lang.Object)
     */
    @Override
    public void validateSchema(Set classNames, Properties props, Object connection)
    {
        // TODO Implement validation of the ODF document
        super.validateSchema(classNames, props, connection);
    }
}




© 2015 - 2024 Weber Informatics LLC | Privacy Policy