summaryrefslogtreecommitdiff
path: root/sources/scala/dbc/statement/Update.scala
blob: bc541200c47fc61e3118ae461521a00b4a1d5897 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
/*                     __                                               *\
**     ________ ___   / /  ___     Scala API                            **
**    / __/ __// _ | / /  / _ |    (c) 2003-2005, LAMP/EPFL             **
**  __\ \/ /__/ __ |/ /__/ __ |                                         **
** /____/\___/_/ |_/____/_/ | |                                         **
**                          |/                                          **
\*                                                                      */

package scala.dbc.statement;

import scala.dbc.statement.expression._;

/** An update of the state of a table. */
case class Update (
	updateTarget: String,
	setClauses: List[SetClause],
	whereClause: Option[Expression]
) extends Status {


	/** A SQL-99 compliant string representation of the select statement. */
	def sqlString: String = (
		"UPDATE " +
		updateTarget +
		" SET " + setClauses.map(sc=>sc.sqlString).mkString("",", ","") +
		(whereClause match {
			case None => ""
			case Some(expr) => " WHERE " + expr.sqlString
		})
	);

	/** The name of the table that should be updated. */
	//def updateTarget: String;

	/** The data that will be added tot he table. */
	//def setClauses: List[SetClause];

	/** Defines condition that must be true in the tuples that will be updated.
		* This value expression must return a boolean or boolean-compatible
		* value. */
	//def whereClause: Option[scala.dbc.statement.expression.Expression];

}