!7

lib 1009105 lib 1009109

import org.tmatesoft.sqljet.core.table.*;
import org.tmatesoft.sqljet.core.schema.*;

p {
  File profileDir = mozillaDefaultProfileDir();
  if (profileDir == null) ret with print("No Firefox profile found");
  print("Using Firefox profile: " + f2s(profileDir));
  
  File placesFile = newFile(profileDir, "places.sqlite");
  if (placesFile.exists())
    print("Places DB found!");
  else
    fail("Places DB not found in: " + f2s(placesFile));
    
  SqlJetDb db = SqlJetDb.open(placesFile, false);
  try {
    print("DB opened!");
    ISqlJetSchema schema = db.getSchema();
    printAsciiHeading("Tables!");
    pnl(schema.getTableNames());
  } finally {
    db.close();
  }
}