source: trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/database/GS3SQLUpdate.java@ 7305

package org.greenstone.gsdl3.gs3build.database;

public   class GS3SQLUpdate extends GS3SQLAction
  { GS3SQLWhere where;

    public GS3SQLUpdate(String table)
    { super(table);
      this.where  = null;
    }

    public void setWhere(GS3SQLWhere where)
    { this.where = where;
    }

    public String toString()
    {
      StringBuffer reply = new StringBuffer();
      reply.append("UPDATE ");
      reply.append(this.table);
      reply.append(" SET ");
      for (int i = 0; i < this.values.size(); i ++)
      { GS3SQLValue value = (GS3SQLValue) this.values.get(i);
        if (i > 0)
      reply.append(", ");
        reply.append(value.field);
    reply.append("=");
    if (value.getType() == null ||
        value.getType().equals(GS3SQLField.VARCHAR_TYPE))
    {
        reply.append("\"");
    }
    reply.append(value.value);
    if (value.getType() == null ||
        value.getType().equals(GS3SQLField.VARCHAR_TYPE))
    {
        reply.append("\"");
    }
      }
      if (this.where != null)
      { reply.append(" WHERE ");
    reply.append(where.toString());
      }
      reply.append(";");
      return reply.toString();
    }
  }