TruxtonInvestigationEvent - Revision history

Sam: /* Sample */

2024-01-27T19:10:33Z

Sample

Sam: /* id: str */

2023-06-02T09:06:00Z

id: str

Sam at 22:22, 2 May 2023

2023-05-02T22:22:38Z

Sam at 15:13, 25 October 2022

2022-10-25T15:13:39Z

Sam at 15:13, 25 October 2022

2022-10-25T15:13:27Z

Sam: Created page with "This class lets you add an investigation event to Truxton. =Attributes and Methods= ==`color: int`== Sets the color of the flag to paint on the timeline. This corr..."

2022-10-25T15:05:00Z

Created page with "This class lets you add an investigation event to Truxton. =Attributes and Methods= ==<code>color: int</code>== Sets the color of the flag to paint on the timeline. This corr..."

New page

This class lets you add an investigation event to Truxton.

=Attributes and Methods=
==<code>color: int</code>==
Sets the color of the flag to paint on the timeline.
This corresponds to the <code>[Color]</code> column of the <code>[InvestigationEvent]</code> table.

==<code>id: str</code>==
A [https://en.wikipedia.org/wiki/Universally_unique_identifier GUID] for the investigation.
This corresponds to the <code>[ID]</code> column of the <code>[InvestigationEvent]</code> table.

==<code>investigationid: str</code>==
A [https://en.wikipedia.org/wiki/Universally_unique_identifier GUID] for the investigation this event belongs to.
This corresponds to the <code>[ID]</code> column of the <code>[Investigation]</code> table and is
stored in the <code>[InvestigationID]</code> column of the <code>[InvestigationEvent]</code> table.

==<code>status: int</code>==
This is the status of the investigation.
It should be a value that appears in the <code>[ID]</code> column of a row in the <code>InvestigationStatus</code> table.
This corresponds to the <code>[InvestigationStatusID]</code> column of the <code>[InvestigationEvent]</code> table.

==<code>save() -> boolean</code>==
This will commit the information to the <code>[InvestigationEvent]</code> table.
It will return [https://docs.python.org/3.10/library/constants.html#True True] if the record was saved to the database, [https://docs.python.org/3.10/library/constants.html#False False] if there was an error.

==<code>text: str</code>==
The text to display on the event flag.
This corresponds to the <code>[Text]</code> column of the <code>[InvestigationEvent]</code> table.

==<code>type: int</code>==
The type of investigation event. 1 - Status change, 2 - Comment.
This corresponds to the <code>[InvestigationEventTypeID]</code> column of the <code>[InvestigationEvent]</code> table.

=Sample=
<source lang="Python" highlight="56-61,80">
import sys
sys.path.append('C:/Program Files/Truxton/SDK')
import truxton
import shutil

from datetime import datetime
from calendar import timegm
from pathlib import Path

EPOCH_AS_FILETIME = 116444736000000000
HUNDREDS_OF_NANOSECONDS = 10000000

EVENT_TYPE_FBI = 20001

def date_to_filetime(dt):
return EPOCH_AS_FILETIME + (timegm(dt.timetuple()) * HUNDREDS_OF_NANOSECONDS)

def add_file(parent_truxton_file, filename):
source_file = open(filename, "rb")
child = parent_truxton_file.newchild()
child.name = Path(filename).name
shutil.copyfileobj(source_file, child)
source_file.close()
child.save()
return child

def add_media(t):
media = t.newmedia()

media.name = "Public Documents"
media.description = "Publicly available documents"
media.case = "DC-SNAFU-2016.2020"
media.evidencebag = "EV-0937459386623-a"
media.originator = "Jeffrey Jensen"
media.latitude = 38.897661
media.longitude = -77.036458
media.type = truxton.MEDIA_TYPE_LOGICAL_FILES
media.save()

return media

def add_cs(parent_file ):
child_file = add_file(parent_file, "cs.jpg")

gps = child_file.newlocation()
gps.type = truxton.LOCATION_TYPE_MEETING
gps.latitude = 51.487329
gps.longitude = -0.124057
gps.label = "HQ"
gps.when= date_to_filetime(datetime.fromisoformat("2016-04-01T12:00:00-05:00"))
gps.save()

def create_investigation(t):
investigation = t.newinvestigation()

investigation.name = "Collusion"
investigation.description = "United States vs. John Smith"
investigation.case = "DC-SNAFU-2016.2020"
investigation.status = truxton.INVESTIGATION_STATUS_OPEN
investigation.type = truxton.INVESTIGATION_TYPE_FRAUD
investigation.save()

return investigation

def main():
t = truxton.create()

new_type = t.neweventtype()
new_type.id = EVENT_TYPE_FBI
new_type.name = "FBI Actions"
new_type.save()

investigation = create_investigation(t)

media = add_media(t)

root_file = media.addroot()
root_file.save()

investigation.addmedia(media.id)

add_cs(root_file)

if __name__ == "__main__":
main()
</source>

@@ Line 32: / Line 32: @@
 This corresponds to the <code>[InvestigationEventTypeID]</code> column of the <code>[InvestigationEvent]</code> table.
-==<code>when: int</code>==
+==<code>when: [https://docs.python.org/3/library/datetime.html datetime]</code>==
-When the event happened in [https://docs.microsoft.com/en-us/windows/win32/api/minwinbase/ns-minwinbase-filetime FILETIME] ticks.
+When the event happened.
 This corresponds to the <code>[When]</code> column of the <code>[InvestigationEvent]</code> table.
 =Sample=

@@ Line 68: / Line 68: @@
 if __name__ == "__main__":
-   main()
+   sys.exit(main())
 </source>

@@ Line 7: / Line 7: @@
 ==<code>id: str</code>==
-A [https://en.wikipedia.org/wiki/Universally_unique_identifier GUID] for the investigation.
+A [https://en.wikipedia.org/wiki/Universally_unique_identifier GUID] for the investigation event.
 This corresponds to the <code>[ID]</code> column of the <code>[InvestigationEvent]</code> table.

@@ Line 38: / Line 38: @@
 =Sample=
-<source lang="Python" highlight="22-25" line>
+<source lang="Python" highlight="22-25">
 import sys
 sys.path.append('C:/Program Files/Truxton/SDK')

@@ Line 31: / Line 31: @@
 The type of investigation event. 1 - Status change, 2 - Comment.
 This corresponds to the <code>[InvestigationEventTypeID]</code> column of the <code>[InvestigationEvent]</code> table.
 =Sample=
-<source lang="Python" highlight="56-61,80">
+<source lang="Python" highlight="22-25" line>
 import sys
 sys.path.append('C:/Program Files/Truxton/SDK')
 import truxton
 def create_investigation(t):
@@ Line 101: / Line 57: @@
 def main():
    t = truxton.create()
    investigation = create_investigation(t)
-   media = add_media(t)
+   investigation_event = investigation.createevent()
+  investigation_event.text = "I did this"
-   root_file = media.addroot()
+   investigation_event.when = truxton.parsetime("2016-08-15T12:05:00-05:00")
-   root_file.save()
+   investigation_event.save()
-   add_cs(root_file)
+   return None
 if __name__ == "__main__":
    main()
 </source>

TruxtonInvestigationEvent - Revision history

Sam: /* Sample */

Sam: /* id: str */

Sam at 22:22, 2 May 2023

Sam at 15:13, 25 October 2022

Sam at 15:13, 25 October 2022

Sam: Created page with "This class lets you add an investigation event to Truxton. =Attributes and Methods= ==color: int== Sets the color of the flag to paint on the timeline. This corr..."

Sam: Created page with "This class lets you add an investigation event to Truxton. =Attributes and Methods= ==`color: int`== Sets the color of the flag to paint on the timeline. This corr..."