#24. MySQL cheatsheet

-

MySQL cheatsheet

sudo service mysql stop sudo service mysql start

mysql -u root -p -h 198.11.12.12 machine_integration

select code from stock sf where sf.code LIKE 'CO%S' limit 10;
'CONS' 'CONS' 'CONS' 'CONS' 'CONS' 'CONS' 'CONS' 'CONS'

Comments

Post a Comment

Let me know for any query..

Popular posts from this blog

#6. Fetch time in rails

-
 In the Rails do not prefer to use Time.now, Date.today etc We should always prefer to use it with zone like, Time.zone.now, Time.zone.today etc. but why so? Beacause when we fetch Time.now its always return system local time and ignore  config.time_zone  set in the  application.rb. file. Here is the example tested in the rails console, 3.0.3 :001 > Time.now  => 2022-04-19 09:57:58.413034249 +0530  3.0.3 :002 > Time.zone  => #<ActiveSupport::TimeZone:0x000055704feec360 @name="UTC", @tzinfo=#<TZInfo::DataTimezone: Etc/UTC>, @utc_offset=nil>  3.0.3 :003 > Time.zone.now  => Tue, 19 Apr 2022 04:28:07.277000358 UTC +00:00  3.0.3 :004 > Time.zone = 'Sydney'  => "Sydney"  3.0.3 :005 > Time.zone  => #<ActiveSupport::TimeZone:0x000055705192d850 @name="Sydney", @tzinfo=#<TZInfo::DataTimezone: Australia/Sydney>, @utc_offset=nil>  3.0.3 :008 > Time.now  => 2022...
Read more

#8. nginx+puma deployment using capistrano

-
 In the Gemfile, ---------------------------------------- group :development do   gem 'capistrano',         require: false   gem 'capistrano-rvm',     require: false   gem 'capistrano-rails',   require: false   gem 'capistrano-bundler', require: false   gem 'capistrano3-puma',   require: false end -------------------------------------------------- bundle install cap install create a file as,  /home/raj/workspace/chat/config/nginx.conf ------------------------------------------------ upstream puma {   server unix:///home/raj/deployed_apps/chat/shared/tmp/sockets/chat-puma.sock; } server {   listen 80 default_server deferred;   # server_name example.com;   root /home/raj/deployed_apps/chat/current/public;   access_log /home/raj/deployed_apps/chat/current/log/nginx.access.log;   error_log /home/raj/deployed_apps/chat/current/log/nginx.error.log info;   location ...
Read more

#21. Rails scope

-
Author has_many books books belongs_to author Named Scope scope :available, -> { where(available: true) } select 'books'.* from books where books.available = 't' scope :unavailable, -> { where(available: [nil, false]) } select 'books'.* from books where books.available = 'f' or books.available is null scope :public_status, -> { where(status:  'public') } 3.1.2 :004 > Article.public_status   Article Load (0.2ms)  SELECT "articles".* FROM "articles" WHERE "articles"."status" = ? AND "articles"."status" = ?  [["status", "public"], ["status", "public"]] Here two times same status(‘public’) checked because one of the default scope and one of the named scope( public_status ). Author.joins(:books).merge(Book.available) select authors.* from authors inner join books on books.author_id=authors.id where books.available = 't' We can achi...
Read more