コード例 #1
0
def main():
    if len(sys.argv) < 2:
        usage()
        return

    action = sys.argv[1]
    if action == 'create':
        sqlalchemysetup.setupwithcredentials(config.dbengine, config.dbuser,
                                             config.dbpassword, config.dbhost,
                                             config.dbname)
        create()
        sqlalchemysetup.close()
    elif action == 'drop':
        sqlalchemysetup.setupwithcredentials(config.dbengine, config.dbuser,
                                             config.dbpassword, config.dbhost,
                                             config.dbname)
        drop()
        sqlalchemysetup.close()
    elif action == 'reload':
        sqlalchemysetup.setupwithcredentials(config.dbengine, config.dbuser,
                                             config.dbpassword, config.dbhost,
                                             config.dbname)
        drop()
        create()
        sqlalchemysetup.close()
    else:
        usage()
コード例 #2
0
def main():
   if len(sys.argv) < 2:
      usage()
      return

   action = sys.argv[1]
   if action == 'create':
      sqlalchemysetup.setupwithcredentials( config.dbengine, config.dbuser, config.dbpassword, config.dbhost, config.dbname )
      create()
      sqlalchemysetup.close()
   elif action == 'drop':
      sqlalchemysetup.setupwithcredentials( config.dbengine, config.dbuser, config.dbpassword, config.dbhost, config.dbname )
      drop()
      sqlalchemysetup.close()
   elif action == 'reload':
      sqlalchemysetup.setupwithcredentials( config.dbengine, config.dbuser, config.dbpassword, config.dbhost, config.dbname )
      drop()
      create()
      sqlalchemysetup.close()
   else:
      usage()
コード例 #3
0
def main():
   print ""
   print "AILadder website setup"
   print "======================"
   print ""

   print "Check python version..."
   if not checkpythonversion():
      return

   neededpackages = []

   print "Check sqlalchemy..."
   try:
      import sqlalchemy
      print "checked sqlalchemy: already installed.  Good."
   except:
      neededpackages.append('sqlalchemy')
      print "... need to install sqlalchemy"
   print ""

   print "Check jinja2..."
   try:
      import jinja2
      print "checked jinja2: already installed.  Good."
   except:
      neededpackages.append('jinja2')
      print "... need to install jinja2"
   print ""

   print "Check python-openid..."
   try:
      import openid
      print "checked python-openid: already installed.  Good."
   except:
      neededpackages.append('openid')
      print "... need to install python-openid"
   print ""

   print "Check elementtree..."
   try:
      import elementtree
      print "checked elementtree: already installed.  Good."
   except:
      neededpackages.append('elementtree')
      print "... need to install elementtree"
   print ""

   newpythonexecutable = None
   if len(neededpackages) > 0:
      print "We need to install some packages to run AILadder website."
      print "They can be installed globally, or in a virtual environment."
      print "If you are on a dedicated machine, global installation is probably best."
      print "If you are on a shared webhosting, you probably should use a virtual environment."
      installlocation = userinput.choice("Please choose target installation environment", { 'global': 'install globally', 'virtualenv': 'install to virtual environment' } )
      while installlocation == None:
         print "Please choose target installation environment:"
         print "g: install globally"
         print "v: install to a virtual environment."
         line = sys.stdin.readline().strip().lower()
         if line == 'g':
            installlocation = 'global'
         if line == 'v':
            installlocation = 'virtualenv'

      if installlocation == 'global':
         if 'sqlalchemy' in neededpackages:
            os.chdir(scriptdir + "/dependencies/SQLAlchemy-0.5.6")
            popen = subprocess.Popen([sys.executable, "setup.py","install"] )
            popen.wait()
         if 'jinja2' in neededpackages:
            os.chdir(scriptdir + "/dependencies/Jinja2-2.2.1")
            popen = subprocess.Popen([sys.executable, "setup.py","install"] )
            popen.wait()
         if 'openid' in neededpackages:
            os.chdir(scriptdir + "/dependencies/python-openid-2.2.4")
            popen = subprocess.Popen([sys.executable, "setup.py","install"] )
            popen.wait()
         if 'elementtree' in neededpackages:
            os.chdir(scriptdir + "/dependencies/elementtree-1.2.6")
            popen = subprocess.Popen([sys.executable, "setup.py","install"] )
            popen.wait()
      elif installlocation == 'virtualenv':
         virtualenvpath = ''
         while virtualenvpath == '':
            print "Please enter the path to the virtual env you wish to use or create:"
            virtualenvpath = sys.stdin.readline().strip()
            os.chdir(scriptdir + "/dependencies/virtualenv-1.3.4")
            popen = subprocess.Popen([sys.executable, "virtualenv.py", virtualenvpath] )
            popen.wait()
            newpythonexecutable = virtualenvpath + "/bin/python"

            if 'sqlalchemy' in neededpackages:
               os.chdir(scriptdir + "/dependencies/SQLAlchemy-0.5.6")
               popen = subprocess.Popen([newpythonexecutable, "setup.py","install"] )
               popen.wait()
            if 'jinja2' in neededpackages:
               os.chdir(scriptdir + "/dependencies/Jinja2-2.2.1")
               popen = subprocess.Popen([newpythonexecutable, "setup.py","install"] )
               popen.wait()
            if 'jinja2' in neededpackages:
               os.chdir(scriptdir + "/dependencies/python-openid-2.2.4")
               popen = subprocess.Popen([newpythonexecutable, "setup.py","install"] )
               popen.wait()
            if 'elementtree' in neededpackages:
               os.chdir(scriptdir + "/dependencies/elementtree-1.2.6")
               popen = subprocess.Popen([newpythonexecutable, "setup.py","install"] )
               popen.wait()

            print "Restarting in virtual environment..."
            popen = subprocess.Popen([newpythonexecutable, scriptdir + "/" + sys.argv[0] ], stdin = sys.stdin, stdout = sys.stdout )
            popen.wait()
            sys.exit(0)

   print ""
   print "Website installation"
   websitedir = ''
   while websitedir == '':
      print "Which directory do you wish to install the website to?"
      websitedir = sys.stdin.readline().strip()

   print "Copying website files..."
   if not os.path.exists(websitedir):
      os.makedirs(websitedir)
   for root, dirs, files in os.walk( scriptdir + "/website" ):
      reldir = root[len(scriptdir + "/website"):]
      #print reldir + " " + str(dirs) + " " + str(files)
      if not os.path.exists(websitedir + reldir):
         os.makedirs( websitedir + reldir )
      for file in files:
         shutil.copy( root + "/" + file, websitedir + reldir + "/" + file )
   if not os.path.exists(websitedir + "/replays"):
      os.makedirs(websitedir + "/replays")
   print " ... done"

   # replace path in .py files
   print "Updating #! path in website files..."
   targetpythonexecutable = sys.executable
   if newpythonexecutable != None:
      targetpythonexecutable = newpythonexecutable
   for file in os.listdir( websitedir ):
      if file.endswith(".py"):
         originalpyfile = filehelper.readFile( websitedir + "/" + file )
         originalpyfilelines = originalpyfile.split("\n")
         if originalpyfilelines[0].startswith("#!"):
            originalpyfilelines[0] = "#!" + targetpythonexecutable
            filehelper.writeFile( websitedir + "/" + file, "\n".join(originalpyfilelines) )
   print " ... done"

   print ""
   print "Database setup"
   print "=============="
   print ""
   dbengine = userinput.choice("Do you want to use mysql (needs mysql, recommended), or sqlite, for the website database?", {'mysql':'mysql','sqlite':'sqlite'} )

   configcontents = filehelper.readFile(websitedir + "/config.py.template" )
   dbuser = None
   dbpassword = None
   dbhost = None
   dbname = None
   if dbengine == 'sqlite':
      gotpath = False
      while not gotpath:
         print ""
         dbname = userinput.getValueFromUser("Please enter the full path to use for the sqlite database")
         print "checking if directory " + os.path.dirname( dbname ) + " exists..."
         if os.path.exists( os.path.dirname( dbname ) ):
            print " ... exists. Ok."
            gotpath = True
         else:
            print " ... does not exist."
      configcontents = configcontents.replace("DBENGINE",'sqlite')
      configcontents = configcontents.replace("DBNAME", dbname )
   elif dbengine == 'mysql':
      gotcredentials = False
      while not gotcredentials:
         print ""
         print "Please provide the name and host of a MySQL database that exists, and the username and password of a MySQL user with full write access to the database."
         dbuser = userinput.getValueFromUser("Please enter the database username")
         dbpassword = userinput.getValueFromUser("Please enter the database password")
         dbname = userinput.getValueFromUser("Please enter the database name")
         dbhost = userinput.getValueFromUser("Please enter the database hostname ('localhost' if it's on the same machine)")
         import sqlalchemy
         engine = sqlalchemy.create_engine('mysql://' + dbuser + ":" + dbpassword + "@" + dbhost + "/" + dbname )
         try:
            print "Checking connection to database..."
            connection = engine.connect()
            connection.close()
            print " ... succeeded"
            gotcredentials = True
         except:
            print " ... failed to connect to database"

      configcontents = configcontents.replace("DBENGINE", 'mysql' )
      configcontents = configcontents.replace("DBUSER", dbuser )
      configcontents = configcontents.replace("DBPASS", dbpassword )
      configcontents = configcontents.replace("DBHOST", dbhost )
      configcontents = configcontents.replace("DBNAME", dbname )

   filehelper.writeFile( websitedir + "/config.py", configcontents )

   print ""
   print "Populating database ..."
   from core import sqlalchemysetup
   sqlalchemysetup.setupwithcredentials( dbengine, dbuser, dbpassword, dbhost, dbname )
   sqlalchemysetup.reloadalltables()
   sqlalchemysetup.close()
   print " ... done"

   print ""
   print "This configuration completed."
   print ""
   print "Please do the following next:"
   print " - configure your webserver to host the " + websitedir + " directory"
   print " - ensure your website runs .py files in " + websitedir + " as Python in cgi"
   print " - ensure that " + websitedir + "/replays is writable by the webserver"
   print " - open the website in your web-browser to check all is ok."
コード例 #4
0
ファイル: setupwebsite.py プロジェクト: furoka/ailadder
def main():
   print ""
   print "AILadder website setup"
   print "======================"
   print ""

   print "Check python version..."
   if not checkpythonversion():
      return

   neededpackages = []

   print "Check sqlalchemy..."
   try:
      import sqlalchemy
      print "checked sqlalchemy: already installed.  Good."
   except:
      neededpackages.append('sqlalchemy')
      print "... need to install sqlalchemy"
   print ""

   print "Check jinja2..."
   try:
      import jinja2
      print "checked jinja2: already installed.  Good."
   except:
      neededpackages.append('jinja2')
      print "... need to install jinja2"
   print ""

   newpythonexecutable = None
   if len(neededpackages) > 0:
      print "We need to install some packages to run AILadder website."
      print "They can be installed globally, or in a virtual environment."
      print "If you are on a dedicated machine, global installation is probably best."
      print "If you are on a shared webhosting, you probably should use a virtual environment."
      installlocation = userinput.choice("Please choose target installation environment", { 'global': 'install globally', 'virtualenv': 'install to virtual environment' } )
      while installlocation == None:
         print "Please choose target installation environment:"
         print "g: install globally"
         print "v: install to a virtual environment."
         line = sys.stdin.readline().strip().lower()
         if line == 'g':
            installlocation = 'global'
         if line == 'v':
            installlocation = 'virtualenv'

      if installlocation == 'global':
         if 'sqlalchemy' in neededpackages:
            os.chdir(scriptdir + "/dependencies/SQLAlchemy-0.5.6")
            popen = subprocess.Popen([sys.executable, "setup.py","install"] )
            popen.wait()
         if 'jinja2' in neededpackages:
            os.chdir(scriptdir + "/dependencies/Jinja2-2.2.1")
            popen = subprocess.Popen([sys.executable, "setup.py","install"] )
            popen.wait()
      elif installlocation == 'virtualenv':
         virtualenvpath = ''
         while virtualenvpath == '':
            print "Please enter the path to the virtual env you wish to use or create:"
            virtualenvpath = sys.stdin.readline().strip()
            os.chdir(scriptdir + "/dependencies/virtualenv-1.3.4")
            popen = subprocess.Popen([sys.executable, "virtualenv.py", virtualenvpath] )
            popen.wait()
            newpythonexecutable = virtualenvpath + "/bin/python"

            if 'sqlalchemy' in neededpackages:
               os.chdir(scriptdir + "/dependencies/SQLAlchemy-0.5.6")
               popen = subprocess.Popen([newpythonexecutable, "setup.py","install"] )
               popen.wait()
            if 'jinja2' in neededpackages:
               os.chdir(scriptdir + "/dependencies/Jinja2-2.2.1")
               popen = subprocess.Popen([newpythonexecutable, "setup.py","install"] )
               popen.wait()

            print "Restarting in virtual environment..."
            popen = subprocess.Popen([newpythonexecutable, scriptdir + "/" + sys.argv[0] ], stdin = sys.stdin, stdout = sys.stdout )
            popen.wait()
            sys.exit(0)

   print ""
   print "Website installation"
   websitedir = ''
   while websitedir == '':
      print "Which directory do you wish to install the website to?"
      websitedir = sys.stdin.readline().strip()

   print "Copying website files..."
   if not os.path.exists(websitedir):
      os.makedirs(websitedir)
   for root, dirs, files in os.walk( scriptdir + "/website" ):
      reldir = root[len(scriptdir + "/website"):]
      #print reldir + " " + str(dirs) + " " + str(files)
      if not os.path.exists(websitedir + reldir):
         os.makedirs( websitedir + reldir )
      for file in files:
         shutil.copy( root + "/" + file, websitedir + reldir + "/" + file )
   if not os.path.exists(websitedir + "/replays"):
      os.makedirs(websitedir + "/replays")
   print " ... done"

   # replace path in .py files
   print "Updating #! path in website files..."
   targetpythonexecutable = sys.executable
   if newpythonexecutable != None:
      targetpythonexecutable = newpythonexecutable
   for file in os.listdir( websitedir ):
      if file.endswith(".py"):
         originalpyfile = filehelper.readFile( websitedir + "/" + file )
         originalpyfilelines = originalpyfile.split("\n")
         if originalpyfilelines[0].startswith("#!"):
            originalpyfilelines[0] = "#!" + targetpythonexecutable
            filehelper.writeFile( websitedir + "/" + file, "\n".join(originalpyfilelines) )
   print " ... done"

   print ""
   print "Database setup"
   print "=============="
   print ""
   dbengine = userinput.choice("Do you want to use mysql (needs mysql, recommended), or sqlite, for the website database?", {'mysql':'mysql','sqlite':'sqlite'} )

   configcontents = filehelper.readFile(websitedir + "/config.py.template" )
   dbuser = None
   dbpassword = None
   dbhost = None
   dbname = None
   if dbengine == 'sqlite':
      gotpath = False
      while not gotpath:
         print ""
         dbname = userinput.getValueFromUser("Please enter the full path to use for the sqlite database")
         print "checking if directory " + os.path.dirname( dbname ) + " exists..."
         if os.path.exists( os.path.dirname( dbname ) ):
            print " ... exists. Ok."
            gotpath = True
         else:
            print " ... does not exist."
      configcontents = configcontents.replace("DBENGINE",'sqlite')
      configcontents = configcontents.replace("DBNAME", dbname )
   elif dbengine == 'mysql':
      gotcredentials = False
      while not gotcredentials:
         print ""
         print "Please provide the name and host of a MySQL database that exists, and the username and password of a MySQL user with full write access to the database."
         dbuser = userinput.getValueFromUser("Please enter the database username")
         dbpassword = userinput.getValueFromUser("Please enter the database password")
         dbname = userinput.getValueFromUser("Please enter the database name")
         dbhost = userinput.getValueFromUser("Please enter the database hostname ('localhost' if it's on the same machine)")
         import sqlalchemy
         engine = sqlalchemy.create_engine('mysql://' + dbuser + ":" + dbpassword + "@" + dbhost + "/" + dbname )
         try:
            print "Checking connection to database..."
            connection = engine.connect()
            connection.close()
            print " ... succeeded"
            gotcredentials = True
         except:
            print " ... failed to connect to database"

      configcontents = configcontents.replace("DBENGINE", 'mysql' )
      configcontents = configcontents.replace("DBUSER", dbuser )
      configcontents = configcontents.replace("DBPASS", dbpassword )
      configcontents = configcontents.replace("DBHOST", dbhost )
      configcontents = configcontents.replace("DBNAME", dbname )

   filehelper.writeFile( websitedir + "/config.py", configcontents )

   print ""
   print "Populating database ..."
   from core import sqlalchemysetup
   sqlalchemysetup.setupwithcredentials( dbengine, dbuser, dbpassword, dbhost, dbname )
   sqlalchemysetup.reloadalltables()
   sqlalchemysetup.close()
   print " ... done"

   print ""
   print "This configuration completed."
   print ""
   print "Please do the following next:"
   print " - configure your webserver to host the " + websitedir + " directory"
   print " - ensure your website runs .py files in " + websitedir + " as Python in cgi"
   print " - ensure that " + websitedir + "/replays is writable by the webserver"
   print " - open the website in your web-browser to check all is ok."