Accessing a sqlite ...
 
Notifications
Clear all

Accessing a sqlite database in UFED PA Python

13 Posts
3 Users
0 Reactions
2,925 Views
(@mattias1978)
Active Member
Joined: 14 years ago
Posts: 8
Topic starter  

Thanks Ron
It is a bit annoying that we must export out all our sqlite3 databases. Process them outside PA in different Python scripts, put the result in a base64 encoded cvs files and then process the cvs files inside PA to add the elements to the correct model and get it displayed in reports.

Cheers
Mattias


   
ReplyQuote
(@alexc)
Reputable Member
Joined: 16 years ago
Posts: 301
 

Please keep us updated in this thread - I'd love to know what was going on here!


   
ReplyQuote
(@mattias1978)
Active Member
Joined: 14 years ago
Posts: 8
Topic starter  

Hi
I got an answer from a colleague. When accessing a SQLite database inside the python prompt of UFED PA you have to use the built in parser that Cellebrite have created. This is done in the following way
import SQLiteParser

node = <file system path>
db = SQLiteParser.Database.FromNode(node)

tableName = "myTable"
for record in db.ReadTableRecords(tableName)
print record[‘myTable_column_name’].Value


   
ReplyQuote
Page 2 / 2
Share: