historySQL property

  1. @override
String get historySQL
override

Implementation

@override
String get historySQL {
  return """
      SELECT
          datetime(
              visit_date/1000000, 'unixepoch', 'localtime'
          ) AS 'visit_time',
          url,
          moz_places.title
      FROM
          moz_historyvisits
      INNER JOIN
          moz_places
      ON
          moz_historyvisits.place_id = moz_places.id
      WHERE
          visit_date IS NOT NULL AND url LIKE 'http%' AND title IS NOT NULL
  """;
}