MySql command

mysql                         mysql_config_editor        mysqldumpslow              mysqlprocgrep              mysqlserverclone
mysqladmin                 mysqld                     mysql_embedded             mysqlpump                  mysqlserverinfo
mysqlanalyze               mysqldbcompare             mysqlfailover              mysqlrepair                mysqlshow
mysqlauditadmin            mysqldbcopy                mysqlfrm                   mysqlreplicate             mysqlslap
mysqlauditgrep             mysqldbexport              mysqlgrants                mysqlreport                mysqlslavetrx
mysqlbinlog                mysqldbimport              mysqlimport                mysqlrpladmin              mysql_ssl_rsa_setup
mysqlbinlogmove            mysqldiff                  mysqlindexcheck            mysqlrplcheck              mysql_tzinfo_to_sql
mysqlbinlogpurge           mysqldiskusage             mysql_install_db           mysqlrplms                 mysqluc
mysqlbinlogrotate          mysqld_multi               mysqlmetagrep              mysqlrplshow               mysql_upgrade
mysqlcheck                 mysqld_safe                mysqloptimize              mysqlrplsync               mysqluserclone
mysql_config               mysqldump                  mysql_plugin               mysql_secure_installation  mysql-workbench

Create user in mysql 

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

GRANT ALL ON my_db.* TO 'username'@'localhost';

FLUSH PRIVILEGES;

Upload image using ajax request in rails

          <%=  file_field_tag :customer_profile, id: "customer_profile"  %>           

          var formData = new FormData();
          custProfile  =$("#customer_profile")[0].files[0]
          formData.append("device_img", custProfile);
          $.ajax({
          url: "<%=  upload_image_customer_path(id: params[:id]) %>",
          type: 'POST',
          dataType: 'json',
          data: formData,
          contentType: false,
          processData: false,
          cache : false,
          success: function(data){
            if(data["msg"] == true){
              alert(success)
             }
            },
           error: function(data){
             console.log(data); 
            }
          });

Image convert in base64 in rails

require "base64"

file_url = "https://s3.ap-south-1.amazonaws.com/on-store-billing/uploads/insurance/servify_device_image/58/1__2_.jpeg"

encoded_string = Base64.encode64(open(file_url) { |io| io.read })

decode_img= Base64.decode64(encoded_string)

below given method write/create image with name image.png in directory

File.open(‘image.png’, ‘wb’) { |f| f.write(decode_img) }

Login Postgresql with specific database

$  psql -d db_name -U username

e.g. $  psql -d on_store_development -U postgres

then it will ask for password default is root or postgres. Or check your database.yml for a password that password you have to type here.

Get array of files from directory in rails

Dir.glob("#{Rails.root}/public/reports/*")

Important commands in rails and rake

Rails:
  console
  credentials:edit
  credentials:show
  dbconsole
  destroy
  encrypted:edit
  encrypted:show
  generate
  new
  runner
  secrets:edit
  secrets:setup
  secrets:show
  server
  test
  version

Rake:
  about
  active_storage:install
  app:template
  app:update
  assets:clean[keep]
  assets:clobber
  assets:environment
  assets:precompile
  cache_digests:dependencies
  cache_digests:nested_dependencies
  db:create
  db:drop
  db:environment:set
  db:fixtures:load
  db:load_config
  db:migrate
  db:migrate:status
  db:rollback
  db:schema:cache:clear
  db:schema:cache:dump
  db:schema:dump
  db:schema:load
  db:seed
  db:setup
  db:structure:dump
  db:structure:load
  db:version
  dev:cache
  initializers
  log:clear
  middleware
  notes
  notes:custom
  restart
  routes
  secret
  stats
  test
  test:db
  test:system
  time:zones[country_or_offset]
  tmp:clear
  tmp:create
  yarn:install