@groovy.util.logging.Log class Schema extends java.lang.Object
The default schema, which uses SQLite syntax
| Type | Name and description | 
|---|---|
static java.lang.String  | 
                            CREATE_SAMPLE_SQL | 
                        
static java.lang.String  | 
                            VARIANT_OBSERVATION_TABLE | 
                        
static java.util.Map<java.lang.Integer, java.util.Map<java.lang.String, java.util.List<java.lang.String>>>  | 
                            schema | 
                        
java.lang.Object  | 
                            schemaInfoMeta data about schema that this database is connected to  | 
                        
| Constructor and description | 
|---|
                                Schema
                                () | 
                        
| Type Params | Return Type | Name and description | 
|---|---|---|
 | 
                            void | 
                            checkSchema(groovy.sql.Sql db)Iterate over the schema versions and check if they exist  | 
                        
 | 
                            void | 
                            upgradeLegacy(groovy.sql.Sql db)This function upgrades a "legacy" database that was created as part of the MGHA project to the schema used by this class.  | 
                        
 | 
                            void | 
                            upgradeSchema(groovy.sql.Sql db, int toVersion)Execute the given statements to upgrade the schema  | 
                        
| Methods inherited from class | Name | 
|---|---|
class java.lang.Object | 
                            java.lang.Object#wait(long), java.lang.Object#wait(long, int), java.lang.Object#wait(), java.lang.Object#equals(java.lang.Object), java.lang.Object#toString(), java.lang.Object#hashCode(), java.lang.Object#getClass(), java.lang.Object#notify(), java.lang.Object#notifyAll() | 
                        
Meta data about schema that this database is connected to
Iterate over the schema versions and check if they exist
This function upgrades a "legacy" database that was created as part of the MGHA project to the schema used by this class. It's a one-way conversion, so use caution!
Execute the given statements to upgrade the schema
Groovy Documentation