[{"_1":2,"_158":-5,"_69":-5},"loaderData",{"_3":4,"_46":47,"_157":-5},"root",{"_5":6,"_19":-5,"_20":-5,"_21":22,"_23":-5,"_24":-5,"_25":-5,"_26":27,"_28":29,"_30":31,"_40":29,"_41":42,"_43":29,"_44":45},"env",{"_7":8,"_9":10,"_11":12,"_13":14,"_15":16,"_17":18},"SUPABASE_URL","https://hello.websim.com","SUPABASE_ANON_KEY","eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6Im9jamVmZ2NqamlxeWt3YWR2dnJkIiwicm9sZSI6ImFub24iLCJpYXQiOjE3MTE4MzI5OTMsImV4cCI6MjAyNzQwODk5M30.vsreOYwk8pKsr8NFlzpIzWAiD-vXj6ijv_Bhn1vYtHs","POSTHOG_KEY","phc_VHMOlrdxAbgSZHeF0SdSf07LZLRLAg5pZuTHkJGn050","POSTHOG_API_HOST","https://e.wbsm.ai","POSTHOG_UI_HOST","https://app.posthog.com","NODE_ENV","production","authUser","user","isLoggedOutOrAnonymous",true,"plan","balances","rewards","pinned",[],"has_default_username",false,"origins",{"_32":33,"_34":35,"_36":37,"_38":39},"origin","https://websim.com","apiOrigin","https://api.websim.com","contentOrigin","https://{PROJECT_ID}.c.websim.com","appDomainOrigin","https://{SUBDOMAIN}.on.websim.com","isMobile","theme","auto","pinSidebarCookieValue","homepageTabCookieValue","hot","slug",{"_48":49,"_103":104,"_133":134,"_154":155,"_156":-5},"site",{"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_73":74,"_75":76,"_77":78,"_83":84,"_97":98,"_99":100,"_101":-5,"_102":-5},"id","WAjP0X0GXF5rrl6MG","parent_id","zcVkGnUxc5TvDeRpU","created_at","2024-09-11T18:09:41.608755+00:00","state","done","model","sonnet","lore",{"_62":63,"_64":65,"_66":67},"version",1,"attachments",[],"features",{"_68":22,"_69":22,"_70":22,"_71":22,"_72":22},"context","errors","htmx","images","navigation","title","Multi-file CSV to SQL Database Converter","url","https://websim.universe/","prompt",{"_79":80,"_81":82},"type","plaintext","text","Now, let's create a more comprehensive solution that will create tables for all six of your files: bookmarks, followers, following, likes, sites, and users. We'll modify the script to handle multiple file uploads and create a table for each file.\nHere's an updated version of the script that can handle multiple file uploads and create separate tables for each:\n```\n\n\n\n \n \n Multi-file CSV to SQL Database Converter\n \n\n\n

Multi-file CSV to SQL Database Converter

\n \n

\n\n \n \n\n\n```\nKey changes in this updated version:\n\nThe file input now accepts multiple files (multiple attribute added).\nWe've added a handleFiles function that processes each uploaded file.\nThe processFile function uses Papa Parse to parse each CSV file and then calls createSQLDatabase.\nThe createSQLDatabase function now takes a tableName parameter, which is derived from the filename.\nWe've improved the column type detection to look for common patterns in column names (e.g., \"likes\", \"count\", \"date\").\nThe script now creates a separate table for each uploaded file and inserts the data accordingly.\nResults are displayed for each table created.","owner",{"_50":85,"_54":86,"_87":88,"_89":90,"_91":92,"_93":88,"_94":-5,"_95":-5,"_96":29},"7db14195-93ca-416e-bb4e-1f54354fc022","2024-07-25T05:11:24.867203+00:00","username","hintbl0ck","avatar_url","https://lh3.googleusercontent.com/a/ACg8ocKJhsKKehirDSK2bvJSaySshg1B0q5-eEo_SfSIpZCo6yPD0w=s96-c","description"," $\"Fullscreen$ ","twitter","discord_username","discord_id","is_admin","link_url","/p/tu_h74uv8xozclfkf8gr","versioned_link_url","/p/tu_h74uv8xozclfkf8gr/6","deleted_at","yapping","project",{"_50":105,"_54":106,"_107":108,"_73":109,"_110":111,"_46":112,"_113":114,"_115":116,"_52":-5,"_117":-5,"_101":-5,"_118":29,"_119":120,"_127":22,"_91":-5,"_128":129,"_130":-5,"_131":132},"tu_h74uv8xozclfkf8gr","2024-09-11T16:35:02.465284+00:00","updated_at","2024-11-15T20:35:42.424097+00:00","CSV Viewer","visibility","public","csv-viewer","created_by",{"_50":85,"_54":86,"_87":88,"_89":90,"_91":92,"_93":88,"_94":-5,"_95":-5,"_96":29},"current_version",6,"parent_version","posted","stats",{"_121":122,"_123":124,"_125":126},"views",66,"likes",4,"comments",0,"auto_set_current","comments_mode","open","from_template","domains",[],"project_revision",{"_50":135,"_62":116,"_54":136,"_137":-5,"_52":138,"_139":140,"_141":-5,"_113":142,"_143":144,"_146":105,"_107":108,"_101":-5,"_119":147,"_149":29,"_150":51,"_151":-5,"_152":-5,"_153":-5},"0191e246-e0a9-7376-8471-f79c8fd034ce","2024-09-11T18:09:41.545+00:00","visited_at","0191e20f-6895-73b6-a8a2-7dbf8ac10df4","parent_revision_version",5,"parent_revision_project_id",{"_50":85,"_54":86,"_87":88,"_89":90,"_91":92,"_93":88,"_94":-5,"_95":-5,"_96":29},"meta",{"_62":145},"1","project_id",{"_148":126},"multiplayer_count","draft","site_id","chat_session_id","chat_session_run_index","current_screenshot_url","cursor","eyJpZCI6IjAxOTFlMjQ2LWUwYTktNzM3Ni04NDcxLWY3OWM4ZmQwMzRjZSJ9","token","routes/browser/layout","actionData"]