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.

Method Summary

Modifier and Type	Method	Description
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

Method Details

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

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