def schema(self):
# Setup logging
log.setLevel(self.settings.verbosity)
# Display configuration
log.debug("%s" % self.settings)
# Setup database
log.debug("* setup database's...")
db = HashDatabase2(self.settings.database)
if not db.open():
return
yield "-- [Tables]"
yield "-- " + ", ".join(
row["name"]
for row in db.connection.execute(
"SELECT name,sql FROM sqlite_master WHERE (type='table') AND (substr(name,1,7) <> 'sqlite_') ORDER BY name"
)
)
for row in db.connection.execute(
"SELECT name,sql FROM sqlite_master WHERE (type='table') AND (substr(name,1,7) <> 'sqlite_') ORDER BY name"
):
yield row["sql"]
yield "-- [Databases]"
for row in db.connection.execute("PRAGMA database_list"):
yield "-- %s: %s" % (row[1], row[2])
def hash(self, targets=None):
# Setup logging
log.setLevel(self.settings.verbosity)
# Display configuration
log.debug("%s" % self.settings)
# Setup database
log.debug("* setup database's...")
db = HashDatabase2(self.settings.database)
db.extend_locals(self.settings.databases_locals)
if not db.open():
return
# Setup the walker
log.debug("* setup walker...")
walker = Walker()
walker.walk_depth = self.settings.walk_depth
walker.extend_targets(targets or self.settings.hash_targets)
walker.extend_skip_fstypes(self.settings.skip_fstypes)
walker.extend_skip_paths(self.settings.skip_paths)
walker.extend_skip_names(self.settings.skip_names)
walker.extend_skip_dirnames(self.settings.skip_dirnames)
walker.extend_skip_filenames(self.settings.skip_filenames)
walker.skip_mounts = self.settings.skip_mounts
walker.skip_binds = self.settings.skip_binds
walker.skip_symlinks = self.settings.skip_symlinks
log.debug("* walk...")
try:
start_time = time.time()
start_changes = db.connection.total_changes
for target in walker.walk():
target_hash = db.path_hash(target.true, target.stat)
if target_hash == None:
target_hash = build_hash(target)
if target_hash != None:
db.path_setstat(target.true, target.stat, target_hash)
if target_hash != None:
yield (target, target_hash, db)
# Only commit every so often since we are limited by disk speed
now = time.time()
if ((now - start_time) >= THRESHHOLD_TIMEDELTA) or (
(db.connection.total_changes - start_changes) > THRESHHOLD_CHANGEDELTA
):
log.debug("* committing changes...")
db.connection.commit()
start_time = time.time()
start_changes = db.connection.total_changes
finally:
log.debug("* committing changes...")
db.connection.commit()
def view(self):
# Setup logging
log.setLevel(self.setting_verbosity)
# Display configuration
display_settings(self.settings, log.debug)
# Setup database
log.debug("* setup database's...")
db = HashDatabase(self.setting_database)
db.add_combines(self.setting_combine)
if not db.open():
return
# Read mounts (for truepath)
mounts = MountEntries()
# Build a query string, filtering on targets
targets = [mounts.truepath(t) for t in self.setting_targets]
qfilters = []
qargmap = {}
if ("/" not in targets) and ("\\" not in targets) and ("//" not in targets) and ("\\\\" not in targets):
for i, target in enumerate(targets):
target = mounts.truepath(target)
qfilters.append(
r"""(path = :%(name)s) OR (substr(path, 1, :%(name)s_len + 1) = :%(name)s || '/')"""
% {"name": "t%02d" % i}
)
qargmap.update({"t%02d" % i: target, "t%02d_len" % i: len(target)})
qfilter = (r"""WHERE """ + r""" OR """.join(qfilters)) if len(qfilters) != 0 else r""""""
qorder = (
r"""
ORDER BY
path,
mark DESC
"""
if self.setting_walk_depth
else r"""
ORDER BY
count_components(path),
path,
mark DESC
"""
)
query = (
r"""
SELECT
*
FROM
combinedtab
"""
+ qfilter
+ qorder
)
# yield all results as a HashRowData blob (don't expose the underlying row)
for row in db.connection.execute(query, qargmap):
yield (
HashRowData(path=row["path"], hash=row["hash"], mark=row["mark"], time=row["time"], size=row["size"]),
db,
)
