Package org.ametys.odf.ose.export.impl.odf.db

Class EtapeHelper

java.lang.Object

org.ametys.odf.ose.export.impl.odf.db.EtapeHelper

public final class EtapeHelper
extends Object

Helper to build queries to manage the ETAPE table.

Field Summary

Fields

Modifier and Type	Field	Description
private static String	__TABLE_NAME

Constructor Summary

Constructors

Modifier	Constructor	Description
private	EtapeHelper()

Method Summary

Modifier and Type	Method	Description
private static ParameterizableQuery	_insertInto(String code, String title, Long oseCatalog, String degree, String orgUnit, String functionalDomain)
static ParameterizableQuery	deleteFrom()	Query to delete all lines from the table.
static List<ParameterizableQuery>	initialize()	Queries to create the table and associated view.
static List<ParameterizableQuery>	insertInto(String code, String label, Long oseCatalog, String degree, String orgUnit, String functionalDomain)	Queries to insert a line in the table and in NOEUD and SCENARIO_NOEUD.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

__TABLE_NAME

private static final String __TABLE_NAME

See Also:

Constant Field Values

Constructor Detail

EtapeHelper

private EtapeHelper()

Method Detail

initialize

public static List<ParameterizableQuery> initialize()

Queries to create the table and associated view.

Returns:

List of queries for table and view creation

deleteFrom

public static ParameterizableQuery deleteFrom()

Query to delete all lines from the table.

Returns:

The query for deletion

_insertInto

private static ParameterizableQuery _insertInto(String code,
                                                String title,
                                                Long oseCatalog,
                                                String degree,
                                                String orgUnit,
                                                String functionalDomain)

insertInto

public static List<ParameterizableQuery> insertInto(String code,
                                                    String label,
                                                    Long oseCatalog,
                                                    String degree,
                                                    String orgUnit,
                                                    String functionalDomain)

Queries to insert a line in the table and in NOEUD and SCENARIO_NOEUD.

Parameters:

code - The step code

label - The label

oseCatalog - The OSE catalog

degree - The degree

orgUnit - The orgunit

functionalDomain - The functionnal domain

Returns:

The list of queries to insert values in the tables