Package ca.spatial.table

Class FoxProDictionary

java.lang.Object

ca.spatial.table.FoxProDictionary

public class FoxProDictionary
extends Object

This class will read the FoxPro data dicitonary and translate internal 'long names' into external 'short names'.

Constructor Summary

Constructors

Constructor	Description
FoxProDictionary(String database)

Method Summary

Modifier and Type	Method	Description
void	dump(String filename)	Dump out meta data describing the contents of a FoxPro database.
String	getColumnName(String tableName, String columnName)	Retrieve the short column name for the specified column.
String	getFileName(String tableName)	Retrieve the OS file name for the specified table.
static void	main(String[] args)	Dump out meta data describing the contents of a FoxPro database.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

FoxProDictionary

public FoxProDictionary(String database)
                 throws IOException

Throws:

IOException

Method Details

getFileName

public String getFileName(String tableName)

Retrieve the OS file name for the specified table. Return as a qualifed name against the location of the database file.

getColumnName

public String getColumnName(String tableName,
 String columnName)

Retrieve the short column name for the specified column. It appears that the algorithm is 'truncate to 10 characters, and upper case'. In case of a collision, return the first 9 characters and append a sequential number starting at '2'. For example, 'abcdefghij_a' =>'ABCDEFGHIJ' 'abcdefghij_b' => 'ABCDEFGHI2' 'abcdefghij_c' => 'ABCDEFGHI3'

dump

public void dump(String filename)

Dump out meta data describing the contents of a FoxPro database.

Parameters:

filename - The name of the output html file.

main

public static void main(String[] args)

Dump out meta data describing the contents of a FoxPro database.