Package generalDatabase
package generalDatabase
-
ClassDescriptionVersion of SQLLogging which buffers up the data units for a few seconds before writing them so that other parts of PAMguard get a chance to modify them before they go into the database.simple class for passing information about data map making from swing worker to dialog.Run some tests to try to work out why it's so much slower to load data when the query is based on a non indexed column compared to an index one, even though the actual query execution time is a small fraction of the total time.Works with a DataUnitFinder to match PamDataUnits by database index.Class to handle regular commits of the data when Auto Commit is not set.Database system for accessing data in just about any type of odbc database.Version of DBControl for loading settings at program startup.Version of DBControl for normal use while PAMGUARD is running - reading and writing of dataDialog which shows the progress in data map making.Functions for writing database table schema in a format compatible with the Tethys schemas.Load all of the settings from a database and store in a single class.simple abstract class for any extra database functions which do not easily work with PamDataUnits and PamDatablocksA totally empty table definition.Converts arrays of numbers into string representations which are a little bit, but not entirely json like for writing to text fields in the database.Functions for writing a list of modules into any database as character data Runs at DAQ start, goes through the settings manager list and for each set of settings, it serialises the settings data into a binary array, this is then converted from binary data to 6 bit ascii data (using the character set from the AIS standard, which should be compatible with any DBMS).Functions for writing serialised Pamguard Settings into any database as character data Runs at DAQ start, goes through the settings manager list and for each set of settings, it serialises the settings data into a binary array, this is then converted from binary data to 6 bit ascii data (using the character set from the AIS standard, which should be compatible with any DBMS).simple data unit for use with the LogXMLSettings class2022 Additional way of saving settings for each module into the database in more human readable XML format.Slightly modified connection object to pass around - contains not only the database connection, but also an sqlTypes object which can get's used to make a few slightly non standard mods to some column and data formats to keep the various dbms's happy together.Standard logging class for any PamDetection, but you'll want to extend it for any additional information your detector outputs.This class is used as temporary storage for subtable data of PamDataBlocks being loaded from a database.Defines a database table for use with the Pamguard database The Pamguard database can query this table definition to see what columns should be present and to create appropriate tables.Defines a single item (column) for a Pamguard database table These are listed in PamTableDefinition for each table.SQLLogging performs basic SQL actions to write and read data from a database.common functionality to add on to an existing SQL logging object.Utilities for converting between java.sql.types numeric and text formats.Extensions to SQLLogging to be used with datablocks that log sub detections.Different db systems can proide a system specific dialog panel by implementing this interfaceSome general functions to do with table checks which I want to use outside of the normal dattabse interface.Override standard Timestamp class and stop it making UTC corrections as it writes to database