ManagerSql

java.lang.Object
- util.PropertyContainer
- - util.PropertyResources
  - - mysql.AbstractSql
    - - mysql.ManagerSql

All Implemented Interfaces:

Cloneable, ExitCleaning, Initializable, PropertySupplying, ResourceSupplying
```
public class ManagerSql
extends AbstractSql
```
This class is used to check the local database on stella.aip.de for any entries generated by the user web interface. It sends e-mail with instruction to the stella babysitters.

Author:

wooz

Nested Class Summary

Nested Classes
Modifier and Type	Class and Description
`static class`	`ManagerSql.Confirm` Transfers users from the local database to stellausers in Tenerife.
`static class`	`ManagerSql.Fork` Adds a new forking to the template possibilities.
`static class`	`ManagerSql.Mirror` Reads proposal template files and updates the confirmed and proposal tables accordingly.
`static class`	`ManagerSql.Reset` Transfers users from the local database to stellausers in Tenerife.

Nested classes/interfaces inherited from class mysql.AbstractSql
AbstractSql.Columns, AbstractSql.Extract

Nested classes/interfaces inherited from class util.PropertyResources
PropertyResources.Load, PropertyResources.URLResource

Field Summary

Fields
Modifier and Type	Field and Description
`private static String`	`DEFABSTRACTKEY`
`private static String`	`DEFACKFIELD` The default acknowledged field.
`private static String`	`DEFACTIVEFIELD` The default column name.
`private static String`	`DEFACTIVEKEY`
`private static String`	`DEFAFFILFIELD` The key to the object name in the database.
`private static String`	`DEFCOLORFIELD` The key to the object name in the database.
`private static String`	`DEFCONFIRMEDHOST`
`private static String`	`DEFCONFIRMEDPATH`
`private static String`	`DEFCONFIRMEDTABLE` The default table.
`private static String`	`DEFDESCRIPTIONFIELD` The key to the object name in the database.
`private static long`	`DEFDISCOVERTIMEOUT`
`private static String`	`DEFEMAILFIELD` The default column name.
`private static String`	`DEFFORKTABLE` The key to the name of the fork table.
`private static String`	`DEFHASHFIELD` The key to the object name in the database.
`private static String`	`DEFLOCALTABLE` The default table.
`private static long`	`DEFNAG` Default no resend of e-mail.
`private static String`	`DEFNAMEFIELD` The default column name.
`private static String`	`DEFNOTIFYFIELD` The key to the object name in the database.
`private static String`	`DEFPASSWDFIELD` The key to the object name in the database.
`private static String`	`DEFPATHFIELD` The default column name.
`private static String`	`DEFPENDINGTABLE` The default table.
`private static String`	`DEFPIKEY`
`private static String`	`DEFPROPIDFIELD` The key to the object name in the database.
`private static String`	`DEFPROPIDKEY`
`private static String`	`DEFPUBKEYFIELD` The key to the object name in the database.
`private static String`	`DEFSCP`
`private static String`	`DEFSSH`
`private static String`	`DEFSUPPLIEDTABLE` The default table.
`private static String`	`DEFTEMPLATEFIELD` The key to the object name in the database.
`private static long`	`DEFTENERIFETIMEOUT`
`private static String`	`DEFTITLEKEY`
`private static String`	`DEFTMPDIR`
`private static String`	`DEFURLHOST`
`private static String`	`DEFURLPROTOCOL`
`private static String`	`DEFWHERE`
`private static String`	`DEFWHEREEXE`
`private static String`	`DEFWHEREPATH`
`private static String`	`DEFWHO`
`static String`	`KEY_ABSTRACTKEY`
`static String`	`KEY_ACKFIELD` The key to the field name for acknowledged boolean.
`static String`	`KEY_ACTIVEFIELD` The key to the active-until field of confirmed proposals.
`static String`	`KEY_ACTIVEKEY`
`static String`	`KEY_AFFILFIELD` The key to the object name in the database.
`static String`	`KEY_COLORFIELD` The key to the object name in the database.
`static String`	`KEY_CONFIRMEDHOST`
`static String`	`KEY_CONFIRMEDPATH`
`static String`	`KEY_CONFIRMEDTABLE` The table of confirmed proposals.
`static String`	`KEY_DESCRIPTIONFIELD` The key to the object name in the database.
`static String`	`KEY_DISCOVERTIMEOUT`
`static String`	`KEY_EMAILFIELD` The key to the field name for acknowledged boolean.
`static String`	`KEY_FORKTABLE` The key to the name of the fork table.
`static String`	`KEY_HASHFIELD` The key to the object name in the database.
`static String`	`KEY_IMMEDIATE` Targets containing these strings are selected for immediate transfer.
`static String`	`KEY_LOCALTABLE` The key to the field name for acknowledged boolean.
`static String`	`KEY_NAG` The default nagging period (resend e-mail if scknowledge is older).
`static String`	`KEY_NAMEFIELD` The key to the field name for acknowledged boolean.
`static String`	`KEY_NOTIFYFIELD` The key to the object name in the database.
`static String`	`KEY_PASSWDFIELD` The key to the object name in the database.
`static String`	`KEY_PATHFIELD` The key to the field name for acknowledged boolean.
`static String`	`KEY_PENDINGTABLE` The key to the field name for acknowledged boolean.
`static String`	`KEY_PIKEY`
`static String`	`KEY_PROPIDFIELD` The key to the object name in the database.
`static String`	`KEY_PROPIDKEY`
`static String`	`KEY_PUBKEYFIELD` The key to the object name in the database.
`static String`	`KEY_SCP`
`static String`	`KEY_SSH`
`static String`	`KEY_SUPPLIEDTABLE` The key to the field name for acknowledged boolean.
`static String`	`KEY_TEMPLATEFIELD` The key to the object name in the database.
`static String`	`KEY_TENERIFETIMEOUT`
`static String`	`KEY_TITLEKEY`
`static String`	`KEY_TMPDIR`
`static String`	`KEY_URLHOST`
`static String`	`KEY_URLPROTOCOL`
`static String`	`KEY_WHERE`
`static String`	`KEY_WHEREEXE`
`static String`	`KEY_WHEREPATH`
`static String`	`KEY_WHO`

Fields inherited from class mysql.AbstractSql
KEY_TABLE, SQLBATCHDIR, SQLFAILDIR

Fields inherited from class util.PropertyResources
KEY_NOINITONCREATE, POSTFIX_ALPHABET, POSTFIX_BYTES, POSTFIX_DIR, POSTFIX_EXT, POSTFIX_FILE, POSTFIX_LIST, POSTFIX_MODTIME, POSTFIX_URL

Fields inherited from class util.PropertyContainer
KEY_LISTSEPARATOR, KEY_MAPKEYVALUECHAR, KEY_MAPSEPARATOR

Fields inherited from interface util.ResourceSupplying
KEY_URLRESOURCES, KEY_URLUSECONFIG, KEY_URLUSECURRENT, KEY_URLUSEHOME

Fields inherited from interface util.PropertySupplying
CONFIG, KEY_CLASS

Constructor Summary

Constructors
Constructor and Description

ManagerSql(Map<String,String> prop)

Constructors
Constructor and Description
`ManagerSql(Map<String,String> prop)`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`boolean`	`acknowledgeAll(String table)`
`private boolean`	`addFork(String propid, String template, String description)` Adds a fork, i.e.
`private boolean`	`deleteDownloadedTemplate(String name)`
`private boolean`	`deleteDownloadedTemplate(String name, File local)`
`private boolean`	`download(String match)` Downloads all proposal-templates found on stella.aip.de using ssh/scp.
`private boolean`	`download(String host, String path, String match, File local)` Downloads all proposal-templates found on stella.aip.de using ssh/scp.
`private List<String>`	`getAllConfirmedProposalIds()`
`private List<String>`	`getAllProposalIds()`
`Map<String,String>`	`getConfirmedTargetTemplate(String toprop)`
`private static Map<String,String>`	`getDefaultProperties()`
`List<Object>`	`getLocalUsers(long nag)`
`List<Object>`	`getPasswordReset(long nag)`
`List<Object>`	`getSuppliedTargets(long nag)`
`private List<Object>`	`getUnAcknowledged(String table, String unique, long nag)` Checks a table for none-acknowledged entries.
`static void`	`main(String[] arg)`
`private List<Object>`	`pushImmediately(Map<Object,String> immediate)` Takes the list of targets, copies them to the local tmp and further to the appropriate Tenerife machine, where it is immediately added to the running master.
`private Map<Object,String>`	`requestImmediateUpload(List<Object> targets)`
`private Collection<Map<String,String>>`	`retainNewConfirmed(Collection<Map<String,String>> scan)` Retains only the new resource files that have no entry in the confirmed table.
`private Collection<Map<String,String>>`	`retainNewProposals(Collection<Map<String,String>> scan)` Retains only the new resource files that have no entries in the proposal table.
`private Map<String,Map<String,String>>`	`scanDonwloadedTemplates(String ma)` Scans the local dir for downloaded templates.
`private Map<String,Map<String,String>>`	`scanDonwloadedTemplates(String match, File local)` Scans the local dir for downloaded templates.
`boolean`	`sendOperatorEmail(long nag)`
`private boolean`	`updateConfirmed(Map<String,String> template, String name)`
`private boolean`	`updateConfirmed(Map<String,String> template, String path, String name)`
`private boolean`	`updateProposals(Map<String,String> template)`

Methods inherited from class mysql.AbstractSql
delete, distinct, distinct, exit, getAccess, getDefaultArchive, getDefaultFormat, getTable, init, insert, isEntry, release, release, replace, retrieve, retrieve, retrieve, single, single

Methods inherited from class util.PropertyResources
clone, createFrom, createFrom, createFrom, createInstance, getApplet, getAsResources, getLocate, getPropertiesToKey, getPropertiesToKey, getResource, getResourceAsStream, getResourceFromKey, getResources, hasLocalURLs, initProperties, keyCreate, keyCreate, reload, setApplet

Methods inherited from class util.PropertyContainer
augment, augment, augment, augment, augment, defaultBoolean, defaultChar, defaultDouble, defaultFloat, defaultInt, defaultLong, defaultObject, defaultObject, defaultProperties, defaultProperty, getAsBoolean, getAsChar, getAsDouble, getAsEnums, getAsFloat, getAsInt, getAsList, getAsLong, getAsMap, getAsMap, getAsObject, getAsObject, getProperties, getProperty, has, isNew, parseObject, parseObject, reload, removeProperty, requires, rescanned, setObject, setProperties, setProperty, stringProperties, toString

Methods inherited from class java.lang.Object
equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface util.PropertySupplying
defaultBoolean, defaultChar, defaultDouble, defaultFloat, defaultInt, defaultLong, defaultObject, defaultObject, defaultProperties, defaultProperty, getAsBoolean, getAsChar, getAsDouble, getAsFloat, getAsInt, getAsList, getAsLong, getAsMap, getAsObject, getAsObject, getProperties, getProperty, has, parseObject, removeProperty, setObject, setProperty, stringProperties

Field Detail
- KEY_ACKFIELD
```
public static final String KEY_ACKFIELD
```
  The key to the field name for acknowledged boolean.
  
  See Also:
  
  Constant Field Values
- KEY_AFFILFIELD
```
public static final String KEY_AFFILFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- KEY_NAMEFIELD
```
public static final String KEY_NAMEFIELD
```
  The key to the field name for acknowledged boolean.
  
  See Also:
  
  Constant Field Values
- KEY_EMAILFIELD
```
public static final String KEY_EMAILFIELD
```
  The key to the field name for acknowledged boolean.
  
  See Also:
  
  Constant Field Values
- KEY_COLORFIELD
```
public static final String KEY_COLORFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- KEY_NOTIFYFIELD
```
public static final String KEY_NOTIFYFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- KEY_HASHFIELD
```
public static final String KEY_HASHFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- KEY_PASSWDFIELD
```
public static final String KEY_PASSWDFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- KEY_PUBKEYFIELD
```
public static final String KEY_PUBKEYFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- KEY_PATHFIELD
```
public static final String KEY_PATHFIELD
```
  The key to the field name for acknowledged boolean.
  
  See Also:
  
  Constant Field Values
- KEY_LOCALTABLE
```
public static final String KEY_LOCALTABLE
```
  The key to the field name for acknowledged boolean.
  
  See Also:
  
  Constant Field Values
- KEY_PENDINGTABLE
```
public static final String KEY_PENDINGTABLE
```
  The key to the field name for acknowledged boolean.
  
  See Also:
  
  Constant Field Values
- KEY_SUPPLIEDTABLE
```
public static final String KEY_SUPPLIEDTABLE
```
  The key to the field name for acknowledged boolean.
  
  See Also:
  
  Constant Field Values
- KEY_CONFIRMEDTABLE
```
public static final String KEY_CONFIRMEDTABLE
```
  The table of confirmed proposals.
  
  See Also:
  
  Constant Field Values
- KEY_FORKTABLE
```
public static final String KEY_FORKTABLE
```
  The key to the name of the fork table.
  
  See Also:
  
  Constant Field Values
- KEY_PROPIDFIELD
```
public static final String KEY_PROPIDFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- KEY_TEMPLATEFIELD
```
public static final String KEY_TEMPLATEFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- KEY_DESCRIPTIONFIELD
```
public static final String KEY_DESCRIPTIONFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- KEY_ACTIVEFIELD
```
public static final String KEY_ACTIVEFIELD
```
  The key to the active-until field of confirmed proposals.
  
  See Also:
  
  Constant Field Values
- KEY_NAG
```
public static final String KEY_NAG
```
  The default nagging period (resend e-mail if scknowledge is older).
  
  See Also:
  
  Constant Field Values
- KEY_PROPIDKEY
```
public static final String KEY_PROPIDKEY
```
  See Also:
  
  Constant Field Values
- KEY_CONFIRMEDPATH
```
public static final String KEY_CONFIRMEDPATH
```
  See Also:
  
  Constant Field Values
- KEY_CONFIRMEDHOST
```
public static final String KEY_CONFIRMEDHOST
```
  See Also:
  
  Constant Field Values
- KEY_URLHOST
```
public static final String KEY_URLHOST
```
  See Also:
  
  Constant Field Values
- KEY_SCP
```
public static final String KEY_SCP
```
  See Also:
  
  Constant Field Values
- KEY_SSH
```
public static final String KEY_SSH
```
  See Also:
  
  Constant Field Values
- KEY_WHO
```
public static final String KEY_WHO
```
  See Also:
  
  Constant Field Values
- KEY_WHERE
```
public static final String KEY_WHERE
```
  See Also:
  
  Constant Field Values
- KEY_WHEREPATH
```
public static final String KEY_WHEREPATH
```
  See Also:
  
  Constant Field Values
- KEY_WHEREEXE
```
public static final String KEY_WHEREEXE
```
  See Also:
  
  Constant Field Values
- KEY_DISCOVERTIMEOUT
```
public static final String KEY_DISCOVERTIMEOUT
```
  See Also:
  
  Constant Field Values
- KEY_TENERIFETIMEOUT
```
public static final String KEY_TENERIFETIMEOUT
```
  See Also:
  
  Constant Field Values
- KEY_URLPROTOCOL
```
public static final String KEY_URLPROTOCOL
```
  See Also:
  
  Constant Field Values
- KEY_ACTIVEKEY
```
public static final String KEY_ACTIVEKEY
```
  See Also:
  
  Constant Field Values
- KEY_PIKEY
```
public static final String KEY_PIKEY
```
  See Also:
  
  Constant Field Values
- KEY_TITLEKEY
```
public static final String KEY_TITLEKEY
```
  See Also:
  
  Constant Field Values
- KEY_ABSTRACTKEY
```
public static final String KEY_ABSTRACTKEY
```
  See Also:
  
  Constant Field Values
- KEY_TMPDIR
```
public static final String KEY_TMPDIR
```
  See Also:
  
  Constant Field Values
- KEY_IMMEDIATE
```
public static final String KEY_IMMEDIATE
```
  Targets containing these strings are selected for immediate transfer.
  
  See Also:
  
  Constant Field Values
- DEFACKFIELD
```
private static final String DEFACKFIELD
```
  The default acknowledged field.
  
  See Also:
  
  Constant Field Values
- DEFNAMEFIELD
```
private static final String DEFNAMEFIELD
```
  The default column name.
  
  See Also:
  
  Constant Field Values
- DEFAFFILFIELD
```
private static final String DEFAFFILFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- DEFEMAILFIELD
```
private static final String DEFEMAILFIELD
```
  The default column name.
  
  See Also:
  
  Constant Field Values
- DEFCOLORFIELD
```
private static final String DEFCOLORFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- DEFNOTIFYFIELD
```
private static final String DEFNOTIFYFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- DEFHASHFIELD
```
private static final String DEFHASHFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- DEFPASSWDFIELD
```
private static final String DEFPASSWDFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- DEFPUBKEYFIELD
```
private static final String DEFPUBKEYFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- DEFPATHFIELD
```
private static final String DEFPATHFIELD
```
  The default column name.
  
  See Also:
  
  Constant Field Values
- DEFLOCALTABLE
```
private static final String DEFLOCALTABLE
```
  The default table.
  
  See Also:
  
  Constant Field Values
- DEFPENDINGTABLE
```
private static final String DEFPENDINGTABLE
```
  The default table.
  
  See Also:
  
  Constant Field Values
- DEFSUPPLIEDTABLE
```
private static final String DEFSUPPLIEDTABLE
```
  The default table.
  
  See Also:
  
  Constant Field Values
- DEFCONFIRMEDTABLE
```
private static final String DEFCONFIRMEDTABLE
```
  The default table.
  
  See Also:
  
  Constant Field Values
- DEFFORKTABLE
```
private static final String DEFFORKTABLE
```
  The key to the name of the fork table.
  
  See Also:
  
  Constant Field Values
- DEFPROPIDFIELD
```
private static final String DEFPROPIDFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- DEFTEMPLATEFIELD
```
private static final String DEFTEMPLATEFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- DEFDESCRIPTIONFIELD
```
private static final String DEFDESCRIPTIONFIELD
```
  The key to the object name in the database.
  
  See Also:
  
  Constant Field Values
- DEFACTIVEFIELD
```
private static final String DEFACTIVEFIELD
```
  The default column name.
  
  See Also:
  
  Constant Field Values
- DEFPROPIDKEY
```
private static final String DEFPROPIDKEY
```
  See Also:
  
  Constant Field Values
- DEFCONFIRMEDPATH
```
private static final String DEFCONFIRMEDPATH
```
  See Also:
  
  Constant Field Values
- DEFCONFIRMEDHOST
```
private static final String DEFCONFIRMEDHOST
```
  See Also:
  
  Constant Field Values
- DEFURLHOST
```
private static final String DEFURLHOST
```
  See Also:
  
  Constant Field Values
- DEFSCP
```
private static final String DEFSCP
```
  See Also:
  
  Constant Field Values
- DEFSSH
```
private static final String DEFSSH
```
  See Also:
  
  Constant Field Values
- DEFWHO
```
private static final String DEFWHO
```
  See Also:
  
  Constant Field Values
- DEFWHERE
```
private static final String DEFWHERE
```
  See Also:
  
  Constant Field Values
- DEFWHEREPATH
```
private static final String DEFWHEREPATH
```
  See Also:
  
  Constant Field Values
- DEFWHEREEXE
```
private static final String DEFWHEREEXE
```
  See Also:
  
  Constant Field Values
- DEFDISCOVERTIMEOUT
```
private static final long DEFDISCOVERTIMEOUT
```
  See Also:
  
  Constant Field Values
- DEFTENERIFETIMEOUT
```
private static final long DEFTENERIFETIMEOUT
```
  See Also:
  
  Constant Field Values
- DEFURLPROTOCOL
```
private static final String DEFURLPROTOCOL
```
  See Also:
  
  Constant Field Values
- DEFACTIVEKEY
```
private static final String DEFACTIVEKEY
```
  See Also:
  
  Constant Field Values
- DEFPIKEY
```
private static final String DEFPIKEY
```
  See Also:
  
  Constant Field Values
- DEFTITLEKEY
```
private static final String DEFTITLEKEY
```
  See Also:
  
  Constant Field Values
- DEFABSTRACTKEY
```
private static final String DEFABSTRACTKEY
```
  See Also:
  
  Constant Field Values
- DEFTMPDIR
```
private static final String DEFTMPDIR
```
  See Also:
  
  Constant Field Values
- DEFNAG
```
private static final long DEFNAG
```
  Default no resend of e-mail.
  
  See Also:
  
  Constant Field Values

Constructor Detail

ManagerSql

public ManagerSql(Map<String,String> prop)

Parameters:: prop -

Method Detail

getUnAcknowledged

private List<Object> getUnAcknowledged(String table,
                                       String unique,
                                       long nag)
                                throws SQLException

Checks a table for none-acknowledged entries.

Throws:: SQLException

acknowledgeAll

public boolean acknowledgeAll(String table)
                       throws SQLException

Throws:: SQLException

getLocalUsers
```
public List<Object> getLocalUsers(long nag)
                           throws SQLException
```
Returns:

All users names waiting for transfer and not having acknowledgement.

Throws:

SQLException

getPasswordReset
```
public List<Object> getPasswordReset(long nag)
                              throws SQLException
```
Returns:

All users names waiting for transfer and not having acknowledgement.

Throws:

SQLException

getSuppliedTargets
```
public List<Object> getSuppliedTargets(long nag)
                                throws SQLException
```
Returns:

All users names waiting for transfer and not having acknowledgement.

Throws:

SQLException

sendOperatorEmail

public boolean sendOperatorEmail(long nag)

requestImmediateUpload

private Map<Object,String> requestImmediateUpload(List<Object> targets)

getAllConfirmedProposalIds

private List<String> getAllConfirmedProposalIds()
                                         throws SQLException

Throws:: SQLException

getAllProposalIds

private List<String> getAllProposalIds()
                                throws SQLException,
                                       InitException

Throws:: SQLException; InitException

getConfirmedTargetTemplate

public Map<String,String> getConfirmedTargetTemplate(String toprop)
                                              throws SQLException,
                                                     MalformedURLException

Throws:: SQLException; MalformedURLException

download
```
private boolean download(String match)
                  throws IOException,
                         TimeoutException
```
Downloads all proposal-templates found on stella.aip.de using ssh/scp. Files are copied into a local temp directory. This is the crude method though resource discovery might not be possible

Throws:

TimeoutException

IOException

pushImmediately
```
private List<Object> pushImmediately(Map<Object,String> immediate)
                              throws IOException,
                                     TimeoutException
```
Takes the list of targets, copies them to the local tmp and further to the appropriate Tenerife machine, where it is immediately added to the running master.

Parameters:

immediate -

Throws:

TimeoutException

IOException

download

private boolean download(String host,
                         String path,
                         String match,
                         File local)
                  throws IOException,
                         TimeoutException

Downloads all proposal-templates found on stella.aip.de using ssh/scp. Files are copied into a local temp directory. This is the crude method though resource discovery might not be possible

Throws:: TimeoutException; IOException

scanDonwloadedTemplates

private Map<String,Map<String,String>> scanDonwloadedTemplates(String ma)

Scans the local dir for downloaded templates.

scanDonwloadedTemplates

private Map<String,Map<String,String>> scanDonwloadedTemplates(String match,
                                                               File local)

Scans the local dir for downloaded templates.

deleteDownloadedTemplate

private boolean deleteDownloadedTemplate(String name)

deleteDownloadedTemplate

private boolean deleteDownloadedTemplate(String name,
                                         File local)

updateConfirmed

private boolean updateConfirmed(Map<String,String> template,
                                String name)
                         throws SQLException

Throws:: SQLException

updateConfirmed

private boolean updateConfirmed(Map<String,String> template,
                                String path,
                                String name)
                         throws SQLException

Throws:: SQLException

updateProposals

private boolean updateProposals(Map<String,String> template)

retainNewConfirmed

private Collection<Map<String,String>> retainNewConfirmed(Collection<Map<String,String>> scan)
                                                   throws SQLException

Retains only the new resource files that have no entry in the confirmed table.

Throws:: SQLException

retainNewProposals

private Collection<Map<String,String>> retainNewProposals(Collection<Map<String,String>> scan)
                                                   throws SQLException,
                                                          InitException

Retains only the new resource files that have no entries in the proposal table.

Throws:: SQLException; InitException

addFork

private boolean addFork(String propid,
                        String template,
                        String description)
                 throws SQLException

Adds a fork, i.e. a new proposal template to an existin propID.

Returns:
Throws:: SQLException

getDefaultProperties

private static Map<String,String> getDefaultProperties()

main
```
public static void main(String[] arg)
                 throws InitException
```
Parameters:

arg - Only if non-standard properties have to be used.

Throws:

InitException

Class ManagerSql

Nested Class Summary

Nested classes/interfaces inherited from class mysql.AbstractSql

Nested classes/interfaces inherited from class util.PropertyResources

Field Summary

Fields inherited from class mysql.AbstractSql

Fields inherited from class util.PropertyResources

Fields inherited from class util.PropertyContainer

Fields inherited from interface util.ResourceSupplying

Fields inherited from interface util.PropertySupplying

Constructor Summary

Method Summary

Methods inherited from class mysql.AbstractSql

Methods inherited from class util.PropertyResources

Methods inherited from class util.PropertyContainer

Methods inherited from class java.lang.Object

Methods inherited from interface util.PropertySupplying

Field Detail

KEY_ACKFIELD

KEY_AFFILFIELD

KEY_NAMEFIELD

KEY_EMAILFIELD

KEY_COLORFIELD

KEY_NOTIFYFIELD

KEY_HASHFIELD

KEY_PASSWDFIELD

KEY_PUBKEYFIELD

KEY_PATHFIELD

KEY_LOCALTABLE

KEY_PENDINGTABLE

KEY_SUPPLIEDTABLE

KEY_CONFIRMEDTABLE

KEY_FORKTABLE

KEY_PROPIDFIELD

KEY_TEMPLATEFIELD

KEY_DESCRIPTIONFIELD

KEY_ACTIVEFIELD

KEY_NAG

KEY_PROPIDKEY

KEY_CONFIRMEDPATH

KEY_CONFIRMEDHOST

KEY_URLHOST

KEY_SCP

KEY_SSH

KEY_WHO

KEY_WHERE

KEY_WHEREPATH

KEY_WHEREEXE

KEY_DISCOVERTIMEOUT

KEY_TENERIFETIMEOUT

KEY_URLPROTOCOL

KEY_ACTIVEKEY

KEY_PIKEY

KEY_TITLEKEY

KEY_ABSTRACTKEY

KEY_TMPDIR

KEY_IMMEDIATE

DEFACKFIELD

DEFNAMEFIELD

DEFAFFILFIELD

DEFEMAILFIELD

DEFCOLORFIELD

DEFNOTIFYFIELD

DEFHASHFIELD

DEFPASSWDFIELD

DEFPUBKEYFIELD

DEFPATHFIELD

DEFLOCALTABLE

DEFPENDINGTABLE

DEFSUPPLIEDTABLE

DEFCONFIRMEDTABLE

DEFFORKTABLE

DEFPROPIDFIELD

DEFTEMPLATEFIELD

DEFDESCRIPTIONFIELD

DEFACTIVEFIELD

DEFPROPIDKEY

DEFCONFIRMEDPATH

DEFCONFIRMEDHOST

DEFURLHOST