terrible programmers: my god, it's full of chars

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > YOSPOS > terrible programmers: my god, it's full of chars

«‹›1446 »

gnatalie: Jul 1, 2003; blasting women into space

luigi thirty i did a "proper" mvvm version of your blackjack game without all the image stuff. have fun.

# ? Jul 29, 2014 23:42

Adbot: ADBOT LOVES YOU

# ? May 17, 2024 09:30

Fuck them: Jan 21, 2011; and their bullshit

BONGHITZ posted:

if only i could do things without having to learn how to do those things, that would be really nice

yes learn how to do asp.net forms when I could instead do anything else

lol

but yeah realpost that "I don't know this thing yet" feeling sucks

# ? Jul 29, 2014 23:46

Symbolic Butt: Mar 22, 2009; (_!_); Buglord

candy for breakfast posted:

luigi thirty i did a "proper" mvvm version of your blackjack game without all the image stuff. have fun.

holy poo poo I didn't know you could put a camel in commit messages like that

# ? Jul 30, 2014 01:00

duck.exe: Apr 14, 2012; Nap Ghost

how the gently caress does a* work? i've looked at a bunch of tutorials on it and it still doesn't make any sense :iiam:

# ? Jul 30, 2014 04:28

Bloody: Mar 3, 2013

do you understand djikstra's?
http://en.wikipedia.org/wiki/A*

# ? Jul 30, 2014 04:31

zeekner: Jul 14, 2007

if you just look at wikipedia it won't make much sense, you should check out one of the simpler game implementations. it's pretty easy to use a* to do path-finding on 2d grids, and that gives you a practical case for the heuristic and should be pretty easy to comprehend.

this looks like a decent breakdown: http://www.policyalmanac.org/games/aStarTutorial.htm

# ? Jul 30, 2014 04:37

fart simpson: Jul 2, 2005; DEATH TO AMERICA

DukeDuke posted:

how the gently caress does a* work? i've looked at a bunch of tutorials on it and it still doesn't make any sense

its less confusing once you actually write an implementation. just try to write it once and then you'll realize it's actually pretty simple

# ? Jul 30, 2014 04:38

Luigi Thirty: Apr 30, 2006; Emergency confection port.

candy for breakfast posted:

luigi thirty i did a "proper" mvvm version of your blackjack game without all the image stuff. have fun.

wow nice team foundation server error when i load it in visual studio...

_{also thanks this is v helpful}

# ? Jul 30, 2014 07:47

Malcolm XML: Aug 8, 2009; I always knew it would end like ｔｈｉｓ．

http://www.redblobgames.com/pathfinding/a-star/introduction.html

# ? Jul 30, 2014 09:38

Luigi Thirty: Apr 30, 2006; Emergency confection port.

well i have a wpf book recommendation so is c# in depth good too

# ? Jul 30, 2014 19:37

coffeetable: Feb 5, 2006; TELL ME AGAIN HOW GREAT BRITAIN WOULD BE IF IT WAS RULED BY THE MERCILESS JACKBOOT OF PRINCE CHARLES

YES I DO TALK TO PLANTS ACTUALLY

judging by your blackjack thingummy, you'd be better off with Essential C# 5.0. i think there's a lot of foundational material you're probably missing

coffeetable fucked around with this message at 19:49 on Jul 30, 2014

# ? Jul 30, 2014 19:46

Luigi Thirty: Apr 30, 2006; Emergency confection port.

let me tell you about my extensive experience in p-langs and how that knowledge applies to real world things outside of college

# ? Jul 30, 2014 20:09

FamDav: Mar 29, 2008

MeramJert posted:

its less confusing once you actually write an implementation. just try to write it once and then you'll realize it's actually pretty simple

the short version is that for depth first search when i visit a new node i put its unvisited neighbors on a stack and work off the stack. for breadth first search i put unvisited neighbors in a queue and work off that. for a* i put unvisited neighbors in a heap that is sorted by my guess* about that point being in the shortest path and work off that.

my guess is how far it is from start to this point plus how far i think it is from that point to the end

FamDav fucked around with this message at 20:48 on Jul 30, 2014

# ? Jul 30, 2014 20:20

FamDav: Mar 29, 2008

also admissable heuristic really just means your guess is never worse than reality,

# ? Jul 30, 2014 20:22

Shaggar: Apr 26, 2006

Luigi Thirty posted:

let me tell you about my extensive experience in p-langs and how that knowledge applies to real world things outside of college

people in college are literally children so no matter how many times you tell them how things will work when they become adults, they refuse to believe it

# ? Jul 30, 2014 20:40

Luigi Thirty: Apr 30, 2006; Emergency confection port.

Shaggar posted:

people in college are literally children so no matter how many times you tell them how things will work when they become adults, they refuse to believe it

i typed "shaggar was right" into google and the top result was a blogspot named Incarnating Abyssinian Hitlers through music

coffeetable posted:

judging by your blackjack thingummy, you'd be better off with Essential C# 5.0. i think there's a lot of foundational material you're probably missing

wow and it's only 27 dollars on amazon

# ? Jul 30, 2014 20:56

Bloody: Mar 3, 2013

i got http://pastebin.com/RE96mWFU

# ? Jul 30, 2014 20:56

coffeetable: Feb 5, 2006; TELL ME AGAIN HOW GREAT BRITAIN WOULD BE IF IT WAS RULED BY THE MERCILESS JACKBOOT OF PRINCE CHARLES

YES I DO TALK TO PLANTS ACTUALLY

Luigi Thirty posted:

i typed "shaggar was right" into google and the top result was a blogspot named Incarnating Abyssinian Hitlers through music

wow and it's only 27 dollars on amazon

http://libgen.org/

# ? Jul 30, 2014 20:58

Corla Plankun: May 8, 2007; improve the lives of everyone

Luigi Thirty posted:

let me tell you about my extensive experience in p-langs and how that knowledge applies to real world things outside of college

literally every job i have had since high school has been made better by automating the stupid office crap everyone has to do all the time

and plangs make that super easy

# ? Jul 30, 2014 21:35

Luigi Thirty: Apr 30, 2006; Emergency confection port.

i dont think thats legal timb

# ? Jul 30, 2014 22:22

CISADMIN PRIVILEGE: Aug 15, 2004; optimized multichannel
campaigns to drive
demand and increase
brand engagement
across web, mobile,
and social touchpoints,
bitch!

I'm trying to normalize a table where each row contains 3 delimited strings with hundreds on entries in each. I've got a split string function which works well and the following function works but feels like idiot SQL to me because I'm making 3 temp tables with an identity and joining them all for the return table. Is there a simple solution?

code:

CREATE FUNCTION [dbo].[ShittyCreateTempTable]
(
   @STR_InputAcct NVARCHAR(15)
)
RETURNS @FinalTable table
(
ACCTNO VARCHAR(10),
F_Period VARCHAR(10),
Pos Int,
CR_AMT VARCHAR(10),
DR_AMT VARCHAR(10)
)

AS BEGIN
Declare @STR_TestPer NVARCHAR(MAX);
Declare @STR_TestCR NVARCHAR(MAX);
Declare @STR_TestDR NVARCHAR(MAX);
Declare @STR_ACCTNO VARCHAR(10);

DECLARE @TempTable table
(
Pos Int NOT NULL IDENTITY(1,1),
F_Period VARCHAR(10)
)

DECLARE @TempTableCR table
(
Pos Int NOT NULL IDENTITY(1,1),
CR_AMT VARCHAR(10)
)
DECLARE @TempTableDR table
(
Pos Int NOT NULL IDENTITY(1,1),
DR_AMT VARCHAR(10)
)


SELECT 
@STR_TestPer = [FISCAL_PER],
@STR_TestCR = [CR_AMT],
@STR_TestDR = [DB_AMT], 
@STR_ACCTNO = [ACCTNO]
	
FROM [V_TEST].[dbo].[GL_CHART_1] WHERE ACCTNO = @STR_InputAcct

Insert into @TempTable (F_Period)
Select Item FROM dbo.SplitStrings(@STR_TestPer, '^') as F_Period
Insert into @TempTableCR (CR_AMT)
Select Item FROM dbo.SplitStrings(@STR_TestCR, '^') as CR_AMT
Insert into @TempTableDR (DR_AMT)
Select Item FROM dbo.SplitStrings(@STR_TestDR, '^') as DR_AMT

Insert into @FinalTable (ACCTNO,Pos,F_Period,CR_AMT,DR_AMT)
Select 
@STR_ACCTNO,
per.Pos, per.F_Period, cr.CR_AMT, dr.DR_AMT 
From @TempTable per INNER JOIN @TempTableCR cr
	ON per.Pos = cr.Pos JOIN @TempTableDR dr 
	ON dr.Pos = cr.Pos

RETURN

# ? Jul 31, 2014 00:44

MrMoo: Sep 14, 2000

It's idiot schema already, just do whatever to fix it.

Depends how frequently the data updates, one could leave the intermediate tables permanently in place and use triggers to update.

You could always stuff temporary tables behind a materialized view, unless its SQL Server and you probably have to fake it anyway.

# ? Jul 31, 2014 00:51

CISADMIN PRIVILEGE: Aug 15, 2004; optimized multichannel
campaigns to drive
demand and increase
brand engagement
across web, mobile,
and social touchpoints,
bitch!

it's more of I want to know the right way. it's for data conversion so it only needs a couple of runs anyway, so in this case efficiency doesn't matter. it just feels like I'm doing something ugly where there should be a tidier approach.

# ? Jul 31, 2014 01:46

Luigi Thirty: Apr 30, 2006; Emergency confection port.

ah databases something i do know abo-- :stare:

what the hell is that schema

# ? Jul 31, 2014 02:41

CISADMIN PRIVILEGE: Aug 15, 2004; optimized multichannel
campaigns to drive
demand and increase
brand engagement
across web, mobile,
and social touchpoints,
bitch!

Luigi Thirty posted:

ah databases something i do know abo-- what the hell is that schema

for some reason the author of this abomination decided just put GL accounts with one row each and concatenate the credits / debits in caret delimited strings.

# ? Jul 31, 2014 02:49

Luigi Thirty: Apr 30, 2006; Emergency confection port.

do... do they still work there

# ? Jul 31, 2014 03:19

Shaggar: Apr 26, 2006

CISADMIN PRIVILEGE posted:

code:

CREATE FUNCTION [dbo].[ShittyCreateTempTable]
(
   @STR_InputAcct NVARCHAR(15)
)
RETURNS @FinalTable table
(
ACCTNO VARCHAR(10),
F_Period VARCHAR(10),
Pos Int,
CR_AMT VARCHAR(10),
DR_AMT VARCHAR(10)
)

AS BEGIN
Declare @STR_TestPer NVARCHAR(MAX);
Declare @STR_TestCR NVARCHAR(MAX);
Declare @STR_TestDR NVARCHAR(MAX);
Declare @STR_ACCTNO VARCHAR(10);

DECLARE @TempTable table
(
Pos Int NOT NULL IDENTITY(1,1),
F_Period VARCHAR(10)
)

DECLARE @TempTableCR table
(
Pos Int NOT NULL IDENTITY(1,1),
CR_AMT VARCHAR(10)
)
DECLARE @TempTableDR table
(
Pos Int NOT NULL IDENTITY(1,1),
DR_AMT VARCHAR(10)
)


SELECT 
@STR_TestPer = [FISCAL_PER],
@STR_TestCR = [CR_AMT],
@STR_TestDR = [DB_AMT], 
@STR_ACCTNO = [ACCTNO]
	
FROM [V_TEST].[dbo].[GL_CHART_1] WHERE ACCTNO = @STR_InputAcct

Insert into @TempTable (F_Period)
Select Item FROM dbo.SplitStrings(@STR_TestPer, '^') as F_Period
Insert into @TempTableCR (CR_AMT)
Select Item FROM dbo.SplitStrings(@STR_TestCR, '^') as CR_AMT
Insert into @TempTableDR (DR_AMT)
Select Item FROM dbo.SplitStrings(@STR_TestDR, '^') as DR_AMT

Insert into @FinalTable (ACCTNO,Pos,F_Period,CR_AMT,DR_AMT)
Select 
@STR_ACCTNO,
per.Pos, per.F_Period, cr.CR_AMT, dr.DR_AMT 
From @TempTable per INNER JOIN @TempTableCR cr
	ON per.Pos = cr.Pos JOIN @TempTableDR dr 
	ON dr.Pos = cr.Pos

RETURN

I don't think you really need the temp tables but maybe im not totally getting the entire problem.

SQL code:

Insert into @FinalTable
(
	ACCTNO
	,Pos
	,F_Period
	,CR_AMT
	,DR_AMT
)
Select 
	@STR_ACCTNO
	,per.Pos
	,per.F_Period
	,cr.CR_AMT
	,dr.DR_AMT 
From 
	dbo.SplitStrings(@STR_TestPer, '^') per 
	INNER JOIN dbo.SplitStrings(@STR_TestCR, '^') cr
		ON per.Pos = cr.Pos
	INNER JOIN dbo.SplitStrings(@STR_TestDR, '^') dr 
		ON dr.Pos = cr.Pos

there isn't gonna be a great solution to that kind of hosed up data, but doing it with a table value function like that is probably the most "correct". lots of people would throw that poo poo into excel or write an external program to do it. as long as it works and you're only doing it once to normalize the data and all new data goes into the normalized table then it really doesn't matter that much.

# ? Jul 31, 2014 03:52

CISADMIN PRIVILEGE: Aug 15, 2004; optimized multichannel
campaigns to drive
demand and increase
brand engagement
across web, mobile,
and social touchpoints,
bitch!

Luigi Thirty posted:

do... do they still work there

"they" is the author of a member database system for organizations which at one time had thousands of customers including some you've heard of. the poo poo is a result of an sql conversion upgrade from some dumbass flat file mainframe thing.

dude sold his company to a huge company for a shitload of money, who then several years later gave it back to him.

I don't have access to the application code and the only person who does that i know personally is a mediocre programmer at best (not to mention the code is c++ so if the SQL is that much of an abomination i don't actually want to see it)

# ? Jul 31, 2014 04:06

CISADMIN PRIVILEGE: Aug 15, 2004; optimized multichannel
campaigns to drive
demand and increase
brand engagement
across web, mobile,
and social touchpoints,
bitch!

Shaggar posted:

I don't think you really need the temp tables but maybe im not totally getting the entire problem.
SQL code:
Insert into @FinalTable
(
	ACCTNO
	,Pos
	,F_Period
	,CR_AMT
	,DR_AMT
)
Select 
	@STR_ACCTNO
	,per.Pos
	,per.F_Period
	,cr.CR_AMT
	,dr.DR_AMT 
From 
	dbo.SplitStrings(@STR_TestPer, '^') per 
	INNER JOIN dbo.SplitStrings(@STR_TestCR, '^') cr
		ON per.Pos = cr.Pos
	INNER JOIN dbo.SplitStrings(@STR_TestDR, '^') dr 
		ON dr.Pos = cr.Pos
there isn't gonna be a great solution to that kind of hosed up data, but doing it with a table value function like that is probably the most "correct". lots of people would throw that poo poo into excel or write an external program to do it. as long as it works and you're only doing it once to normalize the data and all new data goes into the normalized table then it really doesn't matter that much.

thanks i'll try that tomorrow.

# ? Jul 31, 2014 04:06

Shaggar: Apr 26, 2006

idk if that stuff I wrote is right. maybe you can use an unpivot or something too. also a merge so you can run it over and over w/out duplicating data and stuff. w/e.

its a pretty good exercise tho cause bad data is gonna happen and its nice to know how to fix it.

# ? Jul 31, 2014 04:20

Shaggar: Apr 26, 2006

or maybe a cross apply? like

SQL code:


	SELECT
		f.ACCTNO AS AccountNumber
		,per.Item
	FROM FROM 
		[V_TEST].[dbo].[GL_CHART_1] f
	CROSS APPLY
		dbo.SplitStrings(f.FISCAL_PER, '^') per

that would give you a nice list of AccountNumber, FiscalPeriod but idk what you'd do next on the db_amt to keep them in order. maybe i'll think about this more tomorrow.

# ? Jul 31, 2014 04:57

CISADMIN PRIVILEGE: Aug 15, 2004; optimized multichannel
campaigns to drive
demand and increase
brand engagement
across web, mobile,
and social touchpoints,
bitch!

Shaggar posted:

or maybe a cross apply? like
SQL code:
	SELECT
		f.ACCTNO AS AccountNumber
		,per.Item
	FROM FROM 
		[V_TEST].[dbo].[GL_CHART_1] f
	CROSS APPLY
		dbo.SplitStrings(f.FISCAL_PER, '^') per 	
that would give you a nice list of AccountNumber, FiscalPeriod but idk what you'd do next on the db_amt to keep them in order. maybe i'll think about this more tomorrow.

i use cross apply on the return value from the function above in order to create a final table with |ACCTNO|FISCAL_PER|DR|CR| so that the table can be keyed on ACCTNO and FISCAL_PER for sensible queries. Then I normalized out all of the other account details. (if account type, header account etc) the results are financially sound it's just my function above feels like it could be done much better which I think you did in your previous post.

# ? Jul 31, 2014 05:05

Shaggar: Apr 26, 2006

rad

# ? Jul 31, 2014 05:07

CISADMIN PRIVILEGE: Aug 15, 2004; optimized multichannel
campaigns to drive
demand and increase
brand engagement
across web, mobile,
and social touchpoints,
bitch!

i just hate it when I know there's a better way to write a query, but the fact i don't do this poo poo every day makes it hard for me to figure out.

# ? Jul 31, 2014 05:22

Shaggar: Apr 26, 2006

yeah sql code smell is really strong.

# ? Jul 31, 2014 05:24

Malcolm XML: Aug 8, 2009; I always knew it would end like ｔｈｉｓ．

Corla Plankun posted:

literally every job i have had since high school has been made better by automating the stupid office crap everyone has to do all the time

and plangs make that super easy

exceldna loving owns so hard

f# in excel :hellyeah: