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
HTMLhtm SEDmdb.htm r1 manage 403.4 K 2018-07-31 - 22:22 UnknownUser diagram of database as of 20180729
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

This topic: Palomar/SEDM > WebHome > StatusAndImprovements > DatabaseAndDataAccess
Topic revision: r2 - 2018-07-31 - AlisonDugas
 
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