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.

Field Summary

Fields

Modifier and Type	Field	Description
private static String	__TABLE_NAME

Constructor Summary

Constructors

Modifier	Constructor	Description
private	ElementPedagogiqueHelper()

Method Summary

Modifier and Type	Method	Description
private static ParameterizableQuery	_insertInto(String code, String label, Long oseCatalog, String orgUnit, String stepHolder, String periodType)
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

Field Detail

__TABLE_NAME

private static final String __TABLE_NAME

See Also:

Constant Field Values

Constructor Detail

ElementPedagogiqueHelper

private ElementPedagogiqueHelper()

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 label,
                                                Long oseCatalog,
                                                String orgUnit,
                                                String stepHolder,
                                                String periodType)

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