How to write a SQLite plugin

To write a SQLite plugin it is best to use l2t_scaffolder. The scaffolder will ask you questions and guide you through setting up the necesary files needed for the plugin.

Locate/create test data

  • Before writing the plugin you’ll need to have a SQLite database file to test the plugin with. Either generate one, or have one that does not contain personal data (since it will get checked into the project).
  • Start by listing out all the SQL commands you’ll need to issue against the database beforehand. Try them out manually, see if they work and produce the data you are looking for.

Creating all the files.

  • Start by installing the l2t_scaffolder tool
  • Have your git repo for plaso correctly setup (personal fork, see here).
  • Then follow the usage instructions.
    • Essentially run this command (you’ll need to remember the path to the test file and the path to the plaso git repo before you start).
$ l2t_scaffolder.py plaso
  • After answering all questions a new feature branch will be created in your plaso repository with all the files needed for the plugin.

Write minimal tests

  • Write a test that loads your plugin and parses a file.
  • It will fail initially, but running the test while you’re developing your plugin gives you a quick way to see if your code is doing what you expect.

Develop plugin

  • There will be TODO’s and missing code inside the newly generated files. Fill these in with your code.

Write the formatter

  • Implement your formatter, there will be a generic one generated that may need to be somewhat adjusted.

Expand tests

  • Add additional tests that test your plugin and formatter

Register classes

  • Edit plaso/parsers/sqlite_plugins/init.py to correct alphabetical order of the imports.
  • Edit plaso/formatters/init.py to correct alphabetical order of imports.

Code review/submit