(r1) DatabaseAndDataAccess < Palomar/SEDM

Tags: view all tags

---+ Database and Data Access

---++ Location

The database is currently in testing on the Pharos machine.

Current version in Don Neill's [[https://github.com/scizen9/kpy][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


-- Main.KarlVyhmeister - 12 Jan 2017

Attachments

Topic attachments
I	Attachment	History	Action	Size	Date	Who	Comment
pdf	Db_input_diagram.pdf	r1	manage	335.8 K	2017-01-12 - 23:44	UnknownUser	Data flow in SEDM system
pdf	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

Topic revision: r1 - 2017-01-13 - KarlVyhmeister

~~Edit~~
~~Attach~~