Comments (3)
I may have a possible solution. I'm appending the current environment variables to the env
dictionary before passing it as parameter to subprocess.run
. Here is a sample script:
import os
import subprocess
host = 'localhost'
username = 'xx'
password = 'xx'
database = 'testbed'
env = { 'MYSQL_PWD': password }
# add the current environment variables
env.update(os.environ)
command = [
'mysqldump',
'-h', host,
'-u', username,
'--no-create-db',
'--no-data',
'--compact',
database
]
result = subprocess.run(command, env=env, stderr=subprocess.PIPE)
If you think this is a good way to solve the problem, I can send you a pull request with this change.
Let me know.
from agnostic.
I have submitted a PR for this issue: #15
from agnostic.
Closed via #15
from agnostic.
Related Issues (18)
- Postgres schema support HOT 5
- Create a way to migrate or bootstrap HOT 3
- Absence of migrations should not be an error
- No database password HOT 3
- Boostraped migrations HOT 2
- Documentation about sorting migration names with @, _ is incorrect
- Add SQLite support
- Add integration tests for PostgreSQL schema support
- Integration test for postgres schema support HOT 1
- Fix debug flag
- Separate "restore backup" from "restore snapshot"
- Link to documentation in README.rst is broken. HOT 1
- Add posibility to work with any database.
- MariaDB support
- No change in db after the migration script ran
- Error on connection with pg8000 1.12.3 and postgres 13.4 HOT 2
- Migrated this repo to mehaase/agnostic
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from agnostic.