westonganger

Source Article (See for latest changes): https://westonganger.com/posts/using-postgresql-fdw-with-activerecord-and-rails

If you want to do some cross database joins or includes across postgresql databases regardless of local or remote databases you can use Postgres FDW. Its an awesome tool for the job when you want to avoid data replication.

Base Postgresql FDW Model:

class PostgresFdwBase < ApplicationRecord

  ### Article to familiarize with concepts in this models methods - https://thoughtbot.com/blog/postgres-foreign-data-wrapper

westonganger

Tools

• CSS Load
• CSS Tool
• Iconizer
• SVG Circus - Create SVG Animations
• SpriteMe
• Custom Centering Generator
• Custom Centering Generator
• CSS 3 Generator
• Web Font Blender

westonganger

Step 1: Dump your postgresql create_table statements to a file:

pg_dump -s my_db_name > my_db_name_create.sql

• You will need to manually remove all statements except CREATE TABLE, CREATE INDEX, CREATE_UNIQUE INDEX, etc.
  • Honestly just do it. It wont take too long, you'll be fine.
  • Some statements you will definately need to remove are SET, ALTER, CREATE SEQUENCE

• For INDEX statements we need to find-and-remove USING btree

westonganger

class Forms::BaseForm
  include ActiveModel::Validations

  def initialize(attrs={})
    attrs ||= {}

    attrs.each do |k,v|
      self.send("#{k}=", v) ### Use send so that it checks that attr_accessor has already defined the method so its a valid attribute
    end
  end

westonganger

<%= form_for @post do |f| %>
  <div class="comments-wrapper">
    <% f.fields_for :comments do |f2| %>
      <%= render "comment_fields", f: f2 %>
    <% end %>
  </div>

  <button type="button" class="add-comment">Add Comment</button>

  <script>

westonganger

class Result
  def initialize(h={}, **attrs)
    if !h.is_a?(Hash)
      raise ArgumentError.new("Non-hash argument provided")
    end

    @attrs = h.presence || attrs

    @attrs.each do |k,v|
      define_singleton_method(k) do

westonganger

### BUNDLER
require "bundler/inline"
gemfile(true) do
  source "https://rubygems.org"

  ruby '2.4.1'

  gem "rails"
  gem "sqlite3"
  #gem 'responders'

westonganger

  def self.with_fresh_i18n_load_paths(load_paths, &block)
    prev_load_path = I18n.load_path

    I18n.load_path = load_paths
    I18n.backend.reload!

    block.call
  ensure
    I18n.load_path = prev_load_path
    I18n.backend.reload!

westonganger

# lib/<project_name>/engine.rb

module RailsI18nManager
  class Engine < ::Rails::Engine
    isolate_namespace RailsI18nManager

    ### Automatically load all migrations into main rails app
    initializer "rails_i18n_manager.append_migrations" do |app|
      if !app.root.to_s.match?(root.to_s)
        config.paths["db/migrate"].expanded.each do |expanded_path|

westonganger

# lib/<project_name>/engine.rb

module RailsI18nManager
  class Engine < ::Rails::Engine
    isolate_namespace RailsI18nManager

    initializer "rails_i18n_manager.load_static_assets" do |app|
      ### Expose static assets
      app.middleware.use ::ActionDispatch::Static, "#{root}/public"
    end