object DatabaseUtils
Utility class with methods to help export data frames to a database
- Alphabetic
- By Inheritance
- DatabaseUtils
- AnyRef
- Any
- Hide All
- Show All
- Public
- Protected
Value Members
- final def !=(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- final def ##: Int
- Definition Classes
- AnyRef → Any
- final def ==(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- final def asInstanceOf[T0]: T0
- Definition Classes
- Any
- def clone(): AnyRef
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.CloneNotSupportedException]) @IntrinsicCandidate() @native()
- def databaseUrl(database: String, connection: ConnectionInfo): String
Builds the URL for connecting to a database through JDBC.
Builds the URL for connecting to a database through JDBC.
- database
The name of the database.
- connection
The
ConnectionInfo
object with information on how to connect.
- def deleteRows(scope: PipelineExecutionScopeApi, table: String, database: String, connection: String, filter: Option[String]): Unit
Deletes rows from a table that match a given filter.
Deletes rows from a table that match a given filter.
- scope
The
PipelineExecutionScopeApi
object accessible when running code in a pipeline.
- table
The table to delete data from.
- database
The name of the database.
- connection
The unique ID of the connection object.
- filter
The filter describing what rows to delete. Leave empty to truncate the table.
- def deleteRows(databaseUrl: String, table: String, filter: Option[String]): Unit
Deletes rows from a table that match a given filter.
Deletes rows from a table that match a given filter.
- databaseUrl
The URL for connecting to the database.
- table
The table to delete data from.
- filter
The filter describing what rows to delete. Leave empty to truncate the table.
- final def eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- def equals(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef → Any
- final def getClass(): Class[_ <: AnyRef]
- Definition Classes
- AnyRef → Any
- Annotations
- @IntrinsicCandidate() @native()
- def hashCode(): Int
- Definition Classes
- AnyRef → Any
- Annotations
- @IntrinsicCandidate() @native()
- def insertFrame(frame: DataFrame, scope: PipelineExecutionScopeApi, table: String, database: String, connection: String, properties: Properties = new Properties()): Unit
Deletes rows from a table that match a given filter.
Deletes rows from a table that match a given filter.
- frame
The
DataFrame
object to insert
- scope
The
PipelineExecutionScopeApi
object accessible when running code in a pipeline.
- table
The table to delete data from.
- database
The name of the database.
- connection
The unique ID of the connection object.
- properties
The
Properties
object to use for the JDBC connection.
- def insertFrame(frame: DataFrame, databaseUrl: String, table: String, properties: Properties): Unit
Insert a data frame into a database.
Insert a data frame into a database.
- frame
The
DataFrame
object to insert
- databaseUrl
The URL for connecting to the database.
- table
The table to delete data from.
- properties
The
Properties
object to use for the JDBC connection.
- def insertOrUpdateFrame(frame: DataFrame, scope: PipelineExecutionScopeApi, table: String, database: String, connection: String, keyColumns: List[String], properties: Properties = new Properties()): Unit
Deletes rows from a table that match a given filter.
Deletes rows from a table that match a given filter.
- frame
The
DataFrame
object to insert
- scope
The
PipelineExecutionScopeApi
object accessible when running code in a pipeline.
- table
The table to delete data from.
- database
The name of the database.
- connection
The unique ID of the connection object.
- keyColumns
The list of columns whose combined values determine the rows to delete before the insert.
- properties
The
Properties
object to use for the JDBC connection.
- def insertOrUpdateFrame(frame: DataFrame, databaseUrl: String, table: String, keyColumns: List[String], properties: Properties): Unit
Deletes rows from a table that match a given filter.
Deletes rows from a table that match a given filter.
- frame
The
DataFrame
object to insert
- databaseUrl
The URL for connecting to the database.
- table
The table to delete data from.
- keyColumns
The list of columns whose combined values determine the rows to delete before the insert.
- properties
The
Properties
object to use for the JDBC connection.
- final def isInstanceOf[T0]: Boolean
- Definition Classes
- Any
- final def ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- final def notify(): Unit
- Definition Classes
- AnyRef
- Annotations
- @IntrinsicCandidate() @native()
- final def notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @IntrinsicCandidate() @native()
- final def synchronized[T0](arg0: => T0): T0
- Definition Classes
- AnyRef
- def toString(): String
- Definition Classes
- AnyRef → Any
- final def wait(arg0: Long, arg1: Int): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
- final def wait(arg0: Long): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException]) @native()
- final def wait(): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
Deprecated Value Members
- def finalize(): Unit
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.Throwable]) @Deprecated
- Deprecated
(Since version 9)