search

thomastom99 / wc

wc Public Repository
0 stars 0 forks source link

Please Listout all Tables with Date #42

Open thomastom99 opened 8 years ago

thomastom99 commented 8 years ago

Please List out all Tables with Date filed in WebCloud so that the Date value Upgradation can be planned correctly.

Revathyms commented 8 years ago

These are the tables with Date field

  1. CM_DT_COLUMN_DETAILS_TB
  2. CM_DT_GOOGLETRANSLATOR
  3. CM_LM_LICENSE_INFO_TB
  4. CM_LM_PRDT_LICENSE_TB
  5. CM_LM_PRDT_REGISTER_TB
  6. CM_OL_DOWNLOAD_USER_INFO_TB
  7. CM_OL_ECOM_BUYER_TB
  8. CM_OL_ECOM_PAYPAL_TB
  9. CM_OL_ECOM_PRDCT_DWNLD_TB
  10. CM_OL_ECOM_PRDCT_ORDER_TB
  11. CM_OL_ECOM_PRDCT_SUGG_TB
  12. CM_OL_ECOM_TRANSACTION_TB
  13. CM_OL_ECOM_VNDR_TB
  14. CM_OL_FEEDBACK_TB
  15. CM_OL_POLL_LIST_TB
  16. CM_OL_POLL_RESULTS_TB
  17. CM_OL_USER_LOGS_TB
  18. CM_TT_WORK_DAIRY_TB
  19. CMP_TT_DEFAULT_SETTINGS_TB
  20. CMP_TT_PROJECT_SUB_TASK_TB
  21. CMP_TT_PROJECT_TASK_TB
  22. EMP_DETAILS_EMPLOYEE_MASTER
  23. EMP_DETAILS_EMPLOYEE_REMARKS_TB
  24. EMP_DETAILS_FEEDBACK_TB
  25. FRM_MESSAGE_TB
  26. WST_CLOUD_LOGS_TB
thomastom99 commented 8 years ago

Please see the tables with date filed ..

  1. Plase fix one date(s) filed in table at a time and test it..
  2. Once testing is over then report it here as table fileds migrated with the test cases used for testing.
  3. Take the next date filed and do the task 1 and 2 and so on for the rest of the date fileds in table. Consult Revathy / Nobilin in case you need any help..
thomastom99 commented 8 years ago

Some of the table migration is already done.. Please list it out here so that we dont need to look at it again..

gopuedappattu commented 8 years ago

upgrade date field of " EMP_DETAILS_FEEDBACK_TB " table completed EMP_DETAILS_FEEDBACK_TB_Testcase .xlsx

gopuedappattu commented 8 years ago

" CM_DT_GOOGLETRANSLATOR " Table not implemented .

gopuedappattu commented 8 years ago

When we click on " Update Button " of Manage Exam Candidates page, an error will raise on the query :INSERT INTO WST_CLOUD_LOGS_TB. So i can not test " WST_CLOUD_LOGS_TB " this table .

gopuedappattu commented 8 years ago

upgrade date field of " CM_DT_COLUMN_DETAILS_TB" table completed . CM_DT_COLUMN_DETAILS_TB_Testcase .xlsx

gopuedappattu commented 8 years ago

upgrade date field of " CM_OL_ECOM_VNDR_TB " table completed . CM_OL_ECOM_VNDR_TB_Testcase .xlsx

gopuedappattu commented 8 years ago

upgrade date field of " CM_OL_POLL_LIST_TB " table completed . CM_OL_POLL_LIST_TB_Testcase .xlsx

gopuedappattu commented 8 years ago

upgrade date field of " CM_OL_POLL_RESULTS_TB " table completed . CM_OL_POLL_RESULTS_TB_Testcase .xlsx

gopuedappattu commented 8 years ago

upgrade date field of " CM_OL_USER_LOGS_TB " table completed . CM_OL_USER_LOGS_TB_Testcase .xlsx

gopuedappattu commented 8 years ago

upgrade date field of " CM_TT_WORK_DAIRY_TB " table completed . CM_TT_WORK_DAIRY_TB_Testcase .xlsx

gopuedappattu commented 8 years ago

upgrade date field of " EMP_DETAILS_EMPLOYEE_MASTER " table completed . EMP_DETAILS_EMPLOYEE_MASTER_Testcase .xlsx

gopuedappattu commented 8 years ago

upgrade date field of " EMP_DETAILS_EMPLOYEE_REMARKS_TB " table completed . EMP_DETAILS_EMPLOYEE_REMARKS_TB_Testcase .xlsx

gopuedappattu commented 8 years ago

upgrade date field of " FRM_MESSAGE_TB " table completed . FRM_MESSAGE_TB_Testcase .xlsx

gopuedappattu commented 8 years ago

CMP_TT_PROJECT_TASK_TB and CMP_TT_PROJECT_SUB_TASK_TB contains date fields but does not use anywhere in the code. ie, no insert,update or select commands for that date field. so these two tables are omitted from " Upgrade Date Field Button " code .

gopuedappattu commented 8 years ago

" CMP_TT_DEFAULT_SETTINGS_TB " table does not contain any date field .

gopuedappattu commented 8 years ago

There are two tables also contain data field

  1. CM_OL_USER_LIST_TB
  2. CM_OL_DOWNLOAD_SETTINGS
gopuedappattu commented 8 years ago

" CM_OL_ECOM_PAYPAL_TB " Table not implemented .