myems / myems-api

        cursor.execute(query_data_source, (id_,))

        rows_data_source = cursor.fetchall()

        now = datetime.utcnow().replace(second=0, microsecond=0, tzinfo=None)

        if rows_data_source is not None and len(rows_data_source) > 0:

            for row in rows_data_source:

                last_seen_time = row[5]

                if last_seen_time is not None and (now - last_seen_time).total_seconds() > 5 * 60:

                    status = "online"

                else:

                    status = "offline"

                meta_result = {"id": row[0],

                               "name": row[1],

                               "uuid": row[2],

                               "protocol": row[3],

                               "connection": row[4],

                               "last_seen_datetime": row[5].timestamp()*1000 if isinstance(row[5], datetime) else None,

                               "status": status}

                result.append(meta_result)

        cursor.close()

        cnx.disconnect()

        result = list()

        now = datetime.utcnow().replace(second=0, microsecond=0, tzinfo=None)

        if rows is not None and len(rows) > 0:

            for row in rows:

                last_seen_time = row[4]

                if last_seen_time is not None and (now - last_seen_time).total_seconds() > 5 * 60:

                    status = "online"

                else:

                    status = "offline"

                meta_result = {"id": row[0], "name": row[1], "uuid": row[2],

                               "token": row[3],

                               "last_seen_datetime": row[4].timestamp() * 1000 if isinstance(row[4],

                                                                                             datetime) else None,

                               "status": status}

                result.append(meta_result)

        resp.body = json.dumps(result)