/*
 * Created on 22-jul-2003
 *
 */
package com.quantum.actions;

import com.quantum.ImageStore;
import com.quantum.Messages;
import com.quantum.adapters.DatabaseAdapter;
import com.quantum.model.Bookmark;
import com.quantum.sql.SQLResults;
import com.quantum.view.ViewHelper;
import com.quantum.view.bookmark.EntityNode;
import com.quantum.view.tableview.TableView;

import org.eclipse.ui.IViewPart;

public class PrevSequenceAction extends BaseSequenceAction {
	/**
     * @param text
     * @param view
     */
    public PrevSequenceAction(IViewPart view) {
        super(Messages.getString(PrevSequenceAction.class.getName() + ".text"), view);
        setImageDescriptor(ImageStore.getImageDescriptor(ImageStore.GRID));
    }

    public void run() {
		EntityNode sequence = getEntityNode();
		if (sequence.isSequence()) {
			Bookmark bookmark = sequence.getBookmark();
			DatabaseAdapter adapter = bookmark.getAdapter();
			if (adapter == null) return;
			String name = sequence.getName();
			String query = adapter.getPrevValue(name, sequence.getEntity().getSchema());
			SQLResults results = ViewHelper.tryGetResults(view, getConnection(), query);
			if (results != null && ! results.isError()) 
				TableView.getInstance().loadQuery(bookmark, results);
		}
	}
}