def __init__(self,ip,port):
threading.Thread.__init__(self)
self.name = ""
self.ipv4 = ip
self.port = port
self.socket = None
self.available = False
self.zigbee = False
self.zigbee_properties = None
self.zigbee_addr_long = ''
self.zigbee_addr_short = ''
self.zigbee_cordy = False
self.lowpan = False
self.sensorTemp = False
self.sensorHumdity = False
self.status = {}
self.daemon = True
self.running = True
self.queue = queue.PriorityQueue()
self.pid = 0
self.eid = 0
self.packets_indicator = []
self.get_indi = False
self.get_packs = False
self.keep_running = True
self.reciver_addr_long = ''
self.reciver_addr_short = ''
self.temp_interval = 0
self.humdity_interval = 0
self.duration = 0
self.counter = 0
self.sender_name = ''
self.db = DatabaseConnection()
def create_table_volunteers():
DatabaseConnection().change(
"""CREATE TABLE volunteers(
personName text PRIMARY KEY NOT NULL,
gender text NOT NULL,
birthDate date NOT NULL,
homeRegion text);""")
def create_table_mysecs():
DatabaseConnection().change(
"""CREATE TABLE mysecs(
positionId integer PRIMARY KEY NOT NULL,
personName text NOT NULL,
regionName text NOT NULL,
startDate date NOT NULL,
endDate date);""")
def create_table_weekends():
DatabaseConnection().change(
"""CREATE TABLE weekends (
weekendId integer PRIMARY KEY NOT NULL,
weekendName text NOT NULL,
weekendLocation text NOT NULL,
startDate date NOT NULL,
endDate date NOT NULL,
regionName text NOT NULL);""")
def get_details_fitting_data(cls, commands: list, **kwargs):
assert len(commands) > 0, \
"At least one specifying command must be given"
db_conn = DatabaseConnection()
return db_conn.query(f"""SELECT *
FROM {cls.get_table_name(**kwargs)}
WHERE """ + " AND ".join([
cls.argument_name_to_column_name(command[0]) +
f" {command[1]} '{' '.join(command[2:])}'" for command in commands
]))
def create_table_regions():
DatabaseConnection().change(
"""CREATE TABLE regions (
regionId integer NOT NULL,
regionName text PRIMARY KEY NOT NULL,
regionMailName text NOT NULL,
magazineName text NOT NULL,
mCount integer NOT NULL,
myCount integer NOT NULL,
nonMCount integer NOT NULL,
looking boolean NOT NULL);""")
def __init__(self):
threading.Thread.__init__(self)
self.daemon = True
self.queue = queue.PriorityQueue()
self.nodes_info = [('192.168.1.209', 9998), ('192.168.1.208', 9998),
('192.168.1.207', 9998)]
self.Nodes = []
self.running = True
self.experiment = None
self.db = DatabaseConnection()
self.cordy = None
self.setup_node()
def update_in_db(self):
db_conn = DatabaseConnection()
db_conn.change(self.get_update_command())
def add_to_db(self):
db_conn = DatabaseConnection()
try:
db_conn.change(self.get_insertion_command())
except IntegrityError:
print(f"{sys.exc_info()[0].__name__}: {sys.exc_info()[1]}")
def drop_old_tables():
for table in get_all_existing_table_names():
DatabaseConnection().change("DROP TABLE IF EXISTS {}".format(table))
def create_table_weekend_participant():
DatabaseConnection().change(
"""CREATE TABLE weekend_participant (
weekendId integer NOT NULL,
personName text NOT NULL);""")
def get_all_existing_table_names():
return [table_tuple[0] for table_tuple
in DatabaseConnection().query(
"SELECT name FROM sqlite_master WHERE type='table';")]
