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

Class VolumeHoraireEnsHelper

java.lang.Object

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

public final class VolumeHoraireEnsHelper
extends Object

Helper to build queries to manage the VOLUME_HORAIRE_ENS table.

Field Summary

Fields

Modifier and Type	Field	Description
private static String	__TABLE_NAME

Constructor Summary

Constructors

Modifier	Constructor	Description
private	VolumeHoraireEnsHelper()

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 ParameterizableQuery	insertInto(CoursePart coursePart, String coursePartCode, String coursePartNature, Long oseCatalog, String courseLink, Double numberOfGroups)	Query to insert a line in the table.

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

VolumeHoraireEnsHelper

private VolumeHoraireEnsHelper()

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 ParameterizableQuery insertInto(CoursePart coursePart,
                                              String coursePartCode,
                                              String coursePartNature,
                                              Long oseCatalog,
                                              String courseLink,
                                              Double numberOfGroups)

Query to insert a line in the table.

Parameters:

coursePart - The course part

coursePartCode - The course part code

coursePartNature - The course part nature

oseCatalog - The OSE catalog

courseLink - the course link

numberOfGroups - The number of groups

Returns:

The query to insert values in the table