Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kNZ27-00024J-9T for pgadmin-hackers@arkaria.postgresql.org; Wed, 30 Sep 2020 10:08:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kNZ26-0005pw-3j for pgadmin-hackers@arkaria.postgresql.org; Wed, 30 Sep 2020 10:08:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kNZ25-0005po-Uf for pgadmin-hackers@lists.postgresql.org; Wed, 30 Sep 2020 10:08:21 +0000 Received: from mail-lf1-x12f.google.com ([2a00:1450:4864:20::12f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kNZ23-0000qQ-K0 for pgadmin-hackers@postgresql.org; Wed, 30 Sep 2020 10:08:20 +0000 Received: by mail-lf1-x12f.google.com with SMTP id y11so1425241lfl.5 for ; Wed, 30 Sep 2020 03:08:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=Wa7CxSQLrSjBGdSj0E3hqQTxOxFwchwjcoUnipvkGdM=; b=T8ymNT9EUnxF2W7SZxwpitf0h0S2leRchXg96As5RcVKJaelaqrWZl0jejUGRT27/9 EgkBaOV8XY/riJLPK7zoXlfl+24eTLS0if17ulp8d+qnajpRvHqHE86C+vNMRmA6T+WF nPbBVBmo0bm3RTGpWaw8R72hJqZpfmGpMgTo0DlBKPo5aJ6oXddL3ertjeZ0OwZbLZc+ 0g0ln6doz89SbnZqZBJcrlSbi+JByNud8DETm6gYs4SOqD1P+ioBaUF3NaDzmEgibhnx hZqTLhsk+hjv0Z84shhQn/JTPKfHwlTcQRsP1eP+10fY82TdGUnaKkqHm4RXGOk7qNlx F5ew== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=Wa7CxSQLrSjBGdSj0E3hqQTxOxFwchwjcoUnipvkGdM=; b=ee4xorp1Rg5yRc4v+5OZ+AuH3/PgmW9Q7E4M6oRKM9D30cXTnknTr/veFWNdhHNcKh sng/4UkQ72JrjROo761/sLckEwjRzQej60i2zhX/ufITBDiFOm7IMjhIF+VlYaZrJYp6 0LF9PL5JfbpxIbAtJSh9ad7+QryDXSFZ3MYcL8NfYw3iJu/7un14BlLWOJgmW8ssnkPz d9FmypScARbMqsjgAObLCyaPIbMl2pSrCcIA2Nh+AvDy3z86jN2d1GmjLwUzYVXVDI6l g5dWAPujJsWv3Vuwbm3tn9/CA7030AhL+0iQW9xqx623e5VDJc6Ol+nSuNwm3Ov2jFGB ijxA== X-Gm-Message-State: AOAM532sSYVKRJ6zeTP545UlBV29Wcz/OZXrKt2z8ZNgjdU+FffiTZyu o3Rn6cbrvvbBQJVRGdUwZvMs4boxy9hQFWsRKrX/nNSb+Acp7Bw5hGDUFNugLBMTUUWw7u9BB3s vtrdCuRG/9ZohnJ8shVDHzCu1sjl9hEpwNmu+oNNntAJdHa05LUXKmzL0/pYjGn8+psRkIdxX7z EjSNJxmw8Bxci/DYWoc71vEJTTfB2v6et7hsYPJHJxBr0anyipWZ1JQQFiXriP2/bXp6tv X-Google-Smtp-Source: ABdhPJxLuhHhullxT797Ao08QHgii52nDO9gC6oOkEagfYpZx9zyMr0yRhLph1xWlXn37z7gKwxdMdzDfee/Grb4oXk= X-Received: by 2002:ac2:5327:: with SMTP id f7mr572274lfh.8.1601460496991; Wed, 30 Sep 2020 03:08:16 -0700 (PDT) MIME-Version: 1.0 From: Khushboo Vashi Date: Wed, 30 Sep 2020 15:38:12 +0530 Message-ID: Subject: [pgAdmin4][Patch] - Fix for Sqlalchemy Operational error To: pgadmin-hackers Content-Type: multipart/mixed; boundary="0000000000000bd6d405b085144d" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000000bd6d405b085144d Content-Type: multipart/alternative; boundary="0000000000000bd6d205b085144b" --0000000000000bd6d205b085144b Content-Type: text/plain; charset="UTF-8" Hi, Sqlalchemy gives an operational error with the SQL query with boolean true/false for Python versions < 3.7. Please find the attached patch to fix it. Thanks, Khushboo --0000000000000bd6d205b085144b Content-Type: text/html; charset="UTF-8"
Hi,

Sqlalchemy gives an operational error with the SQL query with boolean true/false for Python versions < 3.7. Please find the attached patch to fix it.

Thanks,
Khushboo
--0000000000000bd6d205b085144b-- --0000000000000bd6d405b085144d Content-Type: application/octet-stream; name="sqlite_boolean_fix.patch" Content-Disposition: attachment; filename="sqlite_boolean_fix.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kfp8774g0 ZGlmZiAtLWdpdCBhL3dlYi9taWdyYXRpb25zL3ZlcnNpb25zLzM5ODY5N2RjOTU1MF8ucHkgYi93 ZWIvbWlncmF0aW9ucy92ZXJzaW9ucy8zOTg2OTdkYzk1NTBfLnB5CmluZGV4IGM5NjUxZjU0Ni4u OTNiMGViNzM1IDEwMDY0NAotLS0gYS93ZWIvbWlncmF0aW9ucy92ZXJzaW9ucy8zOTg2OTdkYzk1 NTBfLnB5CisrKyBiL3dlYi9taWdyYXRpb25zL3ZlcnNpb25zLzM5ODY5N2RjOTU1MF8ucHkKQEAg LTQwLDE0ICs0MCwxNCBAQCBkZWYgdXBncmFkZSgpOgogICAgICIiIikKIAogICAgIGRiLmVuZ2lu ZS5leGVjdXRlKCIiIgotICAgICAgICBJTlNFUlQgSU5UTyBtYWNyb3MgKGlkLCBhbHQsIGNvbnRy b2wsIGtleSwga2V5X2NvZGUpIFZBTFVFUyAoMSwgZmFsc2UsIHRydWUsICcxJywgNDkpLAotICAg ICAgICAoMiwgZmFsc2UsIHRydWUsICcyJywgNTApLCAoMywgZmFsc2UsIHRydWUsICczJywgNTEp LCAoNCwgZmFsc2UsIHRydWUsICc0JywgNTIpLAotICAgICAgICAoNSwgZmFsc2UsIHRydWUsICc1 JywgNTMpLCAoNiwgZmFsc2UsIHRydWUsICc2JywgNTQpLCAoNywgZmFsc2UsIHRydWUsICc3Jywg NTUpLAotICAgICAgICAoOCwgZmFsc2UsIHRydWUsICc4JywgNTYpLCAoOSwgZmFsc2UsIHRydWUs ICc5JywgNTcpLCAoMTAsIGZhbHNlLCB0cnVlLCAnMCcsIDQ4KSwKLSAgICAgICAgKDExLCB0cnVl LCBmYWxzZSwgJ0YxJywgMTEyKSwgKDEyLCB0cnVlLCBmYWxzZSwgJ0YyJywgMTEzKSwgKDEzLCB0 cnVlLCBmYWxzZSwgJ0YzJywgMTE0KSwKLSAgICAgICAgKDE0LCB0cnVlLCBmYWxzZSwgJ0Y0Jywg MTE1KSwgKDE1LCB0cnVlLCBmYWxzZSwgJ0Y1JywgMTE2KSwgKDE2LCB0cnVlLCBmYWxzZSwgJ0Y2 JywgMTE3KSwKLSAgICAgICAgKDE3LCB0cnVlLCBmYWxzZSwgJ0Y3JywgMTE4KSwgKDE4LCB0cnVl LCBmYWxzZSwgJ0Y4JywgMTE5KSwgKDE5LCB0cnVlLCBmYWxzZSwgJ0Y5JywgMTIwKSwKLSAgICAg ICAgKDIwLCB0cnVlLCBmYWxzZSwgJ0YxMCcsIDEyMSksICgyMSwgdHJ1ZSwgZmFsc2UsICdGMTEn LCAxMjIpLCAoMjIsIHRydWUsIGZhbHNlLCAnRjEyJywgMTIzKTsKKyAgICAgICAgSU5TRVJUIElO VE8gbWFjcm9zIChpZCwgYWx0LCBjb250cm9sLCBrZXksIGtleV9jb2RlKSBWQUxVRVMgKDEsIDAs IDEsICcxJywgNDkpLAorICAgICAgICAoMiwgMCwgMSwgJzInLCA1MCksICgzLCAwLCAxLCAnMycs IDUxKSwgKDQsIDAsIDEsICc0JywgNTIpLAorICAgICAgICAoNSwgMCwgMSwgJzUnLCA1MyksICg2 LCAwLCAxLCAnNicsIDU0KSwgKDcsIDAsIDEsICc3JywgNTUpLAorICAgICAgICAoOCwgMCwgMSwg JzgnLCA1NiksICg5LCAwLCAxLCAnOScsIDU3KSwgKDEwLCAwLCAxLCAnMCcsIDQ4KSwKKyAgICAg ICAgKDExLCAxLCAwLCAnRjEnLCAxMTIpLCAoMTIsIDEsIDAsICdGMicsIDExMyksICgxMywgMSwg MCwgJ0YzJywgMTE0KSwKKyAgICAgICAgKDE0LCAxLCAwLCAnRjQnLCAxMTUpLCAoMTUsIDEsIDAs ICdGNScsIDExNiksICgxNiwgMSwgMCwgJ0Y2JywgMTE3KSwKKyAgICAgICAgKDE3LCAxLCAwLCAn RjcnLCAxMTgpLCAoMTgsIDEsIDAsICdGOCcsIDExOSksICgxOSwgMSwgMCwgJ0Y5JywgMTIwKSwK KyAgICAgICAgKDIwLCAxLCAwLCAnRjEwJywgMTIxKSwgKDIxLCAxLCAwLCAnRjExJywgMTIyKSwg KDIyLCAxLCAwLCAnRjEyJywgMTIzKTsKICAgICAiIiIpCiAKIApkaWZmIC0tZ2l0IGEvd2ViL3Bn YWRtaW4vdG9vbHMvc3FsZWRpdG9yL3V0aWxzL21hY3Jvcy5weSBiL3dlYi9wZ2FkbWluL3Rvb2xz L3NxbGVkaXRvci91dGlscy9tYWNyb3MucHkKaW5kZXggNTk3ZDVmOTk2Li4xMGFkOTU4MTEgMTAw NjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL3Rvb2xzL3NxbGVkaXRvci91dGlscy9tYWNyb3MucHkKKysr IGIvd2ViL3BnYWRtaW4vdG9vbHMvc3FsZWRpdG9yL3V0aWxzL21hY3Jvcy5weQpAQCAtMTYyLDEz ICsxNjIsMTMgQEAgZGVmIHVwZGF0ZV9tYWNybyhkYXRhLCBtYWNybyk6CiAgICAgOnBhcmFtIG1h Y3JvOiBtYWNybwogICAgICIiIgogCi0gICAgbmFtZSA9IGdldGF0dHIoZGF0YSwgJ25hbWUnLCBO b25lKQotICAgIHNxbCA9IGdldGF0dHIoZGF0YSwgJ3NxbCcsIE5vbmUpCisgICAgbmFtZSA9IGRh dGEuZ2V0KCduYW1lJywgTm9uZSkKKyAgICBzcWwgPSBkYXRhLmdldCgnc3FsJywgTm9uZSkKIAot ICAgIGlmIG5hbWUgb3Igc3FsIGFuZCBtYWNyby5zcWwgYW5kIG5hbWUgaXMgTm9uZToKKyAgICBp ZiBuYW1lIG9yIHNxbCBhbmQgbWFjcm8uc3FsIGFuZCAnbmFtZScgaW4gZGF0YSBhbmQgbmFtZSBp cyBOb25lOgogICAgICAgICByZXR1cm4gRmFsc2UsIGdldHRleHQoCiAgICAgICAgICAgICAiQ291 bGQgbm90IGZpbmQgdGhlIHJlcXVpcmVkIHBhcmFtZXRlciAobmFtZSkuIikKLSAgICBlbGlmIG5h bWUgb3Igc3FsIGFuZCBtYWNyby5uYW1lIGFuZCBzcWwgaXMgTm9uZToKKyAgICBlbGlmIG5hbWUg b3Igc3FsIGFuZCBtYWNyby5uYW1lIGFuZCAnc3FsJyBpbiBkYXRhIGFuZCBzcWwgaXMgTm9uZToK ICAgICAgICAgcmV0dXJuIEZhbHNlLCBnZXR0ZXh0KAogICAgICAgICAgICAgIkNvdWxkIG5vdCBm aW5kIHRoZSByZXF1aXJlZCBwYXJhbWV0ZXIgKHNxbCkuIikKIAo= --0000000000000bd6d405b085144d--