ืคึฟืึทืจ ืงืึธืืคึผืืขืงืก ืคึผืจืึทืกืขืกืื ื ืคืื ืืจืืืก ืืึทืื ืฉืืขืื (ืคืึทืจืฉืืืขื ืข : ืืืคึผืึธืจืฅ, ืงืึทื ืืืขืจืืฉืึทื ื ืืื ืกืื ืืงืจืึทื ืึทืืืืฉืึทื ืืื ืึท ืคืื ืืจืืืกื ืืืง ืืงืืจ) ืึธืคื ืขืก ืืื ืึท ื ืืื ืืขืืคึผืขืจืขืจืึทืื "ืืขืืขื ืงืขื" ืืื ืืื ืืขืฉืืืื ื ืคึผืจืึธืฆืขืก ืขืคึผืขืก ืืืึทืืืืึทื ืึทืก.
ื ืืืคึผืืฉ ืึทืจืืขื ืคืื ืืขื ืืื ืืืืฉืึทืืืึทืื ืกืึธืื ืืก ืขืคึผืขืก ืืื ืืึธืก: "ืืจืื ืื ืื ืืขืฆืืข ืืืงืืืขื ืคึผืืืืึทื ืฅ, ืืืจ ืืึทืจืคึฟื ืฆื ืืขืฉืืืื ื ืฆืืคึฟืขืืืงืขืจ ืืื ืฆื ืื ืืืขืืืืืื ืืื ืคึฟืึทืจืืื ืืื ื ืืื ืฆื ืืืื ืึทืงืึทืื ืฅ"
ืืืขืจ ืืืขื ืืขืจ ืืึทื ื ืคืื ืืขื "ืขืคึผืขืก" ืืืืื ืฆื ืืขืกืื ืืื ืืื ืืขืจืืขืจ ืคืื ืืขืืืืืื, ืืื ืื ืืื ืกื ืืืื ืคืึธืจืืขืฆื ืฆื ืึทืจืืขืื ืืื ืื ืืึทืืึทืืืืก 24x7, ืคืืืข ืืืึทื ืืคืขืงืฅ ืืืืคืฉืืืื ืืืึธืก ืืืขื ืฆืขืฉืืขืจื ืืืื ืืขืื.
ืฆื ืืึทื ืืืขื ืืื ืืื ืืื PostgreSQL (ืืื ื ืื ืืืืื ืืื ืขืก), ืืืจ ืงืขื ืขื ื ืืฆื ืขืืืขืืข ืึธืคึผืืืืืืึทืืืึธื ืก ืืืึธืก ืืึธืื ืืืจ ืฆื ืคึผืจืึธืฆืขืก ืึทืืฅ ืคืึทืกืืขืจ ืืื ืืื ืืืืื ืืงืขืจ ืืืื ืงืึทื ืกืึทืืฉืึทื.
1. ืืืื ืฆื ืฉืืงื?
ืขืจืฉืืขืจ, ืืึธืืืจ ืืึทืฉืืืกื ืืื ืืืจ ืงืขื ืขื ืฆืืคึฟืขืืืงืขืจ ืื ืืึทืื ืืืึธืก ืืืจ ืืืืื ืฆื "ืคึผืจืึทืกืขืก."
1.1. ืฆืืืืืืืืืืืข ืืืฉื (Temporary TABLE)
ืืื ืคึผืจืื ืฆืืคึผ, ืคึฟืึทืจ PostgreSQL ืฆืืึทืืืืืึทืืืง ืืืฉื ืืขื ืขื ืื ืืขืืืข ืืื ืงืืื ืื ืืขืจืข. ืืขืจืืืขืจ, ืืืืืืขืืฅ ืืื "ืึทืืฅ ืืึธืจื ืืื ืกืืึธืจื ืืืืื ืืื ืืึผืจืื, ืืื ืขืก ืงืขื ืกืืฃ". ืืืขืจ ืขืก ืืขื ืขื ืืืื ืขืืืขืืข ืืึทืืืึทืืืง ืืืคืขืจืึทื ืกืื.
ืืืื ืืืืืขื ืข "ื ืึทืืขืกืคึผืึทืกืข" ืคึฟืึทืจ ืืขืืขืจ ืงืฉืจ ืฆื ืื ืืึทืืึทืืืืก
ืืืื ืฆืืืื ืงืึทื ืขืงืฉืึทื ื ืคึผืจืืืืจื ืฆื ืคืึทืจืืื ืื ืืื ืืขืจ ืืขืืืืงืขืจ ืฆืืึทื CREATE TABLE x, ืืขืืึธืื ืขืืขืฆืขืจ ืืืขื ืืืฉืืืื ืืึทืงืืืขื ื ืื-ืืืืื ืืจืืืงืืื ืืขืืช ืืึทืืึทืืืืก ืึทืืืืฉืขืงืฅ.
ืืืขืจ ืืืื ืืืืืข ืคึผืจืืืืจื ืฆื ืืืกืคืืจื CREATE TEMPORARY TABLE x, ืืขืืึธืื ืืืืืข ืืืขืื ืืึธื ืขืก ื ืึธืจืืึทืื, ืืื ืึทืืขืืขื ืืืขื ืืึทืงืืืขื ืืืื ืงืึธืคึผืืข ืืืฉื. ืืื ืขืก ืืืขื ืืืื ืืึธืจื ืืฉื ืืื ืคึผืจืึธืกื ืฆืืืืฉื ืืื.
"ืืื-ืืขืกืืจืืงื" ืืืขื ืืืกืงืึทื ืขืงืืื ื
ืืืขื ืื ืงืฉืจ ืืื ืคืืจืืืื, ืึทืืข ืฆืืึทืืืืืึทืืืง ืืืฉื ืืขื ืขื ืืืืืึธืืึทืืืฉ ืืืืกืืขืืขืงื, ืึทืืื ืืึทื ืืืึทืื DROP TABLE x ืขืก ืืื ืงืืื ืคืื ื ืืืฅ ...
ืืืื ืืืจ ืึทืจืืขื ืืืจื pgbouncer ืืื ืืจืึทื ืกืึทืงืืืึธื ืืึธืืข, ืืขืืึธืื ืื ืืึทืืึทืืึทืกืข ืืืื ืฆื ืืืืืื ืึทื ืื ืงืฉืจ ืืื ื ืึธื ืึทืงืืืื, ืืื ืืื ืขืก ืื ืฆืืึทืืืืืึทืืืง ืืืฉ ื ืึธื ืืืืืกืฅ.
ืืขืจืืืขืจ, ืืจืืื ื ืฆื ืฉืึทืคึฟื ืขืก ืืืืืขืจ, ืคึฟืื ืึท ืึทื ืืขืจืฉ ืงืฉืจ ืฆื pgbouncer, ืืืขื ืจืขืืืืืึทื ืืื ืึท ืืขืืช. ืืืขืจ ืืขื ืงืขื ืขื ืืืื ืกืขืจืงืึทืืืืขื ืืื ืืืจื ื ืืฆื CREATE TEMPORARY TABLE IF NOT EXISTS x.
ืืืช, ืขืก ืืื ืืขืกืขืจ ื ืืฉื ืฆื ืืึธื ืืึธืก ืกืืึท ืืื ืกืืึท, ืืืืึทื ืืขืืึธืื ืืืจ ืงืขื ืขื "ืคึผืืืฆืืื ื" ืืขืคึฟืื ืขื ืืึธืจื ืื ืืึทืื ืจืืืืื ืืื ืคืื ืื "ืคืจืืึทืขืจืืืง ืืึทืืืฆืขืจ". ืึทื ืฉืืึธื, ืขืก ืืื ืคืื ืืขืกืขืจ ืฆื ืืืืขื ืขื ืื ืืึทื ืืึทื ืืื ืืขื ืึทื ืืืขื ืืืจ ืฉืึทืคึฟื ืึท ืืืฉ ืขืก ืืื ืืขืืืขื ืฆื ืืืืื ON COMMIT DROP - ืึทื ืืื, ืืืขื ืื ืืจืึทื ืกืึทืงืืืึธื ืงืึทืืคึผืืืฅ, ืื ืืืฉ ืืืขื ืืืขืจื ืืืืืึธืืึทืืืฉ ืืืืกืืขืืขืงื.
ื ืื-ืจืขืคึผืืึทืงืืืฉืึทื
ืืืืึทื ืืื ืืขืืขืจื ืืืืื ืฆื ืึท ืกืคึผืขืฆืืคืืฉ ืงืฉืจ, ืฆืืึทืืืืืึทืืืง ืืืฉื ืืขื ืขื ื ืืฉื ืจืขืคึผืืืงืืืืื. ืืืขืจ ืืึธืก ืืืืืึทื ืืืฅ ืื ื ืืื ืคึฟืึทืจ ืืึธืคึผื ืจืขืงืึธืจืืื ื ืคืื ืืึทืื ืืื ืงืืคึผืข + WAL, ืึทืืื INSERT/UPDATE/DELETE ืืื ืขืก ืืื ืคืื ืคืึทืกืืขืจ.
ืืืขืจ ืืืืืืื ื ืฆืืืืืืืืืืืข ืืืฉ ืืื ื ืื ืืืฅ ื "ืืืขื ืืขืืืืื ืืืืข" ืืืฉ, ืงืขื ืืขื ืขืก ืืืื ื ืืฉื ืฉืืคื ืืืืฃ ื ืจืขืคืืืงื. ืืื ืืื ืืกืืขืจ ืคึฟืึทืจ ืืืฆื, ืืึธืืฉ ืื ืงืึธืจืึทืกืคึผืึทื ืืื ื ืืึทืืข ืืื ืกืขืจืงืืึทืืืืืื ืคึฟืึทืจ ืึท ืืึทื ื ืฆืืึทื.
1.2. ืึทื ืืึธืื ืืืฉ
ืึธืืขืจ ืืืึธืก ืืึธื ืืืจ ืืึธื, ืคึฟืึทืจ ืืืึทืฉืคึผืื, ืืืื ืืืจ ืืึธืื ืึท ืืื ืคืื ืงืึทืืืขืจืกืึทื ETL ืคึผืจืึธืฆืขืก ืืืึธืก ืงืขื ืขื ื ืื ืืืื ืืืคึผืืึทืืขื ืึทื ืืื ืืืื ืืจืึทื ืกืึทืงืืืึธื, ืึธืืขืจ ืืืจ ื ืึธื ืืึธืื pgbouncer ืืื ืืจืึทื ืกืึทืงืืืึธื ืืึธืืข? ..
ืึธืืขืจ ืื ืืึทืื ืืืืคื ืืื ืึทืืื ืืจืืืก ืึทื ืขืก ืืื ื ืืฉื ืืขื ืื ืืึทื ืืืืืื ืืืืฃ ืืืื ืงืฉืจ ืคึฟืื ืึท ืืึทืืึทืืืืก (ืืืืขื ืขื, ืืืื ืคึผืจืึธืฆืขืก ืคึผืขืจ ืงืคึผื)? ..
ืึธืืขืจ ืขืืืขืืข ืึทืคึผืขืจืืืฉืึทื ื ืืขื ืขื ืืขืืื ืืขื ืืืืฃ ืืืกืื ืืงืจืึทื ืึทืกืื ืืื ืคืึทืจืฉืืืขื ืข ืงืึทื ืขืงืฉืึทื ื? ..
ืขืก ืืื ืืืืื ืืืื ืึธืคึผืฆืืข ืืึธ - ืฉืึทืคึฟื ืึท ื ืื-ืฆืืึทืืืืืึทืืืง ืืืฉ ืืขืืคึผืขืจืขืจืึทืื. ืคึผืื ืงื, ืืึธ. ืืืก ืืื:
- ืืืฉืืคื "ืืืึทื ืืืืื" ืืืฉื ืืื ืืึทืงืกืืืื ืืจืึทืค - ื ืขืืขื ืึทืืื ืืื ื ืืฉื ืฆื ืื ืืขืจืกืขืงื ืืื ืืืขืจ ืขืก ืื
- ืขืงืกืืจืึทืงื: ืึธื ืืขืคืืื ืืื ืืื ืืึทืื ืคืื ืึท ืคืื ืืจืืืกื ืืืง ืืงืืจ
- ืืืขืจืืึทืื: ืงืึธื ืืืขืจืืขื, ืึธื ืืขืคืืื ืืื ืฉืืืกื ืคึฟืึทืจืืื ืืื ื ืคืขืืืขืจ
- ืืึธืื: ืืืืกืืขืืืกื ืืจืืื ืืึทืื ืืื ืฆืื ืืืฉื
- ืืืืกืืขืืขืงื "ืืืื" ืืืฉื
ืืื ืืืฆื - ืึท ืคืืืขื ืืื ืื ืืืืืืื. ืืื ืคืึทืงื, ืึทืืข ืฉืจืืืื ืืื PostgreSQL ืคึผืึทืกืืจื ืฆืืืื ืืึธื - , ืืขืืึธืื ืืื ืื ืืืฉ / ืืื ืืขืงืก ืืืืขืจ. ืึทืืข ืืขื ืืื ืืขืืื ืฆื ืฉืืืฆื ืึทืกืื ืืื ืจืืืืืง ืืึทืื ืืืืืึทืืืืืื ืฆืืืืฉื COMMIT'ื ืึทืกืื ืืื ROLLBACK'ื ืื ืืจืึทื ืืึทืงืฉืึทื ื.
ืึธืืขืจ ืืืจ ืืึธื ื ืื ืืึทืจืคึฟื ืืึธืก! ืืืจ ืืึธืื ืื ืืื ืฆืข ืคึผืจืึธืฆืขืก ืึธืืขืจ ืขืก ืืื ืืขืืืขื ืืึธืจ ืืขืจืึธืื ืึธืืขืจ ืขืก ืืื ื ืืฉื.. ืขืก ืืื ื ืืฉื ืขื ืื ืืื ืคืืืข ืื ืืขืจืืืืืื ืืจืึทื ืืึทืงืฉืึทื ื ืขืก ืืืขื ืืืื - ืืืจ ืืขื ืขื ื ืืฉื ืืื ืืขืจืขืกืืจื ืืื "ืคืึธืจืืขืฆื ืืขื ืคึผืจืึธืฆืขืก ืคืื ืื ืืืื," ืกืคึผืขืฆืืขื ืืืขื ืขืก ืืื ื ืืฉื ืงืืึธืจ ืืื ืขืก ืืื ืืขืืืขื.
ืฆื ืืึธื ืืึธืก, ืื PostgreSQL ืืขืืืขืืึธืคึผืขืจืก, ืฆืืจืืง ืืื ืืืขืจืกืืข 9.1, ืืึทืงืขื ืขื ืึทืืึท ืึท ืืึทื ืืื :
ืืื ืืขื ืึธื ืืืืึทื, ืื ืืืฉ ืืื ืืืฉืืคื ืืื ืึทื ืืึธืื. ืืึทืื ืืขืฉืจืืื ืฆื ืึทื ืืึธืื ืืืฉื ืืึธื ื ืื ืืืื ืืืจื ืื ืฉืจืืึทืื ืคืึธืจืืืก ืงืืึธืฅ (ืืขื ืืฉืึทืคึผืืขืจ 29), ืืืึธืก ืืขืคึฟืืจื ืึทืืึท ืืืฉื ืฆื ืึทืจืืขื ืคืื ืคืึทืกืืขืจ ืืื ืืขืืืืื ืืืขื. ืึธืืขืจ, ืืื ืืขื ืขื ื ืืฉื ืืืืื ืฆื ืืืจืืคืึทื; ืืื ืคืึทื ืคืื ืกืขืจืืืขืจ ืืืจืืคืึทื ืึธืืขืจ ื ืืืืคืึทื ืฉืึทืืืึทืื, ืึท ืึทื ืืึธืื ืืืฉ ืืืืืึธืืึทืืืฉ ืืจืื ืงืืืืื. ืืขืจืฆื, ืื ืืื ืืึทืื ืคืื ืื ืึทื ืืึธืื ืืืฉ ื ืื ืจืขืคึผืืืงืืืืื ืฆื ืฉืงืืึทืฃ ืกืขืจืืืขืจืก. ืงืืื ืื ืืขืงืกืื ืืืฉืืคื ืืืืฃ ืึท ืึทื ืืึธืื ืืืฉ ืืืขืจื ืืืืืึธืืึทืืืฉ ืึทื ืืึธืื.
ืืงืืฆืืจ, ืขืก ืืืขื ืืืื ืคืื ืคืึทืกืืขืจ, ืึธืืขืจ ืืืื ืื ืืึทืืึทืืืืก ืกืขืจืืืขืจ "ืคืืื", ืขืก ืืืขื ืืืื ืคึผืจืืงืจืข. ืึธืืขืจ ืืื ืึธืคื ืืื ืืึธืก ืคึผืึทืกืืจื, ืืื ืืืื ETL ืคึผืจืึธืฆืขืก ืืืืกื ืืื ืฆื ืคืึทืจืจืืืื ืืขื ืจืืืืืง "ืคืื ืื ืืืื" ื ืึธื "ืจืืืืืืืึทืืืืืื ื" ืื ืืึทืืึทืืืืก?
ืืืื ื ืืฉื, ืืื ืืขืจ ืคืึทื ืืืืื ืืื ืขื ืืขื ืฆื ืืืื, ื ืืฆื UNLOGGED, ืึธืืขืจ ืงืืื ืืึธื ืืึธื ื ืื ืืขืื ืืขื ืึทืืจืืืืื ืืืืฃ ืคืึทืงืืืฉ ืืืฉื, ืื ืืึทืื ืคืื ืืืึธืก ืืื ืืื ืฆื ืืืจ.
1.3. ืืืืฃ ืงืึธืืืื { ืืืกืืขืงื ืจืึธืื | DROP}
ืืขื ืงืึทื ืกืืจืึทืงื ืึทืืึทืื ืืืจ ืฆื ืกืคึผืขืฆืืคืืฆืืจื ืึธืืึทืืึทืืืง ื ืึทืืืจ ืืืขื ืึท ืืจืึทื ืกืึทืงืืืึธื ืืื ืืขืขื ืืืงื ืืืขื ืงืจืืืืืื ื ืึท ืืืฉ.
ืืืืฃ ON COMMIT DROP ืืื ืืื ืฉืืื ืืขืฉืจืืื ืืืืื, ืขืก ืืืฉืขื ืขืจืืืฅ DROP TABLE, ืึธืืขืจ ืืื ON COMMIT DELETE ROWS ืื ืกืืืืึทืฆืืข ืืื ืืขืจ ืืฉืืงืึทืืืข - ืขืก ืืื ืืืฉืขื ืขืจืืืืึทื ืืึธ TRUNCATE TABLE.
ืืื ื ืื ืืื ืฆืข ืื ืคืจืึทืกืืจืึทืงืืฉืขืจ ืคึฟืึทืจ ืกืืึธืจืื ื ืื ืืขืืึท-ืืืกืงืจืืคึผืฉืึทื ืคืื ืึท ืฆืืึทืืืืืึทืืืง ืืืฉ ืืื ืคึผืื ืงื ืื ืืขืืืข ืืื ืึทื ืคืื ืึท ืจืขืืืืขืจ ืืืฉ, ืืขืืึธืื ืงืขืกืืืืขืจืืืง ืฉืึทืคืื ื ืืื ืืืืืฉืึทื ืคืื ืฆืืึทืืืืืึทืืืง ืืืฉื ืคืืจื ืฆื ืฉืืจืขื ื "ืืขืฉืืืืืขืืฅ" ืคืื ืกืืกืืขื ืืืฉื pg_class, pg_attribute, pg_attrdef, pg_depend, ...
ืืขืฆื ืฉืืขืื ืืืื ืคืืจ ืื ืืืจ ืืื ืื ืืจืืขืืขืจ ืืืืฃ ื ืืืจืขืงืืข ืคืืจืืื ืืื ื ืฆื ืื ืืึทืืึทืืืืก, ืืืืก ืขืคื ื ืืขืืข ืจืืข ื ื ืืืข ืืจืื ืืืงืฆืืข, ืฉืืคื, ืคืืื, ืคืจืืฆืขืกืืจื ืืื ืืืืกืืขืงื ื ืฆืืืืืืืืืืืข ืืืฉ... ืขืก ืืืขื ืืื ืื ืงืืืืื ื ืืืืขืคืืืง ืคืื ืืืกื ืืื ืื ืกืืกืืขื ืืืฉื, ืืื ืืึธืก ืืืขื ืคืึทืจืฉืึทืคื ืขืงืกืืจืข ืืจืึทืงืขืก ืคึฟืึทืจ ืืขืืขืจ ืึธืคึผืขืจืึทืฆืืข.
ืืื ืึทืืืขืืืื, ืืึธื ื ืื ืืึธื ืืึธืก! ืืื ืืขื ืคืึทื, ืขืก ืืื ืคืื ืืขืจ ืขืคืขืงืืืื CREATE TEMPORARY TABLE x ... ON COMMIT DELETE ROWS ื ืขืืขื ืขืก ืืืืก ืคืื ืื ืืจืึทื ืกืึทืงืืืึธื ืฆืืงื - ืืขืืึธืื ืืื ืื ืึธื ืืืื ืคืื ืืขืืขืจ ื ืืึท ืืจืึทื ืกืึทืงืืืึธื ืื ืืืฉื ืืขื ืขื ืฉืืื ืืืขื ืขืงืืืกืืืจื (ืืื ืึท ืจืืคื CREATE), ืึธืืขืจ ืืืขื ืืืื ืืืืืืง, ื ืืื ืง ืฆื TRUNCATE (ืืืจ ืืืื ืืขืจืืืขืืืขื ืืืื ืจืืคื) ืืืขื ืงืึทืืคึผืืืืื ื ืื ืคืจืืขืจืืืงืข ืืจืึทื ืกืึทืงืืืึธื.
1.4. ืืื ... ืึทืจืืึทื ืืขืจืขืื ื ...
ืืื ืืขืจืืื ื ืืื ืื ืึธื ืืืื ืึทื ืืืื ืขืจ ืคืื ืื ืืืคึผืืฉ ื ืืฆื ืงืึทืกืขืก ืคึฟืึทืจ ืฆืืึทืืืืืึทืืืง ืืืฉื ืืื ืคืึทืจืฉืืื ืืื ืื ืคืื ืืืคึผืึธืจืฅ - ืืื ืื ืืขืืืขืืึธืคึผืขืจ ืืืื ื ืึธืืืึทืื ืื ืจืฉืืื ืคืื ืคืขืืืขืจ ืคืื ืื ืฆืื ืืืฉ ืืื ืืขืจ ืืขืงืืึทืจืึทืฆืืข ืคืื โโโโืืืื ืฆืืืืืืืืืืืข ...
ืึธืืขืจ ืคืืืืงืืื ืืื ืืขืจ ืืึธืืึธืจ ืคืื ืคึผืจืึธืืจืขืก! ืืืขืื ืืขื ืฉืึทืคึฟื ืึท ื ืืึทืข ืืืฉ "ืืืืืจื ืืืืฃ ืืืกืืขืจ" ืขืก ืงืขื ืืืื ืคืื ืกืืืคึผืืขืจ:
CREATE TEMPORARY TABLE import_table(
LIKE target_table
);ืืื ื ืืืจ ืงืขื ืขื ืืืฉืขื ืขืจืืื ืึท ืคึผืืึทืฅ ืคืื ืืึทืื ืืื ืืขื ืืืฉ, ืืืื ืืืจื ืขืก ืืืขื ืงืืื ืืึธื ืืืื ืฉื ืขื. ืืืขืจ ืขืก ืืื ืึท ืืจืืืืฆืืื ืขืื ืืืืืื ื ืฆื ืืขื - ืื ืืขืงืกืื! ืืื ืืึธ, ืึท ืฆืืึทืืืืืึทืืืง ืืืฉ ืงืขื ืขื ืืืื ืืึธืื ืื ืืขืงืกืื.
ืืื ื, ืึธืคื, ืื ืคืืจืืื ืื ืื ืืขืงืกืื ืฆืื ืืืคืคืึทืื ืืื ืื ืื ืืขืงืกืื ืคืื ืื ืฆืื ืืืฉ, ืืืจ ืงืขื ืขื ืคืฉืื ืฉืจืืึทืื LIKE target_table INCLUDING INDEXES.
ืืืื ืืืจ ืืืื ืืึทืจืคึฟื DEFAULT-ืืืึทืืืขืก (ืคึฟืึทืจ ืืืึทืฉืคึผืื, ืฆื ืคึผืืึธืืืืจื ืื ืขืจืฉืืืง ืฉืืืกื ืืืึทืืืขืก), ืืืจ ืงืขื ืขื ื ืืฆื LIKE target_table INCLUDING DEFAULTS. ืึธืืขืจ ืคืฉืื - LIKE target_table INCLUDING ALL - ืงืืคืืขืก ืืืคืึธืืฅ, ืื ืืขืงืกืื, ืงืึทื ืกืืจืืื ืฅ, ...
ืืืขืจ ืืึธ ืืืจ ืืึทืจืคึฟื ืฆื ืคึฟืึทืจืฉืืืื ืึทื ืืืื ืืืจ ืืืฉืืคื ืึทืจืืึทื ืคืืจ ืืืฉ ืืื ืืื ืื ืืขืงืกืื, ืืื ืื ืืึทืื ืืืขื ื ืขืืขื ืืขืจ ืฆื ืืึทืกืขืืื ืืืื ืืืจ ืขืจืฉืืขืจ ืคึผืืึธืืืืจื ืึทืืฅ ืึทืจืืืฃ, ืืื ืืืืื ืืขืืึธืื ืจืึธืืื ืึทืจืืืฃ ืื ืื ืืขืงืกืื - ืงืืง ืืื ืขืก ืืื ืืึธืก ืืื ืึท ืืืึทืฉืคึผืื .
ืืื ืึทืืืขืืืื, !
2. ืืื ืฆื ืฉืจืืึทืื?
ืืื ืืืจ ื ืึธืจ ืืึธืื - ื ืืฆื ืขืก - ืืืืคื ืึทื ืฉืืึธื ืคืื "ืคึผืึทืง" INSERT, . ืืืจ ืงืขื ืขื ืืคืืื ืืืืึทื ืคึฟืื ืึท ืคืึทืจ-ืืืฉืขื ืขืจืืืืึทื ืืขืงืข.
3. ืืื ืฆื ืคึผืจืึธืฆืขืก?
ืึทืืื, ืืึธืื ืืื ืื ืืึธืื ืืื ืืืขืจ ืื ืืจืึธื ืงืืง ืขืคึผืขืก ืืื ืืึธืก:
- ืืืจ ืืึธืื ืึท ืืืฉ ืืื ืงืืืขื ื ืืึทืื ืกืืึธืจื ืืื ืืืื ืืึทืืึทืืืืก 1 ื ืจืขืงืึธืจืืก
- ืืขืืขืจ ืืึธื ืึท ืงืืืขื ื ืกืขื ืื ืืืจ ืึท ื ืืึทืข ืคืื "ืืืื"
- ืคืื ืืขืจืคืึทืจืื ื ืืืจ ืืืืกื ืึทื ืคืื ืฆืืึทื ืฆื ืฆืืึทื ื ืื ืืขืจ ืืื 10 ืง ืจืขืงืึธืจืืก ืืขื ืขื ืคืืจืขื ืืขืจื
ื ืงืืึทืกืืฉ ืืืึทืฉืคึผืื ืคืื ืึทืืึท ืึท ืกืืืืึทืฆืืข ืืื โ ืขืก ืืขื ืขื ืกื ืืื ืคืืจืื ืืกืื ืืืจืขืกื, ืืืขืจ ืืื ืืขืื ืืืืื ืฉืจืืคื ืืืืคืืืืขื ืืขื ืขื ืคืืจืื ืืืืขืจ ืืืืื ืื ืขื ืืขืจืื ืืขื (ื ืืืขื ืคืื ืืฉืืืื, ืฆืืืืืฉืืขืื ืืืกื, ืืืืกืืขื ืคืื ื ืืืข ืืืืืขืจ) ืืคืืื ืืืืฃ ื ื ืืฆืืื ืืืข ืคืืจื ืขื.
3.1. ืืึทื ืฅ ืกืื ืืงืจืึทื ืึทืืืืฉืึทื ืึทืืืขืจืืืึทื
ืคึฟืึทืจ ืคึผืึทืฉืืขืก, ืืึธืื ืก ืืึธืื ืึทื ืืืจ ืืึธื ื ืื ืืคืืื ืืึทืจืคึฟื ืฆื ืจืืกืืจืึทืงืืฉืขืจ ืื ืืึทืื - ื ืึธืจ ืืจืขื ืืขื ืื ืืืฉ ืืื ืืขืจ ืืขืืืืื ืคืึธืจืขื, ืืึธืก ืืื:
- ืึทืจืึธืคึผื ืขืืขื ืืืขืก ืืืืก ืขืงืืืกืืืจื ืฉืืื ื ืืฉื
- ืืขืจืืืึทื ืืืงื ืึทืืฅ ืืืึธืก ืฉืืื ืขืงืกืืกืืืจื ืืื ืืึทืจืฃ ืืืื ืืขืจืืืึทื ืืืงื
- ืฆื ืืึธื ืึทืืฅ ืืืึธืก ืืื ื ืึธื ื ืืฉื ืืขืฉืขื
ืคืืจืืืืก ืืึธื ืื ืึทืคึผืขืจืืืฉืึทื ื ืืืื ืืขืืื ืืื ืืขื ืกืืจ? ืืืืึทื ืืึธืก ืืื ืืื ืื ืืืฉ ืืจืืืก ืืืขื ืืืึทืงืกื ืืื ืืืึทื ().
ืืืกืืขืงื ืคึฟืื ืืกื
ื ืืื, ืืึธื ืืืจ ืงืขื ืขื ืืึทืงืืืขื ืืืจื ืืืืื ืฆืืืื ืึทืคึผืขืจืืืฉืึทื ื:
- ืึทืจืึธืคึผื ืขืืขื (
DELETE) ืึทืืฅ ืืื ืึทืืืขืืืื - ืฆื ืืึธื ืึทืืข ืคึฟืื ืื ื ืืึทืข ืืืื
ืึธืืขืจ ืืื ืืขืจ ืืขืืืืงืขืจ ืฆืืื, ืืึทื ืง ืฆื MVCC, ืื ืืจืืืก ืคืื ืืขื ืืืฉ ืืืขื ืคืึทืจืืจืขืกืขืจื ืคึผืื ืงื ืฆืืืื ืืึธื! ืืึทืงืืืขื +1 ื ืืืืืขืจ ืคืื ืจืขืงืึธืจืืก ืืื ืึท ืืืฉ ืจืขืื ืฆื ืึท 10 ืง ืืขืจืืืึทื ืืืงื ืืื ืึทืืื-ืึทืืื ืืืขืจืืงืืึทื ...
TRUNCATE dst
ื ืืขืจ ืืงืกืคึผืืจืืึทื ืกื ืืขืืืขืืึธืคึผืขืจ ืืืืืกื ืึทื ืื ืืื ืฆืข ืืึทืืืขื ืงืขื ืขื ืืืื ืงืืื ื ืืึทื ืฅ ืืืืืง:
- ืงืืึธืจ (
TRUNCATE) ืื ืืื ืฆืข ืืืฉ - ืฆื ืืึธื ืึทืืข ืคึฟืื ืื ื ืืึทืข ืืืื
ืืขืจ ืืืคึฟื ืืื ืขืคืขืงืืืื, , ืึธืืขืจ ืขืก ืืื ืึท ืคึผืจืึธืืืขื ... ืืืจ ืืืขืื ืืืืื 1M ืจืขืงืึธืจืืก ืคึฟืึทืจ ืึท ืืึทื ื ืฆืืึทื, ืึทืืื ืืืจ ืงืขื ืขื ื ืืฉื ืคืึทืจืืื ืขื ืืื ืฆื ืืึธืื ืื ืืืฉ ืืืืืืง ืคึฟืึทืจ ืึทืืข ืื ืฆืืื (ืืื ืืืขื ืคึผืึทืกืืจื ืึธื ืจืึทืคึผืื ื ืขืก ืืื ืึท ืืืื ืืจืึทื ืกืึทืงืืืึธื).
ืืืืก ืืืื ื:
- ืืืจ ืึธื ืืืืื ืืึทื ื-ืคืืืกื ืืืง ืืจืึทื ืกืึทืงืืืึธื
TRUNCATEืืืคึผืึธืืืึทื ืึทืงืกืขืก ืืืกืฉืืืกืืง-ืืืึทืงืื ื- ืืืจ ืืึธื ืื ืื ืกืขืจืฉืึทื ืคึฟืึทืจ ืึท ืืึทื ื ืฆืืึทื, ืืื ืึทืืขืืขื ืึทื ืืขืจืฉ ืืื ืืขื ืฆืืึทื ืงืขื ืืคืืื ื ืืฉื
SELECT
ืขืคึผืขืก ืืืื ื ืืฉื ืืื...
ืืืืฉื ืืืฉโฆ ืจืขื ืึทืืขโฆ / ืคืึทืื ืืืฉโฆ
ืึทื ืึธืืืขืจื ืึทืืืื ืืื ืฆื ืคึผืืึธืืืืจื ืึทืืฅ ืืื ืึท ืืึทืืื ืืขืจ ื ืืึท ืืืฉ, ืืื ืืขืืึธืื ืคืฉืื ืจืขื ืึทืืข ืขืก ืืื ืคึผืืึทืฅ ืคืื ืื ืึทืื. ื ืคึผืึธืจ ืคืื ืืืืืก ืืืกื ืืืื:
- ื ืึธื ืืืื ืึทืงืกืขืก ืืืกืฉืืืกืืง, ืืึธืืฉ ืืืืืืืืง ืืืืื ืืงืขืจ ืฆืืึทื
- ืึทืืข ืึธื ืคึฟืจืขื ืคึผืืึทื ื / ืกืืึทืืืกืืืง ืคึฟืึทืจ ืืขื ืืืฉ ืืขื ืขื ืืึทืฉืืขืืืง,
- ืึทืืข ืคืจืขืื ืฉืืืกืืขื ืืขื ืขื ืฆืขืืจืืื (ืคืง) ืฆืื ืืืฉ
ืขืก ืืื ืืขืืืขื ืึท WIP ืืึทืืข ืคืื โโSimon Riggs ืืืึธืก ืกืึทืืืืฉืขืกืืื ืฆื ืืึทืื ALTER- ืึทื ืึธืคึผืขืจืึทืฆืืข ืฆื ืคืึทืจืืืึทืื ืื ืืืฉ ืืืฃ ืืืืฃ ืืขืจ ืืขืงืข ืืืจืื, ืึธื ืจืืจื ืืืง ืกืืึทืืืกืืืง ืืื FK, ืึธืืขืจ ืืื ื ืืฉื ืงืืืึทืื ืงืืืึธืจื.
ืืืกืืขืงื, ืืขืจืืืึทื ืืืงื, ืื ืกืขืจื
ืึทืืื, ืืืจ ืคืึทืจืขื ืืคืขืจื ืืืืฃ ืื ื ืื-ืืืึทืงืื ื ืึธืคึผืฆืืข ืคืื โโืืจืื ืึทืคึผืขืจืืืฉืึทื ื. ืึผืืขื ืืจืืึท ... ืืื ืฆื ืืึธื ืืึธืก ืจืืึฟ ืืคืขืงืืืืืื?
-- ะฒัะต ะดะตะปะฐะตะผ ะฒ ัะฐะผะบะฐั
ััะฐะฝะทะฐะบัะธะธ, ััะพะฑั ะฝะธะบัะพ ะฝะต ะฒะธะดะตะป "ะฟัะพะผะตะถััะพัะฝัั
" ัะพััะพัะฝะธะน
BEGIN;
-- ัะพะทะดะฐะตะผ ะฒัะตะผะตะฝะฝัั ัะฐะฑะปะธัั ั ะธะผะฟะพััะธััะตะผัะผะธ ะดะฐะฝะฝัะผะธ
CREATE TEMPORARY TABLE tmp(
LIKE dst INCLUDING INDEXES -- ะฟะพ ะพะฑัะฐะทั ะธ ะฟะพะดะพะฑะธั, ะฒะผะตััะต ั ะธะฝะดะตะบัะฐะผะธ
) ON COMMIT DROP; -- ะทะฐ ัะฐะผะบะฐะผะธ ััะฐะฝะทะฐะบัะธะธ ะพะฝะฐ ะฝะฐะผ ะฝะต ะฝัะถะฝะฐ
-- ะฑััััะพ-ะฑััััะพ ะฒะปะธะฒะฐะตะผ ะฝะพะฒัะน ะพะฑัะฐะท ัะตัะตะท COPY
COPY tmp FROM STDIN;
-- ...
-- .
-- ัะดะฐะปัะตะผ ะพััััััะฒัััะธะต
DELETE FROM
dst D
USING
dst X
LEFT JOIN
tmp Y
USING(pk1, pk2) -- ะฟะพะปั ะฟะตัะฒะธัะฝะพะณะพ ะบะปััะฐ
WHERE
(D.pk1, D.pk2) = (X.pk1, X.pk2) AND
Y IS NOT DISTINCT FROM NULL; -- "ะฐะฝัะธะดะถะพะนะฝ"
-- ะพะฑะฝะพะฒะปัะตะผ ะพััะฐะฒัะธะตัั
UPDATE
dst D
SET
(f1, f2, f3) = (T.f1, T.f2, T.f3)
FROM
tmp T
WHERE
(D.pk1, D.pk2) = (T.pk1, T.pk2) AND
(D.f1, D.f2, D.f3) IS DISTINCT FROM (T.f1, T.f2, T.f3); -- ะฝะตะทะฐัะตะผ ะพะฑะฝะพะฒะปััั ัะพะฒะฟะฐะดะฐััะธะต
-- ะฒััะฐะฒะปัะตะผ ะพััััััะฒัััะธะต
INSERT INTO
dst
SELECT
T.*
FROM
tmp T
LEFT JOIN
dst D
USING(pk1, pk2)
WHERE
D IS NOT DISTINCT FROM NULL;
COMMIT;
3.2. ืึทืจืืึทื ืคืืจ ืคึผืึธืกืื-ืคึผืจืึทืกืขืกืื ื
ืืื ืืขืจ ืืขืืืืงืขืจ KLADR, ืึทืืข ืืฉืืื ืืืฉื ืจืขืงืึธืจืืก ืืืื ืืืื ืึทืืืฉื ืึทืื ืืืืคื ืืืจื ืคึผืึธืกืื-ืคึผืจืึทืกืขืกืื ื - ื ืึธืจืืึทืืืืื, ืืขืจืืื ืขื ืืืืืืืืื ืืื ืจืืืืกื ืฆื ืื ืคืืจืืื ืื ืกืืจืึทืงืืฉืขืจื. ืึธืืขืจ ืืื ืืึธื ืืืจ ืืืืกื - ืืืึธืก ืคึผืื ืงื ืืขืืืืืึธื ืงืึธืืคึผืืืฆืืจื ืื ืกืื ืืงืจืึทื ืึทืืืืฉืึทื ืงืึธื, ืืืืืื ืึธื ืจืืจื ืืืง ืขืก?
ืืืื ืืืืื ืืืื ืคึผืจืึธืฆืขืก ืืื ืฉืจืืึทืื ืึทืงืกืขืก ืืื ืืขืจ ืฆืืื ืคืื ืกืื ืืงืจืึทื ืึทืืืืฉืึทื, ืืืจ ืงืขื ืขื ื ืืฆื ืึท ืฆืื ืื ืืืึธืก ืืืขื ืงืืืึทืื ืึทืืข ืื ืขื ืืขืจืื ืืขื ืคึฟืึทืจ ืืื ืื:
-- ัะตะปะตะฒัะต ัะฐะฑะปะธัั
CREATE TABLE kladr(...);
CREATE TABLE kladr_house(...);
-- ัะฐะฑะปะธัั ั ะธััะพัะธะตะน ะธะทะผะตะฝะตะฝะธะน
CREATE TABLE kladr$log(
ro kladr, -- ััั ะปะตะถะฐั ัะตะปัะต ะพะฑัะฐะทั ะทะฐะฟะธัะตะน ััะฐัะพะน/ะฝะพะฒะพะน
rn kladr
);
CREATE TABLE kladr_house$log(
ro kladr_house,
rn kladr_house
);
-- ะพะฑัะฐั ััะฝะบัะธั ะปะพะณะธัะพะฒะฐะฝะธั ะธะทะผะตะฝะตะฝะธะน
CREATE OR REPLACE FUNCTION diff$log() RETURNS trigger AS $$
DECLARE
dst varchar = TG_TABLE_NAME || '$log';
stmt text = '';
BEGIN
-- ะฟัะพะฒะตััะตะผ ะฝะตะพะฑั
ะพะดะธะผะพััั ะปะพะณะณะธัะพะฒะฐะฝะธั ะฟัะธ ะพะฑะฝะพะฒะปะตะฝะธะธ ะทะฐะฟะธัะธ
IF TG_OP = 'UPDATE' THEN
IF NEW IS NOT DISTINCT FROM OLD THEN
RETURN NEW;
END IF;
END IF;
-- ัะพะทะดะฐะตะผ ะทะฐะฟะธัั ะปะพะณะฐ
stmt = 'INSERT INTO ' || dst::text || '(ro,rn)VALUES(';
CASE TG_OP
WHEN 'INSERT' THEN
EXECUTE stmt || 'NULL,$1)' USING NEW;
WHEN 'UPDATE' THEN
EXECUTE stmt || '$1,$2)' USING OLD, NEW;
WHEN 'DELETE' THEN
EXECUTE stmt || '$1,NULL)' USING OLD;
END CASE;
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
ืืืฆื ืืืจ ืงืขื ืขื ืฆืืืืืื ืืจืืืขืจื ืืืืืขืจ ืกืืึทืจืืื ื ืกืื ืืงืจืึทื ืึทืืืืฉืึทื (ืึธืืขืจ ืืขืื ืืื ืืืจื ALTER TABLE ... ENABLE TRIGGER ...):
CREATE TRIGGER log
AFTER INSERT OR UPDATE OR DELETE
ON kladr
FOR EACH ROW
EXECUTE PROCEDURE diff$log();
CREATE TRIGGER log
AFTER INSERT OR UPDATE OR DELETE
ON kladr_house
FOR EACH ROW
EXECUTE PROCEDURE diff$log();
ืืื ืืขืืึธืื ืืืจ ืจืืืง ืขืงืกืืจืึทืงื ืึทืืข ืื ืขื ืืขืจืื ืืขื ืืืึธืก ืืืจ ืืึทืจืคึฟื ืคืื ืื ืงืืึธืฅ ืืืฉื ืืื ืืืืคื ืืื ืืืจื ื ืึธื ืืึทื ืืืขืจืก.
3.3. ืืืคึผืึธืจืืื ื ืืื ืืงื ืกืขืฅ
ืืืืื ืืืจ ืืึทืืจืึทืืื ืงืึทืกืขืก ืืืขื ืื ืืึทืื ืกืืจืึทืงืืฉืขืจื ืคืื ืื ืืงืืจ ืืื ืืขืกืืื ืืืฉืึทื ืืขื ืขื ืื ืืขืืืข. ืึธืืขืจ ืืืึธืก ืืืื ืื ืืคึผืืึธืึทื ืคืื ืึท ืคืื ืืจืืืกื ืืืง ืกืืกืืขื ืืื ืึทื ืืขืจืฉ ืคืื ืื ืกืืึธืจืืืืฉ ืกืืจืืงืืืจ ืืื ืืื ืืืขืจ ืืึทืืึทืืืืก?
ืืึธืืืจ ื ืขืืขื ืืื ืึท ืืืืฉืคึผืื ืื ืกืืึธืจืืืืฉ ืคืื ืงืืืืึทื ืฅ ืืื ืืืืขืจ ืึทืงืึทืื ืฅ, ืืขืจ ืงืืึทืกืืฉ "ืคืืืข-ืฆื-ืืืื ืขืจ" ืึธืคึผืฆืืข:
CREATE TABLE client(
client_id
serial
PRIMARY KEY
, inn
varchar
UNIQUE
, name
varchar
);
CREATE TABLE invoice(
invoice_id
serial
PRIMARY KEY
, client_id
integer
REFERENCES client(client_id)
, number
varchar
, dt
date
, sum
numeric(32,2)
);ืึธืืขืจ ืื ืืจืืคืงืืคืืข ืคึฟืื ืึท ืคืื ืืจืืืกื ืืืง ืืงืืจ ืงืืื ืฆื ืืื ืื ืืื ืื ืคืึธืจืขื ืคืื "ืึทืืข ืืื ืืืื":
CREATE TEMPORARY TABLE invoice_import(
client_inn
varchar
, client_name
varchar
, invoice_number
varchar
, invoice_dt
date
, invoice_sum
numeric(32,2)
);ืืึธื, ืงืื ื ืืึทืื ืงืขื ืขื ืืืื ืืืคึผืืืงืืืืื ืืื ืืขื ืืืขืจืกืืข, ืืื ืื ืืืืคึผื ืจืขืงืึธืจื ืืื "ืืฉืืื":
0123456789;ะะฐัั;A-01;2020-03-16;1000.00
9876543210;ะะตัั;A-02;2020-03-16;666.00
0123456789;ะะฐัั;B-03;2020-03-16;9999.00
ืคึฟืึทืจ ืืขื ืืึธืืขื, ืืืจ ื ืึธืจ ืึทืจืืึทื ืืืืื ืืื ืืืขืจ ืคึผืจืึธืืข ืืึทืื, ืึธืืขืจ ืืขืืขื ืงืขื - COPY ืืขืจ ืขืคืขืงืืืื!
INSERT INTO invoice_import
VALUES
('0123456789', 'ะะฐัั', 'A-01', '2020-03-16', 1000.00)
, ('9876543210', 'ะะตัั', 'A-02', '2020-03-16', 666.00)
, ('0123456789', 'ะะฐัั', 'B-03', '2020-03-16', 9999.00);ืขืจืฉืืขืจ, ืืึธืืืจ ืื ืืขืจืฉืืจืืึทืื ืื "ืงืึทืฅ" ืฆื ืืืึธืก ืืื ืืืขืจ "ืคืืงืื" ืึธืคึผืฉืืงื. ืืื ืืื ืืืขืจ ืคืึทื, ืื ืืืืืกืื ืึธืคึผืฉืืงื ืฆื ืงืึทืกืืึทืืขืจื:
CREATE TEMPORARY TABLE client_import AS
SELECT DISTINCT ON(client_inn)
-- ะผะพะถะฝะพ ะฟัะพััะพ SELECT DISTINCT, ะตัะปะธ ะดะฐะฝะฝัะต ะทะฐะฒะตะดะพะผะพ ะฝะตะฟัะพัะธะฒะพัะตัะธะฒั
client_inn inn
, client_name "name"
FROM
invoice_import;ืืื ืกืืจ ืฆื ืจืืืืืง ืคืึทืจืืื ืื ืึทืงืึทืื ืฅ ืืื ืงืื ื IDs, ืืืจ ืขืจืฉืืขืจ ืืึทืจืคึฟื ืฆื ืืขืคึฟืื ืขื ืึธืืขืจ ืืืฉืขื ืขืจืืื ืื ืืืขื ืืืคืืขืจืก. ืืึธืืืจ ืืืืื ืคืขืืืขืจ ืืื ืืขืจ ืืื:
ALTER TABLE invoice_import ADD COLUMN client_id integer;
ALTER TABLE client_import ADD COLUMN client_id integer;ืืึธืืืจ ื ืืฆื ืื ืืืฉ ืกืื ืืงืจืึทื ืึทืืืืฉืึทื ืืืคึฟื ืืืกืงืจืืืื ืืืืื ืืื ืึท ืงืืืื ืึทืืขื ืืืขื ื - ืืืจ ืืืขืื ื ืืฉื ืืขืจืืืึทื ืืืงื ืึธืืขืจ ืืืกืืขืงื ืขืคึผืขืก ืืื ืื ืฆืื ืืืฉ, ืืืืึทื ืืืจ ืึทืจืืึทื ืคืืจ ืงืืืืึทื ืฅ "ืฆืืืขืื-ืืืืื":
-- ะฟัะพััะฐะฒะปัะตะผ ะฒ ัะฐะฑะปะธัะต ะธะผะฟะพััะฐ ID ัะถะต ัััะตััะฒัััะธั
ะทะฐะฟะธัะตะน
UPDATE
client_import T
SET
client_id = D.client_id
FROM
client D
WHERE
T.inn = D.inn; -- unique key
-- ะฒััะฐะฒะปัะตะผ ะพััััััะฒะพะฒะฐะฒัะธะต ะทะฐะฟะธัะธ ะธ ะฟัะพััะฐะฒะปัะตะผ ะธั
ID
WITH ins AS (
INSERT INTO client(
inn
, name
)
SELECT
inn
, name
FROM
client_import
WHERE
client_id IS NULL -- ะตัะปะธ ID ะฝะต ะฟัะพััะฐะฒะธะปัั
RETURNING *
)
UPDATE
client_import T
SET
client_id = D.client_id
FROM
ins D
WHERE
T.inn = D.inn; -- unique key
-- ะฟัะพััะฐะฒะปัะตะผ ID ะบะปะธะตะฝัะพะฒ ั ะทะฐะฟะธัะตะน ััะตัะพะฒ
UPDATE
invoice_import T
SET
client_id = D.client_id
FROM
client_import D
WHERE
T.client_inn = D.inn; -- ะฟัะธะบะปะฐะดะฝะพะน ะบะปัั
ืืื ืคืึทืงื, ืึทืืฅ ืืื ืืื invoice_import ืืืฆื ืืืจ ืืึธืื ืื ืงืึธื ืืึทืงื ืคืขืื ืึธื ืืขืคืืื client_id, ืืื ืืืขืืื ืืืจ ืืืขืื ืืจืืื ืืืืื ืื ืจืขืืขื ืื ื.
ืืงืืจ: www.habr.com