def handle_shell(app, mysql, protocol, hostname, port):
with application.app_context():
print "Launching SQLpie Shell..."
time.sleep(2)
shell = sqlpie.Shell(protocol, hostname, port)
pong = shell.handle_command("/ping")
if pong.startswith("URLError"):
print pong
shell.handle_command("exit")
else:
print "type a command, or type help for a list of commands.\n"
while(True):
try:
g.conn = mysql.connect()
g.cursor = g.conn.cursor()
g.conn.begin()
cmd = raw_input("SQLpie # ")
response = shell.handle_command(cmd)
if len(response) > 1:
print response + "\n"
g.conn.commit()
except Exception as e:
if sqlpie.Util.is_debug():
traceback.print_tb(sys.exc_info()[2])
try:
g.conn.rollback()
except:
pass
finally:
g.cursor.close()
g.conn.close()
def handle_shell(app, mysql, protocol, hostname, port):
with application.app_context():
print "Launching SQLpie Shell..."
time.sleep(2)
shell = sqlpie.Shell(protocol, hostname, port)
pong = shell.handle_command("/ping")
if pong.startswith("URLError"):
print pong
shell.handle_command("exit")
else:
print "type a command, or type help for a list of commands.\n"
while (True):
try:
g.conn = mysql.connect()
g.cursor = g.conn.cursor()
g.conn.begin()
cmd = raw_input("SQLpie # ")
response = shell.handle_command(cmd)
if len(response) > 1:
print response + "\n"
g.conn.commit()
except Exception as e:
if sqlpie.Util.is_debug():
traceback.print_tb(sys.exc_info()[2])
try:
g.conn.rollback()
except:
pass
finally:
g.cursor.close()
g.conn.close()
if sqlpie.Util.is_debug():
traceback.print_tb(sys.exc_info()[2])
try:
g.conn.rollback()
except:
pass
finally:
g.cursor.close()
g.conn.close()
if __name__ == '__main__':
protocol, hostname, port = "http", "localhost", sqlpie.Config.get(sqlpie.Config.SERVER_PORT)
try:
if "--protocol" in sys.argv[1:]:
protocol = sys.argv[int(sys.argv[sys.argv.index("--protocol") + 1])]
if "--hostname" in sys.argv[1:]:
hostname = sys.argv[int(sys.argv.index("--hostname") + 1)]
if "--port" in sys.argv[1:]:
port = sys.argv[int(sys.argv.index("--port") + 1)]
os.environ['sqlpie_debug'] = "False"
application = Flask(__name__)
sqlpie_config = sqlpie.Config().load()
setup = sqlpie.DBSetup(sqlpie_config)
setup.init(application)
mysql = setup.db()
with application.app_context():
handle_shell(application, mysql, protocol, hostname, port)
except:
print "Error. Invalid Parameters."
print "Exiting now.\n\n"
def setUp(self):
application.testing = True
with application.app_context():
self.client = current_app.test_client()
g.conn.rollback()
except:
pass
finally:
g.cursor.close()
g.conn.close()
if __name__ == '__main__':
protocol, hostname, port = "http", "localhost", sqlpie.Config.get(
sqlpie.Config.SERVER_PORT)
try:
if "--protocol" in sys.argv[1:]:
protocol = sys.argv[int(sys.argv[sys.argv.index("--protocol") +
1])]
if "--hostname" in sys.argv[1:]:
hostname = sys.argv[int(sys.argv.index("--hostname") + 1)]
if "--port" in sys.argv[1:]:
port = sys.argv[int(sys.argv.index("--port") + 1)]
os.environ['sqlpie_debug'] = "False"
application = Flask(__name__)
sqlpie_config = sqlpie.Config().load()
setup = sqlpie.DBSetup(sqlpie_config)
setup.init(application)
mysql = setup.db()
with application.app_context():
handle_shell(application, mysql, protocol, hostname, port)
except:
print "Error. Invalid Parameters."
print "Exiting now.\n\n"
