I'm trying to create a separate package in a monorepo to handle TypeORM functions. So if I have two APIs (User API, Admin API), both can refer to the same package to talk to the database. I have written a class which takes all the TypeORM entities, create a connection and export them. Please let ...

database relations can be found here http://www.tpc.org/tpc_documents_current_versions/pdf/tpc-h_v2.18.0.pdf SELECT l_orderkey, sum(l_extendedpriced * (1 - l_discount)) as revenue, o_orderdate, o_shippriority FROM customer, orders, lineitem WHERE c_mktsegment = 'BUILDING' -- '[SEGMENT]' an...

I'm building a simple Django app for reviews of different objects (restaurants, car services, car wash etc). I started with the app, but soon I faced first problem. Every object has features (but every type of object has different features). For example: Restaurants have garden, playground, se...

I'm reasonably new to D3, and I've put together a class based React component which outputs a genomic alignment visually. The result looks like this: The component is as follows: import React from 'react'; import PropTypes from 'prop-types'; import styled from 'styled-components'; import * a...

I have the following code which works perfectly fine. I am using the dial pad to set the number and also to send the DTMF tones. But I find the code to bit more repitive. Is there any better way to optimize the code or the approach I have is good enough ? Thank you in advance for your valuable su...

NOTES=[] hadm=[] for i in sorted(list(notes_df.SUBJECT_ID.unique())): #print(i) NOTES.append(list(notes_df[notes_df.SUBJECT_ID == i].TEXT)) hadm.append(list(notes_df[notes_df.SUBJECT_ID == i].HADM_ID.astype(float))) notes_1_df = pd.DataFrame(list(zip(sorted(list(notes_df.SUBJECT_ID.un...

I have a Singleton manager class for managing request model and it's attributes. My main aim is update object observers when some of the object attributes changes class FlightSearchManager { private val _flightSearchRequestModelLiveData : MutableLiveData<FlightSearchRequestModel> = Mutable...

Hello I've a code for crawling and scrapping o digit in google results. But it's super slow when i run it. What it dot: read a pandas column, search values in google and take the first result link to grape a siret. Could it be less greedy in complexity or be better? # Function pour recupere la ...

I have different set of objects where I have to show Name UI and Menu UI using onmousedown and on mouseenter. Remember Both are optional, the one object may contain both option or maybe one. Currently I have manage to write two seperate scripts like this /// <summary> /// It will shown ...

I have a list of objects, declared in the following way foos = [Foo(bar) for bar in bars] I declare a few parameters, a and b, and call the following function def func(x, y): z = [] for foo in foos: z += foo.dofoo(x, y, a, b) return z This function behaves as intended, h...

I am working on a blog application with Codeigniter 3.1.8 and AngularJS v1.7.8. The Dashboard of the application is "pure" Codeigniter, with Models, Controllers, and views, while the fronted is made up of JSONs managed and displayed by AngularJS. I operated this clear separation between back-en...

I have working code for this project, but I am now in need of some help to create a dynamic ordered list within Outlook from Excel. I am trying to format comments that a user will enter into a UserForm in Excel and pass those comments into an ordered list via a collection; the issue I run into i...

I am developing a web application in JavaScript that allows for filtering a list. For better UX we do not prevent changing the selected filter option while the list is being refreshed. Problem is that if the filter is changed rapidly multiple times the resulting list may not match the last create...

I implemented the singly linked list in c and i stuck in the display function it does not work.But i think someone can review my code:: #include <stdio.h> #include<stdlib.h> typedef struct q_9 { int data; struct q_9 *link; }*node; node head=NULL; node newnode(int x); void node_add(int...

I have gotten a class project to make a program that solves a game of sudoku. The first thing I was to do was to make something that takes input and prints out the board. import math #To be used later def board_filler(): """Creates the sudoku board from user input""" board = [[], [], [...

I am currently implementing a mobile app which has a map and a sliding drawer at the bottom similar to google maps (see image below). However, I would like the size of the map to change dynamically with respect to the size of the drawer. My current approach is to update the state of the main com...

I'm a beginner in Java, and I am confused about MVC. I understand the theory, but how should actionListeners should be implemented? The classes in question are GameLogic and UserInterface Also, I'm new to Swing. Is my use of classes standard practice? Thanks for the help. FruitMachine Class ...

I have a file that contains a multitude of methods that are solutions to some common interview questions. None of these methods are related in any way, shape or form. I have been debating on the two possible ways of asking for review: Posting the entire contents of the file and asking for revie...

For my programming class, we are making a sudoku solver. The first step was to make it print out a board from input. import math #To be used later def board_filler(): """Creates the sudoku board from user input""" board = [[], [], [], [], [], [], [], [], [], [], []] for x in enumer...

I'm working on the most efficient way to calculate the average of n numbers. I came out with this: #include <iostream> using namespace std; int main() { double media = 0, n = 0; int16_t c = 0; do { cin >> n; }while(n && (media += n, ++c)); cout << "Media: " <<...

I try to get my head around the unittest.mock module. Please tell me if this is the right way to test for the right response for the following method : class APIManager: def __init__( self, api_token='token', api_url_base='api_url', headers=No...

I implemented this console application that generates Fibonacci and Lucas sequence numbers using boost and GMP for multiprecision. There is an iterator-like class which can do any sequence based on the recursive rule F(n) = F(n-1) + F(n-2). Then there are two functions which can compute Fibonac...

I'm trying to improve my interview skills so I wrote one of the typical assignments - tic-tac-toe game. The main goals are: time limit: 30 minutes - 1h use only vanilla js I'll attach source but I created PR in dedicated repo as I think it'd easier to comment for reviewers. Repo: https://git...

The problem I have have at the moment is properly displaying images in a tableView cell. My images are saved to Firebase, and I can easily retrieve both images. When I try to display each image in its own table view cell they quickly load both images and the end result is the last image display...

I'm still somewhat new to React and so I'm still getting a handle on the patterns used. I'm trying to do something that feels like it may be a bad idea, but I can't think of a better way. Essentially, I have several React components that I want to be responsive in that they change layout or som...

I have made my first little project using C#/WPF - a simple rock, paper, scissors game. I am happy with the functionality and look but I would love to know how a more experienced programmer would refactor the code I have to bring the size down and make it more readable. Many thanks. MainWindow.x...

I have multiple onEdit app script functions in my Google Spreadsheet which work individually but I cannot work out where to put the brackets to nest them. This is my code which is a little messy and probably needs a tidy up. // Cut Employees Left from Unit Standards sheet and paste in Unit S...