Package nzilbb.labbcat.server.db

Class TestAnnotationAgqlToSql

java.lang.Object

nzilbb.labbcat.server.db.TestAnnotationAgqlToSql

public class TestAnnotationAgqlToSql
extends Object

Constructor Summary

Constructors

Constructor	Description
TestAnnotationAgqlToSql()

Method Summary

Modifier and Type	Method	Description
void	anchorConfidence()
void	annotationLabels()
void	annotators()
void	attributeLabel()
void	cascadingLanguageMatch()	Test SQL generated by matching phrase language, falling back to transcript language
void	confidence()
void	emptyExpression()
void	episodeLabel()
nzilbb.ag.Schema	getSchema()	Return a plausible schema, including SQL attributes.
void	graphAnnotationsByLayer()
void	graphId()
void	idMatch()
void	inAll()
void	invalidLayers()
void	labels()
void	languageLabel()
void	listLength()
static void	main(String[] args)
void	mainParticipantLabelMatch()	Ensure `/.../test(first('main_participant').label)` generates the correct SQL.
void	parentId()
void	participantLayerId()	Ensure that identifying by a participant attribute layer ID works
void	sqlInjection()	SQL injection tests
void	startOffset()
void	temporalLayerId()	Ensure that identifying by a temporal layer works
void	transcriptAttributeLayerId()	Ensure that identifying by a transcript attribute layer ID works
void	transcriptTypeLabel()
void	userWhereClause()
void	whoLabels()

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

TestAnnotationAgqlToSql

public TestAnnotationAgqlToSql()

Method Detail

getSchema

public nzilbb.ag.Schema getSchema()

Return a plausible schema, including SQL attributes.

Returns:

A test schema.

idMatch

public void idMatch()
             throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

temporalLayerId

public void temporalLayerId()
                     throws nzilbb.ag.ql.AGQLException

Ensure that identifying by a temporal layer works

Throws:

nzilbb.ag.ql.AGQLException

participantLayerId

public void participantLayerId()
                        throws nzilbb.ag.ql.AGQLException

Ensure that identifying by a participant attribute layer ID works

Throws:

nzilbb.ag.ql.AGQLException

transcriptAttributeLayerId

public void transcriptAttributeLayerId()
                                throws nzilbb.ag.ql.AGQLException

Ensure that identifying by a transcript attribute layer ID works

Throws:

nzilbb.ag.ql.AGQLException

parentId

public void parentId()
              throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

emptyExpression

public void emptyExpression()
                     throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

inAll

public void inAll()
           throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

annotationLabels

public void annotationLabels()
                      throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

whoLabels

public void whoLabels()
               throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

mainParticipantLabelMatch

public void mainParticipantLabelMatch()
                               throws nzilbb.ag.ql.AGQLException

Ensure `/.../test(first('main_participant').label)` generates the correct SQL.

Throws:

nzilbb.ag.ql.AGQLException

episodeLabel

public void episodeLabel()
                  throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

transcriptTypeLabel

public void transcriptTypeLabel()
                         throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

startOffset

public void startOffset()
                 throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

graphId

public void graphId()
             throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

sqlInjection

public void sqlInjection()
                  throws nzilbb.ag.ql.AGQLException

SQL injection tests

Throws:

nzilbb.ag.ql.AGQLException

graphAnnotationsByLayer

public void graphAnnotationsByLayer()
                             throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

labels

public void labels()
            throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

attributeLabel

public void attributeLabel()
                    throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

languageLabel

public void languageLabel()
                   throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

cascadingLanguageMatch

public void cascadingLanguageMatch()
                            throws nzilbb.ag.ql.AGQLException

Test SQL generated by matching phrase language, falling back to transcript language

Throws:

nzilbb.ag.ql.AGQLException

listLength

public void listLength()
                throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

annotators

public void annotators()
                throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

invalidLayers

public void invalidLayers()
                   throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

userWhereClause

public void userWhereClause()
                     throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

confidence

public void confidence()
                throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

anchorConfidence

public void anchorConfidence()
                      throws nzilbb.ag.ql.AGQLException

Throws:

nzilbb.ag.ql.AGQLException

main

public static void main(String[] args)