package eg.edu.alexu.csd.oop.JDBC.resultSet;

import eg.edu.alexu.csd.oop.JDBC.ResultSetMetaData.DBResultSetMetaData;
import eg.edu.alexu.csd.oop.JDBC.ResultSetMetaData.DBResultSetMetaDataAdabter;

import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

public class DBResultSetAdapter extends DBResultSet {
    private tableData tD;
    private int cursor = -1;
    public DBResultSetAdapter(tableData tD) {
        this.tD = tD;
    }

    public boolean absolute(int row) throws SQLException {
        if (row>0) {
            if (tD.getData().size() < row ) {
                cursor = row - 1;
                return true;
            }
        }
        else {
            if (tD.getData().size() < tD.getData().size()-Math.abs(row)) {
                cursor = tD.getData().size()-Math.abs(row);
                return true;
            }
        }
        return false;
    }

    @Override
    public boolean previous() throws SQLException {
        if (cursor!=0) {
            cursor--;
            return true;
        }
        return false;
    }

    @Override
    public Statement getStatement() throws SQLException {
        return null;
    }

    @Override
    public boolean isClosed() throws SQLException {
        return false;
    }

    public boolean next() throws SQLException{
        if (tD.getData().size() > cursor+1) {
            cursor++;
            return true;
        }
        return false;
    }

    @Override
    public void close() throws SQLException {

    }

    @Override
    public String getString(int columnIndex) throws SQLException {
        return null;
    }

    @Override
    public int getInt(int columnIndex) throws SQLException {
        return 0;
    }

    @Override
    public String getString(String columnLabel) throws SQLException {
        return null;
    }

    @Override
    public int getInt(String columnLabel) throws SQLException {
        return 0;
    }

    @Override
    public ResultSetMetaData getMetaData() throws SQLException {
        DBResultSetMetaData DBRMD = new DBResultSetMetaDataAdabter(tD);
        return DBRMD;
    }

    @Override
    public Object getObject(int columnIndex) throws SQLException {
        return tD.getData().get(cursor-1).get(columnIndex-1);
    }

    @Override
    public int findColumn(String columnLabel) throws SQLException {
        return 0;
    }

    @Override
    public boolean isBeforeFirst() throws SQLException {
        return false;
    }

    @Override
    public boolean isAfterLast() throws SQLException {
        return false;
    }

    @Override
    public boolean isFirst() throws SQLException {
        return false;
    }

    @Override
    public boolean isLast() throws SQLException {
        return false;
    }

    @Override
    public void beforeFirst() throws SQLException {

    }

    @Override
    public void afterLast() throws SQLException {

    }

    @Override
    public boolean first() throws SQLException {
        return false;
    }

    @Override
    public boolean last() throws SQLException {
        return false;
    }

}