/*******************************************************************************
* Copyright (c) 2009 IBM Corporation and others.
* All rights reserved. This program and the accompanying materials
* are made available under the terms of the Eclipse Public License v1.0
* which accompanies this distribution, and is available at
* http://www.eclipse.org/legal/epl-v10.html
*
* Contributors:
* IBM Corporation - initial API and implementation
* Zend Technologies
*******************************************************************************/
package org.eclipse.dltk.core.index.sql;
import java.sql.Connection;
import java.sql.SQLException;
/**
* Element file data access object
*
* @author michael
*
*/
public interface IFileDao {
/**
* Inserts new type into FILES table.
*
* @param connection
* Database connection
* @param path
* Element file
* @param timestamp
* File last update time
* @param containerId
* Container path
* @return new file DAO associated with added row
* @throws SQLException
*/
public File insert(Connection connection, String path, long timestamp,
int containerId) throws SQLException;
/**
* Selects file by path
*
* @param connection
* Database connection
* @param path
* Element file
* @param containerId
* Container path id
* @return file DAO or <code>null</code> in case it doesn't exist
* @throws SQLException
*/
public File select(Connection connection, String path, int containerId)
throws SQLException;
/**
* Selects files by conatiner path
*
* @param connection
* Database connection
* @param containerId
* Container path id
* @return files DAO array
* @throws SQLException
*/
public File[] selectByContainerId(Connection connection, int containerId)
throws SQLException;
/**
* Selects file by key
*
* @param connection
* Database connection
* @param id
* Primary key
* @return file DAO or <code>null</code> in case it doesn't exist
* @throws SQLException
*/
public File selectById(Connection connection, int id) throws SQLException;
/**
* Deletes file from the database
*
* @param connection
* Database connection
* @param path
* File path
* @param containerId
* Container path ID
* @throws SQLException
*/
public void delete(Connection connection, String path, int containerId)
throws SQLException;
/**
* Deletes file from the database by primary key
*
* @param connection
* Database connection
* @param id
* Primary key
* @throws SQLException
*/
public void deleteById(Connection connection, int id) throws SQLException;
}