I have a table with created_at and deleted_at timestamps. I need to know, for each week, how many records existed at any point that week: week records 2022-01 4 2022-02 5 ... ... Essentially, records that were created before the…
I have an async function (getDataFromDB) which I run inside of an useEffect. The function gets data from firestore. The problem is I can't set state to data from firebase. I get the reference to data, I can see the…
I copied this code from the docs but I'm getting the above error import telebot import os BOT_TOKEN = "My_Bot_Token" bot=telebot.TeleBot(BOT_TOKEN) @bot.message_handler(commands=['start', 'hello']) def send_welcome(message): bot.send_message(message, "Howdy, how are you doing?") bot.infinity_polling() Could someone please tell me whats wrong?
I have two schemas in the same database. I want to update a table in one schema based on the table in another schema where the column value matches. The structure of my database is as follows. structure of database…
My existing SQL looks like the below, it will generate only the total_pending_req count. SELECT count(table1.employee_code) as total_requests, table1.employee_code as emp_code FROM table1 WHERE employee_status = 'PENDING' GROUP BY emp_code UNION ALL SELECT count(table2.employee_code) as total_requests, table2.employee_code as emp_code FROM…
I have an Order Model which contains an array of objects called item_details. When I create a new order, I want to iterate over item_details and create new instances of OrderDetail which include the Order id. OrderDetail is a join…
what i am trying to do is if the connection to the database fails, instead of getting No connection could be made because the target machine actively refused it, i want to throw a custom view that displays a simple…
this is myTable clientId, itemId, sellId primary is on clientId and there is also btree index no uniqe on sellId now i have part of very slow query LEFT OUTER JOIN myTable wl ON wl.itemId= ld.itemId and wl.clientId= @clientId question…
I am having below tables and want to populate the PAYID from the PAY table by looking in to CATEGORY_ID for below use case if PAYID is mapped with CATEGORY_ID then return the PAYID if PAYID is not mapped to…
I'm trying to insert data to two different table simultaneously. If failed , then roll back the data. And I try to google, and found some solutions: 1.Use data transactions. 2.Create a extra table then join two table. 3.Create a…