Skip to content

dmitriy-malyutin/query_to_postgres

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

7 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

query_to_postgres

Вторая вСрсия скрипта send_query_to_postrgresql

Π’ΠΊΠ»ΡŽΡ‡Π΅Π½Π° Π²ΠΎΠ·ΠΌΠΎΠΆΠ½ΠΎΡΡ‚ΡŒ Π΄ΠΎΠ±Π°Π²Π»ΡΡ‚ΡŒ любоС количСство запросов ΠΈ Π‘Π”

JSON

  "query_name": {
      "USER": "user",
      "PASSWORD": "password",
      "HOST": "host",
      "BASE": "db_name",
      "PORT": 15432,
      "header": [
        "column1",
        "column2",
        "ΠΊΠΎΠ»ΠΎΠ½ΠΊΠ°3",
        "ΠΊΠΎΠ»ΠΎΠ½ΠΊΠ°42"
      ],
      "sheet": "sheet_name",
      "sql_file_path": "\\query.sql"
  query_name - имя, Π²Ρ‹Π³Ρ€ΡƒΠ·ΠΊΠ° Π±ΡƒΠ΄Π΅Ρ‚ Π½Π°Π·Ρ‹Π²Π°Ρ‚ΡŒΡΡ "ΠžΡ‚Ρ‡Ρ‘Ρ‚_{query_name}_{today}".xlsx
  
  header - ΠΈΠΌΠ΅Π½Π° ΠΊΠΎΠ»ΠΎΠ½ΠΎΠΊ
  
  sheet - имя страницы
  
  sql_file_path - Π½Π°Π·Π²Π°Π½ΠΈΠ΅ Ρ„Π°ΠΉΠ»Π° с запросом, Π»Π΅ΠΆΠ°Ρ‰Π΅Π³ΠΎ Π² ΠΏΠ°ΠΏΠΊΠ΅ sql_requests

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages