Im doing a Count method using SLQ query
but i want to transpose this into a LINQ code
here's my sql query code:
SELECT DEPT_NAME,JS_TITLE,
SUM(CASE WHEN MALE = 1 THEN 1 ELSE 0 END) AS Male,
SUM(CASE WHEN MALE = 0 THEN 1 ELSE 0 END) AS Female from DEPTS
left join EMP on EMP.DEPT_ID = DEPTS.DEPT_...
I am not a developer, but I needed to write a script.
So I wrote it, and published it: https://github.com/gabriel-de-luca/simil/blob/master/simil.py
I am open to review it completely, but I would particularly like to consult on the way I am checking the validity of the data.
The main funct...
This is a follow up to
Chunking strings to binary output
I found the reviews quite helpful in pinpointing what to fix with my code. Here's the result of that update. The format of the output is the same as documented there, but to briefly recap:
The stream format consists of blocks, each 256 ...
I came up with the following setup_cds function as a solution to my own SO question. My question is: how could I improve it (especially the joining of the names looks a bit clumsy to me)? (And is there really no other function in bokeh etc. doing this?)
import hvplot.pandas
from bokeh.models imp...
I'd like a review of my design for an Instagram-like application where users can post and comment on pictures.
I just finished a freecodecamp crash course on database design and this is the first ERD I make. If you also have suggestions for readings on this topic I'd appreciate it.
This is m...
So i am trying to add a usage on my shell script and i need some help
Original Script:
https://github.com/complexorganizations/wireguard-manager
Usage issues:
https://github.com/complexorganizations/wireguard-manager/issues/170
function usage-guide() {
echo "usage: ./"$(basename "$0")" [opti...
Given an array of integers, find two numbers such that they add up to a specific target number.
The function twoSum should return indices of the two numbers such that they add up to the target, where index1 < index2. Please note that your returned answers (both index1 and index2 ) are not zero-b...
I am writing an express endpoint that edits an entry in a database. It has one required field "url" with many optional fields. To accomplish this I stacked if statements like:
router.post('/', (req, res) => {
let { url } = req.body;
if (typeof (url) !== 'string') {
res.status(200).json({...
I am working on a personal project in which I must consume data from different Rest Api, but I am not sure if I am doing it in the most efficient and safe way,
public class consultarActivosFijos extends AppCompatActivity {
private EditText eCodigoIngresado = null;
private TextView tDesc...
I want a method that post from the route in my submitFiles() Javascript that will loop through and create a contact, account name, organization for each row , using the column names associated with each value. I need to know the correct @each PHP syntax for Laravel 5.7
Javascript
s...
I started writing a neural net from scratch about a month ago for fun and to learn better how they work. I think that it's close to being in working order but I'd like to have a second set of eyes look over my code and see if they can point out any errors or misconceptions in my code. I think tha...
The objective of the game is to guess the hue, saturation, and lightness values of a given color swatch across ten rounds.
https://github.com/shreyasminocha/guess-the-hsl
https://guess-the-hsl.now.sh
This being my first svelte project, I'd like some insight into best practices, especially sve...
I'm using this right now to count the number of discrete values in a given []string. Is there a faster way to do this?
func CountDiscrete(x []string) int {
discrete := 0
for i,xi := range x {
is_discrete := true
for j,xj := range x {
if i != j {
...
Trying to build out a login & registration system using PHP classes & object oriented programming,
Can anyone please comment/review and suggest any improvements that could be made.. I realise theres quiet alot to review or read through so I appreciate anyones time or input to this code.
Core/Ini...
This is a revision of a previous question that I asked, with new aspects that I have learnt in Javascript. It is I think better than the previous implementation as it is using switch statement's which will only run if certain conditions are ment, which means a performance gain I guess.. Can anyon...
Read a sequence of double values into a vector. Think of each value as the distance between two cities along a given route. Compute and print the total distance (the sum of all distances). Find and print the smallest and greatest distance between two neighboring cities. Find and print the m...
You'd flag the question; use other and explain why you think a moderator should look into the bounty. I recently flagged a bountied question with:
This is clearly off-topic, but I cannot VtC; can the bounty be removed and the question closed please?
and a moderator refunded the bounty and c...
I've been working on an incremental game that I will need to store extremely large scientific numbers. as a part of this game, precision is only important for numbers within similar magnitudes. If a number is 10^20 times larger than another one, then adding or subtracting these numbers has a "neg...
I'm wondering how I should be writing the docstyle for a class if all it needs is 3 attributes to define this class (with the rest of the attributes from the parent being default set):
class ExampleModel(BaseModel):
"""
Example Model.
Attributes:
- a (int): ...
- b (...
