Class: Utils::CollectionViewComponents

Inherits:

Object

• Object
• Utils::CollectionViewComponents

Defined in:

lib/notion_api/utils.rb

Class Method Summary

• .add_collection_property(collection_id, args) ⇒ Object
• .add_new_row(new_block_id) ⇒ Object
• .create_collection_view(new_block_id, collection_id, view_ids) ⇒ Object
• .insert_data(block_id, column, value, mapping) ⇒ Object
• .query_collection(collection_id, view_id, search_query = "") ⇒ Object
• .set_collection_blocks_alive(new_block_id, collection_id) ⇒ Object
• .set_collection_columns(collection_id, new_block_id, data) ⇒ Object
• .set_collection_title(collection_title, collection_id) ⇒ Object
• .set_view_config(collection_type, new_block_id, view_id, children_ids) ⇒ Object
• .update_property_value(page_id, column_name, new_value) ⇒ Object

Class Method Details

.add_collection_property(collection_id, args) ⇒ Object

# File 'lib/notion_api/utils.rb', line 501

def self.add_collection_property(collection_id, args)
  # ! payload for adding a column to the table.
  # ! collection_id -> the collection ID : ``str``
  # ! args -> the definition of the column : ``str``
  args["format"] = {
    "table_properties" => [
      {
              "property" => "title",
              "visible" => true,
              "width" => 280,
            },
      {
              "property" => "aliases",
              "visible" => true,
              "width" => 200,
            },
      {
              "property" => "category",
              "visible" => true,
              "width" => 200,
            },
      {
              "property" => "description",
              "visible" => true,
              "width" => 200,
            },
      {
              "property" => "ios_version",
              "visible" => true,
              "width" => 200,
            },
      {
              "property" => "tags",
              "visible" => true,
              "width" => 200,
            },
            {
              "property" => "phone",
              "visible" => true,
              "width" => 200,
            },
      {
              "property" => "unicode_version",
              "visible" => true,
              "width" => 200,
            }
    ],
  }
  {
    id: collection_id,
    table: "collection",
    path: [],
    command: "update",
    args: args,
  }
end

.add_new_row(new_block_id) ⇒ Object

# File 'lib/notion_api/utils.rb', line 459

def self.add_new_row(new_block_id)
  # ! payload for adding a new row to the table.
  # ! new_block_id -> the ID of the new row : ``str``
  table = "block"
  path = []
  command = "set"
  type = "page"

  {
    id: new_block_id,
    table: table,
    path: path,
    command: command,
    args: {
      type: type,
      id: new_block_id,
      version: 1,
    },
  }
end

.create_collection_view(new_block_id, collection_id, view_ids) ⇒ Object

# File 'lib/notion_api/utils.rb', line 287

def self.create_collection_view(new_block_id, collection_id, view_ids)
  # ! payload for creating a collection view
  # ! new_block_id -> id of the new block
  # ! collection_id -> ID of the collection.
  # ! view_ids -> id of the view
  table = "block"
  command = "update"
  path = []
  type = "collection_view"
  properties = {}
  timestamp = DateTime.now.strftime("%Q")

  {
    id: new_block_id,
    table: table,
    path: path,
    command: command,
    args: {
      id: new_block_id,
      type: type,
      collection_id: collection_id,
      view_ids: [
        view_ids,
      ],
      properties: properties,
      created_time: timestamp,
      last_edited_time: timestamp,
    },
  }
end

.insert_data(block_id, column, value, mapping) ⇒ Object

# File 'lib/notion_api/utils.rb', line 437

def self.insert_data(block_id, column, value, mapping)
  # ! payload for inserting data into the table.
  # ! block_id -> the ID of the block : ``str``
  # ! column -> the name of the column to insert data into.
  # ! value -> the value to insert into the column.
  # ! mapping -> the column data type.
  table = "block"
  path = [
    "properties",
    column,
  ]
  command = "set"

  {
    id: block_id,
    table: table,
    path: path,
    command: command,
    args: mapping == "date" ? [["‣",[["d",{"type": "date","start_date": value}]]]] : [[value]],
  }
end

.query_collection(collection_id, view_id, search_query = "") ⇒ Object

# File 'lib/notion_api/utils.rb', line 480

def self.query_collection(collection_id, view_id, search_query = "")
  # ! payload for querying the table for data.
  # ! collection_id -> the collection ID : ``str``
  # ! view_id -> the view ID : ``str``
  # ! search_query -> the query for searching the table : ``str``
  query = {}
  loader = {
    type: "table",
    limit: 100,
    searchQuery: search_query,
    loadContentCover: true,
  }

  {
    collectionId: collection_id,
    collectionViewId: view_id,
    query: query,
    loader: loader,
  }
end

.set_collection_blocks_alive(new_block_id, collection_id) ⇒ Object

# File 'lib/notion_api/utils.rb', line 318

def self.set_collection_blocks_alive(new_block_id, collection_id)
  # ! payload for setting the collection blocks to alive.
  # ! new_block_id -> id of the new block
  # ! collection_id -> ID of the collection.
  table = "block"
  path = []
  command = "update"
  parent_table = "collection"
  alive = true
  type = "page"
  properties = {}
  timestamp = DateTime.now.strftime("%Q")

  {
    id: new_block_id,
    table: table,
    path: path,
    command: command,
    args: {
      id: new_block_id,
      type: type,
      parent_id: collection_id,
      parent_table: parent_table,
      alive: alive,
      properties: properties,
      created_time: timestamp,
      last_edited_time: timestamp,
    },
  }
end

.set_collection_columns(collection_id, new_block_id, data) ⇒ Object

# File 'lib/notion_api/utils.rb', line 380

def self.set_collection_columns(collection_id, new_block_id, data)
  # ! payload for setting the columns of the table.
  # ! collection_id -> ID of the collection.
  # ! new_block_id -> id of the new block
  # ! data -> json data to insert into table.
  col_names = data[0].keys
  data_mappings = {Integer => "number", String => "text", Array => "text", Float => "number", Date => "date"}
  exceptions = [ArgumentError, TypeError]
  data_types = col_names.map do |name|
    # TODO: this is a little hacky... should probably think about a better way or add a requirement for user input to match a certain criteria.
    begin 
      DateTime.parse(data[0][name]) ? data_mappings[Date] : nil
    rescue *exceptions
      data_mappings[data[0][name].class] 
    end
  end

  schema_conf = {}
  col_names.each_with_index do |_name, i|
    if i.zero?
      schema_conf[:title] = { name: col_names[i], type: "title" }
    else
      schema_conf[col_names[i]] = { name: col_names[i], type: data_types[i] }
    end
  end
  return {
    id: collection_id,
    table: "collection",
    path: [],
    command: "update",
    args: {
      id: collection_id,
      schema: schema_conf,
      parent_id: new_block_id,
      parent_table: "block",
      alive: true,
    },
  }, data_types
end

.set_collection_title(collection_title, collection_id) ⇒ Object

# File 'lib/notion_api/utils.rb', line 420

def self.set_collection_title(collection_title, collection_id)
  # ! payload for setting the title of the collection.
  # ! collection_title -> title of the collection.
  # ! collection_id -> ID of the collection.
  table = "collection"
  path = ["name"]
  command = "set"

  {
    id: collection_id,
    table: table,
    path: path,
    command: command,
    args: [[collection_title]],
  }
end

.set_view_config(collection_type, new_block_id, view_id, children_ids) ⇒ Object

# File 'lib/notion_api/utils.rb', line 349

def self.set_view_config(collection_type, new_block_id, view_id, children_ids)
  # ! payload for setting the configurations of the view.
  # ! new_block_id -> id of the new block
  # ! view_id -> id of the view
  # ! children_ids -> IDs for the children of the collection.
  table = "collection_view"
  path = []
  command = "update"
  version = 0
  name = "Default View"
  parent_table = "block"
  alive = true

  {
    id: view_id,
    table: table,
    path: path,
    command: command,
    args: {
      id: view_id,
      version: version,
      type: collection_type,
      name: name,
      page_sort: children_ids,
      parent_id: new_block_id,
      parent_table: parent_table,
      alive: alive,
    },
  }
end

.update_property_value(page_id, column_name, new_value) ⇒ Object

# File 'lib/notion_api/utils.rb', line 558

def self.update_property_value(page_id, column_name, new_value)
  # ! update the specified column_name to new_value
  # ! page_id -> the ID of the page: ``str``
  # ! column_name -> the name of the column ["property"] to update: ``str``
  # ! new_value -> the new value to assign to that column ["property"]: ``str``
  table = "block"
  path = [
    "properties",
    column_name
  ]
  command = "set"
  args = [[
    new_value
  ]]

  {
    id: page_id,
    table: table,
    path: path,
    command: command,
    args: args
  }
end