DBFiller

Value Members

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

   Definition Classes

   AnyRef

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

   Definition Classes

   Any

3. final def ##(): Int

   Definition Classes

   AnyRef → Any

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

   Definition Classes

   AnyRef

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

   Definition Classes

   Any

6. def apply(textArea: TextArea, xls: HSSFWorkbook, db: Database): Unit

   Process a xls file of water analysis records, and insert the processed records into a database.

   Process a xls file of water analysis records, and insert the processed records into a database.

   The processing steps are as follows:

   1. Read in all lines of xls file.
   2. Check that header line from xls file has the expected column names.
   3. Create a sequence corresponding to the rows in the xls file of maps from column title to column value.
   4. Check that the "Param" value in each element of the sequence (i.e, an xls row) is an expected value.
   5. Check that the "Test" values, for those "Param"s that have tests, are expected values.
   6. Remove sequence elements with sample point IDs that do not exist in the database "Chemistry SampleInfo" table.
   7. Check that sample point IDs in remaining sequence elements do _not_ exist in major and minor chemistry database tables.
   8. Convert the sequence of maps derived from the xls into a new sequence of maps compatible with the database table schemas.
   9. Remove "low priority" test results (this ensures that only the most preferred test results for those rows with "Test" values get into the database).
   10. Add new rows to the database.
   11. Scan sequence of maps that were just inserted into the database to find those records that fail to meet drinking water standards, and print out a message for those that fail.

   textArea

   for text output

   xls

   HSSFWorkbook from water analysis report in XLS format

   db

   Database for target database

7. final def asInstanceOf[T0]: T0

   Definition Classes

   Any

8. def clone(): AnyRef

   Attributes

   protected[java.lang]

   Definition Classes

   AnyRef

   Annotations

   @throws( ... )

9. final def eq(arg0: AnyRef): Boolean

   Definition Classes

   AnyRef

10. def equals(arg0: Any): Boolean

    Definition Classes

    AnyRef → Any

11. def finalize(): Unit

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

    @throws( classOf[java.lang.Throwable] )

12. final def getClass(): Class[_]

    Definition Classes

    AnyRef → Any

13. def hashCode(): Int

    Definition Classes

    AnyRef → Any

14. final def isInstanceOf[T0]: Boolean

    Definition Classes

    Any

15. final def ne(arg0: AnyRef): Boolean

    Definition Classes

    AnyRef

16. final def notify(): Unit

    Definition Classes

    AnyRef

17. final def notifyAll(): Unit

    Definition Classes

    AnyRef

18. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes

    AnyRef

19. def toString(): String

    Definition Classes

    AnyRef → Any

20. final def wait(): Unit

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

21. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

22. final def wait(arg0: Long): Unit

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )