Tag: pg

error node: error: bind message supplies 16 parameters, but prepared statement "" requires 15

Why I get this error: error: bind message supplies 16 parameters, but prepared statement "" requires 15 code: const r1 = await client.query(` INSERT INTO booking (client_id, car_id, business_id, pick_up_station_id, return_station_id, type, text, from_date, to_date, booking_range, km_free, km_extra, km_overdrawn, excess_back) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, tsrange($10, $11, ‘()’), $12, $13,… Read More error node: error: bind message supplies 16 parameters, but prepared statement "" requires 15

MRLeave a comment

Put text on top div that is inside another div

I want to put the text over the div that is containing an image and that div is inside another div that also has an image. .marioHeader { background-image: url(“resources/marioBackground.jpg”); background-size: 600px; height: 500px; background-position: bottom; display: flex; justify-content: center; align-items: center; background-repeat: repeat-x; background-color: #6096ff; margin-top: 50px; text-align: center; } .title { text-align: center;… Read More Put text on top div that is inside another div

MRLeave a comment

continue loop even if one host is not available

import time import paramiko import sys from getpass import getpass #First Unifi AP IP Address firstip=3 fistdigits = ‘10.0.0.’ #how can we prevent from crashing if 10.0.0.19 is not an available device while firstip<=100: host= f'{fistdigits}{firstip}’ #first one will be 10.0.0.3 then 10.0.0.4 etc username="username" password="password" session= paramiko.SSHClient() session.set_missing_host_key_policy(paramiko.AutoAddPolicy()) session.connect(hostname=host, username=username, password=password) #upgradeurl="https://dl.ui.com/unifi/firmware/U7PG2/4.3.13.11253/BZ.qca956x.v4.3.13.11253.200430.1420.bin&quot; #stdin, stdout,… Read More continue loop even if one host is not available

MRLeave a comment

Google Play Billing Library 5.0 deprecation warnings

Since I’ve upgraded the BillingClient to version 5.0.0: googleImplementation ‘com.android.billingclient:billing:5.0.0’ I get these unique deprecation warnings: warning: [deprecation] getSkus() in Purchase has been deprecated warning: [deprecation] getSkus() in PurchaseHistoryRecord has been deprecated warning: [deprecation] SkuType in BillingClient has been deprecated warning: [deprecation] SkuDetailsResponseListener in com.android.billingclient.api has been deprecated warning: [deprecation] SkuDetailsParams in com.android.billingclient.api has been… Read More Google Play Billing Library 5.0 deprecation warnings

MR1 Comment

Export Postgresql Table to excel with header in Python

My code works but it doesn’t bring the header with the names, it only brings the numbers 0 1 … 10 , what can I do ? Utils_db.py def consulta_sql(sql): try: connection = psycopg2.connect(user="postgres", password="postgres", host="localhost", port="5432", database="tb_cliente") cursor = connection.cursor() except (Exception, psycopg2.Error) as error: try: cursor.execute(sql) connection.commit() except (Exception, psycopg2.Error) as error: finally:… Read More Export Postgresql Table to excel with header in Python

MRLeave a comment