/tmp_zelda

tmp-zelda

Working with Zelda

1. Data Model

1.1 - Create Tables and Indices

✅ Create Tables with a CQL Query(Cassandra Query Language) 
/* ----------------------------------------- */
/* ----      TABLE   Objects          ------ */
/* ----------------------------------------- */

CREATE TABLE IF NOT EXISTS  objects (
	object_id UUID PRIMARY KEY,
    name TEXT,
    description TEXT,
    image TEXT,
    value_in_rupees INT,
    weight INT,
    type TEXT,
    stackable BOOLEAN,
	special MAP<TEXT,INT>);
 
/* ----------------------------------------- */
/* ----      TABLE  Characters        ------ */
/* ----------------------------------------- */

/** A character could be renamed. */
CREATE TABLE IF NOT EXISTS characters (
	character_id UUID PRIMARY KEY,
 	name TEXT,
	stamina INT,
	speed INT,
 	max_health INT,
 	current_health INT,
	weapon_slot UUID,
	shield_slot UUID);
	
/* Search character by name (if exist) with low cardinality. */
CREATE CUSTOM INDEX IF NOT EXISTS characters_name_idx ON characters (name) 
USING 'StorageAttachedIndex' 
WITH OPTIONS = {'case_sensitive': 'false', 'normalize': 'true', 'ascii': 'true'}; 

/* ----------------------------------------- */
/* ----       TABLE Inventory         ------ */
/* ----------------------------------------- */

CREATE TABLE IF NOT EXISTS inventory (
	character_id UUID,
	object_id UUID,
	object_name TEXT,
	weight INT,
	qty INT,
	PRIMARY KEY (character_id, object_name))
WITH CLUSTERING ORDER BY (object_name ASC);

✅ Create Tables with GraphQL

Please use endpoint ending with `api/graphql-schema`

mutation {
  table_objects: createTable(
    keyspaceName:"zelda"
    tableName:"objects"
    ifNotExists:true
    partitionKeys: [ 
      { name: "object_id", type: {basic: UUID} }
    ]
    values: [
      { name: "description", type: {basic: TEXT} },
      { name: "image", type: {basic: INT} },
      { name: "value_in_rupees", type: {basic: INT} },
      { name: "weight", type: {basic: INT} },
      { name: "type", type: {basic: TEXT} },
      { name: "stackable", type: {basic: BOOLEAN} },
      { name: "special", type: { 
          basic: MAP, 
          info: { subTypes: [ 
            { basic: TEXT }, 
            { basic: INT }
           ]
          }
      	}
      }
    ]
  )
  table_characters: createTable(
    keyspaceName: "zelda"
    tableName: "characters"
    partitionKeys: [{ name: "character_id", type: { basic: UUID } }]
    ifNotExists:true
		values: [
      { name: "name", type: {basic: TEXT} },
      { name: "stamina", type: {basic: INT} },
      { name: "speed", type: {basic: INT} },
      { name: "max_health", type: {basic: INT} },
      { name: "current_health", type: {basic: INT} },
      { name: "weapon_slot", type: {basic: UUID} },
      { name: "shield_slot", type: {basic: UUID} }
    ]
  )
  table_inventory: createTable(
    keyspaceName: "zelda"
    tableName: "inventory"
    partitionKeys: [
      { name: "character_id", type: { basic: UUID } }
    ]
    clusteringKeys: [
      { name: "object_name", type: {basic: TEXT}, order: "ASC" }
  	]
    ifNotExists:true
		values: [
      { name: "object_id", type: {basic: UUID} },
      { name: "weight", type: {basic: INT} },
      { name: "qty", type: {basic: INT} }
    ]
  )
  index_character: createIndex(
    keyspaceName:"zelda"
    indexName: "characters_name_idx"
    tableName: "characters"
    columnName: "name"
    ifNotExists:true
    indexType: "StorageAttachedIndex"
  )
}

1.2 - Insert Dataset

✅ Insert Data with a CQL Query(Cassandra Query Language) 
/* ----------------------------------------- */
/* ----             Objects           ------ */
/* ----------------------------------------- */

INSERT INTO objects (object_id, name, description, image, value_in_rupees, weight, type, stackable, special) 
VALUES (a7fdd361-4ac4-4f64-8ed0-ab9a951fc59f, 'Boko Shield', 'Found close to the blue Bokoblins, protects you from attack.', 'https://www.zeldadungeon.net/wiki/images/5/54/Boko-shield.png', 8, 1, 'shield', false, { 'durability': 7 });

INSERT INTO objects (object_id, name, description, image, value_in_rupees, weight, type, stackable, special) 
VALUES (03e81ae3-315a-4f17-8ea7-6119d7804145, 'Traveler’s Sword', 'Found in the Great Plateau, dropped by Bokoblins.', 'https://www.zeldadungeon.net/wiki/images/7/7b/Travelers-sword.png', 10, 1, 'sword', false, { 'durability': 7, 'damage': 5 });

INSERT INTO objects (object_id, name, description, image, value_in_rupees, weight, type, stackable, special) 
VALUES (959538f4-fafb-4113-8dea-80ce9a625816, 'Apple', 'Found on trees or barrels, restores half of a heart.', 'https://www.zeldadungeon.net/wiki/images/c/c3/Apple-botw.png', 2, 1, 'consumable', true, { 'health': 1});

INSERT INTO objects (object_id, name, description, image, value_in_rupees, weight, type, stackable, special) 
VALUES (638fd732-51fb-4230-8a87-2beb9e164691, 'Korok Seeds', 'Used to increase inventory squares.', 'https://www.zeldadungeon.net/wiki/images/0/01/Korok_Seed_-_HWAoC.png', 1, 0, 'item', true, { 'max_inventory_squares_plus': 1});

/* ----------------------------------------- */
/* ----             Characters        ------ */
/* ----------------------------------------- */

INSERT INTO characters(character_id, name, stamina, speed, 
			max_health, current_health,
 			weapon_slot, shield_slot) VALUES (
 			11111111-1111-1111-1111-111111111111, 'Cedrick', 10, 1, 6, 6, 03e81ae3-315a-4f17-8ea7-6119d7804145, a7fdd361-4ac4-4f64-8ed0-ab9a951fc59f);

INSERT INTO characters(character_id, name, stamina, speed, 
			max_health, current_health,
 			weapon_slot, shield_slot) VALUES (
 			22222222-2222-2222-2222-222222222222, 'Ania', 10, 1, 8, 10, 03e81ae3-315a-4f17-8ea7-6119d7804145, a7fdd361-4ac4-4f64-8ed0-ab9a951fc59f);

INSERT INTO characters(character_id, name, stamina, speed, 
			max_health, current_health,
 			weapon_slot, shield_slot) VALUES (
 			33333333-3333-3333-3333-333333333333, 'Aaron', 10, 1, 6, 6, 03e81ae3-315a-4f17-8ea7-6119d7804145, a7fdd361-4ac4-4f64-8ed0-ab9a951fc59f);	
			
/* ----------------------------------------- */
/* ----             Inventory         ------ */
/* ----------------------------------------- */

/* 10 Apples, weight is still 2 as stackable */
INSERT INTO inventory(character_id, object_id, object_name, weight, qty) 
VALUES(11111111-1111-1111-1111-111111111111, 959538f4-fafb-4113-8dea-80ce9a625816, 'Apple', 2, 10);

✅ Insert Data with GraphQL

Please use endpoint ending with `api/zelda`

mutation dataset_objects {
  object_boko_shield: insertobjects(
    value: { 
      object_id: "a7fdd361-4ac4-4f64-8ed0-ab9a951fc59f"
      name:"Boko Shield"
      description: "Found close to the blue Bokoblins, protects you from attack."
      image: "https://www.zeldadungeon.net/wiki/images/5/54/Boko-shield.png"
      value_in_rupees: 8
      weight: 1
      type: "shield"
      stackable: false
      special: { key: "durability", value: 7 }
    }) {
    	value{name}
  }
  
	object_traveler_sword: insertobjects(
    value: { 
      object_id: "03e81ae3-315a-4f17-8ea7-6119d7804145"
      name:"Traveler’s Sword"
      description: "Found in the Great Plateau, dropped by Bokoblins."
      image: "https://www.zeldadungeon.net/wiki/images/7/7b/Travelers-sword.png"
      value_in_rupees: 10
      weight: 1
      type: "sword"
      stackable: false
      special: [
        { key: "durability", value: 7 }
        { key: "damage", value: 5 } 
      ]
    }) {
    	value{name}
    }
  
   object_apple: insertobjects(
    value: { 
      object_id: "959538f4-fafb-4113-8dea-80ce9a625816"
      name:"Apple"
      description: "Found on trees or barrels, restores half of a heart."
      image: "https://www.zeldadungeon.net/wiki/images/c/c3/Apple-botw.png"
      value_in_rupees: 2
      weight: 1
      type: "consumable"
      stackable: true
      special: { key: "health", value: 1 }
    }) {
    	value{name}
  }
  
  object_korok_seed: insertobjects(
    value: { 
      object_id: "959538f4-fafb-4113-8dea-80ce9a625816"
      name:"Korok Seeds"
      description: "Used to increase inventory squares."
      image: "https://www.zeldadungeon.net/wiki/images/0/01/Korok_Seed_-_HWAoC.png"
      value_in_rupees: 1
      weight: 0
      type: "item"
      stackable: true
      special: { key: "max_inventory_squares_plus", value: 1 }
    }) {
    	value{name}
  }
  
}

2. Services

2.1 - Characters

  • Create Character
mutation create_character {
  cedrick: insertcharacters(
    value: { 
      character_id: "11111111-1111-1111-1111-111111111111"
      name: "Cedrick"
      stamina: 10
      speed: 1
      max_health: 6
      current_health: 6
      weapon_slot: "03e81ae3-315a-4f17-8ea7-6119d7804145"
      shield_slot: "a7fdd361-4ac4-4f64-8ed0-ab9a951fc59f"
    }) {
    value{name}
  }
}
  • Check if exist
query find_character_by_id {
  characters(value: { character_id:"11111111-1111-1111-1111-111111111111" }) {
    values { character_id}
  }
}
  • Find character by id
query find_character_by_id {
  characters(value: { character_id:"11111111-1111-1111-1111-111111111111" }) {
    values { name,character_id,current_health,max_health,stamina,speed,weapon_slot,shield_slot}
  }
}
  • Find character by name
query find_character_by_name {
  characters(value: { name:"Ania" }) {
    values { character_id}
  }
}
  • You got an Heart (increase life)
mutation you_got_an_heart {
  updatecharacters(
    value: { 
      character_id: "11111111-1111-1111-1111-111111111111"
      max_health: 8
      current_health: 8
    }) {
    value{max_health}
  }
}
  • Change Life (hit, heart)
mutation change_life {
  updatecharacters(
    value: { 
      character_id: "11111111-1111-1111-1111-111111111111"
      current_health: 7
    }) {
    value{current_health}
  }
}
  • Equip Weapon
mutation equip_weapon {
  updatecharacters(
    value: { 
      character_id: "11111111-1111-1111-1111-111111111111"
      weapon_slot: "03e81ae3-315a-4f17-8ea7-6119d7804145"
    }) {
    value{weapon_slot}
  }
}
  • Drop Weapon
mutation drop_weapon {
  updatecharacters(
    value: { 
      character_id: "11111111-1111-1111-1111-111111111111"
      weapon_slot: null
    }) {
    value{character_id}
  }
}
  • Equip Shield
mutation equip_shield {
  updatecharacters(
    value: { 
      character_id: "11111111-1111-1111-1111-111111111111"
      shield_slot: "a7fdd361-4ac4-4f64-8ed0-ab9a951fc59f"
    }) {
    value{character_id}
  }
}
  • Drop Shield
mutation drop_shield {
  updatecharacters(
    value: { 
      character_id: "11111111-1111-1111-1111-111111111111"
      shield_slot: null
    }) {
    value{character_id}
  }
}
  • Delete Character
mutation drop_weapon {
  deletecharacters(
    value: { 
      character_id: "11111111-1111-1111-1111-111111111111"
    }) {
    value{character_id}
  }
}

2.2 - Inventory

  • Loot Object


    

  • Drop Object from inventory
    •