Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Connect Gists with Dash (Code Snippet Manager)
#!/usr/bin/env ruby
if ARGV[0].nil? || ARGV[0].match(/-h/)
puts "Usage : #{$0} github_username dash_sqlite_db char_appended_to_keyword [no_comments]"
exit
end
require 'net/http'
require 'open-uri'
#require 'awesome_print'
require 'uri'
require 'json'
require 'sqlite3'
#############
# Variables
#############
url = "https://api.github.com/users/#{ARGV[0]}/gists"
tag_regex = /#\w+/
############
# Functions
############
def getHttpsContent(url)
uri = URI.parse(url)
http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = true
http.verify_mode = OpenSSL::SSL::VERIFY_NONE
request = Net::HTTP::Get.new(uri.request_uri)
http.request(request).body
end
#############
# We get all the public gists
#############
puts "\nFetching #{url}...\n"
gists = JSON.parse getHttpsContent(url)
#ap gists
#############
# We list the gists and detect those we'll update
#############
gists_to_update = []
puts "Gists are :\n"
gists.each do |gist|
puts "\t#{gist['description']}\n"
unless (shortcut = gist['description'].match(tag_regex).to_s).empty?
#gist['files'].each {|f| ap f}
files = []
gist['files'].each {|f| files << {:filename => f[0], :url => f[1]['raw_url']}}
gists_to_update << {
:shortcut => shortcut[1..-1],
:files => files
}
end
end
puts "\n\nThose Dash snippets will be updated :\n"
gists_to_update.each {|x| puts "\t#{x[:shortcut]}#{ARGV[2]}"}
#############
# We update the database
#############
db = SQLite3::Database.new(ARGV[1])
#db.execute2 'SELECT * FROM snippets;' do |row|
# ap row
#end
gists_to_update.each do |gist|
content = ""
gist[:files].each do |f|
content << "\n\n### #{f[:filename]}\n\n" if ARGV[3].nil?
open(f[:url]) {|c|
c.each_line {|line| content << line}
}
end
snippet_id = db.get_first_row( "SELECT sid FROM snippets WHERE title = ?","#{gist[:shortcut]}#{ARGV[2]}")
if snippet_id.nil?
db.execute( "INSERT INTO snippets VALUES (null, ?, ?, 'Standard', 0)",
"#{gist[:shortcut]}#{ARGV[2]}",
content )
else
db.execute( "UPDATE snippets SET body = ? WHERE sid = ?",
content,
snippet_id )
end
puts "\n#{gist[:shortcut]}#{ARGV[2]} has been updated"
end

How to

Create or edit a gist

In your gist description, add a keyword like : #jquery

Launch the script

Launch the script without arguments to see the usage. The script will use the keyword to fill the abbreviation field in Dash and fill the snippet with the gist content

Example

You could run :

chmod +x gists_to_dash.rb
./gists_to_dash.rb voising Dropbox/Configs/snippets.dash "$" no_comments

More about the char_appended_to_keyword argument

When you write your snippets you may use a key at the end of the abbreviation. That's what this argument stands for.

If the keyword is #calljquery and the char_appended_to_keyword is "$", the snippet abbreviation will be : calljquery$

@lambdamusic

This comment has been minimized.

Copy link

@lambdamusic lambdamusic commented Oct 3, 2016

The downloader works but it stops after 30 gists or so..
Also, if the resulting DB fails to load using Dash.

@bosbyj

This comment has been minimized.

Copy link

@bosbyj bosbyj commented Mar 4, 2017

Really good idea.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment