com.lucidchart.open.relate.interp

InterpolatedQuery

Related Docs: object InterpolatedQuery | package interp

class InterpolatedQuery extends Sql with MultipleParameter

Linear Supertypes
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. InterpolatedQuery
  2. MultipleParameter
  3. Parameter
  4. Sql
  5. AnyRef
  6. Any
  1. Hide All
  2. Show all
Learn more about member selection
Visibility
  1. Public
  2. All

Instance Constructors

  1. new InterpolatedQuery(parsedQuery: String, params: Seq[Parameter])

Type Members

  1. class BaseStatement extends AnyRef

    Attributes
    protected[com.lucidchart.open.relate]
    Definition Classes
    Sql

Value Members

  1. final def !=(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any
  2. final def ##(): Int

    Definition Classes
    AnyRef → Any
  3. def +(query: InterpolatedQuery): InterpolatedQuery

  4. final def ==(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any
  5. def appendPlaceholders(stringBuilder: StringBuilder): Unit

    Definition Classes
    InterpolatedQueryParameter
  6. def applyParams(stmt: PreparedStatement): Unit

    Attributes
    protected
    Definition Classes
    InterpolatedQuerySql
  7. def asCollection[U, T[_]]()(implicit arg0: Parseable[U], cbf: CanBuildFrom[T[U], U, T[U]], connection: Connection): T[U]

    Definition Classes
    Sql
  8. def asCollection[U, T[_]](parser: (SqlResult) ⇒ U)(implicit cbf: CanBuildFrom[T[U], U, T[U]], connection: Connection): T[U]

    Execute this query and get back the result as an arbitrary collection of records

    Execute this query and get back the result as an arbitrary collection of records

    parser

    the RowParser to use when parsing the result set

    connection

    the connection to use when executing the query

    returns

    the results as an arbitrary collection of records

    Definition Classes
    Sql
  9. final def asInstanceOf[T0]: T0

    Definition Classes
    Any
  10. def asIterable[A]()(implicit arg0: Parseable[A], connection: Connection): Iterable[A]

    Definition Classes
    Sql
  11. def asIterable[A](parser: (SqlResult) ⇒ A)(implicit connection: Connection): Iterable[A]

    Execute this query and get back the result as an iterable of records

    Execute this query and get back the result as an iterable of records

    parser

    the RowParser to use when parsing the result set

    connection

    the connection to use when executing the query

    returns

    the results as an iterable of records

    Definition Classes
    Sql
  12. def asIterator[A](parser: (SqlResult) ⇒ A, fetchSize: Int = 100)(implicit connection: Connection): Iterator[A]

    The asIterator method returns an Iterator that will stream data out of the database.

    The asIterator method returns an Iterator that will stream data out of the database. This avoids an OutOfMemoryError when dealing with large datasets. Bear in mind that many JDBC implementations will not allow additional queries to the connection before all records in the Iterator have been retrieved.

    parser

    the RowParser to parse rows with

    fetchSize

    the number of rows to fetch at a time, defaults to 100. If the JDBC Driver is MySQL, the fetchSize will always default to Int.MinValue, as MySQL's JDBC implementation ignores all other fetchSize values and only streams if fetchSize is Int.MinValue

    Definition Classes
    Sql
  13. def asList[A]()(implicit arg0: Parseable[A], connection: Connection): List[A]

    Definition Classes
    Sql
  14. def asList[A](parser: (SqlResult) ⇒ A)(implicit connection: Connection): List[A]

    Execute this query and get back the result as a List of records

    Execute this query and get back the result as a List of records

    parser

    the RowParser to use when parsing the result set

    connection

    the connection to use when executing the query

    returns

    the results as a List of records

    Definition Classes
    Sql
  15. def asMap[U, V]()(implicit connection: Connection, p: Parseable[(U, V)]): Map[U, V]

    Definition Classes
    Sql
  16. def asMap[U, V](parser: (SqlResult) ⇒ (U, V))(implicit connection: Connection): Map[U, V]

    Execute this query and get back the result as a Map of records

    Execute this query and get back the result as a Map of records

    parser

    the RowParser to use when parsing the result set. The RowParser should return a Tuple of size 2 containing the key and value

    connection

    the connection to use when executing the query

    returns

    the results as a Map of records

    Definition Classes
    Sql
  17. def asMultiMap[U, V]()(implicit connection: Connection, p: Parseable[(U, V)]): Map[U, Set[V]]

    Definition Classes
    Sql
  18. def asMultiMap[U, V](parser: (SqlResult) ⇒ (U, V))(implicit connection: Connection): Map[U, Set[V]]

    Definition Classes
    Sql
  19. def asPairCollection[U, V, T[_, _]]()(implicit cbf: CanBuildFrom[T[U, V], (U, V), T[U, V]], connection: Connection, p: Parseable[(U, V)]): T[U, V]

    Definition Classes
    Sql
  20. def asPairCollection[U, V, T[_, _]](parser: (SqlResult) ⇒ (U, V))(implicit cbf: CanBuildFrom[T[U, V], (U, V), T[U, V]], connection: Connection): T[U, V]

    Execute this query and get back the result as an arbitrary collection of key value pairs

    Execute this query and get back the result as an arbitrary collection of key value pairs

    parser

    the RowParser to use when parsing the result set

    connection

    the connection to use when executing the query

    returns

    the results as an arbitrary collection of key value pairs

    Definition Classes
    Sql
  21. def asScalar[A]()(implicit connection: Connection): A

    Execute this query and get back the result as a single value.

    Execute this query and get back the result as a single value. Assumes that there is only one row and one value in the result set.

    connection

    the connection to use when executing the query

    returns

    the results as a single value

    Definition Classes
    Sql
  22. def asScalarOption[A]()(implicit connection: Connection): Option[A]

    Execute this query and get back the result as an optional single value.

    Execute this query and get back the result as an optional single value. Assumes that there is only one row and one value in the result set.

    connection

    the connection to use when executing the query

    returns

    the results as an optional single value

    Definition Classes
    Sql
  23. def asSeq[A]()(implicit arg0: Parseable[A], connection: Connection): Seq[A]

    Definition Classes
    Sql
  24. def asSeq[A](parser: (SqlResult) ⇒ A)(implicit connection: Connection): Seq[A]

    Execute this query and get back the result as a sequence of records

    Execute this query and get back the result as a sequence of records

    parser

    the RowParser to use when parsing the result set

    connection

    the connection to use when executing the query

    returns

    the results as a sequence of records

    Definition Classes
    Sql
  25. def asSet[A]()(implicit arg0: Parseable[A], connection: Connection): Set[A]

    Definition Classes
    Sql
  26. def asSet[A](parser: (SqlResult) ⇒ A)(implicit connection: Connection): Set[A]

    Execute this query and get back the result as a Set of records

    Execute this query and get back the result as a Set of records

    parser

    the RowParser to use when parsing the result set

    connection

    the connection to use when executing the query

    returns

    the results as a Set of records

    Definition Classes
    Sql
  27. def asSingle[A]()(implicit arg0: Parseable[A], connection: Connection): A

    Definition Classes
    Sql
  28. def asSingle[A](parser: (SqlResult) ⇒ A)(implicit connection: Connection): A

    Execute this query and get back the result as a single record

    Execute this query and get back the result as a single record

    parser

    the RowParser to use when parsing the result set

    connection

    the connection to use when executing the query

    returns

    the results as a single record

    Definition Classes
    Sql
  29. def asSingleOption[A]()(implicit arg0: Parseable[A], connection: Connection): Option[A]

    Definition Classes
    Sql
  30. def asSingleOption[A](parser: (SqlResult) ⇒ A)(implicit connection: Connection): Option[A]

    Execute this query and get back the result as an optional single record

    Execute this query and get back the result as an optional single record

    parser

    the RowParser to use when parsing the result set

    connection

    the connection to use when executing the query

    returns

    the results as an optional single record

    Definition Classes
    Sql
  31. def clone(): AnyRef

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  32. final def eq(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  33. def equals(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any
  34. def execute()(implicit connection: Connection): Boolean

    Execute a statement

    Execute a statement

    connection

    the db connection to use when executing the query

    returns

    whether the query succeeded in its execution

    Definition Classes
    Sql
  35. def executeInsertCollection[U, T[_]](parser: (SqlResult) ⇒ U)(implicit cbf: CanBuildFrom[T[U], U, T[U]], connection: Connection): T[U]

    Execute the query and get the auto-incremented keys using a RowParser.

    Execute the query and get the auto-incremented keys using a RowParser. Provided for the case that a primary key is not an Int or BigInt

    parser

    the RowParser that can parse the returned keys

    connection

    the connection to use when executing the query

    returns

    the auto-incremented keys

    Definition Classes
    Sql
  36. def executeInsertInt()(implicit connection: Connection): Int

    Execute the query and get the auto-incremented key as an Int

    Execute the query and get the auto-incremented key as an Int

    connection

    the connection to use when executing the query

    returns

    the auto-incremented key as an Int

    Definition Classes
    Sql
  37. def executeInsertInts()(implicit connection: Connection): List[Int]

    Execute the query and get the auto-incremented keys as a List of Ints

    Execute the query and get the auto-incremented keys as a List of Ints

    connection

    the connection to use when executing the query

    returns

    the auto-incremented keys as a List of Ints

    Definition Classes
    Sql
  38. def executeInsertLong()(implicit connection: Connection): Long

    Execute the query and get the auto-incremented key as a Long

    Execute the query and get the auto-incremented key as a Long

    connection

    the connection to use when executing the query

    returns

    the auto-incremented key as a Long

    Definition Classes
    Sql
  39. def executeInsertLongs()(implicit connection: Connection): List[Long]

    Execute the query and get the auto-incremented keys as a a List of Longs

    Execute the query and get the auto-incremented keys as a a List of Longs

    connection

    the connection to use when executing the query

    returns

    the auto-incremented keys as a a List of Longs

    Definition Classes
    Sql
  40. def executeInsertSingle[U](parser: (SqlResult) ⇒ U)(implicit connection: Connection): U

    Execute the query and get the auto-incremented key using a RowParser.

    Execute the query and get the auto-incremented key using a RowParser. Provided for the case that a primary key is not an Int or BigInt

    parser

    the RowParser that can parse the returned key

    connection

    the connection to use when executing the query

    returns

    the auto-incremented key

    Definition Classes
    Sql
  41. def executeUpdate()(implicit connection: Connection): Int

    Execute an update

    Execute an update

    connection

    the db connection to use when executing the query

    returns

    the number of rows update by the query

    Definition Classes
    Sql
  42. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  43. final def getClass(): Class[_]

    Definition Classes
    AnyRef → Any
  44. def hashCode(): Int

    Definition Classes
    AnyRef → Any
  45. def insertionStatement(implicit connection: Connection): BaseStatement with InsertionStatementPreparer

    Attributes
    protected
    Definition Classes
    Sql
  46. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any
  47. final def ne(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  48. def normalStatement(implicit connection: Connection): BaseStatement with NormalStatementPreparer

    Attributes
    protected
    Definition Classes
    Sql
  49. final def notify(): Unit

    Definition Classes
    AnyRef
  50. final def notifyAll(): Unit

    Definition Classes
    AnyRef
  51. def parameterize(statement: PreparedStatement, i: Int): Int

    Definition Classes
    MultipleParameterParameter
  52. val params: Seq[Parameter]

    Attributes
    protected
    Definition Classes
    InterpolatedQueryMultipleParameter
  53. val parsedQuery: String

    Attributes
    protected
    Definition Classes
    InterpolatedQuerySql
  54. def results()(implicit connection: Connection): ResultSet

    Provides direct access to the underlying java.sql.ResultSet.

    Provides direct access to the underlying java.sql.ResultSet. Note that this ResultSet must be closed manually or by wrapping it in SqlResult.

    val results = SQL(query).results()
    . . .
    SqlResult(results).asList[A](parser)
    // or
    results.close()
    returns

    java.sql.ResultSet

    Definition Classes
    Sql
  55. def statementString(implicit connection: Connection): String

    Calls PreparedStatement#toString, which for many JDBC implementations is the SQL query after parameter substitution.

    Calls PreparedStatement#toString, which for many JDBC implementations is the SQL query after parameter substitution. This is intended primarily for ad-hoc debugging.

    For more routine logging, consider other solutions, such as log4jdbc.

    Definition Classes
    Sql
  56. def streamedStatement(fetchSize: Int)(implicit connection: Connection): BaseStatement with StreamedStatementPreparer

    Attributes
    protected
    Definition Classes
    Sql
  57. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes
    AnyRef
  58. def toString(): String

    Returns the SQL query, before parameter substitution.

    Returns the SQL query, before parameter substitution.

    Definition Classes
    Sql → AnyRef → Any
  59. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  60. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  61. final def wait(arg0: Long): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  62. def withTimeout(seconds: Int): InterpolatedQuery

Inherited from MultipleParameter

Inherited from Parameter

Inherited from Sql

Inherited from AnyRef

Inherited from Any

Ungrouped