jdbc

Type Members

1. trait ColumnDefiner extends AnyRef

   

2. case class ColumnDefinition(name: ColumnName, definition: Definition) extends Product with Serializable

   

3. case class ColumnName(get: String) extends Product with Serializable

   

4. case class ConnectUrl(get: String) extends Product with Serializable

   

5. case class ConnectionSpec(connectUrl: ConnectUrl, userName: UserName, password: Password) extends Product with Serializable

   

   Pass your DB credentials to this class in a preferred secure way

6. case class Definition(get: String) extends Product with Serializable

   

7. case class DriverClass(get: String) extends Product with Serializable

   

8. trait DriverColumnDefiner[Type <: JdbcType] extends AnyRef

   

   This is a mechanism by which different databases can control and configure the way in which statements are created.

9. trait HsqlDbDriver extends JdbcDriver

   

10. sealed abstract class IsNullable extends AnyRef

    

11. abstract class JDBCSource extends Source with ColumnDefiner with JdbcDriver

    

    Extend this source to let scalding read from or write to a database.

    Extend this source to let scalding read from or write to a database. In order for this to work you need to specify the table name, column definitions and DB credentials. If you write to a DB, the fields in the final pipe have to correspond to the column names in the DB table. Example usage: case object YourTableSource extends JDBCSource { override val tableName = TableName("tableName") override val columns = List( varchar("col1", 64), date("col2"), tinyint("col3"), double("col4") ) override def currentConfig = ConnectionSpec( ConnectUrl("jdbc:mysql://mysql01.company.com:3306/production"), UserName("username"), Password("password"), MysqlDriver ) }

12. trait JdbcDriver extends AnyRef

    

13. sealed trait JdbcType extends AnyRef

    

14. trait MysqlDriver extends JdbcDriver with MysqlTableCreationImplicits

    

15. trait MysqlTableCreationImplicits extends AnyRef

    

16. case class Password(get: String) extends Product with Serializable

    

17. case class TableName(get: String) extends Product with Serializable

    

18. case class UserName(get: String) extends Product with Serializable

    

19. trait VerticaDriver extends JdbcDriver with VerticaTableCreationImplicits

    

    Old Vertica 4.1 jdbc driver see https://my.vertica.com/docs/5.1.6/HTML/index.htm#16699.htm

20. trait VerticaJdbcDriver extends JdbcDriver with VerticaTableCreationImplicits

    

    Vertica jdbc driver (5.1 and higher)

21. trait VerticaTableCreationImplicits extends AnyRef