123ish LLC 123ish

## add_virtual_column_index_to_ahoy_events.rb
class AddVirtualColumnIndexToAhoyEvents < ActiveRecord::Migration[6.0]
  def up
    ActiveRecord::Base.connection.execute (
      'ALTER TABLE ahoy_events ADD properties_id INT AS (JSON_UNQUOTE(properties->"$.id")) STORED;'
    )
    ActiveRecord::Base.connection.execute (
      'ALTER TABLE ahoy_events ADD INDEX (properties_id);'
    )
  end
  def down

## application.html.erb
<%# app/views/layouts/application.html.erb %>
<!DOCTYPE html>
<html>
  <head>
    <!-- add this new application.js -->
    <%= javascript_pack_tag 'application' %>
  </head>
  <body>
    <%= yield %>
  </body>

## application.js
/* app/javascript/packs/application.js */
require("@rails/ujs").start();
require("@rails/activestorage").start();

require("packs/example1");
require("packs/example2");
require("packs/example3");

## example2.js
/* app/javascript/packs/example2.js */

// to call example1 var, you need:

import example1 from './example1';

## example1.js
/* app/javascript/packs/example1.js */

var example1 = function doSomething() {
  // Your codes here
}

export default example1;

## application.js
/* app/javascript/packs/application.js */
require("@rails/ujs").start();
require("@rails/activestorage").start();

## production.js
// config/webpack/production.js
process.env.NODE_ENV = 'production';

const environment = require('./environment');

module.exports = environment.toWebpackConfig();

## erb.js
// config/webpack/loaders/erb.js
module.exports = {
  test: /\.erb$/,
  enforce: 'pre',
  exclude: /node_modules/,
  use: [{
    loader: 'rails-erb-loader',
    options: {
      runner: (/^win/.test(process.platform) ? 'ruby ' : '') + 'bin/rails runner'
    }

## custom_loader.js
// config/webpack/loaders/custom_loaders.js
module.exports = {
  test: /\.ya?ml$/,
  loaders: ['json-loader', 'yaml-loader']
};

## Gemfile
gem "webpacker"
	class AddVirtualColumnIndexToAhoyEvents < ActiveRecord::Migration[6.0]
	def up
	ActiveRecord::Base.connection.execute (
	'ALTER TABLE ahoy_events ADD properties_id INT AS (JSON_UNQUOTE(properties->"$.id")) STORED;'
	)
	ActiveRecord::Base.connection.execute (
	'ALTER TABLE ahoy_events ADD INDEX (properties_id);'
	)
	end
	def down
	<%# app/views/layouts/application.html.erb %>
	<!DOCTYPE html>
	<html>
	<head>
	<!-- add this new application.js -->
	<%= javascript_pack_tag 'application' %>
	</head>
	<body>
	<%= yield %>
	</body>
	/* app/javascript/packs/application.js */
	require("@rails/ujs").start();
	require("@rails/activestorage").start();

	require("packs/example1");
	require("packs/example2");
	require("packs/example3");
	/* app/javascript/packs/example2.js */

	// to call example1 var, you need:

	import example1 from './example1';
	/* app/javascript/packs/example1.js */

	var example1 = function doSomething() {
	// Your codes here
	}

	export default example1;
	// config/webpack/production.js
	process.env.NODE_ENV = 'production';

	const environment = require('./environment');

	module.exports = environment.toWebpackConfig();
	// config/webpack/loaders/erb.js
	module.exports = {
	test: /\.erb$/,
	enforce: 'pre',
	exclude: /node_modules/,
	use: [{
	loader: 'rails-erb-loader',
	options: {
	runner: (/^win/.test(process.platform) ? 'ruby ' : '') + 'bin/rails runner'
	}
	// config/webpack/loaders/custom_loaders.js
	module.exports = {
	test: /\.ya?ml$/,
	loaders: ['json-loader', 'yaml-loader']
	};