package main;
import items.LString;
import java.util.ArrayList;
import dbdao.DBaseManager;
public class SwapDB
{
String table;
int index1;
int index2;
ArrayList<String> lSQL;
public SwapDB( String tabla , int indice1 , int indice2 )
{
table = tabla;
index1 = indice1;
index2 = indice2;
DBaseManager dbm = new DBaseManager();
lSQL = new ArrayList<String>();
ArrayList<LString> lElem = dbm.getElements("SELECT * FROM " + tabla + " WHERE ID=" + index1 + " OR ID=" + index2);
/*
LString aux = lElem.get(0);
for( int i=1 ; i<lElem.get(0).length ; i++ )
{
lElem.get(0).set(i,lElem.get(1).get(i));
lElem.get(1).set(i,aux.get(i));
}
*/
if( table.equalsIgnoreCase("params") )
{
lSQL.add( "UPDATE params SET menuTable='" + lElem.get(0).get(1) + "',display='" + lElem.get(0).get(2) + "',colName='" + lElem.get(0).get(3) + "' WHERE ID=" + lElem.get(1).get(0) );
lSQL.add( "UPDATE params SET menuTable='" + lElem.get(1).get(1) + "',display='" + lElem.get(1).get(2) + "',colName='" + lElem.get(1).get(3) + "' WHERE ID=" + lElem.get(0).get(0) );
}
else
{
System.out.println("Aun no esta implementada la parte de para cualquier tabla que no sea params. No seas vago y hazlo xD");
}
for( int i=0 ; i<lSQL.size() ; i++ )
System.out.println( lSQL.get(i));
dbm.updateElements(lSQL);
}
}