Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

sqlformat(1) [debian man page]

SQLFORMAT(1)							   User Commands						      SQLFORMAT(1)

sqlformat - reformat SQL SYNOPSIS
sqlformat [ OPTION ] ... [ FILE ] ... DESCRIPTION
The `sqlformat' command-line tool can be used to reformat SQL file according to specified options or prepare a snippet in in some program- ming language (only Python and PHP currently supported). Use "-" for FILE to read from stdin. OPTIONS
-i CHOICE|--identifiers=FORMAT Change case of identifiers. FORMAT is one of "upper", "lower", "capitalize". -k CHOICE|--keywords=FORMAT Change case of keywords. FORMAT is one of "upper", "lower", "capitalize". -l CHOICE|--language=LANG Output a snippet in programming language LANG. LANG can be "python", "php". -o FILE|--outfile=FILE Write output to FILE (defaults to stdout). -r|--reindent Reindent statements. --indent_width=INDENT_WIDTH Set indent width to INDENT_WIDTH. Default is 2 spaces. --strip-comments Remove comments. -h|--help Print a short help message and exit. All subsequent options are ignored. --verbose Verbose output. --version Print program's version number and exit. AUTHORS
This man page was written by Andriy Senkovych <> python-sqlparse version: 0.1.2 December 2010 SQLFORMAT(1)

Check Out this Related Man Page

MLLP_SEND(1)							    python-hl7							      MLLP_SEND(1)

mllp_send - MLLP network client python-hl7 features a simple network client, mllp_send, which reads HL7 messages from a file or sys.stdin and posts them to an MLLP server. mllp_send is a command-line wrapper around hl7.client.MLLPClient. mllp_send is a useful tool for testing HL7 interfaces or resending logged messages: $ mllp_send --file sample.hl7 --port 6661 MSH|^~&|LIS|Example|Hospital|Mirth|20111207105244||ACK^A01|A234244|P|2.3.1| MSA|AA|234242|Message Received Successfully| USAGE
Usage: mllp_send [options] <server> Options: -h, --help show this help message and exit -p PORT, --port=PORT port to connect to -f FILE, --file=FILE read from FILE instead of stdin -q, --quiet do not print status messages to stdout --loose allow file to be a HL7-like object ( instead of ). Can ONLY send 1 message. Requires --file option (no stdin) INPUT FORMAT
By default, mllp_send expects the FILE or stdin input to be a properly formatted HL7 message (carriage returns separating segments) wrapped in a MLLP stream (<SB>message1<EB><CR><SB>message2<EB><CR>...). However, it is common, especially if the file has been manually edited in certain text editors, that the ASCII control characters will be lost and the carriage returns will be replaced with the platform's default line endings. In this case, mllp_send provides the --loose option, which attempts to take something that "looks like HL7" and convert it into a proper HL7 message. Currently the --loose option can only handle 1 HL7 message per file (it causes mllp_send to assume the whole file is one HL7 message). ADDITIONAL RESOURCES
John Paulett COPYRIGHT
2011, John Paulett 0.2.2 December 17, 2011 MLLP_SEND(1)
Man Page

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

what is python?

I heard that its a new programming language but ill like to get a deeper explaination of it. (1 Reply)
Discussion started by: kprescod4158
1 Replies

2. UNIX for Dummies Questions & Answers

Reformatting file

Hi, How can I reformat a file (text file) using unix command. This file was FTP'd from Mainframe and contains some garbage character at the end of each line. Each line contains special characters '<soh>' at the end which should have been spaces when I view it in emacs or nedit. I couldnt do find... (2 Replies)
Discussion started by: mrjunsy
2 Replies

3. Shell Programming and Scripting

Zenity Menu

I have some troubles with zenity and menu. I seach for: MAIN MENU CHOICE 1 "do something" CHOICE 2 "do something 2" CHOICE 3 "do something 3" But then in "do someghing " when i click i want to return to the MAIN MENU So something like: while true; do ... (4 Replies)
Discussion started by: aspire
4 Replies

4. Programming

Which language is best suited for regular expressions perl,python.ruby ?

Hello all, i am in a bit of dilema here. i dont know any thing about perl or python. only know a little bit of awk. now unable to take a decission as to which language to go for. my requirement is building a testing framework.suite which will execute ssytem comands remotely on unix... (2 Replies)
Discussion started by: achak01
2 Replies

5. Programming

What programming language would I use to make a translating program?

I want to create a computer program that will translate from English to Spanish and vice versa. So someone could type in a word, phrase, or paragraph and translate from one language to another. What programming language would I use to write up the code and then implement this program? I want to... (0 Replies)
Discussion started by: Anna Hussie
0 Replies

6. Shell Programming and Scripting

How to search for right word using awk?

Hi- I have issue with the code to get the input file reformat --Goal is reformat and print out only column name one per line, leading space or trailing space will be removed... --TABLE1.DDL as input file, and content of file as show below REPLACE VIEW TABLE1 ( ID ,COL1 ... (3 Replies)
Discussion started by: lv99
3 Replies

7. Shell Programming and Scripting

[Solved] File reformat

I am using the code below to reformat the input (hp.txt). The output (newhp.txt) is not in the desired format and I can not seem to figure it out. I have attached both. Thank you. perl -aF/\\t/ -lne 'print join(" ",@F) for ("0 A","0 G","0 C","0 T","A 0","G 0","C 0","T 0")' hp.txt > newhp.txt ... (4 Replies)
Discussion started by: cmccabe
4 Replies

8. Programming

Curious About Offbeat "#" Usage in C . . .

Greetings! Being incredibly rusty in the little C which I ever knew, and, not knowing where else to turn but the best programming community on the web ( :) ), I submit the following snippet for a quick question:#if PERL_VERSION > 7 if (DEBUG_D_TEST) { SV* sva; ... (3 Replies)
Discussion started by: LinQ
3 Replies

9. Programming

Python Regex List Creation

Here is a snippet of my code: blahblahblah... blah for link in goodies.soup.find_all('a'): blah.append(link.get('href')) blah=list(set(blah)) which gives my list of urls. So now I use a regex to search for the relevant urls which I want in a list: for r... (0 Replies)
Discussion started by: metallica1973
0 Replies

10. Shell Programming and Scripting

Change in the file

Hi, I have a file which has wrong time format and we want to correct it before we load it. WRONG FORMAT : 93:0:00 CORRECT FORMAT :09:30:00 If you notice the 0 at the front is missing. Its the case always. (6 Replies)
Discussion started by: varun22486
6 Replies