GeezerVisonThe World Wide Web, restored to 800 pixels of glory. |
| Home|About|Gaming cabinet|Archives|How it works|Starter sites |
GeezerVison is showing github.com — velocity/update_projects.rb at main · cncf/velocity Expand file tree/ Copy pathupdate_projects.rbMore file actions 99 lines (90 loc) · 2.57 KB / Copy pathupdate_projects.rbFile metadata and controls99 lines (90 loc) · 2.57 KB 1 2 3 4 5 6 7 8 9 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 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 require 'csv' require 'pry' require './comment' def update(fmerge, fdata, n_lines) sort_col = 'authors' force = !ENV['FORCE'].nil? projfmt = !ENV['PROJFMT'].nil? dbg = !ENV['DEBUG'].nil? # org,repo,activity,comments,prs,commits,issues,authors,pushes,project,url projects = {} CSV.foreach(fmerge, headers: true) do |row| next if is_comment row h = row.to_h proj = h['project'].strip projects[proj] = h end updates = {} if projfmt # org,repo,activity,comments,prs,commits,issues,authors,pushes,project,url keys = %w(activity comments prs commits issues authors pushes) CSV.foreach(fdata, headers: true) do |row| next if is_comment row h = row.to_h proj = h['project'].strip keys.each do |key| updates[[proj,key]] = h[key] end end else # project,key,value CSV.foreach(fdata, headers: true) do |row| next if is_comment row h = row.to_h proj = h['project'].strip key = h['key'].strip updates[[proj,key]] = h['value'] end end updated = the_same = higher = 0 updates.each do |what, value| proj, key = what unless projects.key? proj puts "Cannot find project #{proj}" next end unless projects[proj].key? key puts "Project #{proj} has no key #{key}" next end if projects[proj][key].to_s == value.to_s puts "Project #{proj} already have #{key} = #{value}" if dbg the_same += 1 next end if projects[proj][key].to_i > value.to_i && !force puts "Project #{proj} have #{key} = #{projects[proj][key]} which is more than #{value}" if dbg higher += 1 next end had = projects[proj][key] projects[proj][key] = value puts "Updated project #{proj} #{key}: #{had} -> #{value}" if dbg updated += 1 end puts "Updated #{updated} values" if updated > 0 puts "The same #{the_same} values" if the_same > 0 puts "Skipped #{higher} values (they already had higher value)" if higher > 0 # Sort by sort_col desc to get list of top projects arr = [] projects.values.each do |row| arr << [row[sort_col].to_i, row] end sorted = arr.sort_by { |item| -item[0] } # Write changes back to file to update hdr = projects.values.first.keys CSV.open(fmerge, "w", headers: hdr) do |csv| csv << hdr lines = 0 sorted.each do |item| lines += 1 csv << item[1] break if lines >= n_lines && n_lines > 0 end end end if ARGV.size < 3 puts "Missing arguments: projects_to_merge.csv additional_data.csv n_rows" exit(1) end update(ARGV[0], ARGV[1], ARGV[2].to_i) |
| You are visitor 01402503 — GeezerVison does not store the pages you look up. Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required. |