Migrate to SQLite

[its-leofisher]

Phase1:

• https://pymongo.readthedocs.io/en/stable/
• Update .env file and references

DB Schema:

JSON Schema Validation

Device

{
  "bsonType": "object",
  "required": ["device_alias", "ip_addr", "date_created", "date_modified"],
  "properties": {
    "device_alias": {
      "bsonType": "string",
      "maxLength": 200,
      "description": "An alias for the device, must be a string with a max length of 200 characters."
    },
    "ip_addr": {
      "bsonType": "string",
      "description": "The IP address of the device, must be a valid string."
    },
    "device_type": {
      "bsonType": "string",
      "description": "The type of device, can be null if not specified.",
      "nullable": true
    },
    "date_created": {
      "bsonType": "date",
      "description": "The date the device was created, must be a valid date."
    },
    "date_modified": {
      "bsonType": "date",
      "description": "The date the device was last modified, must be a valid date."
    }
  }
}

Behavior Color Map

{
  "bsonType": "object",
  "required": ["behavior_id", "device_id", "color_maps", "date_created"],
  "properties": {
    "behavior_id": {
      "bsonType": "objectId",
      "description": "Unique ID for each behavior, must be an ObjectId"
    },
    "device_id": {
      "bsonType": "objectId",
      "description": "Reference to the device ID, must be an ObjectId"
    },
    "color_maps": {
      "bsonType": "array",
      "description": "Array of color mappings related to behaviors",
      "items": {
        "bsonType": "object",
        "required": ["trigger_keyword", "hex_color", "is_blink"],
        "properties": {
          "trigger_keyword": {
            "bsonType": "string",
            "maxLength": 60,
            "description": "Keyword that triggers the behavior, must be a string with max length 60"
          },
          "hex_color": {
            "bsonType": "string",
            "pattern": "^#?([a-fA-F0-9]{6})$",
            "description": "Hexadecimal color code, must be a valid 6-character hex string"
          },
          "is_blink": {
            "bsonType": "int",
            "minimum": 0,
            "maximum": 1,
            "description": "Flag indicating whether blinking is enabled (1) or disabled (0)"
          }
        }
      }
    },
    "date_created": {
      "bsonType": "date",
      "description": "The date when the behavior color map was created"
    }
  }
}