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.

Field Summary

Fields

Modifier and Type	Field	Description
private static String	__TABLE_NAME

Constructor Summary

Constructors

Modifier	Constructor	Description
private	EffectifsHelper()

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

Field Detail

__TABLE_NAME

private static final String __TABLE_NAME

See Also:

Constant Field Values

Constructor Detail

EffectifsHelper

private EffectifsHelper()

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