MarketSquare / MarketSquare/Robotframework-Database-Library
oracledb thin client - support locale specific date and number conversion
還沒有人認領這個 Issue。
- 主要語言
- Python
- 星號
- 179
- 分支
- 178
- PR 合併指標
- 30 天內沒有已合併 PR
描述
Currently there is no native support for the python oracledb module, so this issue occurs when using "connect using custom params" mode (see #173 for connection example).
There is a problem if the test data used in Robot Framework has some regional format different from the Oracle DB.
For example, with decimal/float number and dates:
- The standard English Oracle format for a decimal number is point-based - e.g.
123.45. - But in some other languages/regions (e.g. in Germany) the comma-based format is used -
123,45.
So before I save some local values to the database or compare them with the database values, there is some conversion to be done.
Currently it has to performed manually.
Maybe there is a better way?
The thin mode of the oracledb client doesn't support Oracle Globalization variables (see the full comparison between thin and thick clients here).
So they advice to use the python globalization support - and provide an example.
Also I'm not sure, but maybe this issue is relevant also for other databases?
貢獻指南
這個儲存庫沒有索引到貢獻指南
從這裡開始
- 先讀完整個 Issue,再讀專案的貢獻指南。
- 在 Issue 下留言說明你要接手 —— 這能避免兩個人做同樣的事。
- Fork 儲存庫,在一個分支上完成修改。
- 送出 Pull Request,並在描述裡引用這個 Issue 編號。
研究方向
先從 issue #173 中的 custom-params 連線模式和連線範例開始,然後閱讀連結的 python-oracledb thin-mode 全球化範例。定義 Robot Framework 測試資料應如何進行支援 locale 的日期和數字轉換,並明確範圍是否包括 Oracle 以外的資料庫。
由索引模型根據 Issue 內容生成。
評估
- 技術堆疊
- python
- 領域
- databases
- Issue 類型
- 功能
- 難度
- 4/5
- 預估耗時
- 3-5 天
- 活躍度
- 停滯
- 描述清晰度
- 需要釐清
- 新手友好度
- 35/100