This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DECLARE @UserId INT = 6; -- Replace with actual user ID | |
| DECLARE @NewOwnerId INT = 4; -- Replace with ID of user to reassign content to (-1 = admin) | |
| DECLARE @UserEmail NVARCHAR(255) = 'user@example.com'; -- Or find by email | |
| DECLARE @UserKey NVARCHAR(255) = '881c7002-72e2-49c4-ac8c-467114d14dd6'; -- will be replaced in code below | |
| -- Find user ID by email if needed | |
| -- SELECT @UserId = id FROM umbracoUser WHERE userEmail = @UserEmail; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| You are a senior full-stack software architect, codebase archaeologist, and technical documentation lead. | |
| Task: | |
| Analyze the full source code I provide for a web application and produce comprehensive rebuild documentation explaining how the app is put together and how it could be rebuilt using modern technologies. | |
| Primary objective: | |
| Create documentation detailed enough that a competent engineering team could understand, reproduce, modernize, and safely reimplement the application. | |
| Context: | |
| I will provide the complete source code for the app. You must inspect the codebase as evidence, not guess from framework conventions alone. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Core member export: one row per member */ | |
| SELECT | |
| m.nodeId AS MemberId, | |
| n.uniqueId AS MemberKey, | |
| n.[text] AS MemberName, | |
| m.LoginName AS Username, | |
| m.Email, | |
| ct.alias AS MemberTypeAlias, | |
| ct.[description] AS MemberTypeName, | |
| n.createDate, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH CurrentMemberVersion AS | |
| ( | |
| SELECT | |
| cv.ContentId, | |
| cv.VersionId, | |
| ROW_NUMBER() OVER ( | |
| PARTITION BY cv.ContentId | |
| ORDER BY cv.VersionDate DESC, cv.Id DESC | |
| ) AS rn | |
| FROM cmsContentVersion cv |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| You are a world-class prompt engineer. Your job is to create a high-performance prompt that another AI can execute reliably. | |
| Transform my input into a prompt that is: | |
| - precise | |
| - unambiguous | |
| - context-rich | |
| - outcome-driven | |
| - structured for strong output quality | |
| When building the prompt, do this: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Act as a senior TypeScript SDK, React library, and Next.js architecture expert. | |
| Your job is to generate a production-ready set of TypeScript libraries and supporting app-layer code for a Next.js website that wraps an API into strongly typed objects, clients, hooks, and domain models. | |
| I will provide: | |
| * a Postman collection | |
| * a Postman environment | |
| * one or more PDF documents with API, workflow, or business rules | |
| * optionally example payloads, error responses, and usage notes |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| You are an expert API integration engineer. Your job is to read the attached PDF specification document and convert it into a complete, import-ready Postman collection JSON, plus all supporting setup instructions needed to use it properly. | |
| What I want you to produce: | |
| 1. A valid Postman collection in Collection v2.1 JSON format. | |
| 2. A matching Postman environment JSON with all variables the collection needs. | |
| 3. A clear variable reference table showing: | |
| * variable name | |
| * purpose |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| USE DatabaseName; | |
| GO | |
| -- Truncate the log by changing the database recovery model to SIMPLE. | |
| ALTER DATABASE DatabaseName | |
| SET RECOVERY SIMPLE; | |
| GO | |
| -- Shrink the truncated log file to 1 MB. | |
| DBCC SHRINKFILE (DatabaseName_Log, 1); | |
| GO | |
| -- Reset the database recovery model. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| var count = 0; | |
| for (const property in app) { | |
| try { | |
| var l = JSON.stringify(app[property]).length; | |
| count += l; | |
| console.log(`${property}: ${l}`); | |
| } catch(e) { | |
| // meh | |
| } | |
| }; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ## Ignore Visual Studio temporary files, build results, and | |
| ## files generated by popular Visual Studio add-ons. | |
| ## | |
| ## Get latest from https://github.com/github/gitignore/blob/master/VisualStudio.gitignore | |
| # User-specific files | |
| *.suo | |
| *.user | |
| *.userosscache | |
| *.sln.docstates |
NewerOlder