sexta-feira, 29 de janeiro de 2010

Finding tables which have fields of a given type

Today i wrote some code to find tables which have fields of a given type.


static void Job9(Args _args)
{
ProjectNode myProject;
TreeNode currentNode;

StackBase nodesToBeExported = new StackBase(Types::Class);
TreeNodeIterator treeNodeIterator;
DictTable dictTable;
DictField dictField;
int i;

void addChilds(StackBase _stackBase, TreeNode _parentTreeNode)
{
TreeNode childNode;
TreeNodeIterator treeNodeIteratorChild = _parentTreeNode.AOTiterator();

for (childNode = treeNodeIteratorChild.next() ; childNode ; childNode = treeNodeIteratorChild.next())
{
_stackBase.push(childNode);
}
}
;

myProject = new Info().getNode(UtilElementType::SharedProject, "MyProject");
myProject = myProject.getRunNode();

addChilds(nodesToBeExported, myProject);
for (currentNode = nodesToBeExported.pop() ; currentNode; currentNode = nodesToBeExported.pop())
{
switch (currentNode.applObjectType())
{
case 0: // Group
addChilds(nodesToBeExported, currentNode);
break;
case UtilElementType::Table:
dictTable = new DictTable(currentNode.applObjectId());
for (i = 0 ; i < dictTable.fieldCnt() ; i++)
{
dictField = new dictField(dictTable.id(), dictTable.fieldCnt2Id(i));
if (dictField.typeId() == extendedtypenum(MyDataType))
{
info(dictTable.name() + " - " + dictField.name());
}
}

break;
}
}
}