get fuzzy object from local FMB
fuzzyObjectStruct = DbFuzzyGet(fuzzySQL, objectType, objectIntId) fuzzyObjectStruct = DbFuzzyGet(fuzzySQL, objectType, objectStringId) fuzzyObjectStruct = DbFuzzyGet(fuzzySQL, objectType, objectIntId, ObjectStringId) fuzzyObjectStruct = DbFuzzyGet(fuzzySQL, objectType, objectIntId, ObjectIntId)
FuzzySQL pointer object, returned by either DbFuzzyLoadFMB() or DbFuzzyCreateFMB() functions
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.
A strign fuzzy object identifer.
a struct, representing a fuzzy object with all same fields, which are stored in the database
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.
// 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); | ![]() | ![]() |