Python execMySQL 예제들

예제 #1

파일: dirac-drop-db.py 프로젝트: pmusset/DIRAC

#!/usr/bin/env python
""" Drop DBs from the MySQL server
"""

from __future__ import print_function
from __future__ import absolute_import
from __future__ import division
from DIRAC.Core.Base import Script
Script.setUsageMessage('\n'.join([
    __doc__.split('\n')[1], 'Usage:',
    '  %s [options] ... DB ...' % Script.scriptName, 'Arguments:',
    '  DB: Name of the Database (mandatory)'
]))
Script.parseCommandLine()
args = Script.getPositionalArgs()

if len(args) < 1:
    Script.showHelp(exitCode=1)

from DIRAC.FrameworkSystem.Client.ComponentInstaller import gComponentInstaller
gComponentInstaller.getMySQLPasswords()
for db in args:
    print(gComponentInstaller.execMySQL("DROP DATABASE IF EXISTS %s" % db))

예제 #2

파일: dirac-drop-db.py 프로젝트: DIRACGrid-test/DIRAC

#!/usr/bin/env python
""" Drop DBs from the MySQL server
"""

from DIRAC.Core.Base import Script
Script.setUsageMessage( '\n'.join( [ __doc__.split( '\n' )[1],
                                     'Usage:',
                                     '  %s [option|cfgFile] ... DB ...' % Script.scriptName,
                                     'Arguments:',
                                     '  DB: Name of the Database (mandatory)'] ) )
Script.parseCommandLine()
args = Script.getPositionalArgs()

if len( args ) < 1:
  Script.showHelp()
  exit( -1 )

from DIRAC.FrameworkSystem.Client.ComponentInstaller import gComponentInstaller
gComponentInstaller.getMySQLPasswords()
for db in args:
  print gComponentInstaller.execMySQL( "DROP DATABASE IF EXISTS %s" % db )