I have problems when my output only update column file1. I want to check if column file1 has value then update file2, and the otherwise if file2 has value update columns file1. I hope you can guide me what's wrong with my code:
function update_files($data, $id){
$this->db->where('id',$id)...
This is from LeetCode:
Missing Number
Given an array containing n distinct numbers taken from 0, 1, 2, ...,
n, find the one that is missing from the array.
Example 1:
Input: [3,0,1]
Output: 2
Example 2:
Input: [9,6,4,2,3,5,7,0,1]
Output: 8
Note: Your algo...
The codes below get the rows of data until it reaches the total running quantity limit.
Notice that the SQL uses sub-query. select *, sum(Quantity) over (order by id) as RunningQty from #PurchaseOrderProducts. I'm worried that the sub-query would get all the data from the table. Is there a way t...
So I've been trying to simulate the trajectory of a frisbee in flight thrown with different angles of attack/initial velocities. The differential equations used for the code are:
$$\frac{dv_y}{dt} = k_L v_y^2 - g$$
$$\frac{dv_x}{dt} = -k_D v_x^2$$
where
$$k_L \text{ is the transformed coeffici...
I wrote a stack class in C++ using arrays of fixed width. Could anyone review my code ? I didn't comment on any of the functions, because I thought class itself is self explanatory. Is it a wrong approach or which kind of comments can I write?
#include <stdlib.h>
#include <iostream>
template <...
I have a code that calls many times a function returning a list of the dates between two dates formatted as
('0001-01-01 00:01:00'),('0001-01-02 00:01:00'), ...
The current solution is:
import numpy as np
import time
from datetime import datetime
beg = datetime.strptime('01 01 0001', '%...
The question is: Write a program that prompts the user to input ten values between 80 and 85 and stores them in an array. Your program must be able to count the frequency of each value appears in the array.
So, is there have any more efficient ways to present the count for frequency number betwe...
I'm new in oop programming pattern. I created this simple User Class and i'm wondering if it :
Is following oop rules and logic ?
Is maintaibable ?
Is can be tested without any problems ?
Can be expanded to a large user class (permissions,etc) ?
Is secure ?
this is my class
<?php
class Use...
I have created this bank ATM app mockup which I believe implement some Domain-Design Design layered architecture, repository pattern and uow pattern, if not fully. In my solution, I have these projects (layer):
ATM.Model (Domain model entity layer)
ATM.Persistence (Persistence Layer)
ATM.Applic...I have ifs with similar logic for querying the database. Is it possible to reduce the ifs into ternary expressions?
protected override List<SimpleExpressionBase> GetAdditionalFilterExpressionsForGET(
EntityQueryParametersForGet queryParameters)
{
var expre...
So I've just written a framework that is supposed to make it easier to create a network-based application (client-server) using the native java.net package. I was wondering if the structure of my code is well understandable and if there are ways to improve my code (in both, readability and perfor...
I have this function that takes a string which represents a html-color and returns the OLE value for it. If the string is null or empty or it can't be parsed, it uses a default value.
However I have to write that one line containing the default value twice and I don't see how I could remove this ...
I would like to make this code more efficient, I have isolated the problem as being these two for loops:
for i, device in enumerate(list_devices):
for data_type_attr_name in data_types:
result_list_element = {
"device_reference": device.name,
...
I recently solved the Knight Dialer and the ugly numbers problems, but I'm not quite sure if I got the time complexity right; hence I'm requesting the following:
1) Time and space complexity review on both method and explanation on why so.
Knight dialer: (movs map has all the possible movements...
Building upon a recent question I answered here
Simple middleware pipeline builder (similar to asp.net-core)
I came across a cross site question
Stackoverflow: Adding middleware in Carter framework makes some URL to not trigger
which looked like it could benefit from what I had learned from ...
I have implemented Token and FieldToken classes as part of my project and would like to here some suggestions for improvement.
First, Token class represents logical operators, relational operators, parentheses, etc. It does not hold a value, only type of the token (e.g. AND, OR, etc.). Here is i...
I recently reviewed a question here on Code Review. The problem statement is
Write a program that prompts the user to input ten values between 80 and 85 and stores them in an array. Your program must be able to count the frequency of each value appears in the array.
I coded my own solution ...
I wrote a backtracking Sudoku solving algorithm in Python.
It solves a 2D array like this (zero means "empty field"):
[
[7, 0, 0, 0, 0, 9, 0, 0, 3],
[0, 9, 0, 1, 0, 0, 8, 0, 0],
[0, 1, 0, 0, 0, 7, 0, 0, 0],
[0, 3, 0, 4, 0, 0, 0, 8, 0],
[6, 0, 0, 0, 8, 0, 0, 0, 1],
[0, 7, 0, 0, 0, 2, ...
This code adds the following functionality to the basic tkinter.Tk() class...
settings-file interaction for persistent application settings
fullscreen functionality using F11, can remember last configuration or be defaulted
removes the need for multiple root.configure() statements
removes the n...
The exercise description:
Given a ‘words.txt’ file (attached) containing a newline-delimited
list of dictionary words, please implement a small command line
application capable to return all the anagrams from ‘words.txt’ for a
given word. You can use any Scala library of your choice, no...
I was wondering if I should bother with @Embedded or just use a String to represent a typical String value.
Here's my code for a Localized lookup key
@AllArgsConstructor
@Data
@Embeddable
@NoArgsConstructor
public class Localized implements Serializable {
public static final String KEY_COL...
In recent months I have been trying to figure out how in the world one can mimic the functionality of Excel's New Dynamic Arrays exclusively in VBA. There are tricky ways to do this using the window's API, (see this link), and I have also found that one can utilize ADO with Querytables (see this ...
I have a script in a Work Order Management System (Maximo) that performs a spatial query.
Details:
Takes the X&Y coordinates of a work order in Maximo
Generates a URL from the coordinates (including other spatial query information)
Executes the URL via a separate script/library (LIB_HTTPCLIENT...
Here's a Quicksort I had fun writing and improving, so I thought I'd post it here. In my (brief) testing it's about 15% to 20% faster than Java's Arrays.sort().
The sort routine is a fairly vanilla Quicksort. The main improvements are to the pivot selection, and the Quicksort switches to an In...
