FilesExpand file tree

 main

/

script.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

19 lines (13 loc) · 640 Bytes

 main

/

script.py

Copy path

Top

File metadata and controls

• Code
• Blame

19 lines (13 loc) · 640 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

from datetime import datetime

from os import getcwd

from typing import Union

import pexpect

def dumper(db_host: str, db_port: Union[str, int], db_user: str, db_name: str, db_password: Union[str, int]):

dump_name = f'{db_name}_{datetime.now().strftime("%Y%m%d")}.sql'

child = pexpect.spawn(f"pg_dump -U {db_user} -h {db_host} -p {db_port} -d {db_name} -f {getcwd()}/{dump_name}")

expected_text = "Password: "

child.expect(expected_text)

child.sendline(str(db_password))

child.interact()

# Just an example

# dumper(db_host='localhost', db_port=5432, db_user='postgres', db_name='database', db_password=12345678)