FluidDataSetQuery | SuperCollider 3.13.0 Help

Description

A selection of columns and a set of conditions that match rows of a FluidDataSet. Used to filter and search in a database of descriptors.

Read more about FluidDataSetQuery on the learn platform.

Class Methods

FluidDataSetQuery.new(server)

Arguments:

server

The Server on which to construct this object

Instance Methods

.transform(sourceDataSet, destDataSet, action)

Apply the query to a source FluidDataSet and write to a destination. Can be passed the same for input and output (in-place).

Arguments:

sourceDataSet	Source data, or the DataSet name
destDataSet	Destination data, or the DataSet name
action	A function to execute when the server has completed running transform

.transformJoin(source1DataSet, source2DataSet, destDataSet, action)

Apply the query to a source FluidDataSet and join the resulting subset at the end of the items sharing the same identifiers in a second source. Items unique to a source dataset will be ignored. To add items at the end of a dataset instead, see the 'merge' method of FluidDataSet.

Arguments:

source1DataSet	Source data, or the DataSet name
source2DataSet	Source data, or the DataSet name
destDataSet	Destination data, or the DataSet name
action	A function to execute when the server has completed running transformJoin

.addColumn(column, action)

Add a column to the query

Arguments:

column	Column index
action	A function to execute when the server has completed running addColumn

.addRange(start, count, action)

Add a range of columns to the query

Arguments:

start	First index
count	Number of columns
action	A function to execute when the server has completed running addRange

.filter(column, condition, value, action)

Filter rows according to some condition.

Arguments:

column	Column index
condition	Condition string. Possible values: "==", "!=", "<", "<=", ">", ">="
value	Condition value
action	A function to execute when the server has completed running filter

.and(column, condition, value, action)

Add a condition to an existing filter with an "and" connector.

Arguments:

column	Column index
condition	Condition string. Possible values: "==", "!=", "<", "<=", ">", ">="
value	Condition value
action	A function to execute when the server has completed running and

.or(column, condition, value, action)

Add a condition to an existing filter with an "or" connector.

Arguments:

column	Column index
condition	Condition string. Possible values: "==", "!=", "<", "<=", ">", ">="
value	Condition value
action	A function to execute when the server has completed running or

.clear(action)

Resets the internal state of the model

Arguments:

action

A function to execute when the server has completed running clear

.limit(rows, action)

Limit the number of resulting rows.

Arguments:

rows	Maximum number of rows
action	A function to execute when the server has completed running limit

Inherited instance methods

Undocumented instance methods

.addColumnMsg(column)

.addRangeMsg(start, count)

.andMsg(column, condition, value)

.clearMsg

.filterMsg(column, condition, value, action)

.limitMsg(rows)

.orMsg(column, condition, value)

.transformJoinMsg(source1DataSet, source2DataSet, destDataSet)

.transformMsg(sourceDataSet, destDataSet)

Examples

// Create a DataSet with known data

(
var dict = Dictionary.newFrom([
    "cols",5,
    "data",Dictionary.newFrom(
        100.collect{
            arg i;
            var point = 5.collect{
                arg j;
                j+(i/100);
            };
            [i,point];
        }.flatten
    )
]);

//the integer part of the value is the dimension, and the fractional part is the identifier.
~ds = FluidDataSet(s).load(dict).print;

~tmpbuf = Buffer.alloc(s,5);
)

// Prepare a FluidDataSetQuery object
(
~query = FluidDataSetQuery(s);
~out = FluidDataSet(s);

// prepare a simple query
// select points where the value in column 0 is less than 0.04
~query.filter(0,"<",0.04);
~query.addColumn(2); // the column we actually want copied into ~out is column 2
~query.transform(~ds, ~out);

// check the result
~out.print;
)

(
//prepare a more complex query
~query.clear;
~query.filter(0,">",0.03);
~query.and(1,"<",1.08);
~query.or(2,">",2.98);
~query.addRange(2,3); // addRange will add 3 columns starting at column index 2
~query.transform(~ds, ~out);

// Check the results
~out.print;
)

Joining Datasets// this is how to join 2 datasets, adding columns to items with the same identifier // create 2 datasets ( ~dsA = FluidDataSet(s); ~dsB = FluidDataSet(s); ) //feed them items with almost overlaping identifier lists but with different dimensions ( ~dsA.load( Dictionary.newFrom([ \cols, 2, \data, Dictionary.newFrom([ \zero, [0,0], \one,[1,11], \two,[2,22], \three,[3,33], \four,[4,44] ]) ]) ); ~dsB.load (Dictionary.newFrom([ \cols, 2, \data, Dictionary.newFrom([ \one,[111,1111], \two,[222,2222], \three,[333,3333], \four,[444,4444], \five,[555,5555] ]) ]) ); ~dsA.print; ~dsB.print; ) // no query/filter defined, copies all items with identifiers common to both, and all of the defined column of the first input ( ~ds_joined = FluidDataSet(s); ~joiner = FluidDataSetQuery(s); ~joiner.transformJoin(~dsA,~dsB,~ds_joined); ~ds_joined.print ) ( // all the conditions applicable to 'transform' can be done on the first dataset too. Selected columns of the first source are appended to matching items in the second source. ~joiner.clear; ~joiner.filter(0,">",2.1); ~joiner.and(1,"<", 40); ~joiner.addColumn(0); ~joiner.transformJoin(~dsA,~dsB,~ds_joined); ~ds_joined.print; )

Audio Analysis Data~src = Buffer.read(s,FluidFilesPath("Tremblay-ASWINE-ScratchySynth-M.wav")); // take a listen ~src.play; // make a dataset of pitch anlyses ( ~features = Buffer(s); FluidBufPitch.processBlocking(s,~src,features:~features); ~ds_pitch = FluidDataSet(s).fromBuffer(~features); ~ds_pitch.print; ) // select only the pitch analyses where the pitch confidence is > 0.9 ( ~ds_filtered = FluidDataSet(s); ~dsq = FluidDataSetQuery(s); ~dsq.filter(1,">",0.9); ~dsq.addColumn(0); ~dsq.transform(~ds_pitch,~ds_filtered); ~ds_filtered.print; ) // make another dataset of spectral analyses ( FluidBufSpectralShape.processBlocking(s,~src,features:~features); ~ds_spec = FluidDataSet(s).fromBuffer(~features); ~ds_spec.print; ) // select only the spectral analyses where the pitch confidence is > 0.9; ( ~ds_selected = FluidDataSet(s); ~dsq.clear; ~dsq.filter(1,">",0.9); ~dsq.transformJoin(~ds_pitch,~ds_spec,~ds_selected); ~ds_selected.print; ) // or just append it all together to make one big dataset ( ~dsq.clear; ~dsq.addRange(0,2); // starting at column 0 add two columns (both of the columns in ~ds_pitch) ~dsq.transformJoin(~ds_pitch,~ds_spec,~ds_selected); ~ds_selected.print; ) // or do it all at once: ( ~dsq.clear; ~dsq.filter(1,">",0.9); // only analyses where the pitch conf is high ~dsq.addColumn(0); // we'll take the pitch freq... ~dsq.transformJoin(~ds_pitch,~ds_spec,~ds_selected);// ... and append it to the spectral analyses ~ds_selected.print; )

helpfile source: /usr/share/SuperCollider/Extensions/FluidCorpusManipulation/HelpSource/Classes/FluidDataSetQuery.schelp
link::Classes/FluidDataSetQuery::

FluidDataSetQuery : FluidDataObject : FluidServerObject : Object
Extension

Description

Class Methods

FluidDataSetQuery.new(server)

Arguments:

Inherited class methods

Instance Methods

.transform(sourceDataSet, destDataSet, action)

Arguments:

.transformJoin(source1DataSet, source2DataSet, destDataSet, action)

Arguments:

.addColumn(column, action)

Arguments:

.addRange(start, count, action)

Arguments:

.filter(column, condition, value, action)

Arguments:

.and(column, condition, value, action)

Arguments:

.or(column, condition, value, action)

Arguments:

.clear(action)

Arguments:

.limit(rows, action)

Arguments:

Inherited instance methods

Undocumented instance methods

.addColumnMsg(column)

.addRangeMsg(start, count)

.andMsg(column, condition, value)

.clearMsg

.filterMsg(column, condition, value, action)

.limitMsg(rows)

.orMsg(column, condition, value)

.transformJoinMsg(source1DataSet, source2DataSet, destDataSet)

.transformMsg(sourceDataSet, destDataSet)

Examples

FluidDataSetQuery : FluidDataObject : FluidServerObject : Object Extension

Description

Class Methods

FluidDataSetQuery.new(server)

Arguments:

Inherited class methods

Instance Methods

.transform(sourceDataSet, destDataSet, action)

Arguments:

.transformJoin(source1DataSet, source2DataSet, destDataSet, action)

Arguments:

.addColumn(column, action)

Arguments:

.addRange(start, count, action)

Arguments:

.filter(column, condition, value, action)

Arguments:

.and(column, condition, value, action)

Arguments:

.or(column, condition, value, action)

Arguments:

.clear(action)

Arguments:

.limit(rows, action)

Arguments:

Inherited instance methods

Undocumented instance methods

.addColumnMsg(column)

.addRangeMsg(start, count)

.andMsg(column, condition, value)

.clearMsg

.filterMsg(column, condition, value, action)

.limitMsg(rows)

.orMsg(column, condition, value)

.transformJoinMsg(source1DataSet, source2DataSet, destDataSet)

.transformMsg(sourceDataSet, destDataSet)

Examples

FluidDataSetQuery : FluidDataObject : FluidServerObject : Object
Extension