[{"_1":2,"_172":-5,"_173":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","f51a00d1aedfb0f6c517a3d665913da6776cbefb","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_150":151,"_169":170,"_171":-5},"handle","dinavinter","name","os","path","delete-test-projects-advanced.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":116,"_118":-5,"_119":32,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_136":137,"_149":20},"id","e15ca240-4214-11f0-b519-76b3cceeab13","createdAt",["D",1749131789618],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","6d45e71e-9df4-45e8-82ab-e09c45bfc5a1","pinnedFileId","fd41b95a-455c-11f0-9a97-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","b636164b-34c9-4e0c-9d39-dd3dc6f25436","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ycVgxSUNRd1V1VDlqTnNmYUh6MDA0VW1ldlMifQ","org",{"_94":95,"_135":132,"_12":112},"avatar","branch",{"_138":139,"_96":44,"_102":140,"_141":103,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":97,"_148":95},"version",169,"e15cf164-4214-11f0-b519-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":152,"_96":99,"_153":154,"_155":-5,"_156":140,"_157":158,"_159":116,"_104":160,"_138":161,"_162":163,"_164":165,"_166":20,"_167":-5,"_98":168},"227a0cee-42e8-11f0-b273-76b3cceeab13","fileId","b31e31b0-42e5-11f0-a397-76b3cceeab13","parentId","branchId","branchVersion",73,"latest",["D",1749222522666],6,"fileType","script","content","// Advanced script to delete projects with titles that are \"test\" or start with \"test\"\n// Includes safety features, dry run mode, and comprehensive reporting\n\nconst GIGYA_DOMAIN = process.env.GIGYA_DOMAIN || \"accounts.eu1.gigya.com\";\nconst GIGYA_API_KEY = process.env.GIGYA_API_KEY;\nconst GIGYA_APP_KEY = process.env.GIGYA_APP_KEY;\nconst GIGYA_APP_SECRET = process.env.GIGYA_APP_SECRET;\n\n// Configuration options\nconst CONFIG = {\n dryRun: false, // process.env.DRY_RUN === \"true\", // Set to true to preview deletions without executing them\n requireConfirmation: false, // process.env.REQUIRE_CONFIRMATION !== \"false\", // Require manual confirmation\n batchSize: 5, // Number of projects to delete in each batch\n delayBetweenRequests: 200, // Milliseconds to wait between API calls\n caseSensitive: process.env.CASE_SENSITIVE === \"true\", // Case sensitive matching\n exactMatchOnly: process.env.EXACT_MATCH_ONLY === \"true\", // Only delete exact \"test\" matches\n customPatterns: process.env.CUSTOM_PATTERNS?.split(\",\") || [], // Additional patterns to match\n};\n\nif (!GIGYA_API_KEY || !GIGYA_APP_KEY || !GIGYA_APP_SECRET) {\n console.error(\"Missing Gigya environment variables!\");\n console.log(\"Required variables: GIGYA_API_KEY, GIGYA_APP_KEY, GIGYA_APP_SECRET\");\n console.log(\"\\nOptional environment variables:\");\n console.log(\"- DRY_RUN=true (preview deletions without executing)\");\n console.log(\"- REQUIRE_CONFIRMATION=false (skip confirmation prompt)\");\n console.log(\"- CASE_SENSITIVE=true (case sensitive title matching)\");\n console.log(\"- EXACT_MATCH_ONLY=true (only delete exact 'test' matches)\");\n console.log(\"- CUSTOM_PATTERNS=pattern1,pattern2 (additional patterns to match)\");\n process.exit(1);\n}\n\ninterface ProjectData {\n id?: number;\n title: string;\n description: string;\n repositoryUrl: string;\n votes: number;\n comments: number;\n commitment?: string;\n skills?: string[];\n contribution?: string;\n author?: string;\n enabled: boolean;\n createdAt?: string;\n updatedAt?: string;\n deleted?: boolean;\n deletedAt?: string;\n}\n\ninterface GigyaResponse {\n errorCode: number;\n errorMessage?: string;\n results?: Array<{\n oid: string;\n data: ProjectData;\n }>;\n object?: {\n data: ProjectData;\n };\n}\n\ninterface DeletionStats {\n total: number;\n matched: number;\n deleted: number;\n errors: number;\n skipped: number;\n}\n\nasync function makeGigyaRequest(endpoint: string, params: Record): Promise {\n const url = `https://${GIGYA_DOMAIN}/${endpoint}?httpStatusCodes=true`;\n\n const body = new URLSearchParams({\n apiKey: GIGYA_API_KEY!,\n userKey: GIGYA_APP_KEY!,\n secret: GIGYA_APP_SECRET!,\n ...params,\n });\n\n const response = await fetch(url, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body,\n });\n\n if (!response.ok) {\n const text = await response.text();\n throw new Error(`${response.statusText}: ${text}`);\n }\n\n const text = await response.text();\n return JSON.parse(text);\n}\n\nfunction isTestProject(title: string): { isMatch: boolean; reason: string } {\n const originalTitle = title.trim();\n const checkTitle = CONFIG.caseSensitive ? originalTitle : originalTitle.toLowerCase();\n\n // Check exact match for \"test\"\n if (checkTitle === \"test\") {\n return { isMatch: true, reason: \"Exact match: 'test'\" };\n }\n\n // If exact match only, stop here\n if (CONFIG.exactMatchOnly) {\n return { isMatch: false, reason: \"Not exact match\" };\n }\n\n // Check if starts with \"test\"\n if (checkTitle.startsWith(\"test\")) {\n return { isMatch: true, reason: \"Starts with 'test'\" };\n }\n\n // Check custom patterns\n for (const pattern of CONFIG.customPatterns) {\n if (pattern.trim()) {\n const checkPattern = CONFIG.caseSensitive ? pattern.trim() : pattern.trim().toLowerCase();\n if (checkTitle.includes(checkPattern)) {\n return { isMatch: true, reason: `Matches custom pattern: '${pattern}'` };\n }\n }\n }\n\n return { isMatch: false, reason: \"No match\" };\n}\n\nasync function analyzeProjects(): Promise {\n console.log(\"🔍 Analyzing projects for test patterns...\");\n\n try {\n const searchResponse = await makeGigyaRequest(\"ds.search\", {\n query: \"SELECT * FROM oss_projects WHERE deleted != true\",\n });\n\n if (searchResponse.errorCode !== 0) {\n throw new Error(`Failed to fetch projects: ${searchResponse.errorMessage}`);\n }\n\n const projects = searchResponse.results || [];\n\n const analysis = {\n total: projects.length,\n testProjects: 0,\n exactMatches: 0,\n startsWithTest: 0,\n customPatternMatches: 0,\n };\n\n const matchedProjects: Array<{ project: any; reason: string }> = [];\n\n for (const project of projects) {\n const { isMatch, reason } = isTestProject(project.data.title);\n\n if (isMatch) {\n analysis.testProjects++;\n matchedProjects.push({ project, reason });\n\n if (reason.includes(\"Exact match\")) {\n analysis.exactMatches++;\n } else if (reason.includes(\"Starts with\")) {\n analysis.startsWithTest++;\n } else if (reason.includes(\"custom pattern\")) {\n analysis.customPatternMatches++;\n }\n }\n }\n\n console.log(\"\\n📊 Project Analysis:\");\n console.log(` 📁 Total active projects: ${analysis.total}`);\n console.log(` 🧪 Test projects found: ${analysis.testProjects}`);\n console.log(` 🎯 Exact 'test' matches: ${analysis.exactMatches}`);\n console.log(` 🔤 Starts with 'test': ${analysis.startsWithTest}`);\n console.log(` 🔧 Custom pattern matches: ${analysis.customPatternMatches}`);\n\n if (matchedProjects.length > 0) {\n console.log(\"\\n📋 Projects that will be deleted:\");\n matchedProjects.forEach((item, index) => {\n const { project, reason } = item;\n console.log(` ${index + 1}. \"${project.data.title}\" - ${reason}`);\n if (project.data.author) {\n console.log(` 👤 Author: ${project.data.author}`);\n }\n if (project.data.createdAt) {\n console.log(` 📅 Created: ${new Date(project.data.createdAt).toLocaleDateString()}`);\n }\n });\n }\n } catch (error) {\n console.error(\"❌ Error during analysis:\", error);\n throw error;\n }\n}\n\nasync function confirmDeletion(projectCount: number): Promise {\n if (!CONFIG.requireConfirmation) {\n console.log(\"⚠️ Confirmation skipped (REQUIRE_CONFIRMATION=false)\");\n return true;\n }\n\n console.log(`\\n⚠️ WARNING: About to delete ${projectCount} test projects!`);\n console.log(\"This action cannot be undone.\");\n console.log(\"\\nTo proceed, type 'DELETE' (case sensitive):\");\n\n // In a real interactive environment, you would use readline\n // For this script, we'll check an environment variable\n const confirmation = process.env.CONFIRM_DELETE;\n\n if (confirmation === \"DELETE\") {\n console.log(\"✅ Deletion confirmed.\");\n return true;\n } else {\n console.log(\"❌ Deletion not confirmed. Exiting.\");\n console.log(\"To confirm deletion, set: CONFIRM_DELETE=DELETE\");\n return false;\n }\n}\n\nasync function deleteTestProjects(): Promise {\n console.log(`\\n🗑️ Starting test project deletion... ${CONFIG.dryRun ? \"(DRY RUN)\" : \"\"}`);\n\n const stats: DeletionStats = {\n total: 0,\n matched: 0,\n deleted: 0,\n errors: 0,\n skipped: 0,\n };\n\n try {\n // Fetch all projects\n const searchResponse = await makeGigyaRequest(\"ds.search\", {\n query: \"SELECT * FROM oss_projects WHERE deleted != true\",\n });\n\n if (searchResponse.errorCode !== 0) {\n throw new Error(`Failed to fetch projects: ${searchResponse.errorMessage}`);\n }\n\n const allProjects = searchResponse.results || [];\n stats.total = allProjects.length;\n\n // Identify test projects\n const testProjects = allProjects.filter(project => {\n const { isMatch } = isTestProject(project.data.title);\n return isMatch;\n });\n\n stats.matched = testProjects.length;\n\n if (testProjects.length === 0) {\n console.log(\"✅ No test projects found to delete.\");\n return stats;\n }\n\n // Confirm deletion\n if (!CONFIG.dryRun) {\n const confirmed = await confirmDeletion(testProjects.length);\n if (!confirmed) {\n stats.skipped = testProjects.length;\n return stats;\n }\n }\n\n // Process deletions in batches\n for (let i = 0; i < testProjects.length; i += CONFIG.batchSize) {\n const batch = testProjects.slice(i, i + CONFIG.batchSize);\n console.log(\n `\\n📦 Processing batch ${Math.floor(i / CONFIG.batchSize) + 1}/${\n Math.ceil(testProjects.length / CONFIG.batchSize)\n }`,\n );\n\n for (const project of batch) {\n try {\n const { reason } = isTestProject(project.data.title);\n console.log(`🔄 ${CONFIG.dryRun ? \"[DRY RUN] \" : \"\"}Deleting \"${project.data.title}\"`);\n console.log(` 📝 Reason: ${reason}`);\n\n if (!CONFIG.dryRun) {\n // Mark project as deleted (soft delete)\n const updatedProjectData = {\n ...project.data,\n deleted: true,\n deletedAt: new Date().toISOString(),\n updatedAt: new Date().toISOString(),\n };\n\n const deleteResponse = await makeGigyaRequest(\"ds.delete\", {\n type: \"oss_projects\",\n oid: project.oid,\n });\n\n if (deleteResponse.errorCode === 0) {\n console.log(` ✅ Successfully deleted`);\n stats.deleted++;\n } else {\n console.error(` ❌ Failed to delete: ${deleteResponse.errorMessage}`);\n stats.errors++;\n }\n\n // Rate limiting delay\n await new Promise((resolve) => setTimeout(resolve, CONFIG.delayBetweenRequests));\n } else {\n stats.deleted++; // Count as deleted for dry run stats\n }\n } catch (error) {\n console.error(`❌ Error deleting \"${project.data.title}\":`, error);\n stats.errors++;\n }\n }\n }\n\n return stats;\n } catch (error) {\n console.error(\"❌ Error during deletion process:\", error);\n throw error;\n }\n}\n\nasync function generateReport(stats: DeletionStats): Promise {\n console.log(\"\\n📊 Final Deletion Report:\");\n console.log(\"=\".repeat(50));\n console.log(`📁 Total projects analyzed: ${stats.total}`);\n console.log(`🎯 Test projects found: ${stats.matched}`);\n console.log(`🗑️ Successfully deleted: ${stats.deleted}`);\n console.log(`⏭️ Skipped: ${stats.skipped}`);\n console.log(`❌ Errors: ${stats.errors}`);\n\n if (stats.matched > 0) {\n const successRate = (stats.deleted / stats.matched * 100).toFixed(1);\n console.log(`📈 Success rate: ${successRate}%`);\n }\n\n if (CONFIG.dryRun) {\n console.log(\"\\n⚠️ This was a DRY RUN - no projects were actually deleted\");\n console.log(\" Set DRY_RUN=false and CONFIRM_DELETE=DELETE to execute deletions\");\n }\n}\n\nasync function verifyDeletion(): Promise {\n if (CONFIG.dryRun) return;\n\n console.log(\"\\n🔍 Verifying deletions...\");\n\n try {\n // Check active projects\n const activeResponse = await makeGigyaRequest(\"ds.search\", {\n query: \"SELECT * FROM oss_projects WHERE deleted != true\",\n });\n\n // Check deleted projects\n const deletedResponse = await makeGigyaRequest(\"ds.search\", {\n query: \"SELECT * FROM oss_projects WHERE deleted = true\",\n });\n\n if (activeResponse.errorCode === 0 && deletedResponse.errorCode === 0) {\n const activeProjects = activeResponse.results || [];\n const deletedProjects = deletedResponse.results || [];\n\n const remainingTestProjects = activeProjects.filter(project => {\n const { isMatch } = isTestProject(project.data.title);\n return isMatch;\n });\n\n const deletedTestProjects = deletedProjects.filter(project => {\n const { isMatch } = isTestProject(project.data.title);\n return isMatch;\n });\n\n console.log(`✅ Verification complete:`);\n console.log(` 📝 Total active projects: ${activeProjects.length}`);\n console.log(` 🧪 Remaining test projects: ${remainingTestProjects.length}`);\n console.log(` 🗑️ Deleted test projects: ${deletedTestProjects.length}`);\n\n if (remainingTestProjects.length > 0) {\n console.log(\"\\n⚠️ Test projects still active:\");\n remainingTestProjects.forEach((project, index) => {\n const { reason } = isTestProject(project.data.title);\n console.log(` ${index + 1}. \"${project.data.title}\" - ${reason}`);\n });\n } else {\n console.log(\"🎉 All matching test projects have been successfully deleted!\");\n }\n } else {\n console.error(\"❌ Verification failed\");\n }\n } catch (error) {\n console.error(\"❌ Error during verification:\", error);\n }\n}\n\n// Main execution\nasync function main() {\n console.log(\"🚀 Advanced Test Project Deletion Script\");\n console.log(\"=\".repeat(50));\n\n console.log(\"🔧 Configuration:\");\n console.log(` Dry Run: ${CONFIG.dryRun}`);\n console.log(` Require Confirmation: ${CONFIG.requireConfirmation}`);\n console.log(` Case Sensitive: ${CONFIG.caseSensitive}`);\n console.log(` Exact Match Only: ${CONFIG.exactMatchOnly}`);\n console.log(` Custom Patterns: ${CONFIG.customPatterns.length > 0 ? CONFIG.customPatterns.join(\", \") : \"None\"}`);\n\n try {\n await analyzeProjects();\n const stats = await deleteTestProjects();\n await generateReport(stats);\n await verifyDeletion();\n\n console.log(\"\\n🎉 Script completed successfully!\");\n } catch (error) {\n console.error(\"❌ Script execution failed:\", error);\n process.exit(1);\n }\n}\n\n// Run the script\nmain();","deleted","label",[99],"permalink","https://www.val.town/x/dinavinter/os/code/delete-test-projects-advanced.ts","extension","actionData","errors"]