Environmental Variables

The following are the env variables you should set to allow epidote to establish connections to the database. All envs follow the <adapter>_<var> pattern.

MONGODB_HOST=127.0.0.1
MONGODB_PORT=27017
MONGODB_USER=root
MONGODB_PASS=example
MONGODB_DB_NAME=epidote_test

MYSQL_HOST=localhost
MYSQL_PORT=3306
MYSQL_USER=root
MYSQL_PASS=mysql
MYSQL_DB_NAME=epidote_test

In addition setting envs with <adapter>_RO_HOST or <adapter>_RO_PORT will establish RO connections that will be used for querying. In the example below we define the DNS name of the master which will be used for any Creates, Deletes, or Updates. Then a RO loadbalancer DNS entry is defined for any Read operations.

# RW Host information
MYSQL_HOST=mysql-master.mysql.svc.cluster.local
MYSQL_PORT=3306

# RO Host information
MYSQL_RO_HOST=mysql-slaves.mysql.svc.cluster.local
MYSQL_RO_PORT=3306

# Shared credentials
MYSQL_USER=root
MYSQL_PASS=mysql
MYSQL_DB_NAME=epidote_test

The MySQL pool configuration can be passed with environmentals as well:

MYSQL_DB_INITIAL_POOL_SIZE=1
MYSQL_DB_MAX_POOL_SIZE=25
MYSQL_DB_IDLE_POOL_SIZE=5
MYSQL_DB_CHECKOUT_TIMEOUT=10.0
MYSQL_DB_RETRY_ATTEMPTS=2
MYSQL_DB_RETRY_DELAY=0.2

MongoDB example

require "epidote/model/mongo"

class MyModel::Mongo < Epidote::Model::Mongo
  collection(:my_model)
  attributes(name: String, unique_name: {
    index:  true,
    unique: true,
    type:   String,
  })
  attribute :default_value, String, default: "a string"
  attribute :not_nil_value, Int32, not_nil: true

  add_index [:id, :unique_name], unique: true
end

MySQL example

require "epidote/model/mysql"

class MyModel::MySQL < Epidote::Model::MySQL
  table(:my_model)
  attributes(
    id: {
      primary_key:    true,
      type:           Int32,
      auto_increment: true,
    },
    name: String,
    unique_name: {
      index:  true,
      unique: true,
      type:   String,
    })

  attribute :default_value, String, default: "a string"
  attribute :not_nil_value, Int32, not_nil: true
  attribute :uuid, UUID
  attribute :extra_data, JSON::Any

  add_index [:id, :unique_name], unique: true
end

Hooks

There are two available hooks for before and after a record is saved. They are pre_commit and post_commit. The pre commit hook will be called before every save or update and post commit hook will be called after. Here is an example that will set the modified time of the record every time it is saved or updated:

class MyModel::MySQL < Epidote::Model::MySQL
  table(:my_model)
  attributes(
    id: {
      primary_key:    true,
      type:           Int32,
      auto_increment: true,
    },
    created_at: {
      type:    Time,
      default: Time.utc,
    },
    modified_at: Time
  )

  pre_commit ->{ self.modified_at = Time.utc }

  post_commit ->{
    # do something after save
  }
end

Other instance variables

If you want to have other instance variables that are not saved to the record, you must add the following annotations to them so BSON and JSON serialization ignores them:

  @[BSON::Prop(ignore: true)]
  @[JSON::Field(ignore: true)]
  @dont_save_this_var = 100

Development

Contributing