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.

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

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 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