Nerd Alert! Unix shell programmers...

[Veritas]

...if you know of any good online resources for a complete n00b at this, can you PM me? I know C++ on the win32 side, but haven't done any shell programming.

TIA.

[Veritas]

I'll just save some time here...

<snarky colley comment>

[yermom]

what are we talking about here?

what are you trying to do?

what are you using? bash?

[yermom]

<insert snarky comment here>

[Osce0la]

I thought this thread was about 1TC and his tricycle :mad:

[yermom]

if he was a shell programmer i don't think he'd be asking about his USB ports ;)

[Norm In Norman]

I've done some bash stuff fairly recently and it sucks. Generally, answers to questions are "RTFM." I think this guide seems familiar:

http://www.tldp.org/LDP/abs/html/

I frickin hate it. One time i spent like 4 hours on a problem, and the whole thing revolved around an extra space in the wrong spot.

[Veritas]

what are we talking about here?
I dunno. That's the issue.


what are you trying to do?
I've got a cronjob pulling down an XML file every five minutes or so. What I need to do is take that XML file, parse it, and insert certain values into a MySQL database.

The difficulty is that the XML file is damn large, and using a PHP script is horridly inefficient. I don't know Perl very well at all. But I know C, so...


what are you using? bash?
Yeah. Although I know there are shells that may be more conducive to programming.

Given that info if you guys have a better idea I'm all ears.

[yermom]

sounds like you should be using Perl for that...

there are modules to talk directly to MySQL or Oracle or whatever

not that i ever use them... but i've had to install them for people

[colleyvillesooner]

I'll just save some time here...

<snarky colley comment>

HEY! :mad:

I resent that......

























http://www.horrordvds.com/reviews/misc/pictures/nerds.jpg

[Veritas]

sounds like you should be using Perl for that...

there are modules to talk directly to MySQL or Oracle or whatever
Sighs.

I know. I got a book on Perl at the library yesterday. I just don't want to have to deal with learning new syntax and new weird little rules. Usually I'm all about learning something new, but I've got so much **** to do right now that I just want this done and off my plate.

So. Perl. Are there any decent IDEs or do I get to spend some happy time in vi?

[yermom]

i basically use vi for everything... but i'm not really much of a programmer

[sooner n houston]

Get "Unix in a nutshell", "sed and awk", and "learning the Korn shell", all by O'Rielly and Assoc. Or if your near Bentonville, I could loan them to you! :D

[sooner n houston]

Are there any decent IDEs or do I get to spend some happy time in vi?


Oh man I love me some vi!!! :D

[Veritas]

Does "Learning the Korn Shell" have the bass tab for Freak on a Leash? I'm stuck on the bridge. ;)

I'm not "close" to Bentonvile, per se.

[colleyvillesooner]

Does "Learning the Korn Shell" have the bass tab for Freak on a Leash? I'm stuck on the bridge. ;)


Swing and a miss.

Don't worry, you'll be back to old form soon. :D

[Vaevictis]

As a general rule, the stuff you want to use shell programming for, you are probably going to pick up naturally in your day to day use of the shell interactively, with a smattering of man page.

For all other scripting, you probably want perl or python. -- Perl if you want quick dirty and powerful, and python if you want something a little more organized.

emacs and vi are the generally recommended IDEs for perl. And in case you think I'm joking: I'm not.

[SoonerInKCMO]

Sighs.

I know. I got a book on Perl at the library yesterday. I just don't want to have to deal with learning new syntax and new weird little rules. Usually I'm all about learning something new, but I've got so much **** to do right now that I just want this done and off my plate.

So. Perl. Are there any decent IDEs or do I get to spend some happy time in vi?

I may have some Perl code laying around that parses text files and sticks the data in a database. Oracle though... but that just means you'd need to load a different module than what I'm using.

Lemme look around...

[LSUdeek]

i generally recommend python for doing what you are trying to do. hell, for parsing xml files? throw up something in c#/mono. you can cron anything sir.

[SoonerInKCMO]

Hmmm.... looks like all my stuff is for comma-delimited files... since the parsing is probably the most complicated part, it probably won't do you any good to see my code. Sorry.

[Sooner_75]

http://www.ss64.com/bash/

http://linux-newbie.sunsite.dk/index.html

[Norm In Norman]

There is a mysql command that imports a file into a table, but I think it has to be a csv file or something. Something that took php like 3 minutes to import it imported in less than a second. The problem is you need something to go from xml to the csv file. or is it tab seperated...

[slickdawg]

Man, little did I know that I had fellow unix geeks on sf.com


VI ROOOLZ!@@$@#$

[Norm In Norman]

http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html

I dunno if that command will help you or not. You'd have to parse your XML file and create an import file first. I wouldn't be too surprised if there isn't something already out there that does that part for you too. mysqlimport is really damned fast, btw.

[Vaevictis]

Man, little did I know that I had fellow unix geeks on sf.com


VI ROOOLZ!@@$@#$

We are everywhere, waiting in the shadows for the right time to rise up in revolt against the Redmondian Overlords to restore us to our rightful place on all low end to mid-range computers everywhere.

[Stoop Dawg]

If you know C, why not just write a C app?

If it where me, I'd write a Win32 app to do the work. I'd pull the file off the *nix box with FTP or SAMBA.

Hell, I'd nix the cron job altogether and do it all from Win32. Actually, from .NET.

I'm pretty sure this isn't the advice you're looking for, so I'll stop.

[Stoop Dawg]

We are everywhere, waiting in the shadows for the right time to rise up in revolt against the Redmondian Overlords to restore us to our rightful place on all low end to mid-range computers everywhere.

If you're seriously still coding in vi, I'm not worried. ;)

[yermom]

If you're seriously still coding in vi, I'm not worried. ;)

if you're still using Windows, we aren't either ;)

[Getem]

Yeah, i'd do it in C, since you already know C. The mysql C lib is plenty high level, and I don't know that the shell would be that much faster than PHP, would it? Still interpreted.

Although, depending on what you are doing, it might just be a few grep commands and the mysql import that Norm mentioned.

[StoopTroup]

...if you know of any good online resources for a complete n00b at this, can you PM me? I know C++ on the win32 side, but haven't done any shell programming.

TIA.
Sure...

We ask where you've been lately and all we get is...

"I need help."

[Vaevictis]

If you're seriously still coding in vi, I'm not worried. ;)

Noway, I'm a pico ninja, man! ;p