Commit: 9d5bedd6ecb082eadcfdffbba73cb7b2ca6f77cf - MyUtils (hg)

Папка MyUtils

Commit MetaInfo

• Revision: 9d5bedd6ecb082eadcfdffbba73cb7b2ca6f77cf (tree)
• Time: 2011-09-28 14:48:07
• Author: Константин Кошкин <catsoft1940@gmai...>
• Commiter: Константин Кошкин

Log Message

Скрипт выгрузки данных из базы

Change Summary

• add: Scripts/1C/Backup/unload.bat

Incremental Difference

diff -r 186e21ac3a39 -r 9d5bedd6ecb0 Scripts/1C/Backup/unload.bat
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Scripts/1C/Backup/unload.bat	Wed Sep 28 09:48:07 2011 +0400
@@ -0,0 +1,70 @@
+@echo off
+
+rem ‘ªà¨¯â ¢ë£à㧪¨ ¤ ­­ëå ¨§ 1‘
+rem
+rem  à ¬¥âàë
+rem %1 - ãâì ª ¡ §¥
+rem %2 - ®«ì§®¢ â¥«ì
+rem %3 -  à®«ì
+
+rem  áâனª¨
+
+rem ãâì ª  à娢­®¬ã ª â «®£ã
+set arcpath=E:\base\!!!Backup\
+
+rem ˆ¬ï ä ©«  ¢ë£à㧪¨
+set arcfile=1s
+
+rem ãâì ª ¨á¯®«­ï¥¬®¬ã ä ©«ã 1cv7
+set v7path="C:\Program Files\1Cv77\BIN\1cv7s.exe"
+
+rem  áâனª¨ ¯® 㬮«ç ­¨î
+set default_base=E:\base\1C-‚®§­¥á¥­áª¨©\
+set default_user=Š®èª¨­_Š®­á⠭⨭
+set default_pass=478050
+
+rem ãâì ª ¡ §¥
+if "%1" == "" (
+	set base=%default_base%
+) else (
+	set base="%1"
+)
+
+rem ®«ì§®¢ â¥«ì
+if "%2" == "" (
+	set user=%default_user%
+) else (
+	set user="%2"
+)
+
+rem  à®«ì
+if "%3" == "" (
+	set pass=%default_pass%
+) else (
+	set pass="%3"
+)
+
+rem ƒ¥­¥à æ¨ï ª®­ä¨£ãà æ¨®­­®£® ä ©«  ­ áâ஥ª ¢ë£à㧪¨
+
+rem ãâì ª ª®­ä¨£ãà æ¨®­­®¬ã ä ©«ã ­ áâ஥ª ¢ë£à㧪¨
+set conf="%base%unload.cfg"
+
+echo [General] > %conf%
+echo Output="%base%unload.log" >> %conf%
+echo Quit=1 >> %conf%
+echo UnloadData=1 >> %conf%
+echo [UnloadData] >> %conf%
+for /f "tokens=1,2,3 delims=." %%i in ("%date%") do (
+for /f "tokens=1,2 delims=:" %%l in ("%time%") do (
+echo UnloadToFile="%arcpath%%arcfile%_%%i%%j%%k_%%l%%m" >> %conf%
+))
+echo IncludeUserDef=1 >> %conf%
+
+rem ‡ ¯ãcª ¢ë£à㧪¨
+%v7path% config /d"%base%" /n%user% /p%pass% /@%conf%
+goto :exit
+
+:error
+echo Žè¨¡ª  ¢ ¯ à ¬¥âà å
+
+:exit