Modifier and Type | Constant Field | Value |
---|---|---|
public static final java.lang.String |
DATA_SOURCE |
"liferayDataSource" |
public static final java.lang.String |
ORDER_BY_JPQL |
" ORDER BY assignment.id.userId ASC" |
public static final java.lang.String |
ORDER_BY_SQL |
" ORDER BY QTI_Assignment.userId ASC" |
public static final java.lang.String |
SESSION_FACTORY |
"liferaySessionFactory" |
public static final java.lang.String |
TABLE_NAME |
"QTI_Assignment" |
public static final java.lang.String |
TABLE_SQL_CREATE |
"create table QTI_Assignment (userId LONG not null,uolId LONG not null,status INTEGER,uoltype INTEGER,title VARCHAR(75) null,username VARCHAR(75) null,primary key (userId, uolId))" |
public static final java.lang.String |
TABLE_SQL_DROP |
"drop table QTI_Assignment" |
public static final java.lang.String |
TX_MANAGER |
"liferayTransactionManager" |
Modifier and Type | Constant Field | Value |
---|---|---|
public static final java.lang.String |
DATA_SOURCE |
"liferayDataSource" |
public static final java.lang.String |
ORDER_BY_JPQL |
" ORDER BY testResult.id.userId ASC" |
public static final java.lang.String |
ORDER_BY_SQL |
" ORDER BY QTI_TestResult.userId ASC" |
public static final java.lang.String |
SESSION_FACTORY |
"liferaySessionFactory" |
public static final java.lang.String |
TABLE_NAME |
"QTI_TestResult" |
public static final java.lang.String |
TABLE_SQL_CREATE |
"create table QTI_TestResult (userId LONG not null,uolId LONG not null,result INTEGER,autoComment VARCHAR(75) null,teacherComment VARCHAR(75) null,title VARCHAR(75) null,username VARCHAR(75) null,primary key (userId, uolId))" |
public static final java.lang.String |
TABLE_SQL_DROP |
"drop table QTI_TestResult" |
public static final java.lang.String |
TX_MANAGER |
"liferayTransactionManager" |
Modifier and Type | Constant Field | Value |
---|---|---|
public static final java.lang.String |
DATA_SOURCE |
"liferayDataSource" |
public static final java.lang.String |
ORDER_BY_JPQL |
" ORDER BY uol.classRoomId ASC" |
public static final java.lang.String |
ORDER_BY_SQL |
" ORDER BY QTI_Uol.classRoomId ASC" |
public static final java.lang.String |
SESSION_FACTORY |
"liferaySessionFactory" |
public static final java.lang.String |
TABLE_NAME |
"QTI_Uol" |
public static final java.lang.String |
TABLE_SQL_CREATE |
"create table QTI_Uol (I_Id LONG not null primary key,classRoomId LONG,subjectId LONG,countryId LONG,companyId LONG,assessmentTestId LONG,createDate DATE null,requestedDate DATE null,description VARCHAR(75) null,active_ BOOLEAN,evalTypeId INTEGER,title VARCHAR(75) null)" |
public static final java.lang.String |
TABLE_SQL_DROP |
"drop table QTI_Uol" |
public static final java.lang.String |
TX_MANAGER |
"liferayTransactionManager" |