Versions Compared

Old Version 2

changes.mady.by.user Alessandro Stecchi

Saved on

compared with

New Version Current

changes.mady.by.user Alessandro Stecchi

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

#TitleUser StoryImportanceNotes
1
DBFiles Python parser

Jira
showSummaryfalse
serverINFN Ticketing System
serverId8087fedc-8816-3706-9e66-78f987f39e0c
keyLNFDCS-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

Jira
serverINFN Ticketing System
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId8087fedc-8816-3706-9e66-78f987f39e0c
keyLNFDCS-160

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
2

User interaction and design

...