search

ucd-cws / PISCES

Software for tracking and analyzing fish species range data
Other
0 stars 2 forks source link

Make More Robust Transactions #34

Closed nickrsan closed 9 years ago

nickrsan commented 10 years ago

Original report by AndyB (Bitbucket: AndyB, GitHub: AndyB).

Add SQL and date/time fields to transactions table

nickrsan commented 9 years ago

Original comment by Nicholas Santos (Bitbucket: nickrsan, GitHub: nickrsan).

Scheduling for 1.7. We may also want to verify that other edits add to the transactions table. One way we can do this is with an API call or something so that it's easier to add transactions later on (and for main imports).

nickrsan commented 9 years ago

Original comment by Nicholas Santos (Bitbucket: nickrsan, GitHub: nickrsan).

datetime added. Will add full SQL momentarily

nickrsan commented 9 years ago

Original comment by Nicholas Santos (Bitbucket: nickrsan, GitHub: nickrsan).

Going to close this and not add a full SQL field to the transaction - the where clause subset is already there, and the associated records are connected through a foreign key, so I think we should be ok now.