app.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "' Justin Beiber was born on March 1, 1994. So, he was born in 1994. The Super Bowl is usually held in February of each year. So, the Super Bowl in the year Justin Beiber was born would be the Super Bowl held in February of 1994. The Super Bowl in February of 1994 was Super Bowl XXVIII, held on January 30, 1994. The Dallas Cowboys won Super Bowl XXVIII by defeating the Buffalo Bills with a score of 30-13. Therefore, the Dallas Cowboys won the Super Bowl in the year Justin Beiber was born.'"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import os\n",
    "from dotenv import load_dotenv, find_dotenv\n",
    "import langchain\n",
    "from langchain_core.prompts import PromptTemplate\n",
    "\n",
    "load_dotenv(find_dotenv())\n",
    "\n",
    "from langchain_openai import OpenAI\n",
    "\n",
    "API_KEY = \"sk-proj-9IKsYUgfkxlK6srrKNyPT3BlbkFJkb9uu74lHxL5KWw1zDMe\"\n",
    "\n",
    "llm = OpenAI(openai_api_key=API_KEY)\n",
    "\n",
    "question = \"What NFL team won the Super Bowl in the year Justin Beiber was born?\"\n",
    "template = \"\"\"Question: {question}\n",
    "\n",
    "Answer: Let's think step by step.\"\"\"\n",
    "\n",
    "prompt = PromptTemplate.from_template(template)\n",
    "\n",
    "\n",
    "llm_chain = prompt | llm\n",
    "\n",
    "\n",
    "llm_chain.invoke(question)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[\"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        112,\\n        '2024-06-22 00:00:00',\\n        '2024-06-22'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        21,\\n        '2024-06-21 00:00:00',\\n        '2024-06-21'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        222,\\n        '2024-06-20 00:00:00',\\n        '2024-06-20'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        123,\\n        '2024-06-19 00:00:00',\\n        '2024-06-19'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        112,\\n        '2024-06-18 00:00:00',\\n        '2024-06-18'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        54,\\n        '2024-06-17 00:00:00',\\n        '2024-06-17'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        64,\\n        '2024-06-16 00:00:00',\\n        '2024-06-16'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        80,\\n        '2024-06-15 00:00:00',\\n        '2024-06-15'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        192,\\n        '2024-06-14 00:00:00',\\n        '2024-06-14'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        185,\\n        '2024-06-13 00:00:00',\\n        '2024-06-13'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        69,\\n        '2024-06-12 00:00:00',\\n        '2024-06-12'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        127,\\n        '2024-06-11 00:00:00',\\n        '2024-06-11'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        218,\\n        '2024-06-10 00:00:00',\\n        '2024-06-10'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        77,\\n        '2024-06-09 00:00:00',\\n        '2024-06-09'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        217,\\n        '2024-06-08 00:00:00',\\n        '2024-06-08'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        66,\\n        '2024-06-07 00:00:00',\\n        '2024-06-07'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        211,\\n        '2024-06-06 00:00:00',\\n        '2024-06-06'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        75,\\n        '2024-06-05 00:00:00',\\n        '2024-06-05'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        79,\\n        '2024-06-04 00:00:00',\\n        '2024-06-04'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        11,\\n        '2024-06-03 00:00:00',\\n        '2024-06-03'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        195,\\n        '2024-06-02 00:00:00',\\n        '2024-06-02'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        157,\\n        '2024-06-01 00:00:00',\\n        '2024-06-01'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        113,\\n        '2024-05-31 00:00:00',\\n        '2024-05-31'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        196,\\n        '2024-05-30 00:00:00',\\n        '2024-05-30'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        220,\\n        '2024-05-29 00:00:00',\\n        '2024-05-29'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        38,\\n        '2024-05-28 00:00:00',\\n        '2024-05-28'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        131,\\n        '2024-05-27 00:00:00',\\n        '2024-05-27'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        57,\\n        '2024-05-26 00:00:00',\\n        '2024-05-26'\\n    );\\n    \",\n",
       " \"\\n    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\\n    VALUES (\\n        '78bdd876-3e25-4841-909a-4af94bb2272b',\\n        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\\n        51,\\n        '2024-05-25 00:00:00',\\n        '2024-05-25'\\n    );\\n    \"]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import random\n",
    "from datetime import datetime, timedelta\n",
    "\n",
    "# Set the start date (one month before the latest date)\n",
    "start_date = datetime.strptime('2024-06-23', '%Y-%m-%d')\n",
    "\n",
    "# Generate the SQL insert statements\n",
    "sql_statements = []\n",
    "\n",
    "for i in range(1, 30):\n",
    "    current_date = start_date - timedelta(days=i)\n",
    "    random_questions = random.randint(10, 223)\n",
    "    sql = f\"\"\"\n",
    "    INSERT INTO public.analytics (user_id, bot_id, questions_asked, created_at, date)\n",
    "    VALUES (\n",
    "        '78bdd876-3e25-4841-909a-4af94bb2272b',\n",
    "        'fa91d7fc-7ce6-47b4-ba88-f60c16c0f2a6',\n",
    "        {random_questions},\n",
    "        '{current_date}',\n",
    "        '{current_date.date()}'\n",
    "    );\n",
    "    \"\"\"\n",
    "    sql_statements.append(sql)\n",
    "\n",
    "sql_statements\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "from supabase import create_client, Client\n",
    "\n",
    "url: str = \"https://hpogngdwousevnyrnmew.supabase.co\"\n",
    "key: str = \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6Imhwb2duZ2R3b3VzZXZueXJubWV3Iiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImlhdCI6MTcxNDg5NDE1MiwiZXhwIjoyMDMwNDcwMTUyfQ.ZzvQboRczmpcu2AgCx8YdTXm82AsFerZYe8Nzkx7JbI\"\n",
    "supabase: Client = create_client(url, key)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "res = supabase.storage.list_buckets()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "response = supabase.table('users').select(\"*\").execute()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'name': '9e9b8546-8744-4a63-8e61-6b9a0a95eee5',\n",
       "  'id': None,\n",
       "  'updated_at': None,\n",
       "  'created_at': None,\n",
       "  'last_accessed_at': None,\n",
       "  'metadata': None}]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "res = supabase.storage.from_('users').list()\n",
    "\n",
    "res"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting stripe\n",
      "  Downloading stripe-9.9.0-py2.py3-none-any.whl.metadata (2.7 kB)\n",
      "Requirement already satisfied: requests>=2.20 in /Users/antoineross/miniconda3/envs/mikagp/lib/python3.11/site-packages (from stripe) (2.31.0)\n",
      "Requirement already satisfied: typing-extensions>=4.5.0 in /Users/antoineross/miniconda3/envs/mikagp/lib/python3.11/site-packages (from stripe) (4.11.0)\n",
      "Requirement already satisfied: charset-normalizer<4,>=2 in /Users/antoineross/miniconda3/envs/mikagp/lib/python3.11/site-packages (from requests>=2.20->stripe) (3.3.2)\n",
      "Requirement already satisfied: idna<4,>=2.5 in /Users/antoineross/miniconda3/envs/mikagp/lib/python3.11/site-packages (from requests>=2.20->stripe) (3.7)\n",
      "Requirement already satisfied: urllib3<3,>=1.21.1 in /Users/antoineross/miniconda3/envs/mikagp/lib/python3.11/site-packages (from requests>=2.20->stripe) (2.2.1)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in /Users/antoineross/miniconda3/envs/mikagp/lib/python3.11/site-packages (from requests>=2.20->stripe) (2024.2.2)\n",
      "Downloading stripe-9.9.0-py2.py3-none-any.whl (1.5 MB)\n",
      "\u001b[2K   \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m1.5/1.5 MB\u001b[0m \u001b[31m8.7 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0ma \u001b[36m0:00:01\u001b[0m\n",
      "\u001b[?25hInstalling collected packages: stripe\n",
      "Successfully installed stripe-9.9.0\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    }
   ],
   "source": [
    "%pip install stripe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Deactivated price price_1POAehHeFotLJ2yj0XReut6J for product prod_QEdw4ss7XWt7ZK\n",
      "Deactivated price price_1POAehHeFotLJ2yjEd7RSv7Z for product prod_QEdw4ss7XWt7ZK\n",
      "Archived product prod_QEdw4ss7XWt7ZK\n",
      "Deactivated price price_1POAegHeFotLJ2yj16L2yudL for product prod_QEdw05sf3ygnYW\n",
      "Deactivated price price_1POAefHeFotLJ2yjegrQpuVA for product prod_QEdw05sf3ygnYW\n",
      "Archived product prod_QEdw05sf3ygnYW\n",
      "Deactivated price price_1POAefHeFotLJ2yjEbKCJfsV for product prod_QEdwjkKwXrKfw2\n",
      "Deactivated price price_1POAeeHeFotLJ2yj9Ta2aELh for product prod_QEdwjkKwXrKfw2\n",
      "Archived product prod_QEdwjkKwXrKfw2\n",
      "Deactivated price price_1POAedHeFotLJ2yjQYTQHkVn for product prod_QEdwQcfXoLjEtf\n",
      "Deactivated price price_1POAedHeFotLJ2yjUmFKmcdA for product prod_QEdwQcfXoLjEtf\n",
      "Archived product prod_QEdwQcfXoLjEtf\n",
      "Deactivated price price_1POAcjHeFotLJ2yjtWTJXPXg for product prod_QEdur6U69XE3fn\n",
      "Deactivated price price_1POAciHeFotLJ2yj9hBuity4 for product prod_QEdur6U69XE3fn\n",
      "Archived product prod_QEdur6U69XE3fn\n",
      "Deactivated price price_1POAciHeFotLJ2yjaUwQ1zZm for product prod_QEdu9yJXHhnfRT\n",
      "Deactivated price price_1POAchHeFotLJ2yjDk2qmDI5 for product prod_QEdu9yJXHhnfRT\n",
      "Archived product prod_QEdu9yJXHhnfRT\n",
      "Deactivated price price_1POAcgHeFotLJ2yjFPSYtgCN for product prod_QEdue1nl9rUXJG\n",
      "Deactivated price price_1POAcgHeFotLJ2yj1kP9waw9 for product prod_QEdue1nl9rUXJG\n",
      "Archived product prod_QEdue1nl9rUXJG\n",
      "Deactivated price price_1POAcfHeFotLJ2yjWFrLFUEx for product prod_QEdu4zzbFJh1dN\n",
      "Deactivated price price_1POAcfHeFotLJ2yjQy0Zeyxn for product prod_QEdu4zzbFJh1dN\n",
      "Archived product prod_QEdu4zzbFJh1dN\n",
      "Deactivated price price_1POANmHeFotLJ2yjkieZlN7z for product prod_QEdf4NGXl3MkFN\n",
      "Deactivated price price_1POANlHeFotLJ2yjdTn2OYzv for product prod_QEdf4NGXl3MkFN\n",
      "Archived product prod_QEdf4NGXl3MkFN\n",
      "Deactivated price price_1POAFgHeFotLJ2yjKTI7pzbg for product prod_QEdWuLYZ95qlo8\n",
      "Deactivated price price_1POAFgHeFotLJ2yjemY8aJ50 for product prod_QEdWuLYZ95qlo8\n",
      "Archived product prod_QEdWuLYZ95qlo8\n",
      "Deactivated price price_1POAFfHeFotLJ2yjb6bDBFPs for product prod_QEdWkE9qQqrawa\n",
      "Deactivated price price_1POAFfHeFotLJ2yjVwBeNQd5 for product prod_QEdWkE9qQqrawa\n",
      "Archived product prod_QEdWkE9qQqrawa\n",
      "Deactivated price price_1PO1VKHeFotLJ2yjNGXQ3eRI for product prod_QEUUE0P1JU9hwd\n",
      "Deactivated price price_1PO1VJHeFotLJ2yjbYbMrp3E for product prod_QEUUE0P1JU9hwd\n",
      "Archived product prod_QEUUE0P1JU9hwd\n",
      "Deactivated price price_1PO1VJHeFotLJ2yj3SpKxJFX for product prod_QEUUpaSgWBaMwv\n",
      "Deactivated price price_1PO1VIHeFotLJ2yjEzhlGlJU for product prod_QEUUpaSgWBaMwv\n",
      "Archived product prod_QEUUpaSgWBaMwv\n",
      "Deactivated price price_1PO1VHHeFotLJ2yj4GLmZNwy for product prod_QEUUEpckleK49c\n",
      "Deactivated price price_1PO1VHHeFotLJ2yjKIsPu0qT for product prod_QEUUEpckleK49c\n",
      "Archived product prod_QEUUEpckleK49c\n",
      "Deactivated price price_1PO1VGHeFotLJ2yj0tLLbOLZ for product prod_QEUUgT77ZrYudO\n",
      "Deactivated price price_1PO1VFHeFotLJ2yjTAioNBOn for product prod_QEUUgT77ZrYudO\n",
      "Archived product prod_QEUUgT77ZrYudO\n",
      "Deactivated price price_1PO1KSHeFotLJ2yjaDKPkNju for product prod_QEUJHrdqQysMUR\n",
      "Deactivated price price_1PO1KRHeFotLJ2yj9NPB6cqm for product prod_QEUJHrdqQysMUR\n",
      "Archived product prod_QEUJHrdqQysMUR\n",
      "Deactivated price price_1PO1KRHeFotLJ2yjlJcspTTs for product prod_QEUJLzG3oWljr4\n",
      "Deactivated price price_1PO1KQHeFotLJ2yjOxMffADc for product prod_QEUJLzG3oWljr4\n",
      "Archived product prod_QEUJLzG3oWljr4\n",
      "Deactivated price price_1PO1KPHeFotLJ2yjfpRY6xdD for product prod_QEUJo18x2DSdKA\n",
      "Deactivated price price_1PO1KPHeFotLJ2yjp1x4npKR for product prod_QEUJo18x2DSdKA\n",
      "Archived product prod_QEUJo18x2DSdKA\n",
      "Deactivated price price_1PO1KOHeFotLJ2yjGHHSJtXk for product prod_QEUIspBU6M61sx\n",
      "Deactivated price price_1PO1KNHeFotLJ2yjnVZc7EqG for product prod_QEUIspBU6M61sx\n",
      "Archived product prod_QEUIspBU6M61sx\n",
      "Deactivated price price_1PDEcsHeFotLJ2yjNds0Gw7F for product prod_Q3LJAsvD9CqC82\n",
      "Deactivated price price_1PDEcsHeFotLJ2yjMFjj4hLr for product prod_Q3LJAsvD9CqC82\n",
      "Archived product prod_Q3LJAsvD9CqC82\n",
      "Deactivated price price_1PDEcrHeFotLJ2yjFgrOuT9j for product prod_Q3LJeUTepQZ2UQ\n",
      "Deactivated price price_1PDEcrHeFotLJ2yjT1YhOvCd for product prod_Q3LJeUTepQZ2UQ\n",
      "Archived product prod_Q3LJeUTepQZ2UQ\n",
      "Deactivated price price_1PDEcqHeFotLJ2yj4lQmOKqA for product prod_Q3LJl0NCxgOn9S\n",
      "Deactivated price price_1PDEcpHeFotLJ2yjWbtyggUg for product prod_Q3LJl0NCxgOn9S\n",
      "Archived product prod_Q3LJl0NCxgOn9S\n",
      "Deactivated price price_1PDEcoHeFotLJ2yjGJIVdC0O for product prod_Q3LJhk8aOEj1qh\n",
      "Deactivated price price_1PDEcoHeFotLJ2yjHIx2Deis for product prod_Q3LJhk8aOEj1qh\n",
      "Archived product prod_Q3LJhk8aOEj1qh\n",
      "Deactivated price price_1PCzgIHeFotLJ2yjWuOIjssj for product prod_Q35sCdAHDoYC2c\n",
      "Deactivated price price_1PCzgHHeFotLJ2yjwMVT9vVC for product prod_Q35sCdAHDoYC2c\n",
      "Archived product prod_Q35sCdAHDoYC2c\n",
      "Deactivated price price_1PCzgHHeFotLJ2yjUWNAgeTk for product prod_Q35silCb2dSdE0\n",
      "Deactivated price price_1PCzgGHeFotLJ2yj3LyQy2VM for product prod_Q35silCb2dSdE0\n",
      "Archived product prod_Q35silCb2dSdE0\n",
      "Deactivated price price_1PCzgFHeFotLJ2yjRlTyhHaG for product prod_Q35r0bJXeq2xXv\n",
      "Deactivated price price_1PCzgFHeFotLJ2yjpT4xu88Y for product prod_Q35r0bJXeq2xXv\n",
      "Archived product prod_Q35r0bJXeq2xXv\n",
      "Deactivated price price_1PCzgEHeFotLJ2yjlo8EShnl for product prod_Q35ro77oMIGAUX\n",
      "Deactivated price price_1PCzgEHeFotLJ2yj0524bAMj for product prod_Q35ro77oMIGAUX\n",
      "Archived product prod_Q35ro77oMIGAUX\n",
      "Deactivated price price_1PAzjuHeFotLJ2yjcTwo5V9r for product prod_Q11npAqR1cMEVl\n",
      "Archived product prod_Q11npAqR1cMEVl\n",
      "Deactivated price price_1PAzjaHeFotLJ2yj2ybyQzTH for product prod_Q11n5S7YXd1RuD\n",
      "Archived product prod_Q11n5S7YXd1RuD\n",
      "Deactivated price price_1PAzjKHeFotLJ2yjd0spKXeI for product prod_Q11mjofhblKPnI\n",
      "Archived product prod_Q11mjofhblKPnI\n",
      "Deactivated price price_1PAzj5HeFotLJ2yjLSaVo7Tq for product prod_Q11m6L2CadyzW2\n",
      "Archived product prod_Q11m6L2CadyzW2\n",
      "Deactivated price price_1PAziiHeFotLJ2yj1ihg3Uud for product prod_Q11m9NNrFI1jdh\n",
      "Archived product prod_Q11m9NNrFI1jdh\n",
      "Deactivated price price_1PAzi6HeFotLJ2yj2KCufwHK for product prod_Q11lIIHR0dyTvK\n",
      "Archived product prod_Q11lIIHR0dyTvK\n",
      "Deactivated price price_1PAzhcHeFotLJ2yj8RdBZTmn for product prod_Q11lMqg86zMSvu\n",
      "Archived product prod_Q11lMqg86zMSvu\n",
      "Deactivated price price_1PAzggHeFotLJ2yjmm9iq2AJ for product prod_Q11kxwZuqPfJ1l\n",
      "Archived product prod_Q11kxwZuqPfJ1l\n"
     ]
    }
   ],
   "source": [
    "import stripe\n",
    "\n",
    "# Set your secret key. Ensure this is the test mode key.\n",
    "# stripe.api_key = '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'\n",
    "# stripe.api_key = 'sk_test_51OjlK9HeFotLJ2yjlPMzcTe7sDIOZzcBDyI9iI1mYOQC78h4KzkfJyo5FfaCwDPRxfXhIIRlpdTxXpUJqbP16iJo00sOQ8NFA2'\n",
    "# Fetch all products\n",
    "products = stripe.Product.list(limit=100)\n",
    "\n",
    "def deactivate_and_archive_products(stripe_instance):\n",
    "    products = stripe_instance.Product.list(limit=100)\n",
    "\n",
    "    # Loop through and deactivate prices, then archive each product\n",
    "    for product in products.auto_paging_iter():\n",
    "        if product.active:\n",
    "            # Fetch prices for each product\n",
    "            prices = stripe_instance.Price.list(product=product.id)\n",
    "            for price in prices.auto_paging_iter():\n",
    "                # Deactivate the price\n",
    "                stripe_instance.Price.modify(price.id, active=False)\n",
    "                print(f\"Deactivated price {price.id} for product {product.id}\")\n",
    "\n",
    "            # Archive the product after deactivating its prices\n",
    "            stripe_instance.Product.modify(product.id, active=False)\n",
    "            print(f\"Archived product {product.id}\")\n",
    "\n",
    "# Call the function with the Stripe instance\n",
    "deactivate_and_archive_products(stripe)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Move the test mode from stripe to the live mode"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Test Products\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>prices</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>prod_QEepLngv9hvg5x</td>\n",
       "      <td>Enterprise</td>\n",
       "      <td>[price_1POBVYHeFotLJ2yjM8t3e3su, price_1POBVXHeFotLJ2yjzzycbMLc]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>prod_QEepCoBHwq4G2m</td>\n",
       "      <td>Unlimited</td>\n",
       "      <td>[price_1POBVWHeFotLJ2yjOr8cx0rX, price_1POBVWHeFotLJ2yjp0mRitYl]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>prod_QEeptDYVOaAQPc</td>\n",
       "      <td>Pro</td>\n",
       "      <td>[price_1POBVVHeFotLJ2yjoUWmbJVr, price_1POBVVHeFotLJ2yjTaNs7W1s]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>prod_QEepaZAt6UrPV0</td>\n",
       "      <td>Starter</td>\n",
       "      <td>[price_1POBVUHeFotLJ2yjt3hO73oA, price_1POBVTHeFotLJ2yjODBKMMWp]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id        name  \\\n",
       "0  prod_QEepLngv9hvg5x  Enterprise   \n",
       "1  prod_QEepCoBHwq4G2m   Unlimited   \n",
       "2  prod_QEeptDYVOaAQPc         Pro   \n",
       "3  prod_QEepaZAt6UrPV0     Starter   \n",
       "\n",
       "                                                             prices  \n",
       "0  [price_1POBVYHeFotLJ2yjM8t3e3su, price_1POBVXHeFotLJ2yjzzycbMLc]  \n",
       "1  [price_1POBVWHeFotLJ2yjOr8cx0rX, price_1POBVWHeFotLJ2yjp0mRitYl]  \n",
       "2  [price_1POBVVHeFotLJ2yjoUWmbJVr, price_1POBVVHeFotLJ2yjTaNs7W1s]  \n",
       "3  [price_1POBVUHeFotLJ2yjt3hO73oA, price_1POBVTHeFotLJ2yjODBKMMWp]  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Live Products\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>prices</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>prod_QEeunCZQTAGRth</td>\n",
       "      <td>Starter</td>\n",
       "      <td>[price_1POBaNHeFotLJ2yjOajkguph, price_1POBaNHeFotLJ2yjROK9PyuX]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>prod_QEeu4exfbO5FTu</td>\n",
       "      <td>Pro</td>\n",
       "      <td>[price_1POBaLHeFotLJ2yjCDqYYiED, price_1POBaLHeFotLJ2yjUyoFl2OC]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>prod_QEeuNSqj6zVHv7</td>\n",
       "      <td>Unlimited</td>\n",
       "      <td>[price_1POBaJHeFotLJ2yjHFbeB13p, price_1POBaJHeFotLJ2yjgbnvksfn]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>prod_QEeukSdR8Zn5XS</td>\n",
       "      <td>Enterprise</td>\n",
       "      <td>[price_1POBaHHeFotLJ2yj5pCl7iDl, price_1POBaHHeFotLJ2yjU0BtX405]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id        name  \\\n",
       "0  prod_QEeunCZQTAGRth     Starter   \n",
       "1  prod_QEeu4exfbO5FTu         Pro   \n",
       "2  prod_QEeuNSqj6zVHv7   Unlimited   \n",
       "3  prod_QEeukSdR8Zn5XS  Enterprise   \n",
       "\n",
       "                                                             prices  \n",
       "0  [price_1POBaNHeFotLJ2yjOajkguph, price_1POBaNHeFotLJ2yjROK9PyuX]  \n",
       "1  [price_1POBaLHeFotLJ2yjCDqYYiED, price_1POBaLHeFotLJ2yjUyoFl2OC]  \n",
       "2  [price_1POBaJHeFotLJ2yjHFbeB13p, price_1POBaJHeFotLJ2yjgbnvksfn]  \n",
       "3  [price_1POBaHHeFotLJ2yj5pCl7iDl, price_1POBaHHeFotLJ2yjU0BtX405]  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import stripe\n",
    "\n",
    "# Fetch active products from Stripe\n",
    "def fetch_products(stripe_instance):\n",
    "    products = []\n",
    "    for product in stripe_instance.Product.list(limit=100, active=True).auto_paging_iter():\n",
    "        prices = stripe_instance.Price.list(product=product.id).auto_paging_iter()\n",
    "        product_data = {\n",
    "            'id': product.id,\n",
    "            'name': product.name,\n",
    "            'prices': [price.id for price in prices]\n",
    "        }\n",
    "        products.append(product_data)\n",
    "    return products\n",
    "\n",
    "\n",
    "stripe.api_key = 'sk_test_51OjlK9HeFotLJ2yjlPMzcTe7sDIOZzcBDyI9iI1mYOQC78h4KzkfJyo5FfaCwDPRxfXhIIRlpdTxXpUJqbP16iJo00sOQ8NFA2'\n",
    "test_products = fetch_products(stripe)\n",
    "\n",
    "\n",
    "stripe.api_key = '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'\n",
    "live_products = fetch_products(stripe)\n",
    "\n",
    "import pandas as pd\n",
    "from IPython.display import display\n",
    "\n",
    "test_df = pd.DataFrame(test_products)\n",
    "live_df = pd.DataFrame(live_products)\n",
    "\n",
    "pd.set_option('display.max_colwidth', None)\n",
    "\n",
    "print(\"Test Products\")\n",
    "display(test_df)\n",
    "print(\"Live Products\")\n",
    "display(live_df)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'id': 'prod_QEeunCZQTAGRth',\n",
       "  'name': 'Starter',\n",
       "  'prices': ['price_1POBaNHeFotLJ2yjOajkguph',\n",
       "   'price_1POBaNHeFotLJ2yjROK9PyuX']},\n",
       " {'id': 'prod_QEeu4exfbO5FTu',\n",
       "  'name': 'Pro',\n",
       "  'prices': ['price_1POBaLHeFotLJ2yjCDqYYiED',\n",
       "   'price_1POBaLHeFotLJ2yjUyoFl2OC']},\n",
       " {'id': 'prod_QEeuNSqj6zVHv7',\n",
       "  'name': 'Unlimited',\n",
       "  'prices': ['price_1POBaJHeFotLJ2yjHFbeB13p',\n",
       "   'price_1POBaJHeFotLJ2yjgbnvksfn']},\n",
       " {'id': 'prod_QEeukSdR8Zn5XS',\n",
       "  'name': 'Enterprise',\n",
       "  'prices': ['price_1POBaHHeFotLJ2yj5pCl7iDl',\n",
       "   'price_1POBaHHeFotLJ2yjU0BtX405']}]"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "live_products"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "from supabase import create_client, Client\n",
    "\n",
    "# Initialize Supabase client\n",
    "supabase_url = 'https://hpogngdwousevnyrnmew.supabase.co'\n",
    "supabase_key = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6Imhwb2duZ2R3b3VzZXZueXJubWV3Iiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImlhdCI6MTcxNDg5NDE1MiwiZXhwIjoyMDMwNDcwMTUyfQ.ZzvQboRczmpcu2AgCx8YdTXm82AsFerZYe8Nzkx7JbI'\n",
    "supabase: Client = create_client(supabase_url, supabase_key)\n",
    "\n",
    "# Duplicate products with live IDs and update prices\n",
    "def duplicate_products_and_update_prices(test_products, live_products):\n",
    "    # Step 1: Update prices with live product IDs\n",
    "    for test_product in test_products:\n",
    "        matching_live_product = next((p for p in live_products if p['name'] == test_product['name']), None)\n",
    "        if matching_live_product:\n",
    "            # Sort prices by unit amount to ensure higher price is for the year\n",
    "            test_product['prices'].sort(key=lambda x: x['unit_amount'])\n",
    "            matching_live_product['prices'].sort(key=lambda x: x['unit_amount'])\n",
    "            \n",
    "            for test_price, live_price in zip(test_product['prices'], matching_live_product['prices']):\n",
    "                print(f\"\\nUpdating price for product name: {test_product['name']}\")\n",
    "                print(f\"Test mode price ID: {test_price['id']} with interval {test_price['interval']}\")\n",
    "                print(f\"Live mode price ID: {live_price['id']} with interval {live_price['interval']}\")\n",
    "\n",
    "                # Ensure that intervals match before updating\n",
    "                if test_price['interval'] == live_price['interval']:\n",
    "                    # Check if price with live ID already exists in Supabase\n",
    "                    response = supabase.table('prices').select('id').eq('id', live_price['id']).execute()\n",
    "                    if response.data:\n",
    "                        print(f\"Price with ID {live_price['id']} already exists. Skipping update.\")\n",
    "                        continue\n",
    "\n",
    "                    price_update = {\n",
    "                        'id': live_price['id'],\n",
    "                        'product_id': matching_live_product['id']\n",
    "                    }\n",
    "                    # Update price in Supabase\n",
    "                    response = supabase.table('prices').update(price_update).eq('id', test_price['id']).execute()\n",
    "                    if not response.data:\n",
    "                        print(f\"Error updating price {test_price['id']} to {live_price['id']}: {response}\")\n",
    "                    else:\n",
    "                        print(f\"Successfully updated price {test_price['id']} to {live_price['id']}\")\n",
    "                else:\n",
    "                    print(f\"Intervals do not match for prices: {test_price['interval']} and {live_price['interval']}\")\n",
    "\n",
    "    # Step 2: Duplicate test products with live product IDs\n",
    "    for test_product in test_products:\n",
    "        matching_live_product = next((p for p in live_products if p['name'] == test_product['name']), None)\n",
    "        if matching_live_product:\n",
    "            print(f\"Processing product: {test_product['name']}\")\n",
    "            print(f\"Test mode product ID: {test_product['id']}\")\n",
    "            print(f\"Live mode product ID: {matching_live_product['id']}\")\n",
    "\n",
    "            # Check if product with live ID already exists in Supabase\n",
    "            response = supabase.table('products').select('id').eq('id', matching_live_product['id']).execute()\n",
    "            if response.data:\n",
    "                print(f\"Product with ID {matching_live_product['id']} already exists. Skipping duplication.\")\n",
    "                continue\n",
    "\n",
    "            # Fetch test product details from Supabase\n",
    "            response = supabase.table('products').select('*').eq('id', test_product['id']).execute()\n",
    "            if not response.data:\n",
    "                print(f\"Error fetching product details for {test_product['id']}: {response}\")\n",
    "                continue\n",
    "            test_product_details = response.data[0]\n",
    "\n",
    "            # Insert duplicate product with live product ID\n",
    "            product_data = {\n",
    "                'id': matching_live_product['id'],\n",
    "                'active': test_product_details['active'],\n",
    "                'name': test_product_details['name'],\n",
    "                'description': test_product_details['description'],\n",
    "                'image': test_product_details['image'],\n",
    "                'metadata': test_product_details['metadata'],\n",
    "                'features': test_product_details['features'],\n",
    "                'data_sources_limit': test_product_details['data_sources_limit'],\n",
    "                'questions_limit': test_product_details['questions_limit'],\n",
    "            }\n",
    "            response = supabase.table('products').insert(product_data).execute()\n",
    "            if not response.data:\n",
    "                print(f\"Error duplicating product {test_product['id']} with {matching_live_product['id']}: {response}\")\n",
    "            else:\n",
    "                print(f\"Successfully duplicated product {test_product['id']} with {matching_live_product['id']}\")\n",
    "\n",
    "    # Step 3: Delete test mode products\n",
    "    for test_product in test_products:\n",
    "        print(f\"Deleting test mode product: {test_product['name']}\")\n",
    "        response = supabase.table('products').delete().eq('id', test_product['id']).execute()\n",
    "        if not response.data:\n",
    "            print(f\"Error deleting test mode product {test_product['id']}: {response}\")\n",
    "        else:\n",
    "            print(f\"Successfully deleted test mode product {test_product['id']}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Updating price for product name: Enterprise\n",
      "Test mode price ID: price_1POBVYHeFotLJ2yjM8t3e3su\n",
      "Live mode price ID: price_1POBaHHeFotLJ2yj5pCl7iDl\n",
      "Price with ID price_1POBaHHeFotLJ2yj5pCl7iDl already exists. Skipping update.\n",
      "\n",
      "Updating price for product name: Enterprise\n",
      "Test mode price ID: price_1POBVXHeFotLJ2yjzzycbMLc\n",
      "Live mode price ID: price_1POBaHHeFotLJ2yjU0BtX405\n",
      "Successfully updated price price_1POBVXHeFotLJ2yjzzycbMLc to price_1POBaHHeFotLJ2yjU0BtX405\n",
      "\n",
      "Updating price for product name: Unlimited\n",
      "Test mode price ID: price_1POBVWHeFotLJ2yjOr8cx0rX\n",
      "Live mode price ID: price_1POBaJHeFotLJ2yjHFbeB13p\n",
      "Price with ID price_1POBaJHeFotLJ2yjHFbeB13p already exists. Skipping update.\n",
      "\n",
      "Updating price for product name: Unlimited\n",
      "Test mode price ID: price_1POBVWHeFotLJ2yjp0mRitYl\n",
      "Live mode price ID: price_1POBaJHeFotLJ2yjgbnvksfn\n",
      "Successfully updated price price_1POBVWHeFotLJ2yjp0mRitYl to price_1POBaJHeFotLJ2yjgbnvksfn\n",
      "\n",
      "Updating price for product name: Pro\n",
      "Test mode price ID: price_1POBVVHeFotLJ2yjoUWmbJVr\n",
      "Live mode price ID: price_1POBaLHeFotLJ2yjCDqYYiED\n",
      "Price with ID price_1POBaLHeFotLJ2yjCDqYYiED already exists. Skipping update.\n",
      "\n",
      "Updating price for product name: Pro\n",
      "Test mode price ID: price_1POBVVHeFotLJ2yjTaNs7W1s\n",
      "Live mode price ID: price_1POBaLHeFotLJ2yjUyoFl2OC\n",
      "Successfully updated price price_1POBVVHeFotLJ2yjTaNs7W1s to price_1POBaLHeFotLJ2yjUyoFl2OC\n",
      "\n",
      "Updating price for product name: Starter\n",
      "Test mode price ID: price_1POBVUHeFotLJ2yjt3hO73oA\n",
      "Live mode price ID: price_1POBaNHeFotLJ2yjOajkguph\n",
      "Price with ID price_1POBaNHeFotLJ2yjOajkguph already exists. Skipping update.\n",
      "\n",
      "Updating price for product name: Starter\n",
      "Test mode price ID: price_1POBVTHeFotLJ2yjODBKMMWp\n",
      "Live mode price ID: price_1POBaNHeFotLJ2yjROK9PyuX\n",
      "Successfully updated price price_1POBVTHeFotLJ2yjODBKMMWp to price_1POBaNHeFotLJ2yjROK9PyuX\n",
      "Processing product: Enterprise\n",
      "Test mode product ID: prod_QEepLngv9hvg5x\n",
      "Live mode product ID: prod_QEeukSdR8Zn5XS\n",
      "Product with ID prod_QEeukSdR8Zn5XS already exists. Skipping duplication.\n",
      "Processing product: Unlimited\n",
      "Test mode product ID: prod_QEepCoBHwq4G2m\n",
      "Live mode product ID: prod_QEeuNSqj6zVHv7\n",
      "Product with ID prod_QEeuNSqj6zVHv7 already exists. Skipping duplication.\n",
      "Processing product: Pro\n",
      "Test mode product ID: prod_QEeptDYVOaAQPc\n",
      "Live mode product ID: prod_QEeu4exfbO5FTu\n",
      "Product with ID prod_QEeu4exfbO5FTu already exists. Skipping duplication.\n",
      "Processing product: Starter\n",
      "Test mode product ID: prod_QEepaZAt6UrPV0\n",
      "Live mode product ID: prod_QEeunCZQTAGRth\n",
      "Product with ID prod_QEeunCZQTAGRth already exists. Skipping duplication.\n",
      "Deleting test mode product: Enterprise\n",
      "Successfully deleted test mode product prod_QEepLngv9hvg5x\n",
      "Deleting test mode product: Unlimited\n",
      "Successfully deleted test mode product prod_QEepCoBHwq4G2m\n",
      "Deleting test mode product: Pro\n",
      "Successfully deleted test mode product prod_QEeptDYVOaAQPc\n",
      "Deleting test mode product: Starter\n",
      "Successfully deleted test mode product prod_QEepaZAt6UrPV0\n"
     ]
    }
   ],
   "source": [
    "# Update Supabase records\n",
    "duplicate_products_and_update_prices(test_products=test_products, \n",
    "                                     live_products=live_products)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "mikagp",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}