如何在R中自动化Git Bash操作？每周任务自动化求助

Absolutely, automating this repetitive weekly task is straightforward—let’s break down solutions for both Windows and macOS/Linux systems, since the tools differ a bit.

Windows Solution #

Step 1: Create a Batch Script (.bat) #

Write a batch file that runs your R script first, then executes all the Git commands in sequence. Save this as weekly_update.bat (replace paths with your actual file locations):

@echo off
REM Run your R script
"C:\Program Files\R\R-4.3.1\bin\Rscript.exe" "C:\path\to\your\weekly_script.R"

REM Navigate to your Git project directory
cd /D "C:\Documents\website\r-projects"

REM Execute Git commands
git add -A
REM Format the date as MM-DD-YYYY (adjust the %date% substring if your system uses a different date format)
set "today=%date:~4,2%-%date:~7,2%-%date:~10,4%"
git commit -m "%today%"
git push

Step 2: Schedule with Task Scheduler #

1. Open Task Scheduler (search for it in the Start Menu)
2. Click Create Basic Task
3. Name your task (e.g., "Weekly R Script + Git Update") and set a weekly trigger (pick your preferred day/time)
4. Choose Start a program as the action, then browse to your weekly_update.bat file
5. Finish the setup—your task will run automatically on the schedule you set

macOS/Linux Solution #

Step 1: Create a Shell Script (.sh) #

Write a shell script to handle the workflow. Save this as weekly_update.sh:

#!/bin/bash

# Run your R script
Rscript /path/to/your/weekly_script.R

# Navigate to your Git project directory
cd ~/Documents/website/r-projects

# Execute Git commands
git add -A
# Use ISO date format (YYYY-MM-DD) for the commit message
git commit -m "$(date +%Y-%m-%d)"
git push

Step 2: Make the Script Executable #

Run this in Terminal to give the script permission to execute:

chmod +x /path/to/weekly_update.sh

Step 3: Schedule with Cron #

1. Open your crontab editor:

crontab -e

2. Add a line to schedule the script (example runs every Monday at 9 AM—adjust the timing to your needs):

0 9 * * 1 /path/to/weekly_update.sh

Save and exit—cron will handle the weekly execution automatically.

Critical Notes #

• Git Credentials: To avoid being prompted for a username/password every time, set up Git credential storage:
  • Windows: Use Git Credential Manager (included with Git for Windows by default)
  • macOS: Run git config --global credential.helper osxkeychain
  • Linux: Run git config --global credential.helper libsecret
• Absolute Paths: Always use full absolute paths for your R script and Git project directory in the scripts—this avoids issues with working directory context when the script runs automatically.
• Test First: Run the script manually once before scheduling to make sure everything works (check that the R script runs, Git commits/pushes successfully).

内容的提问来源于stack exchange，提问作者Nick Knauer