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

Class EffectifsHelper

java.lang.Object

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

public final class EffectifsHelper
extends Object

Helper to build queries to manage the EFFECTIFS 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(String coursePartCode, Long numberOfStudents, Long oseCatalog, String courseLink)	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(String coursePartCode,
 Long numberOfStudents,
 Long oseCatalog,
 String courseLink)

Query to insert a line in the table.

Parameters:

coursePartCode - The course part code

numberOfStudents - The number of students

oseCatalog - The OSE catalog

courseLink - The course link

Returns:

The query to insert values in the table