Sam: /* Sample */

2021-06-28T09:41:10Z

Sample

Sam: Created page with "This will associate a table name with a file type for more accurately identifying a database. This will add a record to the `[DatabaseTableName]..."`


2021-06-28T09:24:01Z
Created page with "This will associate a table name with a file type for more accurately identifying a database. This will add a record to the <code>[DatabaseTableName]..."
New page
This will associate a table name with a file type for more accurately [[Identifying Databases|identifying a database]].

This will add a record to the <code>[DatabaseTableName]</code> table.



=Syntax=

<source lang="C">

uint32_t truxton_add_database_id( uint64_t truxton_handle, uint64_t file_type_id, char const * table_and_column );

</source>



=Parameters=

==<code>truxton_handle</code>==

The handle created by the [[truxton_create]] call.



==<code>file_type_id</code>==

The type of file to associate with this table name.

This corresponds to the <code>[FileTypeID]</code> column of the <code>[DatabaseTableName]</code> table.



==<code>table_and_column</code>==

The name of the table and column to associate with the file type.

This corresponds to the <code>[Name]</code> column of the <code>[DatabaseTableName]</code> table.



=Remarks=

The <code>table_and_column</code> parameter string should be in the format of "table.column"

Specifying both table and column is the recommended method for identifying a file type.



When adding a mapping, it is better to choose table column pairs that aren't likely to appear in another file type.

For example, "user.id" is likely to appear in several different types of databases and therefore, not a good pair to associate with any file type.



=Sample=

<source lang="C" highlight="3-8">

void truxton_add_database_id( uint64_t truxton_handle )

{

   truxton_add_database_id( truxton, Type_010_Help_Viewer, "ContentsTable.NamespaceId" );

   truxton_add_database_id( truxton, Type_010_Help_Viewer, "FileAttributeSetTable.FilterAttributeSetId" );

   truxton_add_database_id( truxton, Type_010_Help_Viewer, "FolderTable.NamespaceId" );

   truxton_add_database_id( truxton, Type_010_Help_Viewer, "IndexTable.Anchor" );

   truxton_add_database_id( truxton, Type_010_Help_Viewer, "OptimizedFilterTable.FilterAttributeId" );

   truxton_add_database_id( truxton, Type_010_Help_Viewer, "TimeStampTable.NamespaceId" );

}

</source>

Truxton add database id - Revision history

Sam: /* Sample */

Sam: Created page with "This will associate a table name with a file type for more accurately identifying a database. This will add a record to the [DatabaseTableName]..."

Sam: Created page with "This will associate a table name with a file type for more accurately identifying a database. This will add a record to the `[DatabaseTableName]..."`