#!/usr/bin/env python3 # db-create v1.6 — Create 1C information base # Source: https://github.com/Nikolay-Shirokov/cc-1c-skills import argparse import atexit import glob import json import os import random import re import shutil import subprocess import sys import tempfile def _find_project_v8path(): """Walk up from CWD to find .v8-project.json and read its v8path.""" d = os.getcwd() while True: pf = os.path.join(d, ".v8-project.json") if os.path.isfile(pf): try: with open(pf, encoding="utf-8-sig") as f: data = json.load(f) v = data.get("v8path") if v: return v except Exception: pass return None parent = os.path.dirname(d) if parent == d: return None d = parent def _version_dir(p): """Version dir for both Windows (.../1cv8//bin/1cv8.exe) and *nix (.../1cv8//1cv8).""" parent = os.path.dirname(p) if os.path.basename(parent).lower() == "bin": parent = os.path.dirname(parent) return os.path.basename(parent) def _version_key(p): """Numeric sort key from version dir name.""" return [int(x) for x in re.findall(r"\d+", _version_dir(p))] def resolve_v8path(v8path): """Resolve path to a 1C executable (1cv8; ibcmd only when given explicitly).""" if not v8path: v8path = _find_project_v8path() if not v8path: if os.name == "nt": candidates = ( glob.glob(r"C:\Program Files\1cv8\*\bin\1cv8.exe") + glob.glob(r"C:\Program Files (x86)\1cv8\*\bin\1cv8.exe") ) else: # PY-only: PS-порт на *nix не исполняется, поэтому *nix-раскладки нет в .ps1. candidates = glob.glob("/opt/1cv8/*/1cv8") if candidates: v8path = max(candidates, key=_version_key) print(f"Auto-selected platform {_version_dir(v8path)}: {v8path}") else: print("Error: 1C executable not found. Specify -V8Path", file=sys.stderr) sys.exit(1) if os.path.isdir(v8path): # PY-only: на *nix исполняемый называется "1cv8" (без .exe); ibcmd — только явным путём. exe = "1cv8.exe" if os.name == "nt" else "1cv8" v8path = os.path.join(v8path, exe) if not os.path.isfile(v8path): print(f"Error: 1C executable not found at {v8path}", file=sys.stderr) sys.exit(1) return v8path IBCMD_NOUSER_HINT = ( "[ibcmd] No -UserName/-Password given; the infobase may require authentication. " "On Windows ibcmd reads credentials from the console (stdin is ignored), so this " "call may block instead of failing. If it does not return promptly, abort and " "re-run with -UserName and -Password.\n" ) def run_ibcmd(cmd, has_username=False, warn_no_user=True): """Run an ibcmd command non-interactively. input="" closes stdin (EOF) so ibcmd's auth prompt fast-fails instead of hanging. On Windows without -UserName ibcmd reads the console directly and may still block — that residual case is flagged via IBCMD_NOUSER_HINT (model-facing). """ if warn_no_user and os.name == "nt" and not has_username: sys.stderr.write(IBCMD_NOUSER_HINT) sys.stderr.flush() return subprocess.run(cmd, input="", capture_output=True, encoding="utf-8", errors="replace") def main(): sys.stdout.reconfigure(encoding="utf-8") sys.stderr.reconfigure(encoding="utf-8") parser = argparse.ArgumentParser( description="Create 1C information base", allow_abbrev=False, ) parser.add_argument("-V8Path", default="") parser.add_argument("-InfoBasePath", default="") parser.add_argument("-InfoBaseServer", default="") parser.add_argument("-InfoBaseRef", default="") parser.add_argument("-UseTemplate", default="") parser.add_argument("-AddToList", action="store_true") parser.add_argument("-ListName", default="") args = parser.parse_args() v8path = resolve_v8path(args.V8Path) engine = "ibcmd" if os.path.basename(v8path).lower().startswith("ibcmd") else "1cv8" # --- Validate connection --- if engine == "ibcmd": if not args.InfoBasePath: print("Error: ibcmd supports file infobases only (use -InfoBasePath)", file=sys.stderr) sys.exit(1) elif not args.InfoBasePath and (not args.InfoBaseServer or not args.InfoBaseRef): print("Error: specify -InfoBasePath or -InfoBaseServer + -InfoBaseRef", file=sys.stderr) sys.exit(1) # --- Validate template --- if args.UseTemplate and not os.path.exists(args.UseTemplate): print(f"Error: template file not found: {args.UseTemplate}", file=sys.stderr) sys.exit(1) # --- ibcmd branch (file infobase only) --- if engine == "ibcmd": arguments = ["infobase", "create", f"--db-path={args.InfoBasePath}", "--create-database"] if args.UseTemplate: if os.path.splitext(args.UseTemplate)[1].lower() == ".dt": arguments.append(f"--restore={args.UseTemplate}") else: arguments.extend([f"--load={args.UseTemplate}", "--apply"]) ib_data = tempfile.mkdtemp(prefix="ibcmd_data_") atexit.register(shutil.rmtree, ib_data, ignore_errors=True) arguments.append(f"--data={ib_data}") print(f"Running: ibcmd {' '.join(arguments)}") result = run_ibcmd([v8path] + arguments, warn_no_user=False) if result.returncode == 0: print(f"Information base created successfully: {args.InfoBasePath}") else: print(f"Error creating information base (code: {result.returncode})", file=sys.stderr) if result.stdout: print(result.stdout) if result.stderr: print(result.stderr, file=sys.stderr) sys.exit(result.returncode) # --- Temp dir --- temp_dir = os.path.join(tempfile.gettempdir(), f"db_create_{random.randint(0, 999999)}") os.makedirs(temp_dir, exist_ok=True) try: # --- Build arguments --- arguments = ["CREATEINFOBASE"] if args.InfoBaseServer and args.InfoBaseRef: # No embedded quotes: subprocess quotes the whole token; 1C's argv parser # strips outer quotes. Inner quotes get escaped by list2cmdline and break parsing. arguments.append(f'Srvr={args.InfoBaseServer};Ref={args.InfoBaseRef}') else: arguments.append(f'File={args.InfoBasePath}') # --- Template --- if args.UseTemplate: arguments.extend(["/UseTemplate", args.UseTemplate]) # --- Add to list --- if args.AddToList: if args.ListName: arguments.extend(["/AddToList", args.ListName]) else: arguments.append("/AddToList") # --- Output --- out_file = os.path.join(temp_dir, "create_log.txt") arguments.extend(["/Out", out_file]) arguments.append("/DisableStartupDialogs") # --- Execute --- print(f"Running: 1cv8.exe {' '.join(arguments)}") result = subprocess.run( [v8path] + arguments, capture_output=True, text=True, ) exit_code = result.returncode # --- Result --- if exit_code == 0: if args.InfoBaseServer and args.InfoBaseRef: print(f"Information base created successfully: {args.InfoBaseServer}/{args.InfoBaseRef}") else: print(f"Information base created successfully: {args.InfoBasePath}") else: print(f"Error creating information base (code: {exit_code})", file=sys.stderr) if os.path.isfile(out_file): try: with open(out_file, "r", encoding="utf-8-sig") as f: log_content = f.read() if log_content: print("--- Log ---") print(log_content) print("--- End ---") except Exception: pass sys.exit(exit_code) finally: if os.path.isdir(temp_dir): shutil.rmtree(temp_dir, ignore_errors=True) if __name__ == "__main__": main()