gistfile1.txt

filters=[]
    filters.append(getattr(Task, "task_type").__eq__("external"))
    filters.append(getattr(Task, "status").__eq__("executing"))
    tasks = db.session.query(Task).filter(*filters)
    for task in tasks:
        print task.label
        print(type(task))
        print(type(task.input_data))
        print(task.input_data)





<class 'sqlalchemy.orm.query.Query'>
approve_election
<class 'frestq2.models.Task'>
<type 'unicode'>
* URL: https://example.com/election/url
* Title: Test election
* Description: election description
* Voting period: 2013-12-06T18:17:14.457000 - 2013-12-09T18:17:14.457000
* Question data: [
    {
        "max": 1, 
        "tally_type": "ONE_CHOICE", 
        "question": "Who Should be President?", 
        "answers": [
            {
                "a": "ballot/answer", 
                "details": "", 
                "value": "Alice"
            }, 
            {
                "a": "ballot/answer", 
                "details": "", 
                "value": "Bob"
            }
        ], 
        "min": 0
    }
]
* Authorities: [
    {
        "ssl_cert": "-----BEGIN CERTIFICATE-----\nMIIGLzCCBBegAwIBAgIJAPI3yoCFOWzJMA0GCSqGSIb3DQEBBQUAMIGtMQswCQYD\nVQQGEwJFUzEPMA0GA1UECAwGTWFkcmlkMQ8wDQYDVQQHDAZNYWRyaWQxFDASBgNV\nBAoMC0Fnb3Jhdm90aW5nMR0wGwYDVQQLDBRDb25ncmVzb1RyYW5zcGFyZW50ZTEZ\nMBcGA1UEAwwQYWdvcmF2b3RpbmctZW92bTEsMCoGCSqGSIb3DQEJARYdaW5mb0Bj\nb25ncmVzb3RyYW5zcGFyZW50ZS5jb20wHhcNMTQwMzA2MTgxNjM3WhcNMTUwMzA2\nMTgxNjM3WjCBrTELMAkGA1UEBhMCRVMxDzANBgNVBAgMBk1hZHJpZDEPMA0GA1UE\nBwwGTWFkcmlkMRQwEgYDVQQKDAtBZ29yYXZvdGluZzEdMBsGA1UECwwUQ29uZ3Jl\nc29UcmFuc3BhcmVudGUxGTAXBgNVBAMMEGFnb3Jhdm90aW5nLWVvdm0xLDAqBgkq\nhkiG9w0BCQEWHWluZm9AY29uZ3Jlc290cmFuc3BhcmVudGUuY29tMIICIjANBgkq\nhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAxd1z6RJn2JbZlRpSe4niPb1YdUP8tR9L\nGfoU1hCZnAlUMqQaw8NklKtg7xF/mBXtj1FKdxE3xKJkmS1L6lZpqDOb9LNCkn7Z\n2qaDx5OcEaBXwVqorCrRcItXreiifW4QlUlCqL8VXsJuhr8aC9ITvIqU70dFQ3Hz\nJIMCGyMrvjuC24AdZkH2ur6FYHUC/Ck4Hk8yhUNaE8ffw7hcu2kY0qnwuKDLuo4P\nkaaAQKe5+RP+/Mn7m3wkQLs1Ia1b0MYAycofkNJy67BJSPVFHLNLE/kq7QK2Xunz\nEnNb5RDH41Dxi4lr6gn5MHJA7GJWoiKJoNbhphDuI8PbvqfjQmC1gI8dQR/yZUyv\nwrF7wG2qvEXtn6H+IR6jENu28Vnx4MygkXlimjLnqEkxVaXVIfqqx0UTKbSxTfjg\nvcrpTkkgymhjb9XMIfCOcfBACi+nZ7vl29mf8rS3nZZ46ONfDpTHZber4RZhPeu+\nxTd/jSLpLsvGW/KPOzE9l8U2u17I35cOkQ1AVE1LF62+VkpcX9V83weuUMAZlytU\nhJlx533Eh/ZfCjRuMTwLzwD4OVNuGxJs0ygCi7YnzYq1kpIvW7cTGYGMS9V81IR3\n5g01ME7Ir5RKYPCVOu0deBmP6b6zYoPKqLeMWLZjBriSj2mqFMnPq580kA70wZMG\n8cihu29rypsCAwEAAaNQME4wHQYDVR0OBBYEFLqYlI6KVvbsKcqlGyxWMQRNSDme\nMB8GA1UdIwQYMBaAFLqYlI6KVvbsKcqlGyxWMQRNSDmeMAwGA1UdEwQFMAMBAf8w\nDQYJKoZIhvcNAQEFBQADggIBACTGJ1069L9l7rC7RHFGsGQrMOUfmXerz3l+LiHO\nW7nor9py7UnpJRQDVbq2lB3JoKYgjXIGb+eZSLD36Qy1jD0S9tS62n68TsZUE+5g\nGLjKJC8xOiE6u+bIqp3lqUcluT1BgNCLNdOsF1hWF9AbgF/2j434Oh/aDn39+Ae0\nJQPdvLcpg+M6s0d4oELi0aQy5Qhmc3rSyq8eMwBQ6IQoiqlhRx6G9aY/a8hjmHcz\nZi0imeuMLuH1eeoGTqeVD44/KA36XuipAI+06ktVJdv30bvcEFPyV8jXZpEeFxse\noseZeX8Knlq5G6LIM5i71nTl9oj5YD1KOy+arR94J21uHAB0UMyG9tUtIQbDjZ+d\nCtK/L7ZdYYFBsPUFZ5eCGHaFsDp/k3j6l+FOhGl0ekoIYVB0Vy8PoZtaL6BdtyWA\nrGvUpRg5f3tDdF/dAIIaghu1NY3ZYVvPAWSptSPTo//X2SKHm1XkQnLOwC2LvD+X\n6D/LEre86Pqhb5+jMEN6WgeL3I2Na12bMV/g8pK+2uGwn4c4WQ9L0VMBuKEoGYt7\nr9PlQfvJycSP+JJE/cvW3BGE8Ou8uy4O5MzoddixG6G8vqRiTfWJ9bGt6SzvSzHV\nskzxQh4dKIs0fONSyncCMRd54FAIO1+U1LoOPM+dpBokoIYxXFATQiRKUj1CKtBc\n+TiX\n-----END CERTIFICATE-----\n", 
        "election_id": "139420854335", 
        "id": 11, 
        "orchestra_url": "https://agoravoting-eovm:5000/api/queues", 
        "name": "Auth1"
    }, 
    {
        "ssl_cert": "-----BEGIN CERTIFICATE-----\nMIIGMzCCBBugAwIBAgIJAPL6RG8wAY3gMA0GCSqGSIb3DQEBBQUAMIGvMQswCQYD\nVQQGEwJFUzEPMA0GA1UECAwGTWFkcmlkMQ8wDQYDVQQHDAZNYWRyaWQxFDASBgNV\nBAoMC0Fnb3Jhdm90aW5nMR0wGwYDVQQLDBRDb25ncmVzb1RyYW5zcGFyZW50ZTEb\nMBkGA1UEAwwSYWdvcmF2b3RpbmctZW92bS0yMSwwKgYJKoZIhvcNAQkBFh1pbmZv\nQGNvbmdyZXNvdHJhbnNwYXJlbnRlLmNvbTAeFw0xNDAzMDUyMTE2MjFaFw0xNTAz\nMDUyMTE2MjFaMIGvMQswCQYDVQQGEwJFUzEPMA0GA1UECAwGTWFkcmlkMQ8wDQYD\nVQQHDAZNYWRyaWQxFDASBgNVBAoMC0Fnb3Jhdm90aW5nMR0wGwYDVQQLDBRDb25n\ncmVzb1RyYW5zcGFyZW50ZTEbMBkGA1UEAwwSYWdvcmF2b3RpbmctZW92bS0yMSww\nKgYJKoZIhvcNAQkBFh1pbmZvQGNvbmdyZXNvdHJhbnNwYXJlbnRlLmNvbTCCAiIw\nDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBAMRhof50RjW32vKQC7F9TSPdwtat\nCnScEzwRslXaIKkGIhy0+sgrPfS6FuZBXDRpH+66XVGE/pWWtyXk2lRGS7r9pVaN\n8MJxYsUDEWKzqZzXmp7umRq1P6h1ctCynmMgoZ6ZKxLg89yEfMSIxNow2noldvPJ\n7z1ue5a+ItmLkKWhvZYEuJ3Dj9KYxLOc0UCh6QWw0VhuAaftB+rmeM0dDdoWqGGi\nwU61Xm5yCUsn75YzJ4KG/1dkTKEoKfDuAOYY3mEkHgOgt/Qbzerl8oYxW4/uau+V\nq4pLkPqAwWVmE4D7oIz8G8TjJl2GsCN9/oUWTNGnEeLKZvHD5wLkyk1jCAk3Hz2m\nhZLxKE0r4oJ8klsaw2HslWK4xdPD0GGt0/92kI11KR8IaiFK/gfWOcwUfUpwQjIj\n6tzphEyqnnaJsw9YNOWqo5MVma2HJa9yPjtnvP11Ro/+0ygbeQVVk7oBXPrKGs9x\nB/Wokng187zbdxgc4JWEqGnmqcxe389c/esQ8Jeq9nBMU+otGmKNjD1i+487iniH\nRdkQroamcyM7pfMLiQ86vzgheQtI1edfZUhaQHvD7Cdo2B1lba4UyevU9bkHcRGK\nUlfDqOCivUZZZ074HW1t4hnqXedoaU9ZFd+E+aQTtB90zu1z1dJyLstPS8+JYVrZ\n5CF8rSb9iW/yR//fAgMBAAGjUDBOMB0GA1UdDgQWBBQ9xJM6IqpZKf4FtU0vWcQ9\nbKJVpDAfBgNVHSMEGDAWgBQ9xJM6IqpZKf4FtU0vWcQ9bKJVpDAMBgNVHRMEBTAD\nAQH/MA0GCSqGSIb3DQEBBQUAA4ICAQA3MHP4u0Zyyx9EBAUICd/W7IymP2bJKBXL\nDT0f8B4Ok6SCLLafmu8j/3jWAintsYT7vauMnloLOzT2JAZTrVEzDsOIVZt17E7j\nHehEh47h/a2jRpRK6DHheN1rA8HgoO2+MFHIOkt0LR/DZEZlLcK0ct+gMZn953uE\nDoRei1rktROaqq+frXuob812GnioD2P8LzjEF30HELvUF2nbx6/DxAz+te54VHNb\nDU6nccALIFxDTuDNnNCSQr5u5v/zjx3P/3ZEH1ujrk3CheuiJkzoHMxNrdIb6YR1\nXxNxXywxyI81y5PoglWR8ydLccuKE3m/uXJrOc439gJdAcav0eob7caugyKrE0dW\n6GKM65tDT1J/aMIbniYFj0xTrzAQaZOO/nBNqdujvbtKyR/8dw1FKnx09qKhSjU8\nfW/ftsuEVOb0b9UcCMwrFHHBHEP6wGTWpEXOcAa3KFVlU9hAtqNgIjRl3VyEr9r/\nrb25a/HuipIND55kPSmsspAeiLE9WfviR0W6I+esK/6oFwZwhy2sLpcOUH9C2JeN\n9TScchVghGURRq5qASQUyJdWudVoR90CFr8ncTyyA3IkzgR08BHDVBN6BjlPzLS1\nYmo7RpyBsrEUcAkm/zJnXJ4Ly68PCKtv44fCakNICzXMWrrsFxB1CYqzzjdtgZ7C\npqmqSjOgYQ==\n-----END CERTIFICATE-----\n", 
        "election_id": "139420854335", 
        "id": 12, 
        "orchestra_url": "https://agoravoting-eovm-2:5000/api/queues", 
        "name": "Auth2"
    }
]