#! usr/bin/ruby
require 'digest'
require 'fileutils'
require 'colorize'
begin
    DBNAME = "structure.db"

    DB = SQLite3::Database.new(DBNAME)

    DB.execute "CREATE TABLE IF NOT EXISTS nix(file_name TEXT,file_checksum TEXT)"

    structure_data = Dir["**/*"]
    puts structure_data

    insert_query = "INSERT INTO nix(file_name, file_checksum) VALUES "
    structure_data.each do |file|
        if File.directory?("#{file}")
        puts "Directory => #{file}"
    elsif File.file?(file)
        checksum = Digest::SHA256.file "#{file}"
        puts checksum
            insert_query += "('#{file.to_s}', '#{checksum.to_s}'), "
            end
    end
    insert_query = insert_query.chomp(', ')
    insert_query += ";"
    DB.execute(insert_query)

end