Rank.create!([
  { type_name: "President", planet: "Mercury", weekday: "Wednesday", time: "anytime excluding twilight", metal: "Mercury" },
  { type_name: "Knight", planet: "Jupiter", weekday: "Thursday", time: "dawn to sunrise", metal: "Lead" },
  { type_name: "Earl", planet: "Saturn", weekday: "Saturday", time: "anytime in a desolate place", metal: "Iron" },
  { type_name: "Marquis", planet: "Moon", weekday: "Monday", time: "3pm to sunrise", metal: "Silver" },
  { type_name: "Prince", planet: "Mars", weekday: "Tuesday", time: "anytime", metal: "Iron or Steel" },
  { type_name: "Duke", planet: "Venus", weekday: "Friday", time: "sunrise to noon", metal: "Copper" },
  { type_name: "King", planet: "Sun", weekday: "Sunday", time: "on great occasions", metal: "Gold" }
])

Spirit.create!([
  { 
    name: "Bael", 
    rank: Rank.find_by!(type_name: "King"),
    description: "The first spirit of Solomon's Goetia. He makes men go Invisible.", 
    abilities: "Make men invisible, imparts wisdom, provides followers",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Agares",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Teaches all languages, stops and retrieves runaways, causes earthquakes.",
    abilities: "Language comprehension, controlling runaways, causing earthquakes",
    start_date: "2025-03-31",
    end_date: "2025-04-10"
  },
  {
    name: "Vassago",
    rank: Rank.find_by(type_name: "Prince"),
    description: "Declares past, present and future, discovers hidden and lost things.",
    abilities: "Divination, location of lost items",
    start_date: "2025-04-11",
    end_date: "2025-04-20"
  },
  {
    name: "Samigina",
    rank: Rank.find_by(type_name: "Marquis"),
    description: "Teaches all liberal sciences, tells of the souls that died in sin.",
    abilities: "Imparts knowledge, reveals souls",
    start_date: "2025-04-21",
    end_date: "2025-04-30"
  },
  {
    name: "Marbas",
    rank: Rank.find_by(type_name: "President"),
    description: "Answers truly on hidden or secret things, causes diseases and cures them.",
    abilities: "Reveals secrets, controls diseases",
    start_date: "2025-05-01",
    end_date: "2025-05-10"
  },
  {
    name: "Valefor",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Tempter to steal.",
    abilities: "Temptation",
    start_date: "2025-05-11",
    end_date: "2025-05-20"
  },
  {
    name: "Amon",
    rank: Rank.find_by(type_name: "Marquis"),
    description: "Tells of all things past and future, procures feuds, and reconciles controversies.",
    abilities: "Divination, conflict creation and resolution",
    start_date: "2025-05-21",
    end_date: "2025-05-31"
  },
  {
    name: "Barbatos",
    rank: Rank.find_by(type_name: "Duke"),
    description: "He gives understanding of the voices of animals, says past and future, conciliates friends and rulers.",
    abilities: "Animal communication, divination, reconciliation",
    start_date: "2025-06-01",
    end_date: "2025-06-10"
  },
  {
    name: "Paimon",
    rank: Rank.find_by(type_name: "King"),
    description: "Teaches arts and sciences, reveals desires, provides good familiars.",
    abilities: "Knowledge impartation, desire revelation, familiar provision",
    start_date: "2025-06-11",
    end_date: "2025-06-20"
  },
  {
    name: "Buer",
    rank: Rank.find_by(type_name: "President"),
    description: "Teaches natural and moral philosophy, logic, and the properties of herbs.",
    abilities: "Education in philosophy and herbalism",
    start_date: "2025-06-21",
    end_date: "2025-07-01"
  },
  {
    name: "Gusion",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Tells past, present and future, answers all questions, reconciles friendships.",
    abilities: "Divination, omniscience, reconciliation",
    start_date: "2025-07-02",
    end_date: "2025-07-11"
  },
  {
    name: "Sitri",
    rank: Rank.find_by(type_name: "Prince"),
    description: "Causes men to love women and vice versa, and can make people bare themselves naked.",
    abilities: "Induces love and provokes desire",
    start_date: "2025-07-12",
    end_date: "2025-07-21"
  },
  {
    name: "Beleth",
    rank: Rank.find_by(type_name: "King"),
    description: "Causes all the love that may be, both of men and of women.",
    abilities: "Provokes intense love and attraction",
    start_date: "2025-07-22",
    end_date: "2025-08-01"
  },
  {
    name: "Leraje",
    rank: Rank.find_by(type_name: "Marquis"),
    description: "Causes battles and disputes.",
    abilities: "Induces conflict",
    start_date: "2025-08-02",
    end_date: "2025-08-11"
  },
  {
    name: "Eligos",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Discovers hidden things and knows the future of wars and how soldiers will or shall meet.",
    abilities: "Reveals secrets, foretells outcomes of battles",
    start_date: "2025-08-12",
    end_date: "2025-08-22"
  },
  {
    name: "Zepar",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Causes women to fall in love with men.",
    abilities: "Induces romantic attraction in women",
    start_date: "2025-08-23",
    end_date: "2025-09-01"
  },
  {
    name: "Botis",
    rank: Rank.find_by(type_name: "President"),
    description: "Tells of all things past and future, reconciles friends and foes.",
    abilities: "Divination, reconciliation",
    start_date: "2025-09-02",
    end_date: "2025-09-11"
  },
  {
    name: "Bathin",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Knows the virtues of herbs and precious stones, can transport people from country to country.",
    abilities: "Knowledge of herbs and stones, teleportation",
    start_date: "2025-09-12",
    end_date: "2025-09-22"
  },
  {
    name: "Sallos",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Causes love between men and women.",
    abilities: "Induces love and attraction",
    start_date: "2025-09-23",
    end_date: "2025-10-02"
  },
  {
    name: "Purson",
    rank: Rank.find_by(type_name: "King"),
    description: "Knows of hidden things, finds treasures, and tells past, present and future. Brings good familiars.",
    abilities: "Revelation, treasure finding, divination, provides familiars",
    start_date: "2025-10-03",
    end_date: "2025-10-12"
  },
  {
    name: "Marax",
    rank: Rank.find_by(type_name: "President"),
    description: "Teaches astronomy and liberal sciences, gives good familiars.",
    abilities: "Education in astronomy and sciences, provides familiars",
    start_date: "2025-10-12",
    end_date: "2025-10-22"
  },
  {
    name: "Ipos",
    rank: Rank.find_by(type_name: "Prince"),
    description: "Tells of all things hidden or secret, causes and cures fevers, imparts wit.",
    abilities: "Revelation, healing, intelligence boost",
    start_date: "2025-10-23",
    end_date: "2025-11-01"
  },
  {
    name: "Aim",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Sets cities, castles and great places on fire, makes men witty in all ways.",
    abilities: "Pyrokinesis, intelligence boost",
    start_date: "2025-11-02",
    end_date: "2025-11-12"
  },
  {
    name: "Naberius",
    rank: Rank.find_by(type_name: "Marquis"),
    description: "Makes men cunning in all arts, but especially in rhetoric.",
    abilities: "Skill enhancement, expertise in rhetoric",
    start_date: "2025-11-13",
    end_date: "2025-11-22"
  },
  {
    name: "Glasya-Labolas",
    rank: Rank.find_by(type_name: "President"),
    description: "Teaches all arts and sciences, causes love of friends and foes, can cause death.",
    abilities: "Imparts knowledge, induces love, can cause mortality",
    start_date: "2025-11-23",
    end_date: "2025-12-02"
  },
  {
    name: "Bune",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Changes the places of the dead, makes demons under his power, provides rich treasures.",
    abilities: "Necromancy, demon control, wealth acquisition",
    start_date: "2025-12-03",
    end_date: "2025-12-12"
  },
  {
    name: "Ronove",
    rank: Rank.find_by(type_name: "Marquis"),
    description: "Teaches languages, gives good and loyal servants and the favor of friends and foes.",
    abilities: "Language comprehension, provides loyal servants, gains favor",
    start_date: "2025-12-13",
    end_date: "2025-12-21"
  },
  {
    name: "Berith",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Gives true answers about the past, present, and future, turns all metals into gold.",
    abilities: "Divination, alchemy",
    start_date: "2025-12-22",
    end_date: "2025-12-30"
  },
  {
    name: "Astaroth",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Gives true answers about things unknown, secures the respect of friends and foes.",
    abilities: "Revelation, respect acquisition",
    start_date: "2025-12-31",
    end_date: "2025-01-09"
  },
  {
    name: "Forneus",
    rank: Rank.find_by(type_name: "Marquis"),
    description: "Teaches rhetoric and languages, gives good and loyal servants.",
    abilities: "Language and rhetoric education, provides loyal servants",
    start_date: "2025-01-10",
    end_date: "2025-01-19"
  },
  {
    name: "Foras",
    rank: Rank.find_by(type_name: "President"),
    description: "Teaches logic and ethics, reveals treasures, causes a man to be invisible.",
    abilities: "Education in logic and ethics, reveals treasures, invisibility",
    start_date: "2025-01-20",
    end_date: "2025-01-29"
  },
  {
    name: "Asmoday",
    rank: Rank.find_by(type_name: "King"),
    description: "Gives the ring of virtues, teaches geometry and arithmetic, answers about hidden treasures, makes men invisible.",
    abilities: "Imparts virtues, education in mathematics, reveals treasures, invisibility",
    start_date: "2025-01-30",
    end_date: "2025-02-08"
  },
  {
    name: "Gaap",
    rank: Rank.find_by(type_name: "Prince"),
    description: "Teaches liberal sciences, causes love or hatred, transports people from country to country.",
    abilities: "Education, emotion manipulation, teleportation",
    start_date: "2025-02-09",
    end_date: "2025-02-18"
  },
  {
    name: "Furfur",
    rank: Rank.find_by(type_name: "Earl"),
    description: "Raises thunder, lightning, and winds, teaches about secret and divine things.",
    abilities: "Weather control, imparts divine knowledge",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Marchosias",
    rank: Rank.find_by(type_name: "Marquis"),
    description: "Gives true answers to all questions, but is a strong fighter in battle.",
    abilities: "Divination, martial prowess",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Stolas",
    rank: Rank.find_by(type_name: "Prince"),
    description: "Teaches astronomy, the properties of plants, and the worth of precious stones.",
    abilities: "Astronomy, botany, and gemology education",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Phenex",
    rank: Rank.find_by(type_name: "Marquis"),
    description: "Teaches excellent knowledge of all the liberal sciences, is a poet.",
    abilities: "Liberal arts education, poetic skills",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Halphas",
    rank: Rank.find_by(type_name: "Earl"),
    description: "Builds towers, fills them with ammunition and weapons, sends warriors.",
    abilities: "Architecture, weapon provisioning, warrior command",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Malphas",
    rank: Rank.find_by(type_name: "President"),
    description: "Builds houses and high towers, brings enemies together in peace.",
    abilities: "Construction, diplomacy",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Raum",
    rank: Rank.find_by(type_name: "Earl"),
    description: "Steals treasures from kings, destroys cities and dignities, reveals past, present, and future.",
    abilities: "Theft, destruction, divination",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Focalor",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Kills men, drowns them, and overthrows warships; but if commanded, will not harm anyone.",
    abilities: "Causes mortal harm, naval disruption",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Vepar",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Guides waters and battleships; can make the sea rough and stormy, and to appear full of ships.",
    abilities: "Water manipulation, illusion creation",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Sabnock",
    rank: Rank.find_by(type_name: "Marquis"),
    description: "Builds high towers, castles, and cities, and equips them with armor.",
    abilities: "Construction, armory provisioning",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Shax",
    rank: Rank.find_by(type_name: "Marquis"),
    description: "Takes away sight, hearing, and understanding, retrieves stolen goods, discovers hidden things.",
    abilities: "Deprivation of senses, retrieval, discovery",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Vine",
    rank: Rank.find_by(type_name: "King"),
    description: "Discovers things hidden, witches, and overthrown things.",
    abilities: "Discovery, detection of witches",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Bifrons",
    rank: Rank.find_by(type_name: "Earl"),
    description: "Teaches the arts and sciences, knows the virtues of gems, herbs, and woods.",
    abilities: "Education in arts and sciences, knowledge of gems, herbs, and woods",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Vual",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Procures the love of women, tells things past, present, and to come, and procures friendship.",
    abilities: "Induces love, divination, friendship procurement",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Haagenti",
    rank: Rank.find_by(type_name: "President"),
    description: "Makes men wise, converts all metals into gold, and turns wine into water.",
    abilities: "Imparts wisdom, alchemical transmutation",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Crocell",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Teaches geometry and other liberal sciences, warms waters, and discovers baths.",
    abilities: "Education in geometry and liberal sciences, water heating, bath discovery",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Furcas",
    rank: Rank.find_by(type_name: "Knight"),
    description: "Teaches philosophy, astronomy, rhetoric, logic, chiromancy, and pyromancy.",
    abilities: "Education in various disciplines",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Balam",
    rank: Rank.find_by(type_name: "King"),
    description: "Tells past, present, and future events, makes men invisible, and has witty answers.",
    abilities: "Divination, invisibility, wit",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Alloces",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Provides good familiars, teaches arts and sciences, and knows about the stars and their influence.",
    abilities: "Provides familiars, education, astrological knowledge",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Camio",
    rank: Rank.find_by(type_name: "President"),
    description: "Gives understanding of the voices of animals, tells about future things, teaches arts and sciences.",
    abilities: "Animal communication, divination, education",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Murmur",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Teaches philosophy, constrains the souls of the deceased to answer questions.",
    abilities: "Philosophy education, necromancy",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Orobas",
    rank: Rank.find_by(type_name: "Prince"),
    description: "Gives true answers about past, present, and future, bestows honors, and reconciles enemies.",
    abilities: "Divination, honor bestowal, peace-making",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Gremory",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Discovers hidden treasures and procures the love of women.",
    abilities: "Treasure discovery, inducing love",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Ose",
    rank: Rank.find_by(type_name: "President"),
    description: "Turns a man into any shape, teaches liberal sciences, and gives true answers about divine and secret things.",
    abilities: "Transformation, education, divination",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Amy",
    rank: Rank.find_by(type_name: "President"),
    description: "Teaches astrology and liberal arts, provides good spirits, reveals treasures.",
    abilities: "Astrology education, spirit provision, treasure revelation",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Oriax",
    rank: Rank.find_by(type_name: "Marquis"),
    description: "Teaches about the stars and their virtues, gives dignities and confirmations, and transforms men.",
    abilities: "Astrology education, bestows honors, transformation",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Vapula",
    rank: Rank.find_by(type_name: "Duke"),
    description: "Teaches handicrafts, philosophy, and sciences.",
    abilities: "Education in crafts, philosophy, and sciences",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Zagan",
    rank: Rank.find_by(type_name: "King"),
    description: "Turns wine into water, blood into wine, turns fools wise, and leads people into prodigality.",
    abilities: "Transformation of liquids, enhances wisdom, induces extravagance",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  },
  {
    name: "Valac",
    rank: Rank.find_by(type_name: "President"),
    description: "Gives true answers about hidden treasures, where serpents can be seen, and delivers them harmless.",
    abilities: "Treasure revelation, serpent detection and control",
    start_date: "2025-03-21",
    end_date: "2025-03-30"
  }
])