java.lang.Object
- nzilbb.labbcat.server.db.TestOneQuerySearch

public class TestOneQuerySearch
extends Object

Constructor Summary

Constructors
Constructor Description

TestOneQuerySearch()

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`void`	`alignedSegmentSearch()`	Ensure segment search with alignment confidence threshold generates the correct SQL, including checking segment confidences.
`void`	`alignedWords()`	Ensure searching aligned words only generates the correct SQL.
`void`	`anchorStart()`	Ensure searches with word-start anchoring generate the correct SQL.
`nzilbb.ag.Schema`	`getSchema()`	Return a plausible schema, including SQL attributes.
`static void`	`main(String[] args)`
`void`	`mainParticipant()`	Ensure searching main participant utterances only generates the correct SQL.
`void`	`multiColumnAnchorEnd()`	Ensure multi-column searches with word-end anchoring generate the correct SQL.
`void`	`multiColumnSearch()`	Ensure a multi-column search generates the correct SQL.
`void`	`multiWordLayerSearch()`	Ensure a one-column search with multiple word layers generates the correct SQL.
`void`	`numericSearches()`	Ensure searches with min and max generate the correct SQL.
`void`	`oneColumnAnchorEnd()`	Ensure one-column searches with word-end anchoring generate the correct SQL.
`void`	`oneWordLayerSearch()`	Ensure a simple word search on a word layer that's not "word" generates the correct SQL.
`void`	`oneWordSearch()`	Ensure the simplest search structure generates the correct SQL.
`void`	`optimisedOrthographySearch()`	Ensure an orthography-only searches produce optimised SQL.
`void`	`optimisedSpanSearch()`	Ensure one-target-span-only searches produce optimised SQL.
`void`	`restrictByUser()`	Ensure setting restrictByUser generates SQL that filters out disallowed utterances.
`void`	`segmentAnchoring()`	Ensure segment anchoring to word boundaries generates the correct SQL.
`void`	`segmentContextSearch()`	Ensure intra-word segment context searches generate the correct SQL.
`void`	`segmentSearch()`	Ensure one-column segment searches (with and without word matching) generate the correct SQL.
`void`	`spanMatching()`	Ensure searches with word-start anchoring generate the correct SQL.
`void`	`subWordOrdering()`	Ensure targeting aligned word layers generates the correct ORDER BY.
`void`	`transcriptParticipantQueries()`	Ensure transcript and participant queries are handled.

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - TestOneQuerySearch
```
public TestOneQuerySearch()
```
- Method Detail
  - oneWordSearch
```
public void oneWordSearch()
                   throws Exception
```
    Ensure the simplest search structure generates the correct SQL.
    
    Throws:
    
    Exception
  - oneWordLayerSearch
```
public void oneWordLayerSearch()
                        throws Exception
```
    Ensure a simple word search on a word layer that's not "word" generates the correct SQL.
    
    Throws:
    
    Exception
  - transcriptParticipantQueries
```
public void transcriptParticipantQueries()
                                  throws Exception
```
    Ensure transcript and participant queries are handled.
    
    Throws:
    
    Exception
  - restrictByUser
```
public void restrictByUser()
                    throws Exception
```
    Ensure setting restrictByUser generates SQL that filters out disallowed utterances.
    
    Throws:
    
    Exception
  - optimisedOrthographySearch
```
public void optimisedOrthographySearch()
                                throws Exception
```
    Ensure an orthography-only searches produce optimised SQL.
    
    Throws:
    
    Exception
  - optimisedSpanSearch
```
public void optimisedSpanSearch()
                         throws Exception
```
    Ensure one-target-span-only searches produce optimised SQL.
    
    Throws:
    
    Exception
  - mainParticipant
```
public void mainParticipant()
                     throws Exception
```
    Ensure searching main participant utterances only generates the correct SQL.
    
    Throws:
    
    Exception
  - alignedWords
```
public void alignedWords()
                  throws Exception
```
    Ensure searching aligned words only generates the correct SQL.
    
    Throws:
    
    Exception
  - subWordOrdering
```
public void subWordOrdering()
                     throws Exception
```
    Ensure targeting aligned word layers generates the correct ORDER BY.
    
    Throws:
    
    Exception
  - multiWordLayerSearch
```
public void multiWordLayerSearch()
                          throws Exception
```
    Ensure a one-column search with multiple word layers generates the correct SQL.
    
    Throws:
    
    Exception
  - multiColumnSearch
```
public void multiColumnSearch()
                       throws Exception
```
    Ensure a multi-column search generates the correct SQL.
    
    Throws:
    
    Exception
  - numericSearches
```
public void numericSearches()
                     throws Exception
```
    Ensure searches with min and max generate the correct SQL.
    
    Throws:
    
    Exception
  - spanMatching
```
public void spanMatching()
                  throws Exception
```
    Ensure searches with word-start anchoring generate the correct SQL.
    
    Throws:
    
    Exception
  - anchorStart
```
public void anchorStart()
                 throws Exception
```
    Ensure searches with word-start anchoring generate the correct SQL.
    
    Throws:
    
    Exception
  - oneColumnAnchorEnd
```
public void oneColumnAnchorEnd()
                        throws Exception
```
    Ensure one-column searches with word-end anchoring generate the correct SQL.
    
    Throws:
    
    Exception
  - multiColumnAnchorEnd
```
public void multiColumnAnchorEnd()
                          throws Exception
```
    Ensure multi-column searches with word-end anchoring generate the correct SQL.
    
    Throws:
    
    Exception
  - segmentSearch
```
public void segmentSearch()
                   throws Exception
```
    Ensure one-column segment searches (with and without word matching) generate the correct SQL.
    
    Throws:
    
    Exception
  - alignedSegmentSearch
```
public void alignedSegmentSearch()
                          throws Exception
```
    Ensure segment search with alignment confidence threshold generates the correct SQL, including checking segment confidences.
    
    Throws:
    
    Exception
  - segmentContextSearch
```
public void segmentContextSearch()
                          throws Exception
```
    Ensure intra-word segment context searches generate the correct SQL.
    
    Throws:
    
    Exception
  - segmentAnchoring
```
public void segmentAnchoring()
                      throws Exception
```
    Ensure segment anchoring to word boundaries generates the correct SQL.
    
    Throws:
    
    Exception
  - getSchema
```
public nzilbb.ag.Schema getSchema()
```
    Return a plausible schema, including SQL attributes.
    
    Returns:
    
    A test schema.
  - main
```
public static void main(String[] args)
```

Class TestOneQuerySearch

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

TestOneQuerySearch

Method Detail

oneWordSearch

oneWordLayerSearch

transcriptParticipantQueries

restrictByUser

optimisedOrthographySearch

optimisedSpanSearch

mainParticipant

alignedWords

subWordOrdering

multiWordLayerSearch

multiColumnSearch

numericSearches

spanMatching

anchorStart

oneColumnAnchorEnd

multiColumnAnchorEnd

segmentSearch

alignedSegmentSearch

segmentContextSearch

segmentAnchoring

getSchema

main