def dropDB(self, dbName):
if not dbName in self.listDatabases():
return
self.disconnectAll(dbName)
cmd = '%s -p %s -h %s %s' % (self.cmd('dropdb'), self.port, self.host,
dbName)
util.system(cmd)
def dump(self, dbName, path):
assert self.isRunning()
path = os.path.abspath(path)
cmd = '%s -p %s %s > %s' % (self.cmd('pg_dump'), self.port, dbName,
path)
print >> sys.stderr, "DUMP: %r" % cmd
util.system(cmd)
def dropDB(self, dbName):
if not dbName in self.listDatabases():
return
self.disconnectAll(dbName)
cmd = '%s -p %s -h %s %s' % (self.cmd('dropdb'),
self.port, self.host, dbName)
util.system(cmd)
def initDB(self):
if not os.path.exists(self.dbDir):
os.makedirs(self.dbDir)
cmd = "%s --ldata=%s" % (self.cmd('mysql_install_db'), self.dbDir)
t = time.time()
util.system(cmd)
print >> sys.stderr, "INITDB: %r in %s secs" % (self.dbDir,
time.time() - t)
def dump(self, dbName, path):
assert self.isRunning()
path = os.path.abspath(path)
cmd = '%s -p %s %s > %s' % (self.cmd('pg_dump'),
self.port, dbName,
path)
print >> sys.stderr, "DUMP: %r" % cmd
util.system(cmd)
def initDB(self):
# if not os.path.exists(self.dbDir):
# os.makedirs(self.dbDir)
cmd = '%s -A trust -D %s >/dev/null' % (self.cmd('initdb'), self.dbDir)
t = time.time()
util.system(cmd)
print >> sys.stderr, "INITDB: %r in %s secs" % (self.dbDir,
time.time() - t)
def initDB(self):
if not os.path.exists(self.dbDir):
os.makedirs(self.dbDir)
cmd = "%s --ldata=%s" % (self.cmd('mysql_install_db'), self.dbDir)
t = time.time()
util.system(cmd)
print >> sys.stderr, "INITDB: %r in %s secs" % (self.dbDir,
time.time()-t)
def initDB(self):
# if not os.path.exists(self.dbDir):
# os.makedirs(self.dbDir)
cmd = '%s -A trust -D %s >/dev/null' % (self.cmd('initdb'),
self.dbDir)
t = time.time()
util.system(cmd)
print >> sys.stderr, "INITDB: %r in %s secs" % (self.dbDir,
time.time()-t)
def runScripts(self, dbName, scripts):
"""runs sql scripts from given paths"""
for script in scripts:
script = self.resolveScriptPath(script)
if self.verbose:
output = ''
else:
output = '>/dev/null 2>&1'
util.system('%s -q -f %s %s %s' % (
self.psql, script, dbName, output))
def runScripts(self, dbName, scripts):
"""runs sql scripts from given paths"""
for script in scripts:
script = self.resolveScriptPath(script)
if self.verbose:
output = ''
else:
output = '>/dev/null 2>&1'
util.system('%s -q -f %s %s %s' %
(self.psql, script, dbName, output))
def start(self):
daemon_path = self.mysqld_path()
if not daemon_path:
raise IOError, "mysqld was not found. Is a MySQL server installed?"
if self.defaults_file:
defaults = '--defaults-file="%s"' % self.defaults_file
else:
defaults = '--no-defaults'
cmd = "%s %s --datadir=%s --port=%i --pid-file=%s/mysql.pid --socket=%s/mysql.sock & > /dev/null 2>&1 " % (
daemon_path, defaults, self.dbDir, self.port, self.dbDir, self.dbDir)
util.system(cmd)
while not self.isRunning():
time.sleep(0.1)
def start(self):
daemon_path = self.mysqld_path()
if not daemon_path:
raise IOError, "mysqld was not found. Is a MySQL server installed?"
if self.defaults_file:
defaults = '--defaults-file="%s"' % self.defaults_file
else:
defaults = '--no-defaults'
cmd = "%s %s --datadir=%s --port=%i --pid-file=%s/mysql.pid --socket=%s/mysql.sock & > /dev/null 2>&1 " % (
daemon_path, defaults, self.dbDir, self.port, self.dbDir,
self.dbDir)
util.system(cmd)
while not self.isRunning():
time.sleep(0.1)
def createDB(self, dbName):
cmd = "%s -e 'CREATE DATABASE %s'" % (self.mysql, dbName)
util.system(cmd)
def stop(self):
cmd = "%s shutdown > /dev/null 2>&1" % self.mysqladmin
util.system(cmd)
while self.isRunning():
time.sleep(0.3)
def createDB(self, dbName):
cmd = '%s -p %s -h %s %s' % (self.cmd('createdb'), self.port,
self.host, dbName)
util.system(cmd)
def dump(self, dbName, path):
assert self.isRunning()
path = os.path.abspath(path)
cmd = "%s -r %s %s" % (self.mysqldump, path, dbName)
print >> sys.stderr, "DUMP: %r" % cmd
util.system(cmd)
def ctl(self, arg):
cmd = '%s -l "%s" -D %s %s' % (self.cmd('pg_ctl'), self.pgCtlLog,
self.dbDir, arg)
util.system(cmd)
def createDB(self, dbName):
cmd = "%s -e 'CREATE DATABASE %s'" % (self.mysql, dbName)
util.system(cmd)
def dropDB(self, dbName):
if not dbName in self.listDatabases():
return
cmd = "%s -e 'DROP DATABASE %s'" % (self.mysql, dbName)
util.system(cmd)
def runScripts(self, dbName, scripts):
"""runs sql scripts from given paths"""
for script in scripts:
script = self.resolveScriptPath(script)
cmd = "%s %s < %s" % (self.mysql, dbName, script)
util.system(cmd)
def dump(self, dbName, path):
assert self.isRunning()
path = os.path.abspath(path)
cmd = "%s -r %s %s" % (self.mysqldump, path, dbName)
print >> sys.stderr, "DUMP: %r" % cmd
util.system(cmd)
def stop(self):
cmd = "%s shutdown > /dev/null 2>&1" % self.mysqladmin
util.system(cmd)
while self.isRunning():
time.sleep(0.3)
def ctl(self, arg):
cmd = '%s -l "%s" -D %s %s' % (self.cmd('pg_ctl'),
self.pgCtlLog,
self.dbDir, arg)
util.system(cmd)
def dropDB(self, dbName):
if not dbName in self.listDatabases():
return
cmd = "%s -e 'DROP DATABASE %s'" % (self.mysql, dbName)
util.system(cmd)
def createDB(self, dbName):
cmd = '%s -p %s -h %s %s' % (self.cmd('createdb'),
self.port, self.host, dbName)
util.system(cmd)
def runScripts(self, dbName, scripts):
"""runs sql scripts from given paths"""
for script in scripts:
script = self.resolveScriptPath(script)
cmd = "%s %s < %s" % (self.mysql, dbName, script)
util.system(cmd)
