protected virtual List <FirefoxBookmarkRow> GetBookmarksRows(SQLiteConnection connection)
{
var hasLastVisitedColumn = HasColumn(connection, "moz_bookmarks", "last_visit_date");
var columnsToSelect = hasLastVisitedColumn ? ColumnsToSelect + ", p.last_visit_date" : ColumnsToSelect;
var cmd = new SQLiteCommand(string.Format(BookmarksSelectStatementTemplate, columnsToSelect), connection);
dynamic reader = new DynamicReader(cmd.ExecuteReader());
var rows = new List <FirefoxBookmarkRow>();
while (reader.Read())
{
rows.Add(new FirefoxBookmarkRow()
{
Id = reader.id,
Parent = reader.parent,
Type = reader.type,
Position = reader.position,
Title = reader.title,
Url = reader.url,
LastModified = reader.lastmodified,
DateAdded = reader.dateadded,
LastVisit = reader.last_visit_date,
VisitCount = reader.visit_count,
Hidden = reader.hidden > 0,
});
}
return(rows);
}
protected virtual IEnumerable <FirefoxBookmarkAttribute> GetBookmarksAttributes(SQLiteConnection connection)
{
var cmd = new SQLiteCommand(AttributesSelectStatement, connection);
dynamic reader = new DynamicReader(cmd.ExecuteReader());
var attrs = new List <FirefoxBookmarkAttribute>();
while (reader.Read())
{
attrs.Add(new FirefoxBookmarkAttribute()
{
BookmarkId = reader.item_id,
AttributeName = reader.name,
AttributeValue = reader.content
});
}
return(attrs);
}
private void FillDbColumns(SQLiteConnection connection, string tableName)
{
var cmd = new SQLiteCommand(string.Format(TableInfoSelectTemplate, tableName), connection);
var columns = new HashSet <string>();
_dbColumnInfo[tableName] = columns;
dynamic reader = new DynamicReader(cmd.ExecuteReader());
try
{
while (reader.Read())
{
columns.Add(reader.name);
}
}
finally
{
reader.Close();
}
}
private void FillBookmarksRoots(SQLiteConnection connection)
{
if (!_roots.Any())
{
var cmd = new SQLiteCommand(BookmarksRootsSelectStatement, connection);
dynamic reader = new DynamicReader(cmd.ExecuteReader());
try
{
while (reader.Read())
{
string rootName = reader.title.ToLower();
if (!_roots.ContainsKey(rootName))
{
_roots.Add(rootName, (int)reader.id);
}
}
}
finally
{
reader.Close();
}
}
}
private void FillDbColumns(SQLiteConnection connection, string tableName)
{
var cmd = new SQLiteCommand(string.Format(TableInfoSelectTemplate, tableName), connection);
var columns = new HashSet<string>();
_dbColumnInfo[tableName] = columns;
dynamic reader = new DynamicReader(cmd.ExecuteReader());
try
{
while (reader.Read())
{
columns.Add(reader.name);
}
}
finally
{
reader.Close();
}
}
private void FillBookmarksRoots(SQLiteConnection connection)
{
if (!_roots.Any())
{
var cmd = new SQLiteCommand(BookmarksRootsSelectStatement, connection);
dynamic reader = new DynamicReader(cmd.ExecuteReader());
try
{
while (reader.Read())
{
string rootName = reader.root_name.ToLower();
if (!_roots.ContainsKey(rootName))
{
_roots.Add(rootName, (int)reader.folder_id);
}
}
}
finally
{
reader.Close();
}
}
}
protected virtual List<FirefoxBookmarkRow> GetBookmarksRows(SQLiteConnection connection)
{
var hasLastVisitedColumn = HasColumn(connection, "moz_bookmarks", "last_visit_date");
var columnsToSelect = hasLastVisitedColumn ? ColumnsToSelect + ", p.last_visit_date" : ColumnsToSelect;
var cmd = new SQLiteCommand(string.Format(BookmarksSelectStatementTemplate, columnsToSelect), connection);
dynamic reader = new DynamicReader(cmd.ExecuteReader());
var rows = new List<FirefoxBookmarkRow>();
while (reader.Read())
{
rows.Add(new FirefoxBookmarkRow()
{
Id = reader.id,
Parent = reader.parent,
Type = reader.type,
Position = reader.position,
Title = reader.title,
Url = reader.url,
LastModified = reader.lastmodified,
DateAdded = reader.dateadded,
LastVisit = reader.last_visit_date,
VisitCount = reader.visit_count,
FaviconUrl = reader.favicon_url,
FaviconData = reader.favicon_data,
FaviconContentType = reader.favicon_type,
Hidden = reader.hidden > 0,
});
}
return rows;
}
protected virtual IEnumerable<FirefoxBookmarkAttribute> GetBookmarksAttributes(SQLiteConnection connection)
{
var cmd = new SQLiteCommand(AttributesSelectStatement, connection);
dynamic reader = new DynamicReader(cmd.ExecuteReader());
var attrs = new List<FirefoxBookmarkAttribute>();
while (reader.Read())
{
attrs.Add(new FirefoxBookmarkAttribute()
{
BookmarkId = reader.item_id,
AttributeName = reader.name,
AttributeValue = reader.content
});
}
return attrs;
}
