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

Class ElementPedagogiqueHelper

java.lang.Object

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

public final class ElementPedagogiqueHelper
extends Object

Helper to build queries to manage the ELEMENT_PEDAGOGIQUE 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 orgUnit, String stepHolder, String periodType)	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 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

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

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

Parameters:

code - The course code

label - The label

oseCatalog - The OSE catalog

orgUnit - The orgunit

stepHolder - The step holder

periodType - The type of period

Returns:

The list of queries to insert values in the tables