Database and Data Access

Location

The database is currently in testing on the Pharos machine.

Current version in Don Neill's Github.

Data access functions are in kpy/SEDMDb/SedmDb.py.

More complex functions are in kpy/SEDMDb/SedmDb_tools.py

Data Access

The class `SedmDB` in SedmDb.py has functions named with the scheme:

  • add_'table name' to insert into the table (e.g. add_object for the object table)

  • update_'table name' to update an existing entry

  • get_from_'table name' to select certain values from the table

-- KarlVyhmeister - 12 Jan 2017

Topic attachments
I Attachment History Action Size Date Who Comment
PDFpdf Db_input_diagram.pdf r1 manage 335.8 K 2017-01-12 - 23:44 UnknownUser Data flow in SEDM system
PDFpdf SedmDb_diagram_2.pdf r1 manage 220.8 K 2017-01-12 - 23:42 UnknownUser A diagram of the database with the tables and their columns
Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r1 - 2017-01-13 - KarlVyhmeister
 
  • Edit
  • Attach
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback