beer-inventory/prisma/seed.ts

import { ContainerType, PrismaClient, UserType } from "@prisma/client";
import { enhance } from "@zenstackhq/runtime";
import { BeerStyle, Country, Manufacturer, Section, Soda, User, Wine, WineStyle } from "@zenstackhq/runtime/models";

import { hashPassword } from "../app/auth/validate";

const pr = new PrismaClient();


async function seed() {

  const initialPassword = hashPassword("asdf1239");

  await pr.user.upsert({ create: {username: "kenneth", password: initialPassword, type: UserType.Admin}, update: {password: initialPassword}, where: {username: "kenneth"} });
  await pr.user.upsert({ create: {username: "scanner", password: initialPassword, type: UserType.Scanner}, update: {password: initialPassword}, where: {username: "scanner"} });
  const user = await pr.user.findUnique({where: {username: "kenneth"}}) || undefined;

  // Delete all sessions
  pr.session.deleteMany({});

  const db = enhance(pr, {user});

  await db.history.deleteMany({});
  await db.container.deleteMany({});
  await db.beer.deleteMany({});
  await db.wine.deleteMany({});
  await db.soda.deleteMany({});
  await db.cocktail.deleteMany({});
  await db.beerStyle.deleteMany({});
  await db.wineStyle.deleteMany({});
  await db.section.deleteMany({});
  await db.manufacturer.deleteMany({});
  await db.country.deleteMany({});


  await Promise.all(
    getCountries().map((country) => {
      return db.country.create({ data: country });
    })
  );

  await Promise.all(
    getManufacturers().map((man) => {
      return db.manufacturer.create({ data: man });
    })
  );

  await Promise.all(
    getBeerStyles().map((style) => {
      return db.beerStyle.create({ data: style });
    })
  );

  await Promise.all(
    getBeers().map((beer) => {
      return db.beer.create({ data: beer });
    })
  );

  await Promise.all(
    getWineStyles().map((style) => {
      return db.wineStyle.create({ data: style });
    })
  );

  await Promise.all(
    getWines().map((wine) => {
      return db.wine.create({ data: wine });
    })
  );

  await Promise.all(
    getSodas().map((soda) => {
      return db.soda.create({ data: soda });
    })
  );

  await Promise.all(
    getCocktails().map((cocktail) => {
      return db.cocktail.create({ data: cocktail });
    })
  );

  await Promise.all(
    getSections().map((section) => {
      return db.section.create({ data: section });
    })
  );

  await Promise.all(
    getContainers().map((container) => {
      return db.container.create({ data: container });
    })
  );
}

seed();

interface BeerQuery {
  slug: string;
  manufacturer: any;
  name: string;
  description: string;
  abv: number;
  style: any;
  ibu: number | null;
  image: string | null;
  link: string | null;

  gluten: boolean;
  lactose: boolean;
  organic: boolean;
}

interface WineQuery {
  slug: string;
  manufacturer: any;
  name: string;
  description: string;
  abv: number;
  style: any;
  image: string | null;
  link: string | null;

  gluten: boolean;
  lactose: boolean;
  organic: boolean;
}

interface SodaQuery {
  slug: string;
  manufacturer: any;
  name: string;
  description: string;
  abv: number;
  image: string | null;

  carbonated: boolean;

  gluten: boolean;
  lactose: boolean;
  organic: boolean;
}

interface CocktailQuery {
  slug: string;
  manufacturer: any;
  name: string;
  description: string;
  abv: number;
  image: string | null;

  mix: boolean;

  gluten: boolean;
  lactose: boolean;
  organic: boolean;
}

interface ContainerQuery {
  barcode: string;
  drink: any;
  type: ContainerType;
  volume: number;
  portions: number | null;
  inventory: number | 0;
  section: any;
}

function getCountries() : Country[]{
  return [
    {
      code: "nl",
      name: "Netherlands"
    },
    {
      code: "ir",
      name: "Ireland"
    },
    {
      code: "be",
      name: "Belgium"
    },
    {
      code: "ge",
      name: "Germany"
    },
    {
      code: "us",
      name: "United-States"
    },
    {
      code: "ch",
      name: "Swiss"
    },
    {
      code: "sp",
      name: "Spain"
    },
    {
      code: "sc",
      name: "Chile"
    },
    {
      code: "sa",
      name: "South-Africa"
    },
    {
      code: "au",
      name: "Austria"
    }
  ];
}

function getManufacturers() : Manufacturer[] {
  return [
    {
      id: 1,
      country_id: "nl",
      name: "Desperados",  //Heineken
      description: null,
      image: "/manufacturers/desperados.jpeg"
    },
    {
      id: 2,
      country_id: "nl",
      name: "Hertog Jan", // AbInBev
      description: "From our Award-winning Pilsener to our great pride Grand Prestige. And from the fresh Weizener to our new hoppy Enkel. All Hertog Jan beers have something special, call it character. Learn everything about our beers at hertogjan.nl",
      image: "/manufacturers/hertog_jan.jpeg"
    },
    {
      id: 3,
      country_id: "be",
      name: "Brouwerij Bosteels", // AbInBev
      description: "In the hands of the Bosteels family for over 200 years, the brewery relies today on the craftmanship of seven generations. In 1791, Jean-Baptist Bosteels established the brewery, and has been followed by generations who took over the brewery and never stop brewing, even during the world wars. At that time, the brewery played such an important role in the town, the family Bosteels were such influential people that we are not surprised that 3 of the 7 generations have been Town Mayors. In the year 1930’s Antoine Bosteels, 5th generation, carried on the brewing dynasty and played an important role expanding the sales of the Bosteels Pils into other regions such as Ghent, Antwerp and Brussels. His son Ivo Bosteels honored the iconic beer of Pauwel Kwak by bringing it back to the market in 1980; this is the beginning of the strong beers for Brewery Bosteels. In the year 1990, Ivo’s son, Antoine Bosteels, the 7th generation, understood the potential of strong speciality beers and especially the trend for blond ones. Driven by passion of the art of brewing and guided by his creativity, Antoine is at the roots of the succes of Tripel Karmeliet and DeuS Brut des Flandres.",
      image: "/manufacturers/brouwerij_bosteels.jpeg"
    },
    {
      id: 4,
      country_id: "nl",
      name: "Bierbrouwerij De Koningshoeven", // Royal Swinkels
      description: "La Trappe Trappist is genuinely brewed ale from Berkel-Enshot, The Netherlands. It has been brewed within the walls of the Abbey of Our Lady of Koningshoeven since 1884, where the Trappist monks live a life of prayer and work, in peace and quiet, away from the hustle and bustle of everyday life. La Trappe Trappist was awarded the exclusive ‘Authentic Trappist Product’ (ATP) label by the International Trappist Association. This label guarantees that the Trappist ale is brewed under the supervision and responsibility of the monks, within the abbey walls, and that part of the profits are donated to charity. These age-old principles are still respected to this day. The result is an ale brewed in blissful silence with a taste like no other..",
      image: "/manufacturers/bierbrouwerij_de_koningshoeven.jpeg"
    },
    {
      id: 5,
      country_id: "be",
      name: "Abbaye de Leffe", // AbInBev
      description: "Leffe, a brewing tradition since 1240 Founded in 1152, Notre-Dame de Leffe was an abbey of Premonstratensian canons, i.e. monks living in a community characterised by its hospitality. The Leffe abbey in 1740, in its heyday: in the foreground we can see the mill with its half-timbered gable, using the water of the Leffe river. In the background, facing each other, are two enemy fortresses: the Montorgueil tower and the castle of Crevecoeur. A lay master brewer worked for the abbey and made a Leffe beer that was so delicious that the parishioners preferred to drink a Leffe on Sundays rather than go to church. The abbot had to take forceful action. The abbey and the brewery were closed during the French Revolution and seemed to be nothing but a distant memory, until the abbey was re-established in 1929. In 1952 abbot Nys and Albert Lootvoet decided to once again take up the brewing tradition of Leffe with its well-guarded recipe and offer a range of delicious Leffe beers. In the meantime, AB-InBev has taken up the torch and has made a commitment to honour the tradition of the Leffe beer, which has been brewed according to the same recipe since 1240.",
      image: "/manufacturers/abbaye_de_leffe.jpeg"
    },
    {
      id: 6,
      country_id: "ir",
      name: "Guinness", //Diageo
      description: "The Guinness® brand enjoys a global reputation as a uniquely authentic beer and the best-selling stout in the world. Famous for its dark color, creamy head and unique surge and settle, this distinctive beer originated at the St. James’s Gate brewery in Dublin, Ireland. Over 10 million glasses of Guinness beer are enjoyed every single day around the world, and 1.8 billion pints are sold every year. Guinness beer is available in well over 100 countries worldwide and is brewed in almost 50. About Diageo Diageo is a global leader in beverage alcohol with an outstanding collection of brands across spirits, beer and wine categories. These brands include Johnnie Walker, Crown Royal, JεB, Buchanan’s, Windsor and Bushmills whiskies, Smirnoff, Cîroc and Ketel One vodkas, Captain Morgan, Baileys, Don Julio, Tanqueray and Guinness. Diageo is a global company, and our products are sold in more than 180 countries around the world. The company is listed on both the London Stock Exchange (DGE) and the New York Stock Exchange (DEO). For more information about Diageo, our people, our brands, and performance, visit us at www.diageo.com. Visit Diageo’s global responsible drinking resource, www.DRINKiQ.com, for information, initiatives, and ways to share best practice. Celebrating life, every day, everywhere.",
      image: "/manufacturers/guinness_manu.jpeg"
    },
    {
      id: 7,
      country_id: "be",
      name: "Brouwerij der Trappisten van Westmalle",
      description: "For over 200 years, the monks of Westmalle have been choosing to live a life of prayer and work. True to the Rule of Saint Benedict, they ensure their own means of sustenance. For this reason, there is a farm, a cheese dairy and a brewery inside the walls of the Trappist abbey. These three things are deliberately kept to a small scale, and particular care is taken of people and the environment. The brewery’s income is used to make the necessary investments in this respect, to make changes in line with developments in brewing technology, to support Trappist communities and to carry out charity work.",
      image: "/manufacturers/brouwerij_der_trappisten_van_westmalle.jpeg"
    },
    {
      id: 8,
      country_id: "be",
      name: "Brouwerij Van Steenberge",
      description: "The Van Steenberge brewery stands for independence, progress and growth. It emphasises the traditional art of brewing adapted to the current technological developments and guarantees a reliable quality and service. Respect for our employees and care for the environment are central to our policy. Our beers excel because of the craft that created them. They are made according to the traditional rules of the art of brewing with the technology of today. Authentic top beers for the beer lovers of today. Gulden Draak : A unique, Belgian craft beer that is without equal: a strong, dark tripel with secondary fermentation in the bottle. The wine yeast used for the secondary fermentation contributes to the beer’s unparalleled flavour. Augustijn : The historic yeast strains give Augustijn monastery beer its mild, smooth, but very rich flavour. A beer for any occasion that excels when savoured in a relaxed atmosphere. Piraat : The power of Piraat takes you on a journey through some unique flavours based on the brewery's rich traditions. A living beer with a rich past. Set sail! Baptist is brewed on the occasion of the opening of Bar Baptist at the Van Steenberge brewery and as a tribute to Jan Baptist de Bruyne, who founded the brewery in 1784. And many more to discover! www.vansteenberge.com",
      image: "/manufacturers/brouwerij_van_steenberge.jpeg"
    },
    {
      id: 9,
      country_id: "be",
      name: "Brasserie d'Achouffe", // Duvel
      description: "Towards the end of the 1970s, Pierre Gobron and Christian Bauweraerts (two brother-in-laws) decided to create their own beer in their own brewery. With initially only a small amount of money available to them (200.000Bfr, less than 5.000€), they started out on what the fans of the brewery call the ‘Chouffe story’. At the beginning its founders thought of it as a hobby, but the brewery developed at such a rate that, one by one, they decided to devote themselves to the adventure full-time. The first ‘brassin’ (brewing mix) of LA CHOUFFE (49 litres) was finished on 27th August 1982. The elves of Achouffe were impatient to discover new countries, and their Dutch cousins were the first to give them a warm welcome. Even today, the Netherlands is the major destination of Achouffe Beers outside Belgium. Nowadays, more than 20 countries worldwide are supplied with our ‘nectar’ from the Ardennes forests. Coveted international awards have also been received year after year to reward their unique taste. At the end of the summer of 2006 the founders of the Brewery chose to entrust the future of their dear elves to the Duvel Moortgat Brewery. The group’s wish is to invest in Achouffe and to develop the full potential of the Brewery.",
      image: "/manufacturers/brasserie_d_achouffe.jpeg"
    },
    {
      id: 10,
      country_id: "be",
      name: "Brouwerij Haacht Brasserie",
      description: "An independent, family-run brewery for over 125 years. True Belgian craftsmanship. That's Haacht Brewery.",
      image: "/manufacturers/brouwerij_haacht_brasserie.jpeg"
    },
    {
      id: 11,
      country_id: "nl",
      name: "Brouwerij 't IJ", //duvel
      description: "Amsterdam based brewery, brewing beer in a former bathhouse since 1985. All beers are unfiltered and unpasteurised and brewed with our own characteristic yeast.",
      image: "/manufacturers/brouwerij_t_ij.jpeg"
    },
    {
      id: 12,
      country_id: "be",
      name: "Omer Vander Ghinste", 
      description: "When Omer Vander Ghinste started brewing in 1892 in the beautiful West-Flemish village of Bellegem, brand names did not yet exist. He promoted his beers by placing stained glasswindows with the words “Beers Omer Vander Ghinste” in the front windows of the pubs. As these windows were very expensive, it was no option to replace them at every change of generation. Therefore every firstborn son was baptised ‘Omer’. A smart move, with an unexpected effect. A tradition that is still kept alive today, 130 years and 5 generations later.",
      image: "/manufacturers/omer_vander_ghinste.jpeg"
    },
    {
      id: 13,
      country_id: "be",
      name: "Duvel Moortgat",
      description: "It all began when Jan-Léonard Moortgat and his wife founded the Moortgat brewery farm in 1871. Around the turn of the century, Moortgat was one of the over 3,000 breweries operating in Belgium. Jan-Leonard experimented by trial and error, and his top-fermented beers were soon greatly appreciated in the brewery's home town of Puurs and far beyond. Before long, the Brussels bourgeoisie was also won over by his beers. Business was booming and Jan-Leonard's two sons, Albert and Victor, joined the company. There was a clear division of labour: Albert became the brewer, Victor was responsible for delivering the beer to Brussels by horse and dray. In 1923 the production of Duvel began with just a few crates. Today, Duvel is enjoyed literally all around the world (in over 50 countries) by countless beer lovers. The beer is still brewed with profound respect for the original recipe and the time it needs to mature.",
      image: "/manufacturers/duvel_moortgat.jpeg"
    },
    {
      id: 14,
      country_id: "be",
      name: "Delirium - Huyghe Brewery",
      description: "Huyghe Brewery is one of Belgium’s renowned brewers that focuses on speciality Beers and Premium Brands. Huyghe Brewery is the proud owner of the Delirium brand, Averbode abbey beer, La guillotine Gold Blond multigrain, Mongozo gluten free beer and many more. We focus on quality products and we strongly believe in renewable energy and corporate social responsibility. Which led us to be the Most Sustainable Belgium Family Brewer. Today, Delirium is served and enjoyed all over the world. And we believe that the Pink Elephant will keep on growing!",
      image: "/manufacturers/delirium_huyghe_brewery.jpeg"
    },
    {
      id: 15,
      country_id: "nl",
      name: "Texelse Bierbrouwerij", //heineken
      description: "Daar waar twee zeeën samenkomen in een robuust klimaat, brouwen wij ons bier. Daar ligt ons eiland. Met onze kop in de wind doen we het gewoon op onze manier. Onze ingrediënten hebben karakter. Dat proef je in elke slok van ons bier en ervaar je in onze Texelse bierbrouwerij: daar komt alles samen. Wij zijn trots op ons eiland én ons bekroonde bier. Gebrouwen met ambacht, een goudeerlijke mentaliteit en een dosis eigenzinnigheid. Heerlijke schuimende Texels speciaalbieren die stuk voor stuk de moeite waard zijn. Dat gunnen we iedereen!",
      image: "/manufacturers/texelse_bierbrouwerij.jpeg"
    },
    {
      id: 16,
      country_id: "nl",
      name: "Lidl Nederland", 
      description: "Lidl Nederland is een brouwerij uit Huizen, Netherlands. Zij zijn het meest bekend van het bier Kordaat Pilsener maar ook Mexican Style With Non-alcoholic Beer komt uit deze brouwerij.",
      image: "/manufacturers/lidl.jpeg"
    },
    {
      id: 17,
      country_id: "be",
      name: "Brouwerij Alken-Maes", //heineken
      description: "Alken-Maes was created out of the 1988 merger of two small breweries, Maes, located in Waarloos and Alken. Alken-Maes has now become the number two on the Belgian market. Its headquarters are in Waarloos.",
      image: "/manufacturers/brouwerij_alkenmaes.jpeg"
    },
    {
      id: 18,
      country_id: "nl",
      name: "Amstel Bier", //heineken
      description: "Bij Amstel brouwen we al bijna 145 jaar geweldig bier, in uiteenlopende varianten voor verschillende seizoenen en speciale gelegenheden. Bier om samen iets te vieren of ergens bij stil te staan, om met elkaar bij te praten of juist lol te trappen. Amstel bier wordt sinds 1870 met liefde gebrouwen voor al die onvergetelijke momenten in het leven.",
      image: "/manufacturers/amstel_bier.jpeg"
    },
    {
      id: 19,
      country_id: "nl",
      name: "Apple Bandit Cider", 
      description: "In het leven moet je pakken wat je pakken kan. Niks te zoet, niks te geduldig. Gewoon genieten. Hetzelfde geldt voor cider. Daarom pikt Apple Bandit er de beste appels tussenuit. Dit zorgt voor onze pure en verfrissende smaak. Drink Apple Bandit koud in een glas met veel ijs.",
      image: "/manufacturers/apple_bandit_cider.jpeg"
    },
    {
      id: 20,
      country_id: "be",
      name: "Brouwerij Hoegaarden", 
      description: "Perhaps they had too much time on their hands. Or they were sick of the sacramental wine. Maybe it was divine inspiration? We’ll never know for sure. What we do know is that the Hoegaarden monks were the first to discover the unique recipe for wheat beer around 1445.",
      image: "/manufacturers/brouwerij_hoegaarden.jpeg"
    },
    {
      id: 21,
      country_id: "nl",
      name: "Gulpener Bierbrouwerij", 
      description: "'De Vrije Brouwer' Al sinds 1825 beheersen we de kunst om smaken en aroma’s samen te brengen in bieren met een uitgesproken karakter. Uitgesproken omdat we vrij zijn. Vrij om bieren te brouwen zoals wij vinden dat ze horen te smaken. Puur, rijk en verfijnd.",
      image: "/manufacturers/gulpener_bierbrouwerij.jpeg"
    },
    {
      id: 22,
      country_id: "ir",
      name: "Magners Irish Cider", 
      description: "Our ciders are made from 17 varieties of Irish apples and produced in Clonmel, County Tipperary, Ireland, making Magners the Original Irish cider. From blossom to bar, at every step of the journey, craft and care is poured into every glass.",
      image: "/manufacturers/magners_irish_cider.jpeg"
    },
    {
      id: 23,
      country_id: "be",
      name: "Affligem Brouwerij", 
      description: "For years already, the Flemish village of Opwijk (pronounced Op-wike) is known as the home of a brewery that made its first mark in 1935. This is when Op-Ale, the happy amber beer, was launched and immediately adopted by beer drinkers far and wide. Did you know that it even received a gold medal at the Luxemburg international fair of 1951. And that in the region of Opwijk, the brewery is still immediately associated with the “Speciale Op-Ale”",
      image: "/manufacturers/affligem_brouwerij.jpeg"
    },
    {
      id: 24,
      country_id: "be",
      name: "Brouwerij Malheur", 
      description: "Brewery Malheur is an independent, family brewery. The brewery’s old vaulted cellar and the antique coolship, a large shallow pan into which the wort is poured to quickly cool it, are witnesses of the brewery’s rich past. The blonde Malheur beers are brewed according to an old traditional method with barley, hops and yeast but hypermodern equipment is now used in the process. The brown Malheur beers are brewed according to an old Flemish tradition with hops and spices.",
      image: "/manufacturers/brouwerij_malheur.jpeg"
    },
    {
      id: 25,
      country_id: "ge",
      name: "Warsteiner", 
      description: "Warsteiner beer is brewed in the Arnsberg Forest Nature Park outside of Warstein, North Rhine-Westphalia, Germany.",
      image: "/manufacturers/warsteiner.jpeg"
    },
    {
      id: 26,
      country_id: "ge",
      name: "Brauerei VELTINS", 
      description: "In 1824 a small country brewery in Grevenstein, Germany, began brewing beer conforming to the German Purity Law. Over 180 years later it had evolved into one of the most modern private breweries in Europe: C. & A. VELTINS. This unique success story behind the family run company, now in the fifth generation, is based on investment strength, farsighted enterprise, and a corporate culture moulded by both team spirit and the highest quality claims in equal measure. To this very day, this premium beer is still being brewed exclusively from the highest quality ingredients.",
      image: "/manufacturers/brauerei_veltings.jpeg"
    },
    {
      id: 27,
      country_id: "be",
      name: "Brouwerij Het Anker", 
      description: "Het Anker continuously strives for an authentic and unique taste experience. Through our age-old history we developed into an internationally noted brewery. We mainly thank that success to our authenticity. To this day we use traditional recipes as the foundation of our brewing process and a variety of hops and herbs that give our beers that characteristic taste and aroma. Stop by, and discover how we – as one of the oldest breweries in Belgium (1471) - preserved the authenticity of far-off days.",
      image: "/manufacturers/brouwerij_het_anker.jpeg"
    },
    {
      id: 28,
      country_id: "be",
      name: "Brasserie de Brunehaut", 
      description: "In 1890 the Allard family brewery based in Guignies Brunhild , then called Brasserie St Joseph . It is known in the region for brewed beers as The Druid and Brunhilda 8 °. ",
      image: "/manufacturers/brunehaut.jpeg"
    },
    {
      id: 29,
      country_id: "nl",
      name: "Brouwerij De 7 Deugden", 
      description: "Brouwerij de 7 Deugden is een sociale onderneming. Hier worden heerlijke bieren gebrouwen door mensen voor wie op dit moment een baan ergens anders niet vanzelfsprekend is. Bijzonder getalenteerde mensen die bij de brouwerij een gewone baan hebben gevonden. Hiermee wil de brouwerij een voorbeeld en bron van inspiratie zijn voor andere ondernemingen. Want wij vinden dat iedereen bijzonder is. En de liefhebbers van ons bier dragen een steentje bij waardoor wij zoveel mogelijk mensen een kans op een gewone baan kunnen geven. Om zelfvertrouwen te krijgen en weer mee te doen in onze samenleving. Voor sommigen heel bijzonder, voor ons heel gewoon.",
      image: "/manufacturers/7_deugden.jpeg"
    },
    {
      id: 30,
      country_id: "nl",
      name: "Jopen", 
      description: "Dutch = Open; Dutch Craft Beer = Jopen. We believe that everyone has a craft side and that there’s an exceptional Jopen craft beer out there with your name on it. ´The mind is like a parachute. It doesn´t work if it's not open.´ - Frank Zappa",
      image: "/manufacturers/jopen.jpeg"
    },
    {
      id: 31,
      country_id: "be",
      name: "Brouwerij St.Bernardus", 
      description: "In the heart of the West Flemish hop district, we brew a truly inspiring beer that fancies a lot of beer lovers. Special top-fermented dark and light beers have been produced in our establishment ever since 1946, and they are acclaimed as the best in the world. Visitors can stay overnight in Guesthouse Brouwershuis and have the opportunity to undertake a Brewery tour, rent an e-bike and sample to their heart's delight our delicious beers in our brand new rooftop bar ‘Bar Bernard’, offering marvelous 360° panoramic views of the area. This bar makes part of the new visitors’ centre we’ve opened in August 2018. And to top it all off, in the brand new beer shop visitors can buy their ‘heavenly nectar’ to take home.",
      image: "/manufacturers/bernardus.jpeg"
    },
    {
      id: 32,
      country_id: "nl",
      name: "Lux Brewery", 
      description: "Lux Brewery is a Dutch craft brewery which started in 2014 in Eindhoven. As a brewery we aim to make nice, exceptional beers for the real beer lovers!",
      image: "/manufacturers/lux.jpeg"
    },
    {
      id: 33,
      country_id: "be",
      name: "Abbaye de Maredsous", //duvel 
      description: "The Maredsous Abbey stands for values such as patience, devotion and hospitality. Those values still live in the beers we brew. Past and present merge in our abbey, adding to its appeal. The Maredsous beers represent the rich Benedictine tradition. Maredsous's three abbey ales stand out because of their refined flowery-fruity aroma and delicate sparkle. These ales undergo natural refermentation in the bottle, meaning the beer matures further in the bottle.",
      image: "/manufacturers/maredsous.jpeg"
    },
    {
      id: 34,
      country_id: "nl",
      name: "Zuyd Craft", 
      description: "A Flavour Company #maastrichtmade #zuydcraft #zuydhype",
      image: "/manufacturers/zuyd.jpeg"
    },
    {
      id: 35,
      country_id: "be",
      name: "Brouwerij Liefmans", //duvel
      description: "The story of Liefmans began in the 17th century, when Jacobus Liefmans set up business as a brewer in Oudenaarde. The building on Aalststraat, on the banks of the River Schelde, has now been standing for more than 300 years. The original brewing apparatus has been retained and forms part of a living museum. It was around 1900 that Liefmans started filling maturation tanks with black cherries, on a small scale. Local farmers brought their excess crops of black cherries to Liefmans and swapped them for beer. The taste and colour of this cherry beer has undergone a metamorphosis since then.",
      image: "/manufacturers/liefmans.jpeg"
    },
    {
      id: 36,
      country_id: "ge",
      name: "Bayerische Staatsbrauerei Weihenstephan", 
      description: "The Bavarian State Brewery Weihenstephan, founded in 1040, is the oldest continuously operating brewery in the world. Being owned by the Free State of Bavaria, it is run as a modern company brewing beers of the highest quality successfully selling them in more than 50 countries worldwide.",
      image: "/manufacturers/weihenstephan.jpeg"
    },
    {
      id: 37,
      country_id: "nl",
      name: "Royal Swinkels", 
      description: "We are Royal Swinkels. A global family business of maltsters and brewers. We have steered a bold and independent course for over 300 years.",
      image: "/manufacturers/royal_swinkels.jpeg"
    },
    {
      id: 38,
      country_id: "nl",
      name: "René van Waelsden", 
      description: "Zelf gebrouwen door thuis brouwer én oom; René van Waelsden",
      image: "/manufacturers/waelsden.jpg"
    },
    {
      id: 39,
      country_id: "nl",
      name: "SQWZ Drinks", 
      description: "SQWZ- Drinks worth the squeeze- healthier alternative drinks especially for consumers who are looking for drinks with a great taste but without the calories. SQWZ is low in calories and sugars, organic, and made with fresh, high-quality, natural ingredients without unnecessary additives. Perfect for anyone who wants to enjoy in a conscious way.",
      image: "/manufacturers/sqwz.jpg"
    },
    {
      id: 40,
      country_id: "nl",
      name: "Butcha", 
      description: "Probeer maar eens een alcoholvrije drank te vinden. Dat is waar Jiri Brandt (bekend van Brandt & Levie) en Siewerd Nicolai het Butcha-avontuur zijn aangegaan. Een gebrouwen frisdrank die echt voldoet aan de normen van goede smaak.",
      image: "/manufacturers/butcha.jpg"
    },
    {
      id: 41,
      country_id: "nl",
      name: "Batu", 
      description: "BATU kombucha is geen snel geproduceerde frisdrank. Het wordt ambachtelijk, met échte aandacht in kleine handgemaakte batches gemaakt in de meest duurzame brouwerij van Europa.",
      image: "/manufacturers/batu.jpeg"
    },
    {
      id: 42,
      country_id: "us",
      name: "The Coca-Cola Company", 
      description: "The Coca-Cola Company is an American multinational corporation founded in 1892. It produces Coca-Cola. The drink industry company also manufactures, sells, and markets other non-alcoholic beverage concentrates and syrups, and alcoholic beverages.",
      image: "/manufacturers/coca.jpeg"
    },
    {
      id: 43,
      country_id: "nl",
      name: "RedBull Nederland", 
      description: "Geïnspireerd door de functionele drankjes uit het Verre Oosten, richtte Dietrich Mateschitz halverwege de jaren '80 Red Bull op. Hij ontwikkelde niet alleen een nieuw product , maar lanceerde ook een uniek marketingconcept. Bovendien werd bij de presentatie van Red Bull Energy Drink op 1 april 1987 in Oostenrijk een compleet nieuwe productcategorie geboren: de energiedranken.",
      image: "/manufacturers/redbull_ned.jpeg"
    },
    {
      id: 44,
      country_id: "us",
      name: "PepsiCo", 
      description: "PepsiCo, Inc. is an American multinational food, snack, and beverage corporation headquartered in Harrison, New York, in the hamlet of Purchase. PepsiCo's business encompasses all aspects of the food and beverage market. It oversees the manufacturing, distribution, and marketing of its products. PepsiCo was formed in 1965 with the merger of the Pepsi-Cola Company and Frito-Lay, Inc., PepsiCo has since expanded from its namesake product Pepsi Cola to an immensely diversified range of food and beverage brands.",
      image: "/manufacturers/pepsi.jpeg"
    },
    {
      id: 45,
      country_id: "ch",
      name: "Rivella", 
      description: "",
      image: "/manufacturers/rivella.jpeg"
    },
    {
      id: 46,
      country_id: "sp",
      name: "Viñas del Vero", 
      description: "At our winery, we combine tradition and innovation to make wines that are unique and different. Our passion for wine and our commitment have earned us national and international recognition, making us a benchmark for innovation in the winemaking world.",
      image: "/manufacturers/vinas.jpeg"
    },
    {
      id: 47,
      country_id: "sp",
      name: "Juan Ramón Lozano", 
      description: "Our journey began in 1853, when the Lozano family planted their first vineyards in Villarrobledo, mainly of the Aíren variety, native to the area. Since then, four generations have led a solid and continuous path of learning. Our testimony is the commitment and a tribute to the effort, constant work, tenacity and discretion that have characterized our family for more than 160 years, when we began to grow vineyards and produce quality wines.",
      image: "/manufacturers/lozano.jpeg"
    },
    {
      id: 48,
      country_id: "sc",
      name: "Frontera", 
      description: "In a world where everyone seems to be busy thinking about in the past and the future, we exist to make you enjoy your present intensely.",
      image: "/manufacturers/frontera.PNG"
    },
    {
      id: 49,
      country_id: "sa",
      name: "Cimarosa", 
      description: "A wine-ward way of life for Corry and Dino means a “refuge of relaxation” in the mountains where the closest connections with the outside world are the family’s four legged friends, Galileo and Tobias.",
      image: "/manufacturers/cimarosa.jpeg"
    },
    {
      id: 50,
      country_id: "sa",
      name: "Welmoed", 
      description: "Located in Stellenbosch, Welmoed celebrates centuries of winemaking tradition. The farm of Welmoed was first granted to Governor Simon van der Stel in 1690, and over the years, many great wines have been produced in the Welmoed cellar. This approachable range offers value-driven, quality wines for any occasion. The winemaking team still produces these wines with respect to Welmoed heritage.",
      image: "/manufacturers/welmoed.png"
    },
    {
      id: 51,
      country_id: "au",
      name: "Johann Quest", 
      description: "",
      image: null
    },
  ];
}

function getBeerStyles() : BeerStyle[] {
  return [
    {
      id: 1,
      name: "Lager",
      color: "fad96f"
    },
    {
      id: 2,
      name: "Weizen",
      color: "fad96f"
    },
    {
      id: 3,
      name: "Tripel",
      color: "eebc42"
    },
    {
      id: 4,
      name: "Blond",
      color: "f7d360"
    },
    {
      id: 5,
      name: "Quadrupel",
      color: "c06202"
    },
    {
      id: 6,
      name: "Dubbel",
      color: "d77e00"
    },
    {
      id: 7,
      name: "Gekruid",
      color: "e59419"
    },
    {
      id: 8,
      name: "Stout",
      color: "380e0f"
    },
    {
      id: 9,
      name: "Sterk Blond",
      color: "f7d360"
    },
    {
      id: 10,
      name: "Tarwe",
      color: "4a1615"
    },
    {
      id: 11,
      name: "Radler",
      color: "fde8a1"
    },
    {
      id: 12,
      name: "Pilsner",
      color: "fad96f"
    },
    {
      id: 13,
      name: "Fruit",
      color: "d81946"
    },
    {
      id: 14,
      name: "Cider",
      color: "e7c899"
    },
    {
      id: 15,
      name: "Wit",
      color: "f8c059"
    },
    {
      id: 16,
      name: "IPA",
      color: "d36429"
    },
    {
      id: 17,
      name: "Bock",
      color: "983b22"
    },
    {
      id: 18,
      name: "Dark Ale",
      color: "4a1615"
    },
    {
      id: 19,
      name: "Ale",
      color: "f5ad3a"
    }
  ];
}

function getBeers() : BeerQuery[] {
  return [
    {
      slug: "kordaat_0",
      name: "Kordaat 0.0",
      abv: 0,
      ibu: 0,

      manufacturer: {connect: { id: 16}},
      style: {connect: { id: 12}},

      description: "Kordaat Premium Pilsener heeft een toegankelijke, frisse smaak met een aangename bittere afdronk.",
      image: "/beers/kordaat_0.jpeg",
      link: "https://untappd.com/b/lidl-nederland-kordaat-0-0/3359630",

      gluten: true,
      lactose: false,
      organic: false
    }, 
    {
      slug: "waelsden_knoeer",
      name: "Waelsden Knoeër",
      abv: 10,
      ibu: 20,

      manufacturer: {connect: { id: 38}},
      style: {connect: { id: 19}},

      description: "Waelsden Knoeër gebrouwen door thuis brouwer én oom; René van Waelsden.",
      image: "/beers/waelsden_knoeer.jpg",
      link: null,

      gluten: true,
      lactose: false,
      organic: false
    }, 
    {
      slug: "waelsden_tripel",
      name: "Waelsden Tripel",
      abv: 8,
      ibu: 0,

      manufacturer: {connect: { id: 38}},
      style: {connect: { id: 3}},

      description: "Waelsden Tripel gebrouwen door thuis brouwer én oom; René van Waelsden.",
      image: "/beers/waelsden_tripel.jpg",
      link: null,

      gluten: true,
      lactose: false,
      organic: false
    }, 
    {
      slug: "sabor_tequila_camaro",
      name: "Sabor Tequila Camaro",
      abv: 5.9,
      ibu: 0,

      manufacturer: {connect: { id: 16}},
      style: {connect: { id: 1}},

      description: "The gold color, the full body and the unexpected kick of the sweet tequila flavor. That’s what makes this beer your favorite friend through the night.",
      image: "/beers/sabor_tequila_camaro.jpeg",
      link: "https://untappd.com/b/lidl-nederland-sabor-tequila-camaro/2841440",

      gluten: true,
      lactose: false,
      organic: false
    }, 
    {
      slug: "bavaria_gluten_free",
      name: "Bavaria Gluten Free",
      abv: 5,
      ibu: 25,

      manufacturer: {connect: { id: 37}},
      style: {connect: { id: 12}},

      description: "Bavaria Pilsener 5% Glutenvrij is een goed doordrinkbaar, helder lichtblond glutenvrij pils, met een verfrissende smaak en een aangename lichte bitter in de afdronk.",
      image: "/beers/bavaria_gluten_free.jpeg",
      link: "https://untappd.com/b/royal-swinkels-bavaria-gluten-free/1808623",

      gluten: false,
      lactose: false,
      organic: false
    }, 
    {
      slug: "weihenstephaner_hefeweissbier",
      name: "Weihenstephaner Hefeweissbier",
      abv: 5.4,
      ibu: 14,

      manufacturer: {connect: { id: 36}},
      style: {connect: { id: 15}},

      description: "Our golden-yellow wheat beer, with its fine-pored white foam, smells of cloves and impresses consumers with its refreshing banana flavour. It is full bodied and with a smooth yeast taste. To be enjoyed at any time (always a pleasure / enjoyment), goes excellently with fish and seafood, with spicy cheese and especially with the traditional Bavarian veal sausage. Brewed according to our centuries-old brewing tradition on the Weihenstephan hill.",
      image: "/beers/weihenstephaner_hefeweissbier.jpeg",
      link: "https://untappd.com/b/bayerische-staatsbrauerei-weihenstephan-weihenstephaner-hefeweissbier/8745",

      gluten: true,
      lactose: false,
      organic: false
    }, 
    {
      slug: "fruitesse",
      name: "Fruitesse",
      abv: 3.8,
      ibu: 10,

      manufacturer: {connect: { id: 35}},
      style: {connect: { id: 13}},

      description: "Enjoy the fresh, intense flavour of strawberries, raspberries, black cherries, elderberries and blueberries.",
      image: "/beers/fruitesse.jpeg",
      link: "https://untappd.com/b/brouwerij-liefmans-fruitesse/9085",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "saga_10",
      name: "Saga 10",
      abv: 10,
      ibu: 15,

      manufacturer: {connect: { id: 34}},
      style: {connect: { id: 5}},

      description: "Sometimes you just want to go back in time, to discover the worlds untold heroic stories and myths. That is why we created this legendary Quadruple, to rewrite the forgotten tales of the past. Warm, rich and legendary.",
      image: "/beers/saga_10.jpeg",
      link: "https://untappd.com/b/zuyd-craft-saga-10/4292161",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "maredsous_tripel",
      name: "Maredsous Tripel",
      abv: 10,
      ibu: 20,

      manufacturer: {connect: { id: 33}},
      style: {connect: { id: 3}},

      description: "Maredsous Tripel is a golden-bodied Belgian triple, redolent with festive sparkle, creamy body and a luscious head. Its elegant smoothness belies the strong alcohol content. You'll revel in its balanced, long, and warming finish.",
      image: "/beers/maredsous_tripel.jpeg",
      link: "https://untappd.com/b/abbaye-de-maredsous-maredsous-triple-tripel/7768",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "luxe_quadrupel",
      name: "Luxe Quadrupel",
      abv: 10,
      ibu: 0,

      manufacturer: {connect: { id: 32}},
      style: {connect: { id: 5}},

      description: "Een zwaar, moutig bier met een rijke, volle smaak die eindigt in een licht bittere afdronk",
      image: "/beers/luxe_quadrupel.jpeg",
      link: "https://untappd.com/b/lux-brewery-luxe-quadrupel/873375",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "abt_12",
      name: "Abt 12",
      abv: 10,
      ibu: 20,

      manufacturer: {connect: { id: 31}},
      style: {connect: { id: 5}},

      description: "St.Bernardus Abt 12 is a dark beer of top fermentation with a robust head that is ivory in colour. It has a very fruity aroma that is the result of using our own unique yeast. It brims over with different, complex tastes and stands out through its long, bittersweet finish. It is an ideal partner for rich beef dishes and recipes with game. It also forms a perfect match with blue cheese and chocolate.",
      image: "/beers/abt_12.jpeg",
      link: "https://untappd.com/b/brouwerij-st-bernardus-abt-12/6760",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "la_trappe_witte_trappist",
      name: "La Trappe Witte Trappist",
      abv: 7,
      ibu: 22,

      manufacturer: {connect: { id: 4}},
      style: {connect: { id: 15}},

      description: "Light-blonde, cloudy with a firm and long-lasting head. The aroma is slightly sour and refreshing due to the use of wheat malt combined with a floral and fruity (citrus, peach, apricot) hop aroma. The flavour is smooth, malty, lightly sour with a tingling sensation due to the carbonation. The aftertaste is bitter and dry. A consistently drinkable, refreshing thirst quencher.",
      image: "/beers/la_trappe_witte_trappist.jpeg",
      link: "https://untappd.com/b/bierbrouwerij-de-koningshoeven-la-trappe-witte-trappist/17860",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "piraat",
      name: "Piraat",
      abv: 10.5,
      ibu: 23,

      manufacturer: {connect: { id: 8}},
      style: {connect: { id: 19}},

      description: "This light amber coloured Piraat with full foam head overwhelms with an aroma of bitter, spicy, malty and alcoholic scents. What follows is a perfect combination of malty, sweet and hopbitter tastes, after which you are drowned in a very long, semi-sweet after taste with bitter undertone.",
      image: "/beers/piraat.jpeg",
      link: "https://untappd.com/b/brouwerij-van-steenberge-piraat/11561",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "brut_uiteinde",
      name: "Brut Uiteinde",
      abv: 6.5,
      ibu: 30,

      manufacturer: {connect: { id: 30}},
      style: {connect: { id: 16}},

      description: "Make this year's end a sparkling one with this bubbly Brut IPA. The yeasted sugars give this IPA gets its dry ‘Brut’ character. Expect fresh flavors of white grapes.",
      image: "/beers/brut_uiteinde.jpeg",
      link: "https://untappd.com/b/jopen-brut-uiteinde/4030718",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "dubbel_dik",
      name: "Dubbel Dik",
      abv: 6.5,
      ibu: 0,

      manufacturer: {connect: { id: 29}},
      style: {connect: { id: 6}},

      description: "Onze nieuwe Dubbel met een vleugje steranijs",
      image: "/beers/dubbel_dik.jpeg",
      link: "https://untappd.com/b/brouwerij-de-7-deugden-dubbel-dik/4340647",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "brunehaut_triple",
      name: "Brunehaut Triple",
      abv: 8,
      ibu: 25,

      manufacturer: {connect: { id: 28}},
      style: {connect: { id: 19}},

      description: "The flavour is full of freshness despite the alcohol content. Then there is the strong side, it is full, fat and long. Nevertheless elegance remains at the end. Neither too sugary nor excessive caramel. A beer to drink with some hard cheeses, a young Comté with a fruity balance.",
      image: "/beers/brunehaut_triple.jpeg",
      link: "https://untappd.com/b/brasserie-de-brunehaut-brunehaut-triple-organic-and-gluten-free/351081",

      gluten: false,
      lactose: false,
      organic: true
    },
    {
      slug: "gouden_carolus_whisky_infused",
      name: "Gouden Carolus Whisky Infused",
      abv: 11.7,
      ibu: 15,

      manufacturer: {connect: { id: 27}},
      style: {connect: { id: 18}},

      description: "Gouden Carolus Cuvée van de Keizer Imperial Dark was enriched by an infusion of Gouden Carolus Single Malt whisky. The result is a unique beer: powerful and full-bodied, with subtle touches of vanilla, oak and chocolate. An imperial brew to cherish and enjoy in moderation.",
      image: "/beers/gouden_carolus_whisky_infused.jpeg",
      link: "https://untappd.com/b/brouwerij-het-anker-gouden-carolus-whisky-infused/2055873",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "grevensteiner_dunkles_bockbier",
      name: "Grevensteiner Dunkles Bockbier",
      abv: 6.8,
      ibu: 0,

      manufacturer: {connect: { id: 26}},
      style: {connect: { id: 17}},

      description: "Veltins Grevensteiner Dunkles bockbier is een natuurlijk troebele, donkere bierspecialiteit. Qua smaak maakt het krachtige sterke bier indruk met zijn volle en tegelijkertijd smakelijke karakter. Het Grevensteiner Bockbier is op het eerste gezicht iets bijzonders. Het mahoniekleurige bier is zijdemat en troebel, het is doordrongen van amberkleurige reflecties en overgoten met een fluweelzacht, zacht schuim.",
      image: "/beers/grevensteiner_dunkles_bockbier.jpeg",
      link: "https://untappd.com/b/brauerei-veltins-grevensteiner-dunkles-bockbier/4508128",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "zwoele_zomernacht",
      name: "Botanical Blast - Zwoele Zomernacht",
      abv: 3.8,
      ibu: 0,

      manufacturer: {connect: { id: 21}},
      style: {connect: { id: 7}},

      description: "Frisse dorstlesser met tonen van citrusfruit, verse yuzu en gember.",
      image: "/beers/zwoele_zomernacht.jpeg",
      link: "https://untappd.com/b/gulpener-bierbrouwerij-botanical-blast-zwoele-zomernacht/4790919",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "warsteiner_winter",
      name: "Warsteiner Winter",
      abv: 5.6,
      ibu: 20,

      manufacturer: {connect: { id: 25}},
      style: {connect: { id: 1}},

      description: "A seasonal, full-bodied winter beer with a warm and rich copper-red amber color. A satisfying malty taste sensation masterfully balanced with subtle hoppy bitterness. A perfect fit for celebrating the Winter season.",
      image: "/beers/warsteiner_winter.jpeg",
      link: "https://untappd.com/b/warsteiner-warsteiner-weihnacht-winter/825375",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "malheur_10",
      name: "Malheur 10",
      abv: 10,
      ibu: 32,

      manufacturer: {connect: { id: 24}},
      style: {connect: { id: 9}},

      description: "Malheur 10° is also called Malheur Millennium (MM). MM is the year 2000 in Roman numerals. This beer was actually introduced to the market in the year 2000. Beer connoisseur Michael Jackson (The Beer Hunter www.beerhunter.com) describes the aroma of the blonde Malheur 10° as “a pinkish peach with notes of spicy orange and lemon peel. The beer literally boasts a bright yellow colour and a rich honey texture, it is somewhat oily too but with incredible body and a bitter sour note in the warm aftertaste. In short this blonde tasting beer that contains 10% alcohol by volume will delight beer enthusiasts the world over”.",
      image: "/beers/malheur_10.jpeg",
      link: "https://untappd.com/b/brouwerij-malheur-malheur-10-millennium/1939",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "postel_dubbel",
      name: "Postel Dubbel",
      abv: 7,
      ibu: 0,

      manufacturer: {connect: { id: 23}},
      style: {connect: { id: 6}},

      description: "Postel Dubbel is een klassieke Belgische stijl Dubbel. Postel Dubbel is een stevig en zoet bier. Tonen van rozijnen, karamel, bruine suiker en gedroogd fruit. Roodbruin van kleur en helder in het zicht. Het bier heeft een redelijk lange, zoete nasmaak.",
      image: "/beers/postel_dubbel.jpeg",
      link: "https://untappd.com/b/affligem-brouwerij-postel-dubbel/27871",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "magners_original_irish_cider",
      name: "Magners Original Irish Cider",
      abv: 4.5,
      ibu: 0,

      manufacturer: {connect: { id: 22}},
      style: {connect: { id: 14}},

      description: "When William Magner set out to make Ireland’s greatest cider in 1935, this is what he came up with. We’ve barely changed it since then, but why would we? Made with 17 different varieties of fallen apple, pressed and then kept in the dark to mature for a couple of years, it is the crispest way to celebrate any moment.",
      image: "/beers/magners_original_irish_cider.jpeg",
      link: "https://untappd.com/b/magners-irish-cider-magners-original-irish-cider/5879",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "grimbergen_blond",
      name: "Grimbergen Blond",
      abv: 6.7,
      ibu: 22,

      manufacturer: {connect: { id: 17}},
      style: {connect: { id: 4}},

      description: "When the first regular breweries were founded in the Middle Ages, beer filtration was not a common technology and few mastered it. Among these few were the Fathers of Grimbergen Abbey, who became renowned experts in craft brewing. Their masterpiece was the filtrated Grimbergen Blonde – a pure, smooth, blonde ale with ripe fruit flavours and no cloudiness – that stood out from other beers of the time. Today, it’s still an insider tip among beer connoisseurs around the world.",
      image: "/beers/grimbergen_blond.jpeg",
      link: "https://untappd.com/b/brouwerij-alken-maes-grimbergen-blonde/2",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "amstel_radler_2",
      name: "Amstel Radler 2.0",
      abv: 2,
      ibu: 0,

      manufacturer: {connect: { id: 18}},
      style: {connect: { id: 11}},

      description: "De natuurlijke mix van Amstel bier en citroenwater. Amstel Radler is dubbel verfrissend en bevat 2% alcohol. Lekker voor na het sporten of een andere inspanning.",
      image: "/beers/amstel_radler_2.jpeg",
      link: "https://untappd.com/b/amstel-bier-amstel-radler-2-0-citroen/329449",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "frisse_duik",
      name: "Frisse Duik",
      abv: 0.3,
      ibu: 0,

      manufacturer: {connect: { id: 21}},
      style: {connect: { id: 16}},

      description: "Gulpener Frisse Duik is een Frisse en sprankelende alcoholarme IPA met hoppig karakter.",
      image: "/beers/frisse_duik.jpeg",
      link: "https://untappd.com/b/gulpener-bierbrouwerij-frisse-duik/4886232",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "hoegaarden_wit",
      name: "Hoegaarden Wit",
      abv: 4.9,
      ibu: 15,

      manufacturer: {connect: { id: 20}},
      style: {connect: { id: 15}},

      description: "500 years of hard work went into making this beer that features the aroma of orange peel, coriander and herbs that the merry monks imported from sunny Curacao. Speaking of which: pouring Hoegaarden is just like letting the sun fall into your glass: light yellow and naturally murky. And the soft foam adds a cloudy finish. And then there’s the soft taste, light and slightly sweet and sour and with subtle citrus notes… ah, just go ahead and taste it instead of reading about it!",
      image: "/beers/hoegaarden_wit.jpeg",
      link: "https://untappd.com/b/brouwerij-hoegaarden-hoegaarden-wit-blanche/6422",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "desperados_original",
      name: "Desperados Original",
      abv: 5.9,
      ibu: 0,

      manufacturer: {connect: { id: 1}},
      style: {connect: { id: 1}},

      description: "Desperados is the world's first Tequila Flavoured Beer. A distinctive combination of full bodied lager with a kick of Tequila flavour. A light & refreshing taste profile balanced with spicy and lemony notes for sweetness.",
      image: "/beers/desperados_original.jpeg",
      link: "https://untappd.com/b/desperados-nl-desperados-original/5997",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "classic_apple_cider",
      name: "Classic Apple Cider",
      abv: 4.5,
      ibu: 0,

      manufacturer: {connect: { id: 19}},
      style: {connect: { id: 14}},

      description: "Apple Bandit Classic Apple is een frisse appelcider met een natuurlijke, lichtdroge smaak.",
      image: "/beers/classic_apple_cider.jpeg",
      link: "https://untappd.com/b/apple-bandit-cider-classic-apple/2567984",

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      slug: "amstel_rose",
      name: "Amstel Rosé",
      abv: 4,
      ibu: 0,

      manufacturer: {connect: { id: 18}},
      style: {connect: { id: 13}},

      description: "Amstel presenteert vol trots: Amstel Rosé! Een fruitig rosébier met een zacht alcoholgehalte van 4% en de heerlijke smaak van bosbessen, kersen en frambozen. De frisse keuze om mee te proosten op onvergetelijke momenten met vrienden!",
      image: "/beers/amstel_rose.jpeg",
      link: "https://untappd.com/b/amstel-bier-amstel-rose/5383107",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "grimbergen_tripel",
      name: "Grimbergen Tripel",
      abv: 9,
      ibu: 5,

      manufacturer: {connect: { id: 17}},
      style: {connect: { id: 3}},

      description: "The pale malts used give this tripel its deep, ocher colour. Grimbergen Tripel has a bittersweet, spicy and extremely round flavor. The typical spicyness is created by using blonde candy sugar and the subtle mix of soft and bitter hop varieties.The secondary fermentation gives the flavour bouquet a perfect harmony. You'll especially appreciate the perfect aftertaste of this beer.",
      image: "/beers/grimbergen_tripel.jpeg",
      link: "https://untappd.com/b/brouwerij-alken-maes-grimbergen-tripel-triple/9711",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "grimbergen_dubbel",
      name: "Grimbergen Dubbel",
      abv: 6.5,
      ibu: 22,

      manufacturer: {connect: { id: 17}},
      style: {connect: { id: 6}},

      description: "Double has undergone two fermentations, which gives this ale a chocolatey, toffee taste with a warming brandy-like finish.",
      image: "/beers/grimbergen_dubbel.jpeg",
      link: "https://untappd.com/b/brouwerij-alken-maes-grimbergen-dubbel/7364",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "la_trappe_dubbel",
      name: "La Trappe Dubbel",
      abv: 7,
      ibu: 22,

      manufacturer: {connect: { id: 4}},
      style: {connect: { id: 6}},

      description: "A dark-brown Trappist ale with an ivory-coloured head. A fruity aroma with warm tones of vanilla, caramel and roasted chocolate. A classic Trappist ale with a full malty, caramel-sweet taste and the subtle, sweet influence of dates, honey and dried fruits. The aftertaste is sweet and slightly bitter.",
      image: "/beers/la_trappe_dubbel.jpeg",
      link: "https://untappd.com/b/bierbrouwerij-de-koningshoeven-la-trappe-dubbel/368",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "hertog_jan_pilsener",
      name: "Hertog Jan Pilsener",
      abv: 5.1,
      ibu: 21,

      manufacturer: {connect: { id: 2}},
      style: {connect: { id: 12}},

      description: "Hertog Jan Pilsener has been made with love for beer from soft water from the Eiffel and the Ardennes and carefully selected hops and malts. This makes Hertog Jan Pilsener a firm, golden blonde beer. With a nice, dense head, a full flavor and a pleasantly bitter aftertaste.",
      image: "/beers/hertog_jan_pilsener.jpeg",
      link: "https://untappd.com/b/hertog-jan-pilsener/94130",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "kordaat_pilsener",
      name: "Kordaat Pilsener",
      abv: 4.8,
      ibu: 0,

      manufacturer: {connect: { id: 16}},
      style: {connect: { id: 12}},

      description: "Kordaat bier heeft een toegankelijke, frisse en rijke smaak met een aangenaam bittere afdronk.",
      image: "/beers/kordaat_pilsener.jpeg",
      link: "https://untappd.com/b/lidl-nederland-kordaat-pilsener/2896793",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "kordaat_radler_0",
      name: "Kordaat Radler 0.0",
      abv: 0,
      ibu: 0,

      manufacturer: {connect: { id: 16}},
      style: {connect: { id: 11}},

      description: "Kordaat Radler 0.0 is een alcoholvrij bier. Dit bier is de alcoholvrije variant van het Lidl bier Kordaat Pilsener. Een verfrissende combinatie met alcoholvrij bier en citroensap.",
      image: "/beers/kordaat_radler_0.jpeg",
      link: "https://untappd.com/b/lidl-nederland-kordaat-radler-0-0-citroen/3376565",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "desperados_virgin_0",
      name: "Desperados Virgin 0.0",
      abv: 0,
      ibu: 0,

      manufacturer: {connect: { id: 1}},
      style: {connect: { id: 1}},

      description: "Created from a unique recipe of citrus and zest of lemon, Desperados Virgin 0.0% is an alcohol-free innovation that delivers ultimate refreshment and brings the Desperados vibe to any occasion – without the alcohol.",
      image: "/beers/desperados_virgin_0.jpeg",
      link: "https://untappd.com/b/desperados-nl-desperados-virgin-0-0/3793313",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "leffe_blond_0",
      name: "Leffe Blond 0.0",
      abv: 0,
      ibu: 0,

      manufacturer: {connect: { id: 5}},
      style: {connect: { id: 4}},

      description: "Leffe blond 0.0 is a delicious non-alcoholic abbey beer, suitable for every moment. Leffe makes it possible to enjoy blond beer without the alcohol. The taste of Leffe 0.0 is as we are used to from the original beer: slightly bitter, fruity and it contains fine notes of vanilla and cloves.",
      image: "/beers/leffe_blond_0.jpeg",
      link: "https://untappd.com/b/abbaye-de-leffe-leffe-blonde-blond-0-0/2948556",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "skuumkoppe_0",
      name: "Skuumkoppe 0.0",
      abv: 0,
      ibu: 0,

      manufacturer: {connect: { id: 15}},
      style: {connect: { id: 10}},

      description: "Well balanced in taste, refreshing with a light bitterness. A 0.0 for every beerlover with the same characteristics as our Hertog Jan Pilsener.",
      image: "/beers/skuumkoppe_0.jpeg",
      link: "https://untappd.com/b/texelse-bierbrouwerij-skuumkoppe-0-0/5219764",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "hertog_jan_0",
      name: "Hertog Jan 0.0",
      abv: 0,
      ibu: 22,

      manufacturer: {connect: { id: 2}},
      style: {connect: { id: 12}},

      description: "Well balanced in taste, refreshing with a light bitterness. A 0.0 for every beerlover with the same characteristics as our Hertog Jan Pilsener.",
      image: "/beers/hertog_jan_0.jpeg",
      link: "https://untappd.com/b/hertog-jan-hertog-jan-0-0-de-revisie/4422304",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "desperados_mojito",
      name: "Desperados Mojito",
      abv: 5.9,
      ibu: 20,

      manufacturer: {connect: { id: 1}},
      style: {connect: { id: 1}},

      description: "Mojito is there when your night's getting started, a refreshing tequila flavoured beer shaken up with a twist of mojito.",
      image: "/beers/desperados_mojito.jpeg",
      link: "https://untappd.com/b/desperados-nl-desperados-mojito/1988737",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "hertog_jan_weizener",
      name: "Hertog Jan Weizener",
      abv: 5.7,
      ibu: 16,

      manufacturer: {connect: { id: 2}},
      style: {connect: { id: 2}},

      description: "This willful wheat beer combines the best of a German weizen and Belgian witbier. The hop, malted wheat, fresh yeast, coriander and orange peel give it a full, fresh flavor and a deep gold color with a slight haze. The secondary fermentation on the bottle creates a fresher and richer taste and aroma.",
      image: "/beers/weizener.jpeg",
      link: "https://untappd.com/b/hertog-jan-weizener/35142",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "tripel_karmeliet",
      name: "Tripel Karmeliet",
      abv: 8.4,
      ibu: 16,

      manufacturer: {connect: { id: 3}},
      style: {connect: { id: 3}},

      description: "Tripel Karmeliet is still brewed to an authentic beer recipe from 1679 originating in the former Carmelite monastery in Dendermonde. Written over 300 years ago, this recipe describes the use of three kinds of grain: wheat, oats and barley.",
      image: "/beers/tripel_karmeliet.jpeg",
      link: "https://untappd.com/b/brouwerij-bosteels-tripel-karmeliet/6511",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "la_trappe_blond",
      name: "La Trappe Blond",
      abv: 6.5,
      ibu: 20,

      manufacturer: {connect: { id: 4}},
      style: {connect: { id: 4}},

      description: "Golden yellow Trappist ale with a white head and a rich flavour. The fruity and refreshing aromas go well with the sweet smell of malt and aromas reminiscent of spices. The result is an agreeable and tingling ale with a lightly sweet, smoothly bitter and malty taste. The aftertaste is characterised by a combination of sweetness and smooth bitterness.",
      image: "/beers/la_trappe_blond.jpeg",
      link: "https://untappd.com/b/bierbrouwerij-de-koningshoeven-la-trappe-blond/17858",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "la_trappe_tripel",
      name: "La Trappe Tripel",
      abv: 8,
      ibu: 27,

      manufacturer: {connect: { id: 4}},
      style: {connect: { id: 3}},

      description: "A golden blonde Trappist ale with a white head. Fruity aromas of peach and apricot combined with a floral aroma. La Trappe Tripel is a classic Trappist ale with a powerful and full flavour. In addition, this ale has a candy-sweet and light malty character. The aftertaste is bitter and slightly dry.",
      image: "/beers/la_trappe_tripel.jpeg",
      link: "https://untappd.com/b/bierbrouwerij-de-koningshoeven-la-trappe-tripel/2013",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "la_trappe_quadrupel",
      name: "La Trappe Quadrupel",
      abv: 10,
      ibu: 22,

      manufacturer: {connect: { id: 4}},
      style: {connect: { id: 5}},

      description: "A characteristically Trappist ale with a warm amber colour and a cream-coloured head. The aroma is associated with clover and nuts, balanced by the sweet aromas of vanilla, raisins and banana. La Trappe Quadrupel is the heaviest of all the La Trappe Trappist ales and it is also the source for the name of this style. A full, heart-warming and intense taste. Malty with sweet tones of dates and caramel. The aftertaste is smooth and slightly bitter.",
      image: "/beers/la_trappe_quadrupel.jpeg",
      link: "https://untappd.com/b/bierbrouwerij-de-koningshoeven-la-trappe-quadrupel/1830",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "leffe_blond",
      name: "Leffe Blond",
      abv: 6.6,
      ibu: 20,

      manufacturer: {connect: { id: 5}},
      style: {connect: { id: 4}},

      description: "Leffe Blond is the flagship of Leffe. The unique recipe is the fruit of centuries of experience in the art of brewing, which brings a broad palette of aromas into balance. It is elegant, smooth and fruity, and it has a spicy aftertaste with a hint of bitter orange. Its light, sunny colour is due to the use of pale malt.",
      image: "/beers/leffe_blond.jpeg",
      link: "https://untappd.com/b/abbaye-de-leffe-leffe-blonde-blond/5940",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "westmalle_trappist_dubbel",
      name: "Westmalle Trappist Dubbel",
      abv: 7,
      ibu: 30,

      manufacturer: {connect: { id: 7}},
      style: {connect: { id: 6}},

      description: "Westmalle Dubbel is a dark, reddish-brown Trappist beer with a secondary fermentation in the bottle. The creamy head has the fragrance of special malt and leaves an attractive lace pattern in the glass. The flavour is rich and complex, herby and fruity with a fresh-bitter finish. It is a balanced quality beer with a soft feel in the mouth and a long, dry aftertaste.",
      image: "/beers/westmalle_trappist_dubbel.jpeg",
      link: "https://untappd.com/b/brouwerij-der-trappisten-van-westmalle-westmalle-trappist-dubbel/4168",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "gulden_draak_classic",
      name: "Gulden Draak Classic",
      abv: 10.5,
      ibu: 30,

      manufacturer: {connect: { id: 8}},
      style: {connect: { id: 3}},

      description: "Such an impressive symbol that has been around for more than 6 centuries requires an equally impressive beer. Like the dragon at the top of the city, Gulden Draak has been one of the world's best beers for years. It is a dark tripel, which in itself makes it an exceptional beer, but the complex taste with notes of caramel, roasted malt and coffee makes it unique.",
      image: "/beers/gulden_draak_classic.jpeg",
      link: "https://untappd.com/b/brouwerij-van-steenberge-gulden-draak-classic/6758",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "la_chouffe_blond",
      name: "La Chouffe Blond",
      abv: 8,
      ibu: 20,

      manufacturer: {connect: { id: 9}},
      style: {connect: { id: 4}},

      description: "The gnomes of Fairyland are particularly fond of this golden beer. LA CHOUFFE, with its slight hoppy taste, combining notes of fresh coriander and fruity tones, is the drink which gives them their zest for life. At least, that's what these imps say when they are thirsty. Their secret used to be jealously guarded from one generation to the next until the day they shared the recipe with humans to seal their friendship. Of all the legends from the wonderful region of the Belgian Ardennes, the tale of LA CHOUFFE is the one which most merits re-telling.",
      image: "/beers/la_chouffe_blond.jpeg",
      link: "https://untappd.com/b/brasserie-d-achouffe-la-chouffe-blond/52593",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "tongerlo_tripel",
      name: "Tongerlo Tripel",
      abv: 9,
      ibu: 0,

      manufacturer: {connect: { id: 10}},
      style: {connect: { id: 3}},

      description: "This authentic Belgian triple stands out thanks to the scale of fruity notes and the re-fermentation in the bottle, which accentuates the refined bitterness of the aromatic hops. Re-fermentation in the bottle Re-fermentation in the bottle gives the beer a more intense taste and aroma as well as a longer shelf life.",
      image: "/beers/tongerlo_tripel.jpeg",
      link: "https://untappd.com/b/brouwerij-haacht-brasserie-tongerlo-tripel/27099",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "ginger_paradise",
      name: "Ginger Paradise",
      abv: 6.2,
      ibu: 20,

      manufacturer: {connect: { id: 11}},
      style: {connect: { id: 7}},

      description: "This is our summer special for 2021. A special Blond spiced with ginger and paradise seed. Brewed with a lot of wheatmalt for a velvet smooth mouthfeel. Aroma of ginger and slightly spicy which is done by the paradise seed.",
      image: "/beers/ginger_paradise.jpeg",
      link: "https://untappd.com/b/brouwerij-t-ij-ginger-paradise/4435327",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "omer_blond",
      name: "Omer Blond",
      abv: 8,
      ibu: 27,

      manufacturer: {connect: { id: 12}},
      style: {connect: { id: 4}},

      description: "OMER. Traditional Blond is the result of 130 years of brewing tradition. Since 1892 the brewers are named Omer from father to son, now already for five generations. Top-fermented beer, refermented in the bottle. Characterised with a fine fruity aroma and a subtle bitterness.",
      image: "/beers/omer_blond.jpeg",
      link: "https://untappd.com/b/omer-vander-ghinste-omer-traditional-blond/26923",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "guinness",
      name: "Guinness",
      abv: 4.2,
      ibu: 45,

      manufacturer: {connect: { id: 6}},
      style: {connect: { id: 8}},

      description: "Swirling clouds tumble as the storm begins to calm. Settle. Breathe in the moment, then break through the smooth, light head to the bittersweet reward. Unmistakeably GUINNESS, from the first velvet sip to the last, lingering drop. And every deep-dark satisfying mouthful in between. Pure beauty. Pure GUINNESS.",
      image: "/beers/guinness.jpeg",
      link: "https://untappd.com/b/guinness-guinness-draught/4473",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "duvel",
      name: "Duvel",
      abv: 8.5,
      ibu: 33,

      manufacturer: {connect: { id: 13}},
      style: {connect: { id: 9}},

      description: "Duvel is a natural beer with a subtle bitterness, a refined flavour and a distinctive hop character. The unique brewing process, which takes about 90 days, guarantees a pure character, delicate effervescence and a pleasant sweet taste of alcohol. Apart from pure spring water, which is the main ingredient of beer, barley is the most important raw material. Barley must germinate for five days in the malt house, after which malt remains. The colour of the malt and as a consequence also of the beer is determined by the temperature. Duvel obtains its typical bitterness by adding various varieties of aromatic Slovenian and Czech hops. We use only exclusive hops that are renowned for their constant, outstanding quality. Duvel ferments for the first time in tanks at 20 to 26°C. The brewer uses his own culture for this. The original yeast strain, which Victor Moortgat himself selected in the 1920’s, originates from Scotland. After maturing in storage tanks in which the beer is cooled down to -2°C, the drink is ready for bottling. Thanks to the addition of extra sugars and yeast, the beer ferments again in the bottle. This occurs in warm cellars (24°C) and takes two weeks. Then the beer is moved to cold cellars, where it continues to mature and stabilise for a further six weeks. This extra long maturation period is unique and contributes to the refined flavour and pure taste of Duvel.",
      image: "/beers/duvel.jpeg",
      link: "https://untappd.com/b/duvel-moortgat-duvel/6868",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "tripel_lefort",
      name: "Tripel LeFort",
      abv: 8.8,
      ibu: 20,

      manufacturer: {connect: { id: 12}},
      style: {connect: { id: 3}},

      description: "Tripel LeFort is a golden blonde beer of 8.8% ABV and sets itself apart through its crisp, fruity aroma and beautifully rounded full flavour. The top-fermenting yeast used for Tripel LeFort results in a beer with vanilla-clove aromas as well as a fruity taste of bananas and red apples. Pleasant hints of citrus, lime and roses make this into a balanced beer that is intriguingly complex at the same time.",
      image: "/beers/tripel_lefort.jpeg",
      link: "https://untappd.com/b/omer-vander-ghinste-tripel-lefort/1533976",

      gluten: true,
      lactose: false,
      organic: false
    },
    {
      slug: "delirium_tremens",
      name: "Delirium Tremens",
      abv: 8.5,
      ibu: 24,

      manufacturer: {connect: { id: 14}},
      style: {connect: { id: 9}},

      description: "The allusion to pink elephants and the choice of names is not due to chance. With a particular character, the unique taste results from triple fermentation and the use of three different yeast strains. Sweet, biscuit malt backbone, supported by pleasant warmth and spice, finishes well rounded, floral, and dry.",
      image: "/beers/delirium_tremens.jpeg",
      link: "https://untappd.com/b/delirium-huyghe-brewery-delirium-tremens/4485",

      gluten: true,
      lactose: false,
      organic: false
    }
  ];
}

function getWineStyles() : WineStyle[] {
  return [
    {
      id: 1,
      name: "Wit",
      color: "f5ed7d"
    },
    {
      id: 2,
      name: "Rose",
      color: "ff666d"
    },
    {
      id: 3,
      name: "Rood",
      color: "b2153a"
    }
  ];
}

function getWines() : WineQuery[] {
  return [
    {
      name: "Carmenère - Cabernet Sauvignon",
      slug: "carmenere",
      image: "/wine/carmenere.jpg",
      description: "Soft wine with the intense flavor of cassis and plum purple. Full and exciting by its fruity acids. For so and mildly spiced dishes.",
      abv: 13,

      manufacturer: {connect: {id: 48}},
      style: {connect: { id: 3}},

      link: "https://www.vivino.com/NL/en/cl-frontera-carmenere-cabernet-sauvignon/w/1216525?ref=nav-search",

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Viñas del Vero Luces",
      slug: "luces",
      image: "/wine/luces.png",
      description: "It has light colour with crisp greenish hues. It is aromatic and complex enough on the nose, evocative of fruits such as apricot, peach, apple, lime and greenery. On the palate it quickly gives a sense of being structured: it is pleasant and very clean tasting with a pleasing finish reminiscent of exotic fruits such as pineapple and mango.",
      abv: 13,

      manufacturer: {connect: {id: 46}},
      style: {connect: { id: 1}},

      link: "https://www.vivino.com/NL/en/vinas-del-vero-luces-chardonnay-sauvignon-blanc-macabeo/w/2486838?ref=nav-search",

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Gran Noche Clasico Rose Wine",
      slug: "gran",
      image: "/wine/gran.jpg",
      description: "A fruity and pleasant rose wine, with freash and intense aromas of red fruit, a strong rose colour with strawberry tones and a smooth and full taste.",
      abv: 11,

      link: null,

      manufacturer: {connect: {id: 47}},
      style: {connect: { id: 2}},

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Crisp & Refreshing Chenin Blanc",
      slug: "chenin",
      image: "/wine/chenin.jpeg",
      description: "Honey gold in color, bright and clear. Nice acidity, grapefruit gooseberry, quince, bitter almond, honeysuckle . Very much on the dry side.",
      abv: 12.5,

      manufacturer: {connect: {id: 49}},
      style: {connect: { id: 1}},

      link: "https://www.vivino.com/NL/en/vineris-crisp-refreshing-chenin-blanc-western-cape/w/4784083?ref=nav-search",

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Welmoed Rosé",
      slug: "welmoed",
      image: "/wine/welmoed.png",
      description: "It has refreshing, easy-drinking wine with a strawberry pink colour. Soft red and blackberry flavours with a crisp, lively finish.",
      abv: 11.5,

      manufacturer: {connect: {id: 50}},
      style: {connect: { id: 2}},

      link: "https://www.vivino.com/NL/en/welmoed-rose/w/40094",

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Grüner Veltliner Droog",
      slug: "gruner",
      image: "/wine/gruner.jpeg",
      description: "Pale lemon with pear and apple aromas. Dry, high acidity crisp wine with medium alcohol and body. Flavours of apple and white pepper.",
      abv: 12.5,

      manufacturer: {connect: {id: 51}},
      style: {connect: { id: 1}},

      link: "https://www.vivino.com/NL/en/johann-quest-gruner-veltliner-droog/w/4429802?ref=nav-search",

      gluten: false,
      lactose: false,
      organic: false
    }
  ];
}

function getSodas() : SodaQuery[] {
  return [
    {
      name: "Kombucha Ginger lemongrass & green tea",
      slug: "ginger_lemongrass",
      image: "/soda/ginger_lemongrass.jpeg",
      description: "Gebrouwen met gembersap, aromatische citroengras, frisse pittige peper en groene thee.",
      abv: 0,

      manufacturer: {connect: {id: 40}},
      carbonated: true,

      gluten: false,
      lactose: false,
      organic: false

    },
    {
      name: "Kombucha Rasberry rose & black tea",
      slug: "rasberry_rose",
      image: "/soda/rasberry_rose.jpeg",
      description: "Gebrouwen met zoet rood fruit, de volwassen smaak van rozenwater en zwarte thee.",
      abv: 0,

      manufacturer: {connect: {id: 40}},
      carbonated: true,

      gluten: false,
      lactose: false,
      organic: false

    },
    {
      name: "Rhubarb Lemonade",
      slug: "rhubarb",
      image: "/soda/rhubarb.jpeg",
      description: "You can’t just put your finger on it. She’s sour, yet slightly sweet. She stands tall in her beautiful red gown, while she wears her green crown proudly. The ideal combination for a very seductive and delicious squeeze affair!",
      abv: 0,

      manufacturer: {connect: {id: 39}},
      carbonated: true,

      gluten: false,
      lactose: false,
      organic: true

    },
    {
      name: "Lemon & Ginger Lemonade",
      slug: "lemon_ginger",
      image: "/soda/lemon_ginger.jpeg",
      description: "Our Lemon Ginger is a kickstart class act. A lemony-zesty bliss, with subtle spicy touch. Always crisp on the uptake, it’ll leave you feeling so refreshed and so clean. Simply the zest. Squeeze the day!",
      abv: 0,

      manufacturer: {connect: {id: 39}},
      carbonated: true,

      gluten: false,
      lactose: false,
      organic: true

    },
    {
      name: "White Peach Lemonade",
      slug: "white_peach",
      image: "/soda/white_peach.jpeg",
      description: "Juicy, bubbly & cheeky. Not just your average kind of peach. This one is just how we like it. The perfect pick-me-up. Peach, please!",
      abv: 0,

      manufacturer: {connect: {id: 39}},
      carbonated: true,

      gluten: false,
      lactose: false,
      organic: true

    },
    {
      name: "Kombucha Lime & Mint",
      slug: "lime_mint",
      image: "/soda/lime_mint.jpeg",
      description: "Kombucha, limoen en munt, dat is driedubbel zomer. Interessant, avontuurlijk en verfrissend.",
      abv: 0,

      manufacturer: {connect: {id: 41}},
      carbonated: true,

      gluten: false,
      lactose: false,
      organic: true

    },
    {
      name: "Kombucha Ginger & Lemon",
      slug: "ginger_lemon",
      image: "/soda/ginger_lemon.jpeg",
      description: "Kombucha, gember en citroen. Dat is net als je kop gemberthee, maar dan koud en interessanter. Zoet, verfrissend en met een spannende kick. Voor als je er eentje onder je bips nodig hebt.",
      abv: 0,

      manufacturer: {connect: {id: 41}},
      carbonated: true,

      gluten: false,
      lactose: false,
      organic: true

    },
    {
      name: "Kombucha Passion fruit & Hop",
      slug: "passion_hop",
      image: "/soda/passion_hop.jpeg",
      description: "Kombucha, passiefruit en hop. Complex, zoet, friszuur en aromatisch. Een interessante driehoeksverhouding voor volwassen avonturiers. Je moet het gewoon een keer doen. Kombucha drinken bedoelen we.",
      abv: 0,

      manufacturer: {connect: {id: 41}},
      carbonated: true,

      gluten: false,
      lactose: false,
      organic: true

    },
    {
      name: "Fanta exotic taste",
      slug: "fanta_exotic",
      image: "/soda/fanta_exotic.jpeg",
      description: "Tropical Soft Drink with Tropical Flavors Passionfruit, Peach, and Orange.",
      abv: 0,

      manufacturer: {connect: {id: 42}},
      carbonated: true,

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Fanta lemon",
      slug: "fanta_lemon",
      image: "/soda/fanta_lemon.jpeg",
      description: "Fanta Lemon is a sparkling lemon fruit soft drink.",
      abv: 0,

      manufacturer: {connect: {id: 42}},
      carbonated: true,

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Coca Cola",
      slug: "coca_cola",
      image: "/soda/coca_cola.jpeg",
      description: "Coca-Cola, or Coke, is a carbonated soft drink with a cola flavor manufactured by the Coca-Cola Company.",
      abv: 0,

      manufacturer: {connect: {id: 42}},
      carbonated: true,

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Red Bull",
      slug: "redbull",
      image: "/soda/redbull.jpeg",
      description: "Red Bull is a lightly carbonated energy drink with an impeccable blend of caffeine, taurine, B vitamins, real sugar and water.",
      abv: 0,

      manufacturer: {connect: {id: 43}},
      carbonated: true,

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Fuze Black Tea Peach & Hibiscus",
      slug: "fuze_black",
      image: "/soda/fuze_black.jpeg",
      description: "Een verrassende fusie van zwarte thee-extracten met perziksap en een verfijnde smaak van hibiscus.",
      abv: 0,

      manufacturer: {connect: {id: 42}},
      carbonated: false,

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Fuze Green Tea Mango & Chamomile",
      slug: "fuze_green_mango",
      image: "/soda/fuze_green_mango.jpeg",
      description: "Een verrassende fusie van groene thee-extracten met natuurlijke mangosmaak en een fleurige hint van kamille.",
      abv: 0,

      manufacturer: {connect: {id: 42}},
      carbonated: false,

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Fuze Green Tea Blueberry & Lavender",
      slug: "fuze_green_blueberry",
      image: "/soda/fuze_green_blueberry.jpeg",
      description: "Proef de unieke en natuurlijke smaak van fuze tea. Blueberry jasmin is een verrassende ijsthee fusie van groene theeblaadjes met blauwe bessen en een verfijnde smaak van jasmijn.",
      abv: 0,

      manufacturer: {connect: {id: 42}},
      carbonated: false,

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Pepsi Cola",
      slug: "pepsi_cola",
      image: "/soda/pepsi_cola.jpeg",
      description: "De originele pepsi colasmaak.",
      abv: 0,

      manufacturer: {connect: {id: 44}},
      carbonated: true,

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Fanta Orange",
      slug: "fanta_orange",
      image: "/soda/fanta_orange.jpeg",
      description: "Fanta orange is een combinatie van sprankelend water en echt vruchtensap, met natuurlijke aroma's, zonder toegevoegde kleurstoffen. Bewaar Fanta op een droge schone plaats uit de zon. Fanta smaakt ijskoud het lekkerst.",
      abv: 0,

      manufacturer: {connect: {id: 42}},
      carbonated: true,

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Rivella Original",
      slug: "rivella_original",
      image: "/soda/rivella_original.jpeg",
      description: "Rivella is een licht sprankelende, lekker verfrissende frisdrank met natuurlijke ingrediënten. Gedeeltelijk uit wei wordt gemaakt. Wei is een restproduct van de kaasfabricage.",
      abv: 0,

      manufacturer: {connect: {id: 45}},
      carbonated: true,

      gluten: false,
      lactose: true,
      organic: false
    },
  ];
}

function getCocktails() : CocktailQuery[] {
  return [
    {
      name: "Prosecco Rosato",
      slug: "prosecco_rosato",
      image: "/cocktails/prosecco_rosato.jpeg",
      description: "Met de zoete smaak van roodfruit en frisse appel",
      abv: 6.9,

      manufacturer: {connect: {id: 16}},
      mix: true,

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Cosmopolitan",
      slug: "cosmo",
      image: "/cocktails/cosmo.jpeg",
      description: "Cosmopolitan cocktail with vodka, cranberry juice, lime juice and triple sec, e.g. Cointreau.",
      abv: 6.9,

      manufacturer: {connect: {id: 16}},
      mix: true,

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Caipirinha",
      slug: "caip",
      image: "/cocktails/caip.jpeg",
      description: "Caipirinha cocktail made of lemons, cachaça rum, ice and cane sugar.",
      abv: 6.9,

      manufacturer: {connect: {id: 16}},
      mix: true,

      gluten: false,
      lactose: false,
      organic: false
    },
    {
      name: "Mojito",
      slug: "mojito",
      image: "/cocktails/mojito.jpeg",
      description: "Mojito cocktail made with rum, lime juice, cane sugar, sparkling water and mint with lots of ice.",
      abv: 6.9,

      manufacturer: {connect: {id: 16}},
      mix: true,

      gluten: false,
      lactose: false,
      organic: false
    }
  ];
}

function getSections() : Section[] {
  return [
    {
      id: 1,
      name: "Zomerbier"
    },
    {
      id: 2,
      name: "Tripels"
    },
    {
      id: 3,
      name: "Frisdrank"
    },
    {
      id: 4,
      name: "Dubbels"
    },
    {
      id: 5,
      name: "Blond"
    },
    {
      id: 6,
      name: "Random"
    },
    {
      id: 7,
      name: "Pils"
    },
    {
      id: 8,
      name: "Alcoholvrij"
    },
    {
      id: 9,
      name: "Witte koelkast"
    },
    {
      id: 10,
      name: "Wijn"
    }
  ];
}

function getContainers() : ContainerQuery[] {
  return [
    {
      barcode: "20261801",
      drink: {connect: {slug: "gruner"}},
      section : {connect: {id: 10}},
      portions: 7,
      type: ContainerType.WineBottle,
      volume: 750,
      inventory: 1
    },
    {
      barcode: "6004786008490",
      drink: {connect: {slug: "welmoed"}},
      section : {connect: {id: 10}},
      portions: 7,
      type: ContainerType.WineBottle,
      volume: 750,
      inventory: 1
    },
    {
      barcode: "4304493263147",
      drink: {connect: {slug: "chenin"}},
      section : {connect: {id: 10}},
      portions: 7,
      type: ContainerType.WineBottle,
      volume: 750,
      inventory: 3
    },
    {
      barcode: "7804320145853",
      drink: {connect: {slug: "carmenere"}},
      section : {connect: {id: 10}},
      portions: 7,
      type: ContainerType.WineBottle,
      volume: 750,
      inventory: 1
    },
    {
      barcode: "8427894026572",
      drink: {connect: {slug: "gran"}},
      section : {connect: {id: 10}},
      portions: 7,
      type: ContainerType.WineBottle,
      volume: 750,
      inventory: 1
    },
    {
      barcode: "8421293011009",
      drink: {connect: {slug: "luces"}},
      section : {connect: {id: 10}},
      portions: 7,
      type: ContainerType.WineBottle,
      volume: 750,
      inventory: 1
    },
    {
      barcode: "8715600243444",
      drink: {connect: {slug: "rivella_original"}},
      section : {connect: {id: 9}},
      portions: 4,
      type: ContainerType.PlasticBottle,
      volume: 1000,
      inventory: 1
    },
    {
      barcode: "5000112646115",
      drink: {connect: {slug: "fanta_orange"}},
      section : {connect: {id: 9}},
      portions: 6,
      type: ContainerType.PlasticBottle,
      volume: 1500,
      inventory: 0
    },
    {
      barcode: "8715600244403",
      drink: {connect: {slug: "pepsi_cola"}},
      section : {connect: {id: 9}},
      portions: 6,
      type: ContainerType.PlasticBottle,
      volume: 1500,
      inventory: 1
    },
    {
      barcode: "5000112662344",
      drink: {connect: {slug: "fuze_green_blueberry"}},
      section : {connect: {id: 3}},
      portions: 5,
      type: ContainerType.PlasticBottle,
      volume: 1250,
      inventory: 1
    },
    {
      barcode: "5000112646412",
      drink: {connect: {slug: "fuze_green_mango"}},
      section : {connect: {id: 3}},
      portions: 5,
      type: ContainerType.PlasticBottle,
      volume: 1250,
      inventory: 3
    },
    {
      barcode: "5000112646429",
      drink: {connect: {slug: "fuze_black"}},
      section : {connect: {id: 3}},
      portions: 5,
      type: ContainerType.PlasticBottle,
      volume: 1250,
      inventory: 2
    },
    {
      barcode: "90453533",
      drink: {connect: {slug: "redbull"}},
      section : {connect: {id: 9}},
      portions: 1,
      type: ContainerType.Can,
      volume: 250,
      inventory: 6
    },
    {
      barcode: "5000112658620",
      drink: {connect: {slug: "coca_cola"}},
      section : {connect: {id: 9}},
      portions: 1,
      type: ContainerType.Can,
      volume: 250,
      inventory: 8
    },
    {
      barcode: "5000112659269",
      drink: {connect: {slug: "fanta_lemon"}},
      section : {connect: {id: 9}},
      portions: 1,
      type: ContainerType.Can,
      volume: 250,
      inventory: 4
    },
    {
      barcode: "5000112659320",
      drink: {connect: {slug: "fanta_exotic"}},
      section : {connect: {id: 9}},
      portions: 1,
      type: ContainerType.Can,
      volume: 250,
      inventory: 4
    },
    {
      barcode: "8725500170276",
      drink: {connect: {slug: "passion_hop"}},
      section : {connect: {id: 9}},
      portions: 1,
      type: ContainerType.Can,
      volume: 250,
      inventory: 2
    },
    {
      barcode: "8725500170238",
      drink: {connect: {slug: "ginger_lemon"}},
      section : {connect: {id: 9}},
      portions: 1,
      type: ContainerType.Can,
      volume: 250,
      inventory: 2
    },
    {
      barcode: "8725500170252",
      drink: {connect: {slug: "lime_mint"}},
      section : {connect: {id: 9}},
      portions: 1,
      type: ContainerType.Can,
      volume: 250,
      inventory: 2
    },
    {
      barcode: "20438043",
      drink: {connect: {slug: "mojito"}},
      section : {connect: {id: 9}},
      portions: 1,
      type: ContainerType.Can,
      volume: 200,
      inventory: 1
    },
    {
      barcode: "4056489238423",
      drink: {connect: {slug: "caip"}},
      section : {connect: {id: 9}},
      portions: 1,
      type: ContainerType.Can,
      volume: 200,
      inventory: 2
    },
    {
      barcode: "4056489233961",
      drink: {connect: {slug: "cosmo"}},
      section : {connect: {id: 9}},
      portions: 1,
      type: ContainerType.Can,
      volume: 200,
      inventory: 4
    },
    {
      barcode: "4056489249306",
      drink: {connect: {slug: "prosecco_rosato"}},
      section : {connect: {id: 9}},
      portions: 1,
      type: ContainerType.Can,
      volume: 200,
      inventory: 1
    },
    {
      barcode: "8715600248715",
      drink: {connect: {slug: "ginger_lemongrass"}},
      section : {connect: {id: 3}},
      portions: 1,
      type: ContainerType.Can,
      volume: 250,
      inventory: 2
    },
    {
      barcode: "8715600248692",
      drink: {connect: {slug: "rasberry_rose"}},
      section : {connect: {id: 3}},
      portions: 1,
      type: ContainerType.Can,
      volume: 250,
      inventory: 2
    },
    {
      barcode: "5425032063420",
      drink: {connect: {slug: "rhubarb"}},
      section : {connect: {id: 3}},
      portions: 1,
      type: ContainerType.Can,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "5425032063406",
      drink: {connect: {slug: "lemon_ginger"}},
      section : {connect: {id: 3}},
      portions: 1,
      type: ContainerType.Can,
      volume: 330,
      inventory: 2
    },
    {
      barcode: "5425032063413",
      drink: {connect: {slug: "white_peach"}},
      section : {connect: {id: 3}},
      portions: 1,
      type: ContainerType.Can,
      volume: 330,
      inventory: 2
    },
    {
      barcode: "20430955",
      drink: {connect: {slug: "kordaat_0"}},
      section : {connect: {id: 8}},
      portions: 1,
      type: ContainerType.Can,
      volume: 330,
      inventory: 2
    },
    {
      barcode: "552712002",
      drink: {connect: {slug: "waelsden_knoeer"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 4
    },
    {
      barcode: "552712001",
      drink: {connect: {slug: "waelsden_tripel"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 2
    },
    {
      barcode: "4056489373957",
      drink: {connect: {slug: "sabor_tequila_camaro"}},
      section : {connect: {id: 1}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 8
    },
    {
      barcode: "8714800033503",
      drink: {connect: {slug: "bavaria_gluten_free"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "4105120033948",
      drink: {connect: {slug: "weihenstephaner_hefeweissbier"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 500,
      inventory: 1
    },
    {
      barcode: "5411686700118",
      drink: {connect: {slug: "fruitesse"}},
      section : {connect: {id: 1}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 250,
      inventory: 1
    },
    {
      barcode: "8720648361029",
      drink: {connect: {slug: "saga_10"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "5411681038001",
      drink: {connect: {slug: "maredsous_tripel"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "8719324358002",
      drink: {connect: {slug: "luxe_quadrupel"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "54079021",
      drink: {connect: {slug: "abt_12"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "8711406995631",
      drink: {connect: {slug: "la_trappe_witte_trappist"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "8711406995495",
      drink: {connect: {slug: "la_trappe_quadrupel"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "5411663002600",
      drink: {connect: {slug: "piraat"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "8714799408207",
      drink: {connect: {slug: "brut_uiteinde"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "8718819700210",
      drink: {connect: {slug: "dubbel_dik"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "5411065201304",
      drink: {connect: {slug: "brunehaut_triple"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "5425006243032",
      drink: {connect: {slug: "gouden_carolus_whisky_infused"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "4005249003092",
      drink: {connect: {slug: "grevensteiner_dunkles_bockbier"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "8725500906547",
      drink: {connect: {slug: "zwoele_zomernacht"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 0
    },
    {
      barcode: "4000856007167",
      drink: {connect: {slug: "warsteiner_winter"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "5413970200014",
      drink: {connect: {slug: "malheur_10"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "54085022",
      drink: {connect: {slug: "tongerlo_tripel"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 4
    },
    {
      barcode: "5411098700003",
      drink: {connect: {slug: "postel_dubbel"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "5391516871365",
      drink: {connect: {slug: "magners_original_irish_cider"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "8725500170177",
      drink: {connect: {slug: "frisse_duik"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "87167337",
      drink: {connect: {slug: "grimbergen_blond"}},
      section : {connect: {id: 5}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 300,
      inventory: 6
    },
    {
      barcode: "5411681014005",
      drink: {connect: {slug: "duvel"}},
      section : {connect: {id: 5}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 6
    },
    {
      barcode: "8712000059286",
      drink: {connect: {slug: "amstel_radler_2"}},
      section : {connect: {id: 1}},
      portions: 1,
      type: ContainerType.Can,
      volume: 330,
      inventory: 6
    },
    {
      barcode: "5410228168195",
      drink: {connect: {slug: "hoegaarden_wit"}},
      section : {connect: {id: 1}},
      portions: 1,
      type: ContainerType.Can,
      volume: 330,
      inventory: 6
    },
    {
      barcode: "8725000660239",
      drink: {connect: {slug: "hertog_jan_weizener"}},
      section : {connect: {id: 1}},
      portions: 1,
      type: ContainerType.Can,
      volume: 330,
      inventory: 6
    },
    {
      barcode: "8712000060671",
      drink: {connect: {slug: "desperados_original"}},
      section : {connect: {id: 1}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 12
    },
    {
      barcode: "8712000061081",
      drink: {connect: {slug: "desperados_mojito"}},
      section : {connect: {id: 1}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 11
    },
    {
      barcode: "8712000052324",
      drink: {connect: {slug: "classic_apple_cider"}},
      section : {connect: {id: 1}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 300,
      inventory: 5
    },
    {
      barcode: "8712000061449",
      drink: {connect: {slug: "amstel_rose"}},
      section : {connect: {id: 1}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 300,
      inventory: 5
    },
    {
      barcode: "5411663002716",
      drink: {connect: {slug: "gulden_draak_classic"}},
      section : {connect: {id: 2}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 6
    },
    {
      barcode: "87167153",
      drink: {connect: {slug: "grimbergen_tripel"}},
      section : {connect: {id: 2}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 300,
      inventory: 6
    },
    {
      barcode: "8711406995358",
      drink: {connect: {slug: "la_trappe_tripel"}},
      section : {connect: {id: 2}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 6
    },
    {
      barcode: "54050082",
      drink: {connect: {slug: "tripel_karmeliet"}},
      section : {connect: {id: 2}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 6
    },
    {
      barcode: "87167245",
      drink: {connect: {slug: "grimbergen_dubbel"}},
      section : {connect: {id: 4}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 300,
      inventory: 6
    },
    {
      barcode: "8711406995211",
      drink: {connect: {slug: "la_trappe_dubbel"}},
      section : {connect: {id: 4}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 6
    },
    {
      barcode: "87302554",
      drink: {connect: {slug: "hertog_jan_pilsener"}},
      section : {connect: {id: 7}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 300,
      inventory: 6
    },
    {
      barcode: "20086237",
      drink: {connect: {slug: "kordaat_pilsener"}},
      section : {connect: {id: 7}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 300,
      inventory: 25
    },
    {
      barcode: "20430962",
      drink: {connect: {slug: "kordaat_radler_0"}},
      section : {connect: {id: 8}},
      portions: 1,
      type: ContainerType.Can,
      volume: 330,
      inventory: 9
    },
    {
      barcode: "8712000060701",
      drink: {connect: {slug: "desperados_virgin_0"}},
      section : {connect: {id: 8}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 6
    },
    {
      barcode: "5410228261094",
      drink: {connect: {slug: "leffe_blond_0"}},
      section : {connect: {id: 8}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 300,
      inventory: 6
    },
    {
      barcode: "8712000059767",
      drink: {connect: {slug: "skuumkoppe_0"}},
      section : {connect: {id: 8}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 300,
      inventory: 6
    },
    {
      barcode: "8725000654276",
      drink: {connect: {slug: "hertog_jan_0"}},
      section : {connect: {id: 8}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 300,
      inventory: 6
    },
    {
      barcode: "5412343152332",
      drink: {connect: {slug: "westmalle_trappist_dubbel"}},
      section : {connect: {id: 4}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 6
    },
    {
      barcode: "5411858100067",
      drink: {connect: {slug: "tripel_lefort"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    },
    {
      barcode: "5412186000098",
      drink: {connect: {slug: "delirium_tremens"}},
      section : {connect: {id: 6}},
      portions: 1,
      type: ContainerType.BeerBottle,
      volume: 330,
      inventory: 1
    }
  ];
}