Архив за день: 2022-01-14

python pdb — список доступных команд

Добавить комментарий 
(Pdb) h
Documented commands (type help <topic>):
========================================
EOF    c          d        h         list      q        rv       undisplay
a      cl         debug    help      ll        quit     s        unt
alias  clear      disable  ignore    longlist  r        source   until
args   commands   display  interact  n         restart  step     up
b      condition  down     j         next      return   tbreak   w
break  cont       enable   jump      p         retval   u        whatis
bt     continue   exit     l         pp        run      unalias  where
Miscellaneous help topics:
==========================
exec  pdb
(Pdb)
python3 -m pdb myscript.py

MSSQL пример INSERT OR UPDATE

Добавить комментарий 
48	/* если в базе в таблице MyTable нет записи для Id */
49	IF (SELECT count(*) FROM MyTable WHERE Id = 23) = 0
50	    BEGIN
51	        INSERT INTO MyTable (Id,
53	                Field1,
55	                Field2,
58	                )
59	        VALUES (23,
61	                'qwe',
63	                'asd',
66	                )
67	        PRINT 'INSERT INTO MyTable...'
68	    END
69	
70	ELSE
71	    BEGIN
72	        /* обновляем поля Field1 и Field2 */
73	        UPDATE MyTable
74	        SET Field1 = 'qwe',
75	            Field2 = 'asd'
76	        WHERE Id = 23
77	        PRINT 'UPDATE MyTable ("qwe", "asd")'
78	    END
79