Category: Uncategorized

Posted on

API Development

  • Stoplight – Design, Document & Build APIs Faster
    Develop quality APIs with collaborative API-first design.
    https://stoplight.io/
  • Swagger – API Development for Everyone
    Simplify API development for users, teams, and enterprises with the Swagger open source and professional toolset. Find out how Swagger can help you design and document your APIs at scale.
    https://swagger.io/
Posted on

gitlab-rails console

$ gitlab-rails console
User.where("created_at < ?", 60.days.ago).find_each do |user|
  if user.name.length != 10
    puts user.name
  end
end
User.where("length(name) = ?", 10).find_each do |user|
  puts "#{user.id};#{user.name};#{user.email}"
end
User.where("length(username) = ? and length(name) = ?", 10, 10).find_each do |user|
  puts "#{user.id};#{user.username};#{user.name};#{user.email}"
end
users = User.where("length(username) = ? and length(name) = ? and id >= ? and id != ?", 10, 10, 240, 734)

users.find_each do |user|
  puts "#{user.id};#{user.username};#{user.name};#{user.email}"
end
users = User.where("length(username) = ? and length(name) = ? and id >= ? and id != ?", 10, 10, 240, 734)

users.find_each do |user|
  user.destroy
end
emails = ["doox6paigu4M@doox6paigu4M.com", "eeThiel3eex9@eeThiel3eex9.com"]

users = User.where("email in (?)", emails)

users.find_each do |user|
  puts user.name
end
Posted on

NAS – openmediavault

openmediavault is the next generation network attached storage (NAS) solution based on Debian Linux. It contains services like SSH, (S)FTP, SMB/CIFS, DAAP media server, RSync, BitTorrent client and many more. Thanks to the modular design of the framework it can be enhanced via plugins.

https://www.openmediavault.org/

Posted on

PostgreSQL users and roles