Пример #1
0
string JoystickMapper::serializeMap()
{
    vector<string> value;
    
    for (JoystickMapperMap::iterator i = usageIdMap.begin();
         i != usageIdMap.end();
         i++)
    {
        JoystickMapperItem item;
        
        value.push_back(getItemLabel(i->first));
        value.push_back(getItemLabel(i->second.usageId));
        value.push_back(getString(i->second.sensitivity));
        value.push_back(getString(i->second.reverse));
    }
    
    return strjoin(value, ',');
}
Пример #2
0
static void lookupRetroAliLabels(struct track *tg)
/* This converts the retro ids to labels. */
{
struct sqlConnection *conn = hAllocConn(database);
char *retroInfoTbl = trackDbRequiredSetting(tg->tdb, retroInfoTblSetting);

struct linkedFeatures *lf;
unsigned labelSet = getLabelTypes(tg);

for (lf = tg->items; lf != NULL; lf = lf->next)
    getItemLabel(conn, retroInfoTbl, labelSet, lf);
hFreeConn(&conn);
}
static void lookupTransMapLabels(struct track *tg)
/* This converts the transMap ids to labels. */
{
struct sqlConnection *conn = hAllocConn(database);
char *transMapInfoTbl = trackDbRequiredSetting(tg->tdb, transMapInfoTblSetting);
char *transMapGeneTbl = trackDbSetting(tg->tdb, transMapGeneTblSetting);
struct sqlConnection *geneConn = NULL;
if (transMapGeneTbl != NULL)
    geneConn = hAllocConnDbTbl(transMapGeneTbl, &transMapGeneTbl, database);
    

struct linkedFeatures *lf;
unsigned labelSet = getLabelTypes(tg);

for (lf = tg->items; lf != NULL; lf = lf->next)
    getItemLabel(conn, transMapInfoTbl, geneConn, transMapGeneTbl, labelSet, lf);
hFreeConn(&geneConn);
hFreeConn(&conn);
}
Пример #4
0
void odkFormReader::extractFields(QDomNode child, QString tableName, TtableDef &parentTable, QString groupCode, QString xmlCode)
{
    QDomElement item;
    QDomNode node;
    QDomNode childNode;

    QString fieldCode;
    QString fieldName;
    QString fieldOutput;
    QString fieldType;
    QStringList ftypes;
    QStringList ftsizes;

    QString sameTable;
    QString grpCode;

    QString childName;
    QString mselptable;
    QString repeatXMLCode;
    QString fieldXMLCode;


    TtableDef table;
    TtableDef tempTable;
    int pos;

    tableIndex++;
    int tindex;
    tindex = tableIndex;

    bool fieldinmselt;

    TfieldDef fsurveyID;
    TfieldDef foriginID;



    if ((tableName.toLower() != parentTable.name.toLower()) || (parentTable.fields.count() == 0)) //We are not processing a group
    {
        //qDebug() << "Table: " + tableName.toLower() + " Parent: " + parentTable.name.toLower() + ". Fields: " + QString::number(parentTable.fields.count());

        if (tableName.toLower() == mTable.toLower())
        {
            table.name = tableName;
            table.desc = "Main survey Table - Change this description";
            table.xmlCode = xmlCode;
            table.parentTable = "NULL";

            /*fsurveyID.name = "surveyid";
            fsurveyID.desc = "Survey ID (UUID)";
            fsurveyID.type = "varchar";
            fsurveyID.size = 80;
            fsurveyID.decSize = 0;
            fsurveyID.section = "main";
            fsurveyID.rField = "";
            fsurveyID.rTable = "";
            fsurveyID.key = false;
            fsurveyID.xmlCode = "NONE";
            table.fields.append(fsurveyID);

            foriginID.name = "originid";
            foriginID.desc = "Origin ID: formhub or aggregate";
            foriginID.type = "varchar";
            foriginID.size = 15;
            foriginID.decSize = 0;
            foriginID.section = "main";
            foriginID.rField = "";
            foriginID.rTable = "";
            foriginID.key = false;
            foriginID.xmlCode = "NONE";
            table.fields.append(foriginID);*/

        }
        else
        {
            table.name = tableName;
            table.xmlCode = xmlCode;
            table.parentTable = parentTable.name;
            table.desc = "Repeat " + tableName + " - Change this description";
            /*
            //Add the key fields of the parent
            for (pos = 0; pos <= parentTable.fields.count()-1;pos++)
            {
                if (parentTable.fields[pos].key == true)
                {
                    TfieldDef parentKeyField;
                    parentKeyField.name = parentTable.fields[pos].name;
                    parentKeyField.desc = parentTable.fields[pos].desc;
                    parentKeyField.key = true;
                    parentKeyField.type = parentTable.fields[pos].type;
                    parentKeyField.size = parentTable.fields[pos].size;
                    parentKeyField.decSize = parentTable.fields[pos].decSize;
                    parentKeyField.rTable = parentTable.name;
                    parentKeyField.rField = parentTable.fields[pos].name;
                    parentKeyField.xmlCode = "NONE";
                    table.fields.append(parentKeyField);
                }
            }*/

            /*TfieldDef KeyField;
            KeyField.name = tableName + "_rowid";
            KeyField.section = "main";
            KeyField.desc = "Unique row ID";
            KeyField.key = true;
            KeyField.type = "int";
            KeyField.size = 3;
            KeyField.decSize = 0;
            KeyField.rTable = "";
            KeyField.rField = "";
            KeyField.xmlCode = "NONE";
            table.fields.append(KeyField);*/

        }
    }



    node = child;
    while (!node.isNull())
    {
        item = node.toElement();
        if ((item.tagName() == "input") || (item.tagName() == "select1") || (item.tagName() == "select"))
        {
            childNode = item.firstChild();
            fieldCode = item.attribute("ref","CodeNotFound!");
            fieldName = getItemLabel(childNode);
            fieldOutput = getItemOutput(childNode);
            if (fieldOutput != "NONE")
            {
                if (getFieldType(fieldOutput) != "Unknown")
                    fieldCode = fieldOutput;
            }

            fieldName = fieldName.replace("\r","");
            fieldName = fieldName.replace("\n","");
            fieldName = fieldName.replace("\t","");
            fieldName = fieldName.replace("'","");
            fieldName = fieldName.replace(";","");

            fieldType = getFieldType(fieldCode);

            fieldXMLCode = fieldCode.replace("/" + surveyID + "/","");

            pos = fieldCode.lastIndexOf("/");
            fieldCode = fieldCode.right(fieldCode.length()-pos-1);

            fieldCode = fieldCode.replace("-","_");
            fieldCode = fieldCode.replace("'","");
            fieldCode = fieldCode.replace(";","");

            //qDebug() << fieldCode;
            //qDebug() << MainField.toLower();


            if (fieldType != "READONLY")
            {
                TfieldDef field;

                field.name = fieldCode;
                field.xmlCode = fieldXMLCode;
                field.section = groupCode;
                field.desc = fieldName;
                //if (fieldCode.toLower() == MainField.toLower())
                //    field.key = true;
                //else
                    field.key = false;

                ftypes = fieldType.split("|",QString::SkipEmptyParts);
                if (ftypes.count() > 1)
                {
                    field.type = ftypes[0];
                    ftsizes =  ftypes[1].split(",",QString::SkipEmptyParts);
                    if (ftsizes.count() > 1)
                    {
                        field.size = ftsizes[0].toInt();
                        field.decSize = ftsizes[1].toInt();
                    }
                    else
                    {
                        field.size = ftsizes[0].toInt();
                        field.decSize = 0;
                    }
                }
                else
                    field.type = fieldType;

                field.rTable = "";
                field.rField = "";
                fieldinmselt = false;

                if (item.tagName() == "select1")
                {
                    if ((isLookUpYesNo(getSelectValues(item)) == false) || ((isLookUpYesNo(getSelectValues(item)) == true) && (ignoreYesNo == false)))
                    {

                        TtableDef lktable;


                        lktable.lkpValues.append(getSelectValues(item));



                        if (areValuesStrings(lktable.lkpValues))
                        {
                            //qDebug() << lktable.name;
                            field.type = "varchar";
                            field.size = getMaxValueLength(lktable.lkpValues);
                            field.decSize = 0;
                        }

                        lktable.name = "lkp" + fieldCode;
                        lktable.desc = "Lookup table [" + fieldName + "]";
                        lktable.pos = -1;
                        lktable.islookup = true;

                        TfieldDef lkpCode;
                        lkpCode.name = fieldCode + "_cod";
                        lkpCode.desc = "Code";
                        lkpCode.key = true;
                        lkpCode.type = field.type;
                        lkpCode.size = field.size;
                        lkpCode.decSize = field.decSize;
                        lktable.fields.append(lkpCode);

                        TfieldDef lkpDesc;
                        lkpDesc.name = fieldCode + "_des";
                        lkpDesc.desc = "Description";
                        lkpDesc.key = false;
                        lkpDesc.type = "varchar";
                        lkpDesc.size = 255;
                        lkpDesc.decSize = 0;
                        lktable.fields.append(lkpDesc);



                        sameTable = isLkpDuplicated(lktable);

                        if (sameTable.isEmpty())
                        {
                            tables.append(lktable);
                            field.rTable = lktable.name;
                            field.rField = fieldCode + "_cod";
                        }
                        else
                        {
                            field.rTable = sameTable;
                            field.rField = getKeyField(sameTable);
                            //qDebug() << lktable.name + " = " + sameTable + ". " + sameTable + " used instead";
                        }
                    }
                }
                if (item.tagName() == "select")
                {

                    //We change the field type to be varchar(255) and add it to the main table so stores values separated by space. The by a separate process we split the values in the child tables.
                    field.type = "varchar";
                    field.size = 255;
                    field.decSize = 0;

                    if (tableName.toLower() != parentTable.name.toLower()) //If we are not processing a group
                        table.fields.append(field);
                    else
                        parentTable.fields.append(field); //If we are processing a group then the field goes to the parent

                    //Then we change it back to a select type
                    field.type = "int";
                    field.size = 9;


                    //*********************Creates a new table to store the multiselect in different rows**************************

                    TtableDef mselTable;
                    if (tableName.toLower() != parentTable.name.toLower()) //If we are not processing a group
                    {
                        mselptable = table.name;
                        tempTable = table;
                    }
                    else
                    {
                        mselptable = parentTable.name;
                        tempTable = parentTable;
                    }

                    mselTable.name =  mselptable + "_msel_" + fieldCode;
                    mselTable.desc = "Table for multiple select of field " + fieldCode;
                    mselTable.islookup = false;
                    tableIndex++;
                    mselTable.pos = tableIndex;
                    mselTable.xmlCode = "NONE";

                    //Move the keys to the multi select table
                    for (pos = 0; pos <= tempTable.fields.count()-1;pos++)
                    {
                        if (tempTable.fields[pos].key == true)
                        {
                            TfieldDef mselKeyField;
                            mselKeyField.name = tempTable.fields[pos].name;
                            mselKeyField.desc = tempTable.fields[pos].desc;
                            mselKeyField.key = true;
                            mselKeyField.type = tempTable.fields[pos].type;
                            mselKeyField.size = tempTable.fields[pos].size;
                            mselKeyField.decSize = tempTable.fields[pos].decSize;
                            mselKeyField.rTable = tempTable.name;
                            mselKeyField.rField = tempTable.fields[pos].name;
                            mselTable.fields.append(mselKeyField);
                        }
                    }

                    //************************* Creates the lookup table *********************************

                    if ((isLookUpYesNo(getSelectValues(item)) == false) || ((isLookUpYesNo(getSelectValues(item)) == true) && (ignoreYesNo == false)))
                    {

                        TtableDef lktable;


                        lktable.lkpValues.append(getSelectValues(item));



                        if (areValuesStrings(lktable.lkpValues))
                        {
                            //qDebug() << lktable.name;
                            field.type = "varchar";
                            field.size = getMaxValueLength(lktable.lkpValues);
                            field.decSize = 0;
                        }

                        lktable.name = "lkp" + fieldCode;
                        lktable.desc = "Lookup table [" + fieldName + "]";
                        lktable.pos = -1;
                        lktable.islookup = true;

                        TfieldDef lkpCode;
                        lkpCode.name = fieldCode + "_cod";
                        lkpCode.desc = "Code";
                        lkpCode.key = true;
                        lkpCode.type = field.type;
                        lkpCode.size = field.size;
                        lkpCode.decSize = field.decSize;
                        lktable.fields.append(lkpCode);

                        TfieldDef lkpDesc;
                        lkpDesc.name = fieldCode + "_des";
                        lkpDesc.desc = "Description";
                        lkpDesc.key = false;
                        lkpDesc.type = "varchar";
                        lkpDesc.size = 255;
                        lkpDesc.decSize = 0;
                        lktable.fields.append(lkpDesc);



                        sameTable = isLkpDuplicated(lktable);

                        if (sameTable.isEmpty())
                        {
                            tables.append(lktable);
                            field.rTable = lktable.name;
                            field.rField = fieldCode + "_cod";
                        }
                        else
                        {
                            field.rTable = sameTable;
                            field.rField = getKeyField(sameTable);
                            //qDebug() << lktable.name + " = " + sameTable + ". " + sameTable + " used instead";
                        }
                    }

                    fieldinmselt = true;
                    field.key = true;
                    mselTable.fields.append(field);
                    tables.append(mselTable);

                }
                if (fieldinmselt == false)
                {
                    if (tableName.toLower() != parentTable.name.toLower()) //If we are not processing a group
                        table.fields.append(field);
                    else
                        parentTable.fields.append(field); //If we are processing a group then the field goes to the parent
                }

            }
        }
        else
        {
            if (item.tagName() == "group")
            {
                grpCode = item.attribute("ref","/GRPNotKnown");
                pos = grpCode.lastIndexOf("/");
                grpCode = grpCode.right(grpCode.length()-pos-1);
                grpCode = grpCode;
                //qDebug() << "Group:" + item.attribute("ref","/GRPNotKnown");
                //qDebug() << "Group table:" + table.name;

                if (!table.name.isEmpty())
                    extractFields(item.firstChild(),table.name,table,grpCode,xmlCode); //Recursive call for group
                else
                    extractFields(item.firstChild(),parentTable.name,parentTable,grpCode,xmlCode); //Recursive call for group
            }
            if (item.tagName() == "repeat")
            {
                childName = item.attribute("nodeset","unknowrepeat");

                repeatXMLCode = childName.replace("/" + surveyID + "/","");

                pos = childName.lastIndexOf("/");
                childName = childName.right(childName.length()-pos-1);
                if (!table.name.isEmpty())
                    extractFields(item.firstChild(),childName,table,"main",repeatXMLCode); //Recursive call for repeat
                else
                    extractFields(item.firstChild(),childName,parentTable,"main",repeatXMLCode); //Recursive call for repeat
            }
        }


        node = node.nextSibling();
    }

    if (tableName.toLower() != parentTable.name.toLower())
    {
        table.pos = tindex;
        table.islookup = false;
        tables.append(table);
    }

}
Пример #5
0
string JoystickMapper::getMap(OEInt usageId)
{
    return getItemLabel(usageIdMap[usageId].usageId);
}