Advertisements I’m have a problem with method insert from SQLAlchemy. When i want to insert data in my ORM model tabel i get next problem: ORM models tabel with one to many relationship: class OzonProductPrice(Base): __tablename__ = "ozon_product_price" id: Mapped[int] = mapped_column(primary_key=True, autoincrement=True) articul: Mapped[str] = mapped_column(String(120)) brand: Mapped[str] = mapped_column(String(50)) product_price: Mapped[float] product_price_plus_invest: Mapped[float]… Read More Python and SQLAlchemy insert data from API (one to many relationship and more 1000 rows)

Advertisements I want to calculate the difference between open and close price but taking to account if a trade is a Buy/Sell. I have the conditional function below; but l do not know how to insert a new column with the results into the original dataframe which has a list of trades and l am… Read More Insert a column with a conditional function into a dataframe

Advertisements I have a DataFramedf = pd.DataFrame(np.random.randint(-100, 100, 100).reshape(10, -1), columns=list(range(10)), index=list(‘abcdefghij’)) and I found some indexes using method .idxmin(axis=1) and getting Seriesdf_ind = a 5 b 8 c 2 d 0 e 7 f 0 g 4 h 6 i 5 j 2 How to get column of their values and than add (insert)… Read More Knowing a column of indexes how to get column of their values in Dataframe?

Advertisements If multiple different services send INSERT queries for the same table simultaneously to SQL Server, using their own connections, how many INSERTS can be committed by SQL Server in parallel? Or SQL Server can only process them sequentially? >Solution : You can have up to 32,767 user connections. The INSERT behavior depends on factors… Read More What is the maximum number of concurrent INSERT queries for Microsoft SQL Server?

Advertisements I’am trying to change the following code to get the following return : "1 2 3 … 31 32 33 34 35 36 37 … 63 64 65" def createFooter2(current_page, total_pages, boundaries, around) -> str: footer = [] page = 1 #Append lower boundaries while page <= boundaries: footer.append(page) page += 1 #Append current… Read More Inserting items in a list with python while looping

Advertisements I have the following problem: I have to create table with projects and employees. Employee can be assigned to few projects, but he cannot be assigned twice to the same projects. How can I prevent doing that? My tables: use projprac create table dbo.employees ( [idEmployee][int] PRIMARY KEY, [name][varchar](50) NOT NULL, [lastname][varchar](50) NOT NULL,… Read More How to prevent entering the same value second time in sql?

Advertisements I have a code, but I don’t really know python, so I have a problem. I know that the insert isn’t right for strings but I don’t know how can I insert? original_string = input("What’s yout sentence?") add_character = input("What char do you want to add?") slice = int(input("What’s the step?")) for i in… Read More How to insert every nth charts in string? PYTHON

Advertisements I’m trying to create a method that lets me insert a new node in my liked list at a chosen index, it is currently working as intended when inserting into index 0 or 1 but when I try to insert into any index >= 2 the first value in the list is being lost.… Read More C – linked list removing values on insertion

Advertisements For an assignment I have which includes a delete and add friend system (like Facebook), I’ve made a query that works by using two SQL tables, one which includes a friend_id, name and other information, and another which holds two friend_id columns, that show the relationship with the users and if they’re friends. User… Read More Reversing DELETE Query to an INSERT INTO query

Advertisements This was just a challenge I made up for myself and it’s really annoying. Would appreciate your help very much. I get the error saying on line 5 "’str’ object cannot be interpreted as an integer" for insert method but it checks and verifies at the top that the items in the list are… Read More python first argument of .insert cannot be 'str'