/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements. See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You 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.
 */
package org.apache.activemq.artemis.jdbc.store.file;

import java.nio.ByteBuffer;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.postgresql.PGConnection;
import org.postgresql.largeobject.LargeObject;
import org.postgresql.largeobject.LargeObjectManager;

@SuppressWarnings("SynchronizeOnNonFinalField")
public final class PostgresSequentialSequentialFileDriver extends JDBCSequentialFileFactoryDriver {

   private static final String POSTGRES_OID_KEY = "POSTGRES_OID_KEY";

   public PostgresSequentialSequentialFileDriver() throws SQLException {
      super();
   }

   @Override
   protected void prepareStatements() throws SQLException {
      this.deleteFile = connection.prepareStatement(sqlProvider.getDeleteFileSQL());
      this.createFile = connection.prepareStatement(sqlProvider.getInsertFileSQL(), Statement.RETURN_GENERATED_KEYS);
      this.selectFileByFileName = connection.prepareStatement(sqlProvider.getSelectFileByFileName());
      this.copyFileRecord = connection.prepareStatement(sqlProvider.getCopyFileRecordByIdSQL());
      this.renameFile = connection.prepareStatement(sqlProvider.getUpdateFileNameByIdSQL());
      this.readLargeObject = connection.prepareStatement(sqlProvider.getReadLargeObjectSQL());
      this.appendToLargeObject = connection.prepareStatement(sqlProvider.getAppendToLargeObjectSQL());
      this.selectFileNamesByExtension = connection.prepareStatement(sqlProvider.getSelectFileNamesByExtensionSQL());
   }

   @Override
   public void createFile(JDBCSequentialFile file) throws SQLException {
      synchronized (connection) {
         try {
            connection.setAutoCommit(false);

            LargeObjectManager lobjManager = ((PGConnection) connection).getLargeObjectAPI();
            long oid = lobjManager.createLO();

            createFile.setString(1, file.getFileName());
            createFile.setString(2, file.getExtension());
            createFile.setLong(3, oid);
            createFile.executeUpdate();

            try (ResultSet keys = createFile.getGeneratedKeys()) {
               keys.next();
               file.setId(keys.getLong(1));
            }
            connection.commit();
         } catch (SQLException e) {
            connection.rollback();
            throw e;
         }
      }
   }

   @Override
   public void loadFile(JDBCSequentialFile file) throws SQLException {
      synchronized (connection) {
         connection.setAutoCommit(false);
         readLargeObject.setLong(1, file.getId());

         try (ResultSet rs = readLargeObject.executeQuery()) {
            if (rs.next()) {
               file.setWritePosition(getPostGresLargeObjectSize(file));
            }
            connection.commit();
         } catch (SQLException e) {
            connection.rollback();
            throw e;
         }
      }
   }

   @Override
   public int writeToFile(JDBCSequentialFile file, byte[] data) throws SQLException {
      synchronized (connection) {
         LargeObjectManager lobjManager = ((PGConnection) connection).getLargeObjectAPI();
         LargeObject largeObject = null;

         Long oid = getOID(file);
         try {
            connection.setAutoCommit(false);
            largeObject = lobjManager.open(oid, LargeObjectManager.WRITE);
            largeObject.seek(largeObject.size());
            largeObject.write(data);
            largeObject.close();
            connection.commit();
         } catch (Exception e) {
            connection.rollback();
            throw e;
         }
         return data.length;
      }
   }

   @Override
   public int readFromFile(JDBCSequentialFile file, ByteBuffer bytes) throws SQLException {
      LargeObjectManager lobjManager = ((PGConnection) connection).getLargeObjectAPI();
      LargeObject largeObject = null;
      long oid = getOID(file);
      synchronized (connection) {
         try {
            connection.setAutoCommit(false);
            largeObject = lobjManager.open(oid, LargeObjectManager.READ);
            int readLength = (int) calculateReadLength(largeObject.size(), bytes.remaining(), file.position());

            if (readLength > 0) {
               if (file.position() > 0)
                  largeObject.seek((int) file.position());
               byte[] data = largeObject.read(readLength);
               bytes.put(data);
            }

            largeObject.close();
            connection.commit();

            return readLength;
         } catch (SQLException e) {
            connection.rollback();
            throw e;
         }
      }
   }

   private Long getOID(JDBCSequentialFile file) throws SQLException {
      Long oid = (Long) file.getMetaData(POSTGRES_OID_KEY);
      if (oid == null) {
         synchronized (connection) {
            connection.setAutoCommit(false);
            readLargeObject.setLong(1, file.getId());
            try (ResultSet rs = readLargeObject.executeQuery()) {
               if (rs.next()) {
                  file.addMetaData(POSTGRES_OID_KEY, rs.getLong(1));
               }
               connection.commit();
            } catch (SQLException e) {
               connection.rollback();
               throw e;
            }
         }
      }
      if ((Long) file.getMetaData(POSTGRES_OID_KEY) == 0) {
         System.out.println("FD");
      }
      return (Long) file.getMetaData(POSTGRES_OID_KEY);
   }

   private int getPostGresLargeObjectSize(JDBCSequentialFile file) throws SQLException {
      LargeObjectManager lobjManager = ((PGConnection) connection).getLargeObjectAPI();

      int size = 0;
      Long oid = getOID(file);
      if (oid != null) {
         synchronized (connection) {
            try {
               connection.setAutoCommit(false);
               LargeObject largeObject = lobjManager.open(oid, LargeObjectManager.READ);
               size = largeObject.size();
               largeObject.close();
               connection.commit();
            } catch (SQLException e) {
               connection.rollback();
               throw e;
            }
         }
      }
      return size;
   }
}
