Tags:
create new tag
view all tags

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
ISorted ascending Attachment History Action Size Date Who Comment
HTMLhtm SEDmdb.htm r1 manage 403.4 K 2018-07-31 - 22:22 UnknownUser diagram of database as of 20180729
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: 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