...
Goals
- Realization of a system (EDA: Easy DBFiles Access) composed by Python code and a dedicated SQL database that symplifies the retrieval of information on DCS elements, DEVILs, VMs, locations, etc...
...
At this moment the retrieval of information about elements in the DCS requires a series of manual actions (ssh login, grep on DBFiles, browsing the documentation, etc.). This system must be able to transfer – through a Python application – information from the DCS DBFiles to a SQL database.
Assumptions
- The system must employ mySQL, Python, regex
Requirements
| # | Title | User Story | Importance | Notes |
|---|
| 1 |
DBFiles Python parser | | Jira |
|---|
| showSummary | false |
|---|
| server | INFN Ticketing System |
|---|
| serverId | 8087fedc-8816-3706-9e66-78f987f39e0c |
|---|
| key | LNFDCS-161 |
|---|
|
| As a developer I want an SQL DB installed so that I can write and read data to and from it using a Python application. | Must have | - Make some practice with mySQL statements from command line
|
| 2 | |
2 | DBFiles Python parser| Jira |
|---|
showSummary | false |
|---|
| server | INFN Ticketing System |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 8087fedc-8816-3706-9e66-78f987f39e0c |
|---|
| key | LNFDCS- |
|---|
|
|
161 | As a user I want to access an SQL database so that I can retrieve information resident in the DANTE DBFiles. | Must have | - To be done by using Python as programming language
|
User interaction and design
...