Difference: DatabaseAndDataAccess (1 vs. 2)

Revision 22018-07-31 - AlisonDugas

Line: 1 to 1
 
META TOPICPARENT name="StatusAndImprovements"

Database and Data Access

Line: 25 to 25
  -- KarlVyhmeister - 12 Jan 2017
Added:
>
>
 
META FILEATTACHMENT attachment="Db_input_diagram.pdf" attr="" comment="Data flow in SEDM system" date="1484264691" moveby="Main.KarlVyhmeister" movedto="Palomar/SEDM.DatabaseAndDataAccess.Db_input_diagram.pdf" movedwhen="1484265867" movefrom="Palomar/SEDM.Software.Db_input_diagram.pdf" name="Db_input_diagram.pdf" path="Db_input_diagram.pdf" size="343886" stream="Db_input_diagram.pdf" user="Main.KarlVyhmeister" version="1"
META FILEATTACHMENT attachment="SedmDb_diagram_2.pdf" attr="" comment="A diagram of the database with the tables and their columns" date="1484264524" moveby="Main.KarlVyhmeister" movedto="Palomar/SEDM.DatabaseAndDataAccess.SedmDb_diagram_2.pdf" movedwhen="1484265898" movefrom="Palomar/SEDM.Software.SedmDb_diagram_2.pdf" name="SedmDb_diagram_2.pdf" path="SedmDb_diagram_2.pdf" size="226132" stream="SedmDb_diagram_2.pdf" user="Main.KarlVyhmeister" version="1"
Added:
>
>
META FILEATTACHMENT attachment="SEDmdb.htm" attr="" comment="diagram of database as of 20180729" date="1533075724" name="SEDmdb.htm" path="SEDmdb.htm" size="413121" user="AlisonDugas" version="1"

Revision 12017-01-13 - KarlVyhmeister

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="StatusAndImprovements"

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

META FILEATTACHMENT attachment="Db_input_diagram.pdf" attr="" comment="Data flow in SEDM system" date="1484264691" moveby="Main.KarlVyhmeister" movedto="Palomar/SEDM.DatabaseAndDataAccess.Db_input_diagram.pdf" movedwhen="1484265867" movefrom="Palomar/SEDM.Software.Db_input_diagram.pdf" name="Db_input_diagram.pdf" path="Db_input_diagram.pdf" size="343886" stream="Db_input_diagram.pdf" user="Main.KarlVyhmeister" version="1"
META FILEATTACHMENT attachment="SedmDb_diagram_2.pdf" attr="" comment="A diagram of the database with the tables and their columns" date="1484264524" moveby="Main.KarlVyhmeister" movedto="Palomar/SEDM.DatabaseAndDataAccess.SedmDb_diagram_2.pdf" movedwhen="1484265898" movefrom="Palomar/SEDM.Software.SedmDb_diagram_2.pdf" name="SedmDb_diagram_2.pdf" path="SedmDb_diagram_2.pdf" size="226132" stream="SedmDb_diagram_2.pdf" user="Main.KarlVyhmeister" version="1"
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2021 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback