def main(): ex("sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib") ex("mysql -u root --execute \"create user '%s'@'localhost'\""%user) _createDb(nlt) _createDb(researchbroker) _createDb(surveysidekick) _createDb(vialogues) _createDb(cas)
def mySqlToDownloadsDir(): chdir(DOWNLOAD_DIR) url = MYSQL_32_URL if is64Bit(): url = MYSQL_64_URL ex("curl -o mysql-5.5.25-osx10.6-x86_64.tar.gz -L %s"%url) ex("sudo tar xvzf mysql-5.5.25-osx10.6-x86_64.tar.gz -C %s"%USR_LOCAL) ex("sudo ln -s %s/mysql-5.5.25-osx10.6-x86_64.tar.gz %s/mysql"%(USR_LOCAL, USR_LOCAL)) ex('echo "export PATH=\\$PATH:%s" >> ~/.profile'%(join(USR_LOCAL, "mysql", "bin"))) ex('echo "export DYLD_LIBRARY_PATH=%s/mysql/lib/" >> ~/.profile'%USR_LOCAL)
def is64Bit(): out = ex("uname -a")[0] for line in out: if re.match(".*RELEASE_X86_64 x86_64$", line) is not None: return True elif re.match(".*RELEASE_I386 i386$", line) is not None: return False else: raise Exception("Cant detect if cpu is 32 bit or 64 bit")
def _createDb(project): ex("mysqladmin --user=root drop %s"%project) ex("mysqladmin --user=root create %s"%project) ex("mysql -u root --execute \"GRANT ALL ON %s.* TO '%s'@'localhost';\""%(project, user)) pass
def _createUser(): for line in ex("whoami")[0]: user = strip(line) ex('echo "export PATH=%s:\\$PATH" >> ~/.profile'%(join(USR_LOCAL, "mysql", "bin"))) ex("sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib") ex('echo "export DYLD_LIBRARY_PATH=%s/mysql/lib/" >> ~/.profile'%USR_LOCAL) ex("mysql -u root --execute \"create user '%s'@'localhost'\""%user) ex("mysqladmin --user=root create vialogues") ex("mysql -u root --execute \"GRANT ALL ON vialogues.* TO '%s'@'localhost';\""%user) pass