コード例 #1
0
ファイル: NodeThread.py プロジェクト: Samidahlawi/IOT_Project
 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()
コード例 #2
0
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);""")
コード例 #3
0
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);""")
コード例 #4
0
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);""")
コード例 #5
0
 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
     ]))
コード例 #6
0
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);""")
コード例 #7
0
 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()
コード例 #8
0
 def update_in_db(self):
     db_conn = DatabaseConnection()
     db_conn.change(self.get_update_command())
コード例 #9
0
 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]}")
コード例 #10
0
def drop_old_tables():
    for table in get_all_existing_table_names():
        DatabaseConnection().change("DROP TABLE IF EXISTS {}".format(table))
コード例 #11
0
def create_table_weekend_participant():
    DatabaseConnection().change(
        """CREATE TABLE weekend_participant (
            weekendId integer NOT NULL,
            personName text NOT NULL);""")
コード例 #12
0
def get_all_existing_table_names():
    return [table_tuple[0] for table_tuple
            in DatabaseConnection().query(
            "SELECT name FROM sqlite_master WHERE type='table';")]