You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

UpdateColumnIncrement.java 1.4KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  1. /*
  2. * Copyright 2004-2011 H2 Group.
  3. * Copyright 2011 James Moger.
  4. *
  5. * Licensed under the Apache License, Version 2.0 (the "License");
  6. * you may not use this file except in compliance with the License.
  7. * You may obtain a copy of the License at
  8. *
  9. * http://www.apache.org/licenses/LICENSE-2.0
  10. *
  11. * Unless required by applicable law or agreed to in writing, software
  12. * distributed under the License is distributed on an "AS IS" BASIS,
  13. * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  14. * See the License for the specific language governing permissions and
  15. * limitations under the License.
  16. */
  17. package com.iciql;
  18. /**
  19. * This class represents "SET column = (column + x)" in an UPDATE statement.
  20. *
  21. * @param <T> the query type
  22. * @param <A> the new value data type
  23. */
  24. public class UpdateColumnIncrement<T, A> implements UpdateColumn {
  25. private Query<T> query;
  26. private A x;
  27. private A y;
  28. UpdateColumnIncrement(Query<T> query, A x) {
  29. this.query = query;
  30. this.x = x;
  31. }
  32. public Query<T> by(A y) {
  33. query.addUpdateColumnDeclaration(this);
  34. this.y = y;
  35. return query;
  36. }
  37. public void appendSQL(SQLStatement stat) {
  38. query.appendSQL(stat, null, x);
  39. stat.appendSQL("=(");
  40. query.appendSQL(stat, null, x);
  41. stat.appendSQL("+");
  42. query.appendSQL(stat, x, y);
  43. stat.appendSQL(")");
  44. }
  45. }