Forum Discussion

cauline's avatar
cauline
Contributor
8 years ago

Is there a way to set a DB Table variable programmatically in JavaScript?

I am trying to programmatically setup a DB Table variable in JavaScript.  Is there a way to do this, or do I have to go through the Wizard?

 

Thx!

  • tristaanogre's avatar
    tristaanogre
    8 years ago

    Research the DDT object and associated "driver" methods.  Basically, the variable type of DB Table that you find in Project, Project Suite, and Keyword Test variables are a UI way of creating this DDT object type.  

     

    So, for example, if you want to have a DB Table of data in an excel spreadsheet and be able to, on the fly, create that variable, you COULD do...

    function getExcelData(excelFilePath, sheetName) {
    return DDT.ExcelDriver(excelFilePath, sheetName, true);
}

    Running that function with the necessary data will create such a driveable object.

    Then, TECHNICALLY what you could do is create a variable that has a type "Object" and assign the result of that function to it.  Like so.


    function getExcelData(excelFilePath, sheetName) {
    return DDT.ExcelDriver(excelFilePath, sheetName, true);
}

function foo3() {
    Project.Variables.dbObject = getExcelData('C:\\Source\\Sandbox\\JavaScriptProject\\Script\\Book1.xlsx', 'DataSheet1');
    while (!Project.Variables.dbObject.EOF()){
        Log.Message(Project.Variables.dbObject.Value('Value1'));
        Log.Message(Project.Variables.dbObject.Value('Value2'));
        Project.Variables.dbObject.Next();
    }
    DDT.CloseDriver(Project.Variables.dbObject.Name);

}
  • baxatob's avatar
    baxatob
    Community Hero
    8 years ago

    DB Table variable uses some outer source like excel file or database records.

    So if you need to assign a new value -> you need to change an appropriate file or database record.

    Of course you can do it programmatically, but approach depends on your DB Table source.

    • tristaanogre's avatar
      tristaanogre
      Esteemed Contributor
      8 years ago

      Research the DDT object and associated "driver" methods.  Basically, the variable type of DB Table that you find in Project, Project Suite, and Keyword Test variables are a UI way of creating this DDT object type.  

       

      So, for example, if you want to have a DB Table of data in an excel spreadsheet and be able to, on the fly, create that variable, you COULD do...

      function getExcelData(excelFilePath, sheetName) {
    return DDT.ExcelDriver(excelFilePath, sheetName, true);
}

      Running that function with the necessary data will create such a driveable object.

      Then, TECHNICALLY what you could do is create a variable that has a type "Object" and assign the result of that function to it.  Like so.


      function getExcelData(excelFilePath, sheetName) {
    return DDT.ExcelDriver(excelFilePath, sheetName, true);
}

function foo3() {
    Project.Variables.dbObject = getExcelData('C:\\Source\\Sandbox\\JavaScriptProject\\Script\\Book1.xlsx', 'DataSheet1');
    while (!Project.Variables.dbObject.EOF()){
        Log.Message(Project.Variables.dbObject.Value('Value1'));
        Log.Message(Project.Variables.dbObject.Value('Value2'));
        Project.Variables.dbObject.Next();
    }
    DDT.CloseDriver(Project.Variables.dbObject.Name);

}