Class: Birdwatcher::Commands::QueryCsv
- Inherits:
-
Birdwatcher::Command
- Object
- Birdwatcher::Command
- Birdwatcher::Commands::QueryCsv
- Defined in:
- lib/birdwatcher/commands/query_csv.rb
Constant Summary
Constants inherited from Birdwatcher::Command
Birdwatcher::Command::ARGUMENT_SEPARATOR
Constants included from Birdwatcher::Concerns::Concurrency
Birdwatcher::Concerns::Concurrency::DEFAULT_THREAD_POOL_SIZE
Constants included from Birdwatcher::Concerns::Core
Birdwatcher::Concerns::Core::DATA_DIRECTORY
Instance Attribute Summary
Attributes inherited from Birdwatcher::Command
Class Method Summary collapse
Instance Method Summary collapse
Methods inherited from Birdwatcher::Command
auto_completion, auto_completion_strings, descendants, #execute, has_name?, meta, meta=
Methods included from Birdwatcher::Concerns::Concurrency
Methods included from Birdwatcher::Concerns::Persistence
included, #save_status, #save_user
Methods included from Birdwatcher::Concerns::Presentation
included, #make_status_summary_output, #make_url_summary_output, #make_user_details_output, #make_user_summary_output, #output_status_summary, #output_user_details, #output_user_summary, #page_text
Methods included from Birdwatcher::Concerns::Outputting
#confirm, #error, #fatal, included, #info, #line_separator, #newline, #output, #output_formatted, #task, #warn
Methods included from Birdwatcher::Concerns::Util
#escape_html, #excerpt, included, #parse_time, #pluralize, #strip_control_characters, #strip_html, #suppress_output, #suppress_warnings, #time_ago_in_words, #unescape_html
Methods included from Birdwatcher::Concerns::Core
#console, #current_workspace, #current_workspace=, #database, included, #klout_client, #read_data_file, #twitter_client
Class Method Details
.detailed_usage ⇒ Object
10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
# File 'lib/birdwatcher/commands/query_csv.rb', line 10 def self.detailed_usage <<-USAGE The #{'query_csv'.bold} command can be used to execute raw SQL queries against the underlying database for Birdwatcher. The query results will be shown in CSV format for easy parsing by other tools or code. #{'IMPORTANT:'.bold} The query_csv command does not automatically isolate the data to the current workspace so queries will need to handle that on their own. Most tables will have a column called #{'workspace_id'.bold} which will contain the numeric ID of the workspace the object belongs to. #{'USAGE EXAMPLES:'.bold} #{'See current workspaces:'.bold} query_csv SELECT * from workspaces ORDER BY name #{'See geo coordinates for all statuses in a workspace:'.bold} query_csv SELECT longitude,latitude FROM statuses WHERE geo IS TRUE AND workspace_id = 1 #{'See statuses containing the word "password":'.bold} query_csv SELECT u.screen_name, s.text, s.posted_at FROM users AS u JOIN statuses AS s ON s.user_id = u.id WHERE s.text LIKE '%password%' #{'See status geographic places by frequency:'.bold} query_csv SELECT COUNT(*) AS count, place_name FROM statuses WHERE place_name IS NOT NULL GROUP BY place_name ORDER BY count DESC USAGE end |
Instance Method Details
#run ⇒ Object
37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
# File 'lib/birdwatcher/commands/query_csv.rb', line 37 def run if !arguments? error("You must provide an SQL query to execute") return false end query = arguments.join(" ") result = database[query] rows = result.map { |r| r.to_hash.values } headers = result.columns.map { |c| c.to_s } csv = CSV.generate(:write_headers => true, :headers => headers) do |doc| rows.each { |r| doc << r } end page_text(csv) rescue Sequel::DatabaseError => e error("Syntax error: #{e.}") end |