Skip to content

Instantly share code, notes, and snippets.

@stevehenderson

stevehenderson/find_to_sqllite3.sh

Created April 16, 2024 04:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stevehenderson/86080b266773d44c6dc088f4044fd230 to your computer and use it in GitHub Desktop.
Save stevehenderson/86080b266773d44c6dc088f4044fd230 to your computer and use it in GitHub Desktop.
Download ZIP
Index a folder and store it in SQLite
Raw
find_to_sqllite3.sh
find ~/Downloads -type f -exec stat -c "%n|%s|%y" {} \; | awk -F"|" '{printf("INSERT INTO files (file_path, file_size, file_date) VALUES ('\''%s'\'', %s, '\''%s'\'');\n", $1, $2, $3)}' | sqlite3 mydb.db
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment