Re: PSA: How to archive your EXACT homescreen(s) apps to Windows for perfect cross-platform backup/restore sans the net

Maria Sophia <[email protected]>
Newsgroups comp.mobile.android,alt.comp.microsoft.windows,alt.comp.os.windows-10
Organization BWH Usenet Archive (https://usenet.blueworldhosting.com)
Message-ID <[email protected]>
UPDATE:

Based on valuable improvement suggestions from folks on the Python team:
 Newsgroups: comp.lang.python
 Subject: PSA: A python script to clone your phone exactly, over Wi-Fi or USB
 Date: Fri, 21 Aug 2026 19:11:29 -0700
 Message-ID: <[email protected]>

  Lawrence D¢Oliveiro <[email protected]> writes:
   > CUSTOM_ADB_PATH = r"C:\app\editor\android\scrcpy\adb.exe"
   By the way, I think Python lets you write "/" instead of "\", which
   saves trouble with r-strings.

  Keith Thompson wrote:
   File paths are interpreted by the OS.  If an open() call succeeds
   with "C:/app/editor/android/scrcpy/adb.exe", I don't think that has
   anything to do with Python (other than Python not going out of its
   way to make it fail).      See also the pathlib module.

Both suggestions were added to the script for improved portability.
 v2p4 20260823 Adopted pathlib module for cross-platform path handling
 v2p3 20260823 Changed backslash to forwardslash for improved portability

Currently, restore_apps.bat relies on Windows syntax (@echo off, pause, 
backslashes/quotes), but if we ever decide to port the entire workflow 
to macOS or Linux in the future, we could expand version v2p4 to generate 
an additional companion shell script (e.g., restore_apps.sh using chmod +x) 
alongside the batch file which the script outputs for replication.

Here's the latest version taking into account both useful suggestions!
  # -------------------------------------------------------------------
  # apkhome.py 
  #  Creates a perfect app archive replica of the phone to the desktop 
  #    1. Exactly replicates Android homescreen panes/folders/apps/apk(s) 
  #    2. Into a perfect duplicate on the desktop 
  #    3. And also to a batch file 
  #    4. Which can be used to restore that perfect archive to any phone
  #  Note that
  #    A. The exact homescreen panes are replicated in the same order
  #    B. Using the exact folder names replicated in the same locations
  #    C. And using the exact icon launcher names and exact placement
  #    D. Along with each icon calling the exact same actionable intent
  #    E. Which launches the exact same app versions as the original
  #  Also note
  #    a. This works without the cloud, any accounts or the Internet
  #    b. As it works over Wi-Fi on the LAN or with the phone on USB
  #    c. Built using pathlib for native macOS, Linux and Windows support
  #  WIP: Perhaps add a companion macOS/Linux script to the Windows batch
  # -------------------------------------------------------------------
  #  Usage: python apkhome.py
  # -------------------------------------------------------------------
  # v2p4 20260823 Adopted pathlib module for cross-platform path handling
  # v2p3 20260823 Changed backslash to forwardslash for improved portability
  # v2p2 20260820 Added strict return-code validation for adb pull transfers
  # v2p1 20260819 Added automated batch-restoration-script generator 
  # v2p0 20260819 Added re-installation reference guide & ADB syntax options
  # v1p9 20260819 Added missing/uninstalled app tracking list and report
  # v1p8 20260819 Added _versio_ naming convention for package versioning
  # v1p7 20260819 Added end-of-run execution summary and tracking metrics
  # v1p6 20260819 Added cleanup prompt for existing ./apkhome directory
  # v1p5 20260819 Added custom fallback path for scrcpy's bundled adb.exe
  # v1p4 20260819 Added log file output (apkhome.log) alongside console
  # v1p3 20260819 Added Ctrl+C (KeyboardInterrupt) handling & cleanup
  # v1p2 20260819 Added interactive debug mode toggle for dry runs
  # v1p1 20260819 Added automated ADB split/monolithic APK pulling
  # v1p0 20260819 Combined SQL parsing and direct directory tree generation
  # -------------------------------------------------------------------
  # Creates a duplicate inventory of Android homescreen panels, folders, 
  # app icons, loose desktop shortcuts and Android application packages 
  # extracted from the Nova Launcher internal databases (nova.db). 
  # 
  # Reads nova.db, re-creates the homescreen folder and package hierarchy,
  # checks for a connected ADB device, runs adb shell pm path <package> 
  # to dynamically locate and pull component files (base.apk plus splits) 
  # feeding results into the newly created matching homescreen hierarchy.
  # -------------------------------------------------------------------
  # Prerequisite: "nova.db" SQL database file created using the 
  # last-known-good-version of the Tesla Coil Nova Launcher 7.0.57
  #    <https://mobile.softpedia.com/apk/nova-launcher/7.0.57/>
  # 
  # A. On Android, Nova Settings > Backup & restore > Backup > Save
  #      /storage/emulated/0/0000/bck/nova_backup/2026-08-19_11-31.novabackup
  # B. Copy the nova backup to the desktop & rename it to a zip extension
  #      adb pull 2026-08-19_11-31.novabackup 2026-08-19_11-31.novabackup.zip
  # C. Unzip using 7-zip (or equivalent)
  #      08/19/2026  11:31 AM 7,430,144 nova.db
  #      08/19/2026  11:31 AM     6,455 nova.xml
  #      08/19/2026  11:31 AM     4,818 supportDetails.txt
  # 
  # Tested on Android 13 USA-spec Samsung Galaxy A32-5G (locked bootloader)
  # Tested on Windows 10, Python 3.14.1, with the phone on the Wi-Fi LAN
  # -------------------------------------------------------------------
  # Sample output (note that system apps may have defined APK names)
  # 
  # com.android.systemui_versio_13
  #    08/19/2026  09:14 PM   38,323,407 SystemUI.apk
  #                1 File(s)   38,323,407 bytes
  #
  # com.simplemobiletools.clock_versio_5.11.2
  #    08/19/2026  09:04 PM   10,004,630 base.apk
  #                1 File(s)   10,004,630 bytes
  # 
  #    com.trianguloy.instantintent_versio_0.1
  #    08/19/2026  09:06 PM        47,835 base.apk
  #    08/19/2026  09:06 PM        10,221 split_config.xhdpi.apk
  #                2 File(s)       58,056 bytes
  #  
  #    com.chibatching.worldclockwidget_versio_20260316.0
  #    08/19/2026  09:04 PM   12,027,785 base.apk
  #    08/19/2026  09:04 PM           57,672 split_config.arm64_v8a.apk
  #    08/19/2026  09:04 PM           58,511 split_config.xhdpi.apk
  #                3 File(s)   12,143,968 bytes
  #  
  #    com.neuracle.zulutime_versio_1.5
  #    08/19/2026  09:03 PM   21,619,972 base.apk
  #    08/19/2026  09:03 PM   25,650,697 split_config.arm64_v8a.apk
  #    08/19/2026  09:03 PM           45,465 split_config.en.apk
  #    08/19/2026  09:03 PM           67,159 split_config.xhdpi.apk
  #                4 File(s)   47,383,293 bytes
  #  
  #    pixer.worldclock_versio_1.0.29
  #    08/19/2026  09:03 PM    6,161,133 base.apk
  #    08/19/2026  09:03 PM   14,546,665 split_config.arm64_v8a.apk
  #    08/19/2026  09:03 PM           29,018 split_config.en.apk
  #    08/19/2026  09:03 PM           16,730 split_config.es.apk
  #    08/19/2026  09:03 PM           68,714 split_config.xhdpi.apk
  #                5 File(s)   20,822,260 bytes
  # -------------------------------------------------------------------
  # To re-install the exact package subversion using adb over Wi-Fi,
  # navigate into any specific app folder containing your pulled APKs, 
  # and then run the appropriate "adb install" command as shown below.
  #
  # For a single APK such as com.simplemobiletools.gallery.pro:
  #    adb install -r -d -i "com.android.vending" base.apk
  #
  # For multi-split install files:
  #    adb install-multiple base.apk split_config.arm64_v8a.apk split_config.en.apk
  #
  # Advanced flags for system migration / restores:
  #    -r : Replace existing application (updates/overwrites cleanly)
  #    -d : Allow version code downgrade (if the current device has a newer app)
  #    -i : Specify any desired custom installer package identifier tag 
  #
  # Combined Example:
  #    adb install-multiple -r -d -i "adb" base.apk split_config.arm64_v8a.apk
  # -------------------------------------------------------------------
  
  import re
  import shutil
  import sqlite3
  import subprocess
  from pathlib import Path
  
  db_file = Path("nova.db")
  base_dir = Path("./apkhome")
  log_filename = Path("apkhome.log")
  
  # Custom fallback path for ADB using pathlib for universal OS interpretation
  CUSTOM_ADB_PATH = Path("C:/app/editor/android/scrcpy/adb.exe")
  
  # Tracking metrics for summary
  stats = {
      "screens_processed": 0,
      "folders_processed": 0,
      "loose_apps_processed": 0,
      "apps_attempted": 0,
      "apps_success": 0,
      "apps_failed": 0
  }
  
  # List to track missing/uninstalled packages for the final report
  missing_apps_list = []
  
  if not db_file.exists():
      print(f"Error: {db_file} not found. Please place it in the working directory.")
      exit(1)
  
  # Open log file for writing via pathlib
  log_file = log_filename.open("w", encoding="utf-8")
  
  def log_print(message):
      """Prints to console and writes to the log file simultaneously."""
      print(message)
      log_file.write(message + "\n")
      log_file.flush()
  
  # Helper to find the correct adb executable command/path using pathlib
  def get_adb_binary():
      # 1. Try global 'adb' command first
      try:
          subprocess.run(["adb", "version"], capture_output=True, text=True, check=True)
          return "adb"
      except (subprocess.SubprocessError, FileNotFoundError):
          pass
      
      # 2. Try the custom scrcpy path fallback
      if CUSTOM_ADB_PATH.exists():
          return str(CUSTOM_ADB_PATH)
          
      return None
  
  def get_app_version(binary, pkg):
      """Queries package version name via ADB, returns 'unknown' if it fails."""
      try:
          res = subprocess.run(
              [binary, "shell", "dumpsys", "package", pkg],
              capture_output=True, text=True, timeout=5
          )
          for line in res.stdout.splitlines():
              if "versionName=" in line:
                  parts = line.strip().split("versionName=")
                  if len(parts) > 1:
                      raw_ver = parts[1].split()[0]
                      return re.sub(r'[\\/*?:"<>|]', "", raw_ver)
      except Exception:
          pass
      return "unknown"
  
  # --- Setup & modes prompt ---
  log_print("--- Setup Mode ---")
  mode_choice = input("Run in [D]ebug mode (mock files, no phone needed) or [L]ive mode (real ADB pull)? [d/l]: ").strip().lower()
  log_file.write(f"User selected mode choice: {mode_choice}\n")
  DEBUG_MODE = mode_choice.startswith('d')
  
  # --- Existing directory handling ---
  if base_dir.exists():
      clean_choice = input(f"Existing '{base_dir}' folder detected. [C]lean/wipe it completely or [K]eep existing files? [c/k]: ").strip().lower()
      log_file.write(f"User selected directory cleanup choice: {clean_choice}\n")
      if clean_choice.startswith('c'):
          try:
              shutil.rmtree(base_dir)
              log_print(f"[i] Successfully wiped existing '{base_dir}' directory.")
          except Exception as e:
              log_print(f"[!] Warning: Failed to fully remove '{base_dir}': {e}")
      else:
          log_print(f"[i] Keeping existing '{base_dir}' directory (merging/updating content).")
  
  adb_binary = None
  adb_active = False
  
  if DEBUG_MODE:
      log_print("\n[!] Running in DEBUG mode. ADB will be bypassed, and dummy APKs will be created.")
  else:
      log_print("\n[i] Running in LIVE mode. Locating ADB binary...")
      adb_binary = get_adb_binary()
      
      if not adb_binary:
          log_print(f"Warning: 'adb' not found in PATH or at custom path ({CUSTOM_ADB_PATH}). Skipping APK pulling.")
          adb_active = False
      else:
          log_print(f"Using ADB binary at: {adb_binary}")
          try:
              adb_check = subprocess.run([adb_binary, "devices"], capture_output=True, text=True, check=True)
              devices = [line for line in adb_check.stdout.splitlines() if "\tdevice" in line]
              if not devices:
                  log_print("Warning: No active ADB devices found. Directory skeleton will be built, but APK pulling will be skipped.")
                  adb_active = False
              else:
                  log_print(f"ADB device detected: {devices[0].split()[0]}")
                  adb_active = True
          except (subprocess.SubprocessError, FileNotFoundError):
              log_print("Warning: Failed to execute ADB. Skipping APK pulling.")
              adb_active = False
  
  log_print(f"\nConnecting to {db_file} and processing layout...")
  
  conn = sqlite3.connect(db_file)
  cursor = conn.cursor()
  
  try:
      # 1. Fetch distinct screen indices associated with desktop items
      cursor.execute(
          "SELECT DISTINCT screen FROM favorites WHERE container = -100 ORDER BY screen ASC;"
      )
      screens = cursor.fetchall()
  
      for (screen_num,) in screens:
          stats["screens_processed"] += 1
          current_panel = f"panel_{screen_num}"
          log_print(f"\n--- Processing: {current_panel} ---")
  
          # 2. Find folders located directly on this specific screen (ignoring blank titles)
          cursor.execute(
              "SELECT _id, title FROM favorites WHERE container = -100 AND screen = ?"
              " AND intent IS NULL AND title IS NOT NULL AND TRIM(title) != '';",
              (screen_num,),
          )
          folders = cursor.fetchall()
  
          for folder_id, folder_name in folders:
              stats["folders_processed"] += 1
              clean_folder_name = re.sub(r'[\\/*?:"<>|]', "", folder_name).strip()
              if not clean_folder_name:
                  clean_folder_name = "unnamed_folder"
  
              cursor.execute(
                  "SELECT title, intent FROM favorites WHERE container = ?;",
                  (folder_id,),
              )
              items = cursor.fetchall()
  
              if items:
                  for app_title, intent in items:
                      stats["apps_attempted"] += 1
                      pkg = "Unknown"
                      if intent and "component=" in intent:
                          try:
                              part = intent.split("component=")[1]
                              pkg = part.split("/")[0]
                          except IndexError:
                              pkg = intent
  
                      # Fetch version if possible to build _versio_ suffix
                      version_str = "unknown"
                      if pkg != "Unknown":
                          if DEBUG_MODE:
                              version_str = "1.0.0-debug"
                          elif adb_active:
                              version_str = get_app_version(adb_binary, pkg)
  
                      pkg_folder_name = f"{pkg}_versio_{version_str}" if pkg != "Unknown" else pkg
  
                      target_path = base_dir / current_panel / clean_folder_name / pkg_folder_name
                      target_path.mkdir(parents=True, exist_ok=True)
                      log_print(f"  [Folder] {clean_folder_name} -> App: {pkg} (v:{version_str})")
  
                      # Pull APK or generate mock file depending on mode
                      if DEBUG_MODE and pkg != "Unknown":
                          dummy_apk_path = target_path / "base.apk"
                          dummy_apk_path.write_text("mock apk content")
                          log_print(f"    [Mock ADB] Created test file at {dummy_apk_path}")
                          stats["apps_success"] += 1
                      elif adb_active and pkg != "Unknown":
                          path_cmd = subprocess.run(
                              [adb_binary, "shell", "pm", "path", pkg],
                              capture_output=True, text=True
                          )
                          paths_found = 0
                          pull_success_count = 0
  
                          for line in path_cmd.stdout.splitlines():
                              if line.startswith("package:"):
                                  remote_path = line.replace("package:", "").strip()
                                  if remote_path:
                                      paths_found += 1
                                      pull_result = subprocess.run(
                                          [adb_binary, "pull", remote_path, str(target_path)],
                                          stdout=subprocess.DEVNULL, stderr=subprocess.DEVNULL
                                      )
                                      if pull_result.returncode == 0:
                                          pull_success_count += 1
  
                          if paths_found > 0 and pull_success_count == paths_found:
                              stats["apps_success"] += 1
                          else:
                              stats["apps_failed"] += 1
                              missing_apps_list.append(f"{current_panel} / {clean_folder_name} / {pkg}")
                              log_print(f"    [ADB] Warning: Failed to fully pull APK(s) for package: {pkg}")
                      else:
                          stats["apps_failed"] += 1
              else:
                  target_path = base_dir / current_panel / clean_folder_name
                  target_path.mkdir(parents=True, exist_ok=True)
  
          # 3. Find loose/top-level apps sitting directly on this screen
          cursor.execute(
              "SELECT title, intent FROM favorites WHERE container = -100 AND screen = ?"
              " AND intent IS NOT NULL;",
              (screen_num,),
          )
          loose_apps = cursor.fetchall()
  
          if loose_apps:
              for app_title, intent in loose_apps:
                  stats["loose_apps_processed"] += 1
                  stats["apps_attempted"] += 1
                  pkg = "Unknown"
                  if intent and "component=" in intent:
                      try:
                          part = intent.split("component=")[1]
                          pkg = part.split("/")[0]
                      except IndexError:
                          pkg = intent
  
                  version_str = "unknown"
                  if pkg != "Unknown":
                      if DEBUG_MODE:
                          version_str = "1.0.0-debug"
                      elif adb_active:
                          version_str = get_app_version(adb_binary, pkg)
  
                  pkg_folder_name = f"{pkg}_versio_{version_str}" if pkg != "Unknown" else pkg
  
                  target_path = base_dir / current_panel / "loose_apps" / pkg_folder_name
                  target_path.mkdir(parents=True, exist_ok=True)
                  log_print(f"  [Loose App] {pkg} (v:{version_str})")
  
                  if DEBUG_MODE and pkg != "Unknown":
                      dummy_apk_path = target_path / "base.apk"
                      dummy_apk_path.write_text("mock apk content")
                      log_print(f"    [Mock ADB] Created test file at {dummy_apk_path}")
                      stats["apps_success"] += 1
                  elif adb_active and pkg != "Unknown":
                      path_cmd = subprocess.run(
                          [adb_binary, "shell", "pm", "path", pkg],
                          capture_output=True, text=True
                      )
                      paths_found = 0
                      pull_success_count = 0
  
                      for line in path_cmd.stdout.splitlines():
                          if line.startswith("package:"):
                              remote_path = line.replace("package:", "").strip()
                              if remote_path:
                                  paths_found += 1
                                  pull_result = subprocess.run(
                                      [adb_binary, "pull", remote_path, str(target_path)],
                                      stdout=subprocess.DEVNULL, stderr=subprocess.DEVNULL
                                  )
                                  if pull_result.returncode == 0:
                                      pull_success_count += 1
  
                      if paths_found > 0 and pull_success_count == paths_found:
                          stats["apps_success"] += 1
                      else:
                          stats["apps_failed"] += 1
                          missing_apps_list.append(f"{current_panel} / loose_apps / {pkg}")
                          log_print(f"    [ADB] Warning: Failed to fully pull APK(s) for package: {pkg}")
                  else:
                      stats["apps_failed"] += 1
  
      # --- Execution summary block ---
      summary_text = (
          "\n"
          "========================================\n"
          "         Execution summary\n"
          "========================================\n"
          f"Panels/Screens Processed: {stats['screens_processed']}\n"
          f"Folders Discovered:         {stats['folders_processed']}\n"
          f"Loose Apps Discovered:    {stats['loose_apps_processed']}\n"
          f"----------------------------------------\n"
          f"Total App References:      {stats['apps_attempted']}\n"
          f"Successfully Pulled APKs: {stats['apps_success']}\n"
          f"Missing / Uninstalled:    {stats['apps_failed']}\n"
          "========================================\n"
      )
      log_print(summary_text)
  
      # --- Missing apps detailed report ---
      if missing_apps_list:
          missing_report = "Missing / Uninstalled Apps Breakdown:\n"
          for item in missing_apps_list:
              missing_report += f"  - {item}\n"
          missing_report += "========================================\n"
          log_print(missing_report)
  
      # --- Optional Restoration Script Generation ---
      gen_script_choice = input("Would you like to generate an ADB batch restoration script for these pulled apps? [y/n]: ").strip().lower()
      log_file.write(f"User selected restoration script generation choice: {gen_script_choice}\n")
      
      if gen_script_choice.startswith('y'):
          restore_script_filename = Path("restore_apps.bat")
          commands = []
          
          if base_dir.exists():
              for root, dirs, files in base_dir.walk():
                  apks = [f for f in files if f.endswith(".apk")]
                  if apks:
                      # Sort so base.apk always comes first
                      apks.sort(key=lambda x: 0 if x == "base.apk" else 1)
                      apk_paths = [root / apk for apk in apks]
                      
                      binary_to_use = adb_binary if adb_binary else "adb"
                      
                      if len(apk_paths) == 1:
                          cmd = f'"{binary_to_use}" install -r -d -i "com.android.vending" "{apk_paths[0]}"'
                      else:
                          joined_apks = '" "'.join([str(p) for p in apk_paths])
                          cmd = f'"{binary_to_use}" install-multiple -r -d -i "com.android.vending" "{joined_apks}"'
                          
                      commands.append(cmd)
              
              with restore_script_filename.open("w", encoding="utf-8") as r_file:
                  r_file.write("@echo off\n")
                  r_file.write(":: Generated by apkhome.py Restoration Script Generator\n")
                  r_file.write("echo Starting batch app restoration...\n\n")
                  for cmd in commands:
                      r_file.write(cmd + "\n")
                  r_file.write("\necho Restoration script completed.\n")
                  r_file.write("pause\n")
                  
              log_print(f"[i] Successfully generated restoration script: {restore_script_filename} ({len(commands)} apps targeted).")
  
  except KeyboardInterrupt:
      log_print("\n\n[!] Operation cancelled by user (Ctrl+C). Exiting safely...")
  
  finally:
      # Ensure database connection and log file are cleanly closed
      conn.close()
      log_file.close()
  
  # end of apkhome.py

-- 
Usenet is a team where every player tries to move the ball forward.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.