Posts

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

Posted on

Aws instance scheduler

Como interrompo e inicio instâncias do Amazon EC2 em intervalos regulares usando o Lambda?
https://aws.amazon.com/pt/premiumsupport/knowledge-center/start-stop-lambda-cloudwatch/

Automate starting and stopping AWS instances
https://docs.aws.amazon.com/solutions/latest/instance-scheduler/welcome.html

Awslabs / AWS Instance Scheduler – Scheduler for Cross-Account and Cross-Region scheduling for EC2 and RDS instances
https://github.com/awslabs/aws-instance-scheduler

Posted on

Nvidia Mosaic – Linux

xorg.conf

Option         "MetaModes" "1920x1080 +0+0, 1920x1080 +1920+0, 1920x1080 +0+1080, 1920x1080 +1920+1080"