Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
#!/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$

@wzpan

This comment has been minimized.

Copy link
Owner Author

@wzpan wzpan commented May 30, 2015

I got an error when I tried this script:

./gists_to_dash_db.rb:30:in `getHttpsContent': uninitialized constant OpenSSL (NameError)
    from ./gists_to_dash_db.rb:40:in `<main>'

How to resolve it?

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