Carlos Aguni

Highly motivated self-taught IT analyst. Always learning and ready to explore new skills. An eternal apprentice.


Boomtable Generics

13 Feb 2022 »
def gen_boomtable_generics(from_ms, to_ms):

    response = []
    row = []
    shield_warning = '<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAeVJREFUOE9jZKAQMML0Hz9z6TE2s1RVFI5jExcR4AsDicMN2Hv4+H+e7zcY2P68QVGvIPEShf+fS5nhn0QUg4gAP1gvigEqz9oZhD4fQdHwT+MvqgP+SDH8NjhBnAEzL2swMAj/Z0h1uoYwhBQDes7qMfwX/M9Q7HWBPANmXYG4IMWRTBcsv6nC8F/sL0OE5R3CLth/9OR/hWd9DCIfd8MVb30gx/Bf4i+Dl8EjhAF/lRm+ae9mkBQRRo2FIyfP/uV5s4tJ+Xk3XPGrb5wM/1X+MojyfYeL/edKZHjGn/9TS1mRAyUadx85eon5H4OuxuMKBt7vV8Ea5l7VYPgv8o8hyf46xIDfPAy/DS4xnL12Y7e7tbUbigFTVqxQ01NUvsH47QWj2pNGBq6f9xhef+dg+K/8l0GE7wcDw29Ohr+qaxjufRT8e/LcOY3s2FhwwMATEogzb+3aFFVZ+dl/vn9mkH2zkEH0w3YGBrWfDP8ZtBj+qC9mePj65/9z164mpIaGLoL5CcUAkODUJctDVOVkl7GzsrMy/XjBoKUqwPCNRY3h2q1b3+88fhSTHR29DjlpYhgANmT5cllWRuZ6BRnpxP+MDP8ePH4y9+ef3y15MTFP0DMWVgNgiiYtWSIDYmPTCFMDAGAV2BF54GIzAAAAAElFTkSuQmCC"/>'
    shield_ok = '<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAYlJREFUOE9jZKAQMML0z1u97jE2s+QlpI5jE3e2tQgDicMNmLp02X9JEVEGDnY2FPVP/ouh8HmZ/jCIMX1hcLa1BOtFMUBPVY3h18/fKBrKr4qg8M0lmBmChF+OGoAtDKYtX/H/4k9phkMPvqEE2uECCxT+2/fvGR48fMzg7mCLGguzV67++5xBiGn59T94DXj4+AnDg0dPfgZ7u3OgROP0xUsv/WNm0t37QYrh+qsfcEOQXfD12zeGu3cfMNy6e293RkK0G4oBDb29atLSMje+M7Axbn8lxPDgHcQQmAHfv/9guP/gMcPjF8/+3r5/R6OhqOgOigEgTuuUKSniomKzf/xlYLjxR5Lh8MPvDHuyTRnevP/A8OLFK4bnr17+v/PwXkJdQcEimBPhKREm0NDTEyIqLrmMmZWZ9RcDO4OBggzDl6/fGB4+ffT95auXMQ0lJeuQAwnDAJBkdW+vLAcjS72oqGgiI8P/fy/evJr7/9evloby8ifoGQurAXDXdHbKgNjYNMLUAACYg8QR6A5liQAAAABJRU5ErkJggg=="/>'
    shield_bad = '<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAjFJREFUOE+lk11IU2EYx//vOfvwbHNunhlbbWtrbYZg0GVINxEFddFNBuGEgoRC7SKKkIjdmBcaVJLVMEfEakrobRcSQTrGIbdgpAyRMrdYeJgVuQ/3dWKLI51aMei9ep/nff4/eJ7n/xL85yGiPrQQjddiOffaQrXyBp32dCW/DXg5FxLIx/fAtw1J/Z5CRhLTZguYIydg0DVVtRIA5X8IEl2QCFpZvSTOaXVovP/03wBCUaAYBqV0GlWASgVkc4BQRl0AY08/1O0HsDrQD2ezHtTAEMrv3kKYelwfQGE0wT78AIXUOpS0DALLIuW5iuYvfH2AStOMsxWOu75q/8krF2D4nKhO7K8tvApyAqYmQN4EQas1sN28AxnbUgVQXzcgDN+AkEkjazCCueWFycBKtzDPhUt5bo6iAuMwXbwM7cFD+HCtD2q5HDsGb0MIcyB+L/KHjyN98sxWm8PeIFnj7HwwSpfQTrwjoJNx0I1aFPh1uFg9+AYVFJkMGKUCmkfPEY7FZo91dByVAO5NTrr22x2xAs8T2jcKJH8aU/RBnpZB4RnBJ6WqxEUi+3q7u1ckgErgm54+77TsHs9/3wT1YgaEew1Xkwa5nVZorg8hvpkRIkuLZ3s6O5+I7tp2opgY8wdOOa2WZ0q5Ul5M8WgztqBotmJpeTm7El9z93Z1zfxqzT8AlcexQMAiJ7THZt51TiAor8YTE1vFwuAltzvx+8eqCRCLRv1+c+VeSyjW/ACFENoRri4lwgAAAABJRU5ErkJggg=="/>'
    status_error = '<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAv9JREFUOE9dk01MVFcYhp/v3Dszd+wIRFQCSQUbjR0KNS1CBVQ6pcHEmMjCnyZVk9pFU3XRXdsNCzZtdy5Q00VtojapPwtMTBOMSFEZFKSNhTI1NhVsAkGlAZ06d2buvae5t52p4ay+nO+873nf70dYcgZbXjuuPfeQ1toqpETEFmWcakv+emTpeylcDLbUdUjY6Kt6q5XVDZsIl5aCBgRyi4s8GrvDzO0hdM7d3pacuFIk9wMfHFlZ3hc/+AHGwjzPk/3kfxvHy/yNir5E6NV6lrW045aVkzr9Ldkn80WSQMH1to264bMu8jf6yIxeR9sZVn3xDWZrO85QP48//xCxokQbtxHaup2xL7vZNng3wIrvee3u9w6XLc5i/zSMFoVOP6Oi/17R7lz7BiS2HNEe1pvNLJRW8uDi9yf8mshAS63d+NHHkVzvWbRpBiAv/YyyExcxa9bjTN1n4fBuVGx5kBPHIdy5n9GvT2YTyUnLJ9Cbd3RgT/wMhgJPBxaiB49ide7H7j1L5nRPYAEl4HpYdW9w64crJJKTIgOtdXpzcwP5uZlAPlpDPoeKbyTWdYx09yd4qbsQCoNIYCNUUcWt4TESQxMiA1vqdXN8LY7rBV0rEOj0U3Q2i0QiSKzkfwLANBTDqQckbo6LXNtan23a8ErYMBWep8Hz0M/ThPYcItz5Prne78hfOIUsi4FSKCW4jsfIvT9y79wYj8iFpvi5hpqqvS9XrML1wa6L/3v0THFWyBzoCFSIYWAoxZ9zjxmbmjm/ZyS1z+/lmoEtddON9bVYVgTPcQIF7NxXVMDlc4ECZZrYdpbR8UkSNyeqgYfBMHTFq4+8u7qsZ9PrtUQtC53PoW0bXAcME7EsJBQmY9vc+WWSq48Wjnanpo8Hbf1vWkq64tUH3l4R61lXU01lZQVmJPJvQUVwsllmZ+f4fWqaH/9K++AzwNMXCfy4BFh/vin+6cqQsQt0uLBMILkneffS3pHUV8D9AngpQWF01wDlgHphdT1g3ve8dJ3/AQJ5PCDFymIbAAAAAElFTkSuQmCC"/>'
    status_warning = '<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAipJREFUOE+lk01IVFEYhp9zR51+SIisKVNhFEILQsfRmf7ITJctpAKFclHhJtSEFlFot5GkRWBqbaRaWJBQ4aKlZkYtZsaZUYJSAh1QsywjMPoZde6Je2aUzASps7nf5Xvf57zfd7mC/zxiJb+vsdCeIKKjZn9eWjJd9f7w37QrArwN+QM5pWW5pmmou2vQ7QnmrRrgu1JYnWxLb80ur1Ge4c5WZqbGa1yX/W1/QpYlCOj566TF+s156gLh8Wmlt6enELh7DRGNrHfqwe+/Q5YBzOiZRUdzN+/O4FidV2kfNbv59GqM0b7Hy0ZZAvDqzvINtqwHO0/UwtB5jrc4FOBhbQhyrvPmfgtfp0Yq3HqgcyHFEoDPs186q66iTTRDZIgjN4qV7sm5XrDmYKTVEWi/hKvh5aJvsfDWO7oziitLtm0Nw/QLWKNRpKuPQJ8+CD8NSDnA+w92xno7etyNoVKzpwD9ekHJWtuO7l1lhyHcDiIRrPDxc7ICbNk0AxFAzoG9itddT/kx9ba0QO/vUQCf56DMqzxD4pc7IBNAaGA1KGvKV4Cui0GIaCANEPPMbTzNQMdtXA3PhfDre26mug+d3Z41DLPmNVosV5JBUXVabIS2CZg1AeabAUlW3o1kM+l9dksEm/ZJx8nU2FKN+ErMhwVIUA6YFxA1R4jvXosVoXuTCL9nrzSiEmnIuGABItHipdlCLuxbqoRCE2gWocLGBv3Hs+LPtFreLxpRum1bjXdCAAAAAElFTkSuQmCC"/>'    status_ok = '<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAndJREFUOE+lk11Ik1EYx39nH6GLaYpWIkyQgiCvnFiZEIKJ0U0JC7sogiJCMQhnFBUIEphmEPZ1E4TSTYIFsSIQiyBM16Jmhllqmw41TWcttb3b3jjvNrekuw6ci/f5+D0f5/8K/vOItfn7r2JVQjRHVMpVQAbodGDQ0SME5xx2XMk5fwEqW7mZsT6t5siek2zPK0BRAviXp5nxe3GPv8P5ZQhFCXc9tnMoDlkFVLbwIDczx3bjeCduXwfvPR2EIiAE6AWkGPMJLJt57h5k6XfklsNOrYRoANm2OcX05vqJTnqHa5kPTGtta85YCVUFeRf8mThH5lHCFMlxNHdFM71Hyw6Xbc72MzzzVKsoK0un3IPsJBiCM6Uqrb2C0QmYnOWFo4GyOEBtrD6Le7aFlWA02aADnYCwCisK1JdKFLS/FkxMwkcPOOxaKOxtRj1vO8Xg3B1OF0cD2/oERh0Ew2Avidrkue0SeD3gHoMnDTFAxRXUmn1VeIPd1FkTwZdfCS7sTnxf6xeYU2B8FN4nAypbUG0lu1DMfQSCUF+USIpXbnMKTEYw6uHzJ8GQR00aoYl+67aNxRZLEGHy80tCChOQNpcg1QjrDLA4Jxj9CmMT6sCzi+zQdlBYzcG8nXQXbkkn27II+ujWIzEdyKryhhUYGxGM+FS8Tqre3udhXEim8kvcS8vCtjVXR/amCOlZIPSxAcLgnxN8m4bRKZXFWbp6mjgGLCVL2VLRyF3TBspzMgRmU1SB8sin/LkEUwsqge9ash3wJuls9ZXyCw5QkmulzpBKsVSeFiQgtMyAz0X7h0e8jCf/CyBtJiAXSFvzp/4AfLLtZPsfEEzyES+XhMsAAAAASUVORK5CYII="/>'
    dummy = '<img src=""/>'

    shields = [shield_warning, shield_ok, shield_bad]
    status = [status_ok, status_warning, status_error]
    for i in range(10):
        row.append({
            "name": f"EC2{i:02d}",
            "ip": f"10.0.0.{i}",
            "cpu": f"{random.randint(10,100)}%",
            "status": random.choice(status),
            "alert compliance": random.choice(shields),
        })
    
    df = pd.DataFrame(row)    
    cols = [i for i in list(df.columns) if i != "_value_"]
    ___ = " ;;; "
    for idy, c in enumerate(cols):
        response.append({
            "target": f"row000{___}col{idy:03d}{___}{c}",
            "datapoints": [[1, to_ms]],
        })
    for idx,doc in enumerate(df.to_dict('records')):
        idxref = f"{idx+1:03d}"
        val = doc.get("_value_", 1)
        for idy, c in enumerate(cols):
            idyref = f"{idy:03d}"
            cval = doc.get(c, '')
            response.append({
                "target": f"row{idxref}{___}col{idyref}{___}{cval}",
                "datapoints": [[val, to_ms]],
            })
    return response