username = None
password = None
else:
a = raw_input("Server: [127.0.0.1]: ")
hostname = a if len(a) != 0 else "127.0.0.1"
a = raw_input("Database: [msnoise]: ")
database = a if len(a) != 0 else "msnoise"
a = raw_input("Username: [msnoise]: ")
username = a if len(a) != 0 else "msnoise"
a = getpass("Password: [msnoise]: ")
password = a if len(a) != 0 else "msnoise"
engine = create_engine("mysql://%s:%s@%s/%s" % (username, password, hostname, database), echo=False)
create_database_inifile(tech, hostname, database, username, password)
# create tables
Base.metadata.create_all(engine)
Session = sessionmaker(bind=engine)
session = Session()
configs = []
for name in default.keys():
session.add(Config(name=name, value=default[name][-1]))
# session.add_all(configs)
session.commit()
session.close()
print "Installation Done! - Go to Configuration Step!"
def main(tech=None, hostname="localhost", username="******",
password="******", database="msnoise", filename="msnoise.sqlite"):
if tech is None:
print "Welcome to MSNoise"
print
print "What database technology do you want to use?"
print " [1] sqlite"
print " [2] mysql"
tech = int(raw_input('Choice:'))
if tech == 1:
a = raw_input('Filename: [msnoise.sqlite]: ')
hostname = a if len(a) != 0 else "msnoise.sqlite"
database = None
username = None
password = None
else:
a = raw_input('Server: [127.0.0.1]: ')
hostname = a if len(a) != 0 else "127.0.0.1"
a = raw_input('Database: [msnoise]: ')
database = a if len(a) != 0 else "msnoise"
a = raw_input('Username: [msnoise]: ')
username = a if len(a) != 0 else "msnoise"
a = getpass('Password: [msnoise]: ')
password = a if len(a) != 0 else "msnoise"
if tech == 1:
engine = create_engine('sqlite:///%s'%filename, echo=False)
database = None
username = None
password = None
hostname = filename
else:
engine = create_engine('mysql+pymysql://%s:%s@%s/%s' % (username,
password,
hostname,
database),
echo=False)
create_database_inifile(tech, hostname, database, username, password)
# create tables
Base.metadata.create_all(engine)
Session = sessionmaker(bind=engine)
session = Session()
configs = []
for name in default.keys():
session.add(Config(name=name,value=default[name][-1]))
# session.add_all(configs)
try:
session.commit()
except IntegrityError:
print "The database seems to already exist and is not empty, cannot continue"
return "Integrity Error - DB already exist"
session.close()
msg = "Installation Done! - Go to Configuration Step!"
return msg
def main(tech=None,
hostname="localhost",
username="******",
password="******",
database="msnoise",
filename="msnoise.sqlite"):
if tech is None:
print "Welcome to MSNoise"
print
print "What database technology do you want to use?"
print " [1] sqlite"
print " [2] mysql"
tech = int(raw_input('Choice:'))
if tech == 1:
a = raw_input('Filename: [msnoise.sqlite]: ')
hostname = a if len(a) != 0 else "msnoise.sqlite"
database = None
username = None
password = None
else:
a = raw_input('Server: [127.0.0.1]: ')
hostname = a if len(a) != 0 else "127.0.0.1"
a = raw_input('Database: [msnoise]: ')
database = a if len(a) != 0 else "msnoise"
a = raw_input('Username: [msnoise]: ')
username = a if len(a) != 0 else "msnoise"
a = getpass('Password: [msnoise]: ')
password = a if len(a) != 0 else "msnoise"
if tech == 1:
engine = create_engine('sqlite:///%s' % filename, echo=False)
database = None
username = None
password = None
hostname = filename
else:
engine = create_engine('mysql://%s:%s@%s/%s' %
(username, password, hostname, database),
echo=False)
create_database_inifile(tech, hostname, database, username, password)
# create tables
Base.metadata.create_all(engine)
Session = sessionmaker(bind=engine)
session = Session()
configs = []
for name in default.keys():
session.add(Config(name=name, value=default[name][-1]))
# session.add_all(configs)
try:
session.commit()
except IntegrityError:
print "The database seems to already exist and is not empty, cannot continue"
return "Integrity Error - DB already exist"
session.close()
msg = "Installation Done! - Go to Configuration Step!"
return msg
