【Auto Test Case】【RIDE】【Model】取得DB每一欄位資料存成字串

*** Test Cases ***
Main UI
    Connect Database    #連線資料庫
    ${DB_List}    Create List
    ${DML}=    Set Variable    SELECT * FROM CheckItem
    ${queryResults}=    Query    ${DML}    #執行DML資料操作語言
    ${RowCount}    Row Count    ${DML}    #取得列資料有幾筆
    : FOR    ${index}    IN RANGE    0    ${RowCount}
    \    ${DB_List_Return}=    Query DB data by Nested loop    ${queryResults}    ${index}    ${DB_List}



*** Keywords ***
Query DB data by Nested loop
    [Arguments]    ${queryResults}    ${x}    ${DB_List}
    ${one dimension array}    Convert To String    ${queryResults[0]}    #只取一列資料當代表
    #用逗號分開字串(註解不要寫在有=的句子後面)
    ${two dimension array} =    Split String    ${one dimension array}    ,
    ${ColumnTotal}    Get Length    ${two dimension array}    #可以取得長度=欄位數
    Log    取得列資料的欄位數${ColumnTotal}
    : FOR    ${y}    IN RANGE    0    ${ColumnTotal}
    \    ${string}    Convert To String    ${two dimension array[${x}][${y}]}
    \    Append To List    ${DB_List}    ${string}
    [Return]    ${DB_List}