Esempio n. 1
0
#! /usr/bin/env python
import sys, os
MAIN_DIR = os.path.dirname(os.path.abspath(__file__))
sys.path.append(os.path.join(MAIN_DIR, ".."))
#----------------------------------------------------------------------------------------------------------------------


from logger import get_log_db
from database import init_db

print("Create new Database?")
print("!!!  This will delete all existing data !!!")

answer = input("y\\n?: ")

if answer == "y":
    get_log_db().info("Creating new database")
    init_db()
    get_log_db().info("New database created!")
    input()
Esempio n. 2
0
import database

print("Adding school ...")
print("Pls answer following question [(*) := optional]:")

name = input("name [2-128]: ")
shortcut = input("shortcut [2-16]: ")
url = input("url: ")
username = input("(username): ")
pw = input("(password): ")
city = input("city [2-32]: ")
state = input("(state) [2-32]: ")
country = input("(country) [2-32]: ")

answer = input("\nadd school y\\n: ")

if answer == "y":
    get_log_db().info("adding school")
    db = database.connect_db()

    try:
        row_id = ctrl_school.add_school(db, name, shortcut, url, city, username, pw, state, country)
        get_log_db().info(name + " added, id: " +str(row_id))
        open(os.path.join(MAIN_DIR, "..", "database", "school.id"), "a+").write(name + ", " + city + ": " + str(row_id) + "\n")
    except ValueError as e:
        print("Error while creating school entry:")
        print(str(e))
        print("Please try again")

    db.close();
    input()