gem 'dymos'

Dymos::Query::CreateTable.name('ProductCatalogs')
  .attributes(category: 'S', title: 'S', ISBN:'S', price:'N')
  .keys(category: 'HASH', title: 'RANGE')
  .gsi([{name: 'global_index_isbn', keys: {ISBN: 'HASH'}, projection: {type: 'INCLUDE', attributes: [:title, :ISBN]}, throughput: {read: 20, write: 10}}])
  .lsi([{name: 'local_index_category_price', keys: {category: 'HASH', price: 'RANGE'}}])
  .throughput(read: 20, write: 10)

class Product < Dymos::Model
    table 'ProductCatalogs'
    field :category, :integer
    field :title, :string
    field :ISBN, :string
    field :price, :integer
    field :authors, :array
    field :created_at, :time
  end

Product.all

Product.find('Novels', 'The Catcher in the Rye') #key is category && title

Product.where(category:'Comics').all
Product.where(category:'Comics').add_filter(:authors,:contains,'John Smith').all
Product.where(category:'Comics').desc.one
Product.index(:local_index_category_price).add_condition(:category,'Comics')add_condition(:price,:gt,10000).all

product = Product.new(params)
product.save!

product = Product.find(conditions)
product.price += 100
product.update!

product = Product.find(conditions)
product.add(price:100).put(authors:['Andy','Bob','Charlie']).update!

product = Product.find(conditions)
product.add_expected(:price,10000).delete