[{"_1":2,"_151":-5,"_65":-5},"loaderData",{"_3":4,"_41":42,"_150":-5},"root",{"_5":6,"_19":-5,"_20":-5,"_21":-5,"_22":-5,"_23":-5,"_24":25,"_26":27,"_28":29,"_38":27,"_39":40},"env",{"_7":8,"_9":10,"_11":12,"_13":14,"_15":16,"_17":18},"SUPABASE_URL","https://hello.websim.ai","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","plan","balances","rewards","pinned",[],"has_default_username",false,"origins",{"_30":31,"_32":33,"_34":35,"_36":37},"origin","https://websim.ai","apiOrigin","https://api.websim.ai","contentOrigin","https://{PROJECT_ID}.c.websim.ai","appDomainOrigin","https://{SUBDOMAIN}.on.websim.ai","isMobile","theme","auto","slug",{"_43":44,"_99":100,"_129":130,"_148":149},"site",{"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_69":70,"_71":72,"_73":74,"_79":80,"_93":94,"_95":96,"_97":-5,"_98":-5},"id","WAjP0X0GXF5rrl6MG","parent_id","zcVkGnUxc5TvDeRpU","created_at","2024-09-11T18:09:41.608755+00:00","state","done","model","sonnet","lore",{"_57":58,"_59":60,"_61":62},"version",1,"attachments",[],"features",{"_63":64,"_65":64,"_66":64,"_67":64,"_68":64},"context",true,"errors","htmx","images","navigation","title","Multi-file CSV to SQL Database Converter","url","https://websim.universe/","prompt",{"_75":76,"_77":78},"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",{"_45":81,"_49":82,"_83":84,"_85":86,"_87":88,"_89":84,"_90":-5,"_91":-5,"_92":27},"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",{"_45":101,"_49":102,"_103":104,"_69":105,"_106":107,"_41":108,"_109":110,"_111":112,"_47":-5,"_113":-5,"_97":-5,"_114":27,"_115":116,"_123":64,"_87":-5,"_124":125,"_126":-5,"_127":128},"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",{"_45":81,"_49":82,"_83":84,"_85":86,"_87":88,"_89":84,"_90":-5,"_91":-5,"_92":27},"current_version",6,"parent_version","posted","stats",{"_117":118,"_119":120,"_121":122},"views",66,"likes",4,"comments",0,"auto_set_current","comments_mode","open","from_template","domains",[],"project_revision",{"_45":131,"_57":112,"_49":132,"_133":-5,"_47":134,"_135":136,"_137":-5,"_109":138,"_139":140,"_142":101,"_103":104,"_97":-5,"_115":143,"_145":27,"_146":46,"_147":-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",{"_45":81,"_49":82,"_83":84,"_85":86,"_87":88,"_89":84,"_90":-5,"_91":-5,"_92":27},"meta",{"_57":141},"1","project_id",{"_144":122},"multiplayer_count","draft","site_id","current_screenshot_url","cursor","eyJpZCI6IjAxOTFlMjQ2LWUwYTktNzM3Ni04NDcxLWY3OWM4ZmQwMzRjZSJ9","routes/browser/layout","actionData"]