Best prompts for ChatGPT for coding using automating repetitive tasks

Write a complete Python 3 script named batch_rename.py that: - Accepts CLI args: --dir (directory), --pattern (regex), --replacement (replacement string using re.sub syntax), --dry-run (flag), --map-file (path to write JSON map of old->new names), --ignore-case (flag). - Recursively finds files in --dir, computes new names using re.sub(pattern, replacement), and shows a preview table. - On confirmation, performs atomic renames, writes the mapping JSON to --map-file, and supports an --undo flag that reads the map and restores original names. - Logs all operations and handles name collisions safely (skip and log collision). - Include usage examples and unit tests for the core rename function. Produce the full script code and a short README section explaining usage and safety notes.

Create a Node.js (ESM) CLI project scaffold named csv2s3 with a bin script csv2s3.js that: - Accepts args: --input <glob>, --bucket <s3-bucket>, --prefix <s3-prefix>, --schema <json-schema-file>, --concurrency <n>, --dry-run. - Uses fast-csv or csv-parse to convert CSV rows to JSON, validates against the provided JSON Schema (ajv), and uploads files in batches to S3 using AWS SDK v3 with configurable concurrency and exponential backoff. - Produces detailed summary stats (rows processed, failures, uploaded objects, bytes) and writes a log file. - Includes package.json, example usage, and unit tests for parsing and validation. Return full code for csv2s3.js, example package.json, and README usage examples.

Write a GitHub Actions workflow (.github/workflows/ci-cd.yml) that: - Triggers on push to main and on pull_request to main. - Runs a matrix job for node versions [16,18] and OS [ubuntu-latest, macos-latest]. - Steps: checkout, cache node modules, install, run linter, run tests with coverage, build artifact, upload artifact to workflow, and on push to main deploy to a staging server via SSH (use secrets: STAGING_HOST, STAGING_USER, STAGING_SSH_KEY). - Includes conditional steps: only deploy on push to main, only upload coverage when tests succeed, and uses concurrency group to avoid parallel deploys. Provide the full YAML and a short explanation of required repo secrets and how to adapt for other infra (e.g., S3 or Docker image push).

Generate a SQL migration (up and down) plus a Python verification script that: - Targets Postgres and renames columns whose names match a provided mapping, e.g., {"usr_id": "user_id", "createdAt": "created_at"}. - Preserves constraints, indexes, foreign keys by generating appropriate ALTER TABLE statements and recreating dependent objects if necessary. - Includes BEGIN/COMMIT, transactional safety, and a rollback (down) migration that restores old names. - Provides a Python script verify_schema.py that connects to the DB, verifies all target tables have the new names, and optionally checks row counts remained unchanged. - Include guidance on running in production with minimal locking (use pg_repack recommendations if appropriate). Return the SQL migration, verify_schema.py, and short run instructions.

Write a jscodeshift transform script replace_api.js that: - Accepts a mapping from deprecated identifiers to new identifiers and optionally a new module path, e.g., {"oldApi": {"newName": "newApi", "newModule": "@new/lib"}}. - Finds occurrences of oldApi as named imports, default imports, and property access (obj.oldApi), replaces them with the new API, and updates import sources when newModule is provided. - Preserves comments and formatting, and emits a summary of changed files and nodes. - Include instructions on running the transform: npx jscodeshift -t replace_api.js src --parser=tsx and examples of mappings. Provide the full transform code and two concrete mapping examples.

Produce a Bash script rotate_logs.sh that: - Accepts args: --dir, --days, --archive-dir, --remote (user@host:/path), --compress (gz|xz), --dry-run. - Finds files in --dir older than --days, groups them by date, compresses each group into a timestamped archive in --archive-dir, enforces a max number of archives to keep, and then rsyncs new archives to --remote with retry/backoff. - Writes a manifest JSON with archive contents and size, supports verbose and quiet modes, and exits non-zero on unrecoverable errors. - Handles filenames with spaces/newlines and uses flock or lockfile for single-run safety. Return the full script with usage examples and a small systemd timer example to run weekly.