Пример #1
0
def loadAnswerSet(path, pattern = "default"):
	database.open()
	if os.path.isfile(path):
		files = [path]
	elif os.path.isdir(path):
		files = glob.glob(path + "/*/*/*")
	else:
		print("\"" + path + "\" is neither a file nor a folder. We assume that it is a file pattern...")
		files = glob.glob(path)

	for file in files:
		print("Looking at " + file)
		(trial,student,solution) = parseFilename(file, pattern)
		history = loadCSV(file)
		n = 1
		nm = NodeMap(trial)
		data = {}
		for row in history:
			src = nm.get(row["Source"])
			dst = nm.get(row["Destination"])
			if row["Action"] == "Connecting":
				database.addProgress(solution, n, "create", src, dst, "")
				data[(src,dst)] = (n, "")
			elif row["Action"] == "Renaming":
				database.addProgress(solution, n, "rename", src, dst, row["to"])
				data[(src,dst)] = (n, row["to"])
			elif row["Action"] == "Disconnecting":
				database.addProgress(solution, n, "remove", src, dst, "")
				del data[(src,dst)]
			n += 1
		for d in data:
			ordering,desc = data[d]
			database.addAnswer(solution, ordering, d[0], d[1], desc)
Пример #2
0
 def __init__(self, path):
     self.db = database.open(path)
     self.backreferences = registry.BackreferenceRegistry()
     self.instances = registry.ModelInstanceRegistry()
     self.models = {}
     self.context = None
     self.Model = model.create(self)
Пример #3
0
def selectTrial():
	database.open()
	print("Please select one of these experiments:")
	trials = database.listTrials()
	valid = []
	for t in trials:
		print("\t" + str(t[0]) + "\t" + str(t[1]))
		valid.append(str(t[0]))
	res = input("> ")
	if res.isdigit() and (res in valid):
		print()
		return int(res)
	else:
		print("Your input was invalid.")
		print()
		return selectTrial()
Пример #4
0
def selectTrial():
    database.open()
    print("Please select one of these experiments:")
    trials = database.listTrials()
    valid = []
    for t in trials:
        print("\t" + str(t[0]) + "\t" + str(t[1]))
        valid.append(str(t[0]))
    res = input("> ")
    if res.isdigit() and (res in valid):
        print()
        return int(res)
    else:
        print("Your input was invalid.")
        print()
        return selectTrial()
Пример #5
0
def loadAnswerSet(path, pattern="default"):
    database.open()
    if os.path.isfile(path):
        files = [path]
    elif os.path.isdir(path):
        files = glob.glob(path + "/*/*/*")
    else:
        print(
            "\"" + path +
            "\" is neither a file nor a folder. We assume that it is a file pattern..."
        )
        files = glob.glob(path)

    for file in files:
        print("Looking at " + file)
        (trial, student, solution) = parseFilename(file, pattern)
        history = loadCSV(file)
        n = 1
        nm = NodeMap(trial)
        data = {}
        for row in history:
            src = nm.get(row["Source"])
            dst = nm.get(row["Destination"])
            if row["Action"] == "Connecting":
                database.addProgress(solution, n, "create", src, dst, "")
                data[(src, dst)] = (n, "")
            elif row["Action"] == "Renaming":
                database.addProgress(solution, n, "rename", src, dst,
                                     row["to"])
                data[(src, dst)] = (n, row["to"])
            elif row["Action"] == "Disconnecting":
                database.addProgress(solution, n, "remove", src, dst, "")
                del data[(src, dst)]
            n += 1
        for d in data:
            ordering, desc = data[d]
            database.addAnswer(solution, ordering, d[0], d[1], desc)
import shapely.wkt

import database
import mapGenerator


#############################################################################

METERS_PER_MILE = 1609.344

#############################################################################

# Open the database.

database.open()

# Get our CGI parameters.

form = cgi.FieldStorage()

countryID = int(form['countryID'].value)
radius    = int(form['radius'].value)
x         = int(form['x'].value)
y         = int(form['y'].value)
mapWidth  = int(form['mapWidth'].value)
mapHeight = int(form['mapHeight'].value)

# Calculate the lat/long bounds for the map the user clicked on.

details = database.get_country_details(countryID)
Пример #7
0
 def test_is_open_opened(self):
     database.create_menu_table('speedy')
     database.open('speedy')
     self.assertTrue(database.is_open('speedy'))
Пример #8
0
 def test_close_an_open_restaurant(self):
     database.create_menu_table('subway')
     database.open('subway')
     self.assertTrue(database.close('subway'))
Пример #9
0
 def test_open_an_opened_restaurant(self):
     database.create_menu_table('subway')
     database.open('subway')
     self.assertFalse(database.open('subway'))
Пример #10
0
 def test_open_closed_restaurant(self):
     database.create_menu_table('speedy')
     self.assertTrue(database.open('speedy'))
def open():
    restaurant = input("Which restaurant you want to open: ")
    if database.is_there_such_restaurant(restaurant):
        database.open(restaurant)
    else:
        print("There is no such restaurant")
Пример #12
0
from vk_api.bot_longpoll import VkBotLongPoll, VkBotEventType
import vk_group_bot
import database
import bot
import user_message_handler
import admin_message_handler

if __name__ == "__main__":
    vk_group_bot.initialize()
    database.open()
    bot.initialize()

    longpool = VkBotLongPoll(vk_group_bot.vk, vk_group_bot.GROUP_ID)
    Running = True
    while Running:
        for event in longpool.listen():
            if not Running:
                break

            # handle events
            if event.type == VkBotEventType.MESSAGE_NEW:
                if event.object.peer_id != vk_group_bot.ADMIN_CHAT_ID:
                    user_message_handler.handle(event.object)
                else:
                    admin_message_handler.handle(event.object)
Пример #13
0
        "--db", dest="db_path", help="Path to the database file to be used", type=str, default=DEFAULT_DB_PATH)
    argparser.add_argument("--broker", dest="mqtt_broker",
                           help="The MQTT broker URI", type=str, default=DEFAULT_MQTT_BROKER)
    args = argparser.parse_args()

    # make database instance
    db_path = args.db_path
    database_path = os.path.dirname(db_path)
    database_name = os.path.basename(db_path)
    if not os.path.exists(database_path):
        logging.info('Creating directory "{}"'.format(database_path))
        os.mkdir(database_path)

    db_path = os.path.join(database_path, database_name)
    logging.info("Connecting to database '{}'".format(db_path))
    database.open(db_path)

    # first off, get all existing data from the database
    topics = database.get_topics()
    for topic in topics:
        data = database.get_data(topic)

        # sensor type is the last part in the topic
        sensor_type_str, sensor_name_str = sensor_type_and_name_from_db_name(
            topic)

        with g_topic_data_lock:
            if sensor_type_str in g_topic_data:
                sensor_type: SensorType = g_topic_data[sensor_type_str]
                the_data = sensor_type.add_series(sensor_name_str)
            else:
Пример #14
0
import database

database.open('BotDB.db')

with open('CreationScript.sql') as SQLFile:
    sqlText = SQLFile.read()

tableTexts = sqlText.split('=====\n')
for text in tableTexts:
    database.cursor.execute(text)
    database.connection.commit()
    print(text.split('\n')[1])
print('tables created')
database.close()