<< DbFuzzyDelete SciDb DbFuzzyHasFMB >>

SciDb >> SciDb > DbFuzzyGet

DbFuzzyGet

get fuzzy object from local FMB

Calling Sequence

fuzzyObjectStruct = DbFuzzyGet(fuzzySQL, objectType, objectIntId)
fuzzyObjectStruct = DbFuzzyGet(fuzzySQL, objectType, objectStringId)
fuzzyObjectStruct = DbFuzzyGet(fuzzySQL, objectType, objectIntId, ObjectStringId)
fuzzyObjectStruct = DbFuzzyGet(fuzzySQL, objectType, objectIntId, ObjectIntId)

Parameters

fuzzySQL

FuzzySQL pointer object, returned by either DbFuzzyLoadFMB() or DbFuzzyCreateFMB() functions

objectIntId

Each object is retrieved from collection by it's identifier. These identifiers may be either integer id's or objects names (not for all objects). For example, FuzzyTableInfo object can be returned by table id or by table name, FuzzyCol object can be retrieved by column id or by full column name (including table name). Some object require 2 identifiers: FuzzyNearnessDef - needs 2 column ids, FuzzyTableQuantifier - needs table id and quantifier name.

ObjectStringId

A strign fuzzy object identifer.

fuzzyObjectStruct

a struct, representing a fuzzy object with all same fields, which are stored in the database

Description

DbConnect(...) Retrieves a fuzzy object of certain type from local copy of FMB. To use Fuzzy fucntions you first need to create a FuzzySQL pointer object. This may be done by two functions: FuzzyCreateFMB() - if you wish to create fuzzy meta base on a database, where it is not yet present. Or FuzzyLoadFMB() - if you would like to load a FMB from database from it's local copy.

Examples

// Opens a “PostgreSQL” connection with a structure
connexionStruct          = struct();
connexionStruct.provider = "postgresql";
connexionStruct.database = "myDataBase";
connexionStruct.hostname = "127.0.0.1" ;
connexionStruct.use      = "myUsername";
connexionStruct.password = "myPassword";

DbConnect(connexionStruct);

//creating FuzzySQL object on default connection;
fuzzySQL = DbFuzzyLoadFMB();

//Getting a fuzzy column object (FCL) with 'columnId'=2
fuzCol = DbFuzzyGet(fuzzySQL, 'FCL', 2);

See Also

Authors


Report an issue
<< DbFuzzyDelete SciDb DbFuzzyHasFMB >>