01-05-2008
Evan including "" doesnt works
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
Am new to scripting. So i just need your ideas to help me out. Here goes my requirement.
I have two csv files
1.csv 2.csv
abc,1.24 abc,1
def,2.13 def,1
I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies
2. UNIX for Advanced & Expert Users
I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner.
I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
2 Replies
3. UNIX for Advanced & Expert Users
Hi
I have csv file which has test as multiline in the one column. ex.
---------data.csv------------
Seqno,EmpID,EmpName,Dept
1,123,"Vipin
Agrawal","IT
BUSINESS
OFFSHORE"
2,124,"Simon Bhai","IT"
The problem is name "Vipin Agrawal" has one new line character b/w name. same as Dept. ... (1 Reply)
Discussion started by: meetvipin
1 Replies
4. UNIX for Dummies Questions & Answers
Hi guys,
I am not experienced with Unix, so please dont mind if the question seem to be irrelevant.
I have written a simple script, that connects DB & fetches few records from a table. I wanted to get those details as file in .CSV format via mail.
-I stored the query o/p in a file.
-I... (6 Replies)
Discussion started by: sumitburnwal88
6 Replies
5. Shell Programming and Scripting
Hi ,
I need a help in following scenario.I tried searching in google but couldn't able to find the exact answer. Sorry if i am re-posting already answered query.
While i am trying to convert into log file into csv i couldn't able to get the format which i am looking for.
I converted file... (4 Replies)
Discussion started by: varmas424
4 Replies
6. Shell Programming and Scripting
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies
7. Shell Programming and Scripting
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
8. Shell Programming and Scripting
Hi, all
I want to sort a csv file based on timestamp from oldest to newest and save the output as csv file itself. Here is an example of my csv file.
test.csv
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0739.JPG,2015:02:17 11:32:21
/home/intannf/foto/IMG_0749.JPG,2015:02:17 11:37:28... (10 Replies)
Discussion started by: refrain
10 Replies
9. Shell Programming and Scripting
Hi,
I have another problem. I want to sort another csv file by the first field.
result.csv
SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw
/home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 Replies
LEARN ABOUT DEBIAN
sqlheavy-gen-orm
sqlheavy-gen-orm(1) SQLHeavy sqlheavy-gen-orm(1)
NAME
sqlheavy-gen-orm - SQLHeavy ORM Generator
SYNOPSIS
sqlheavy-gen-orm [OPTION...] SOURCE...
DESCRIPTION
This tool will generate a Vala file which provides an object for each table in the specified database(s), each of which extends the SQL-
HeavyRecord class.
You should pass at least one SQLite database file, which it will examine to produce the output. Additionally, you can specifiy metadata
files (which is a key file), as well as vala files to provide custom code in the output.
OPTIONS
--help
-o, --output=FILE
Write output to FILE (defaults to stdout)
-m, --metadata=FILE
Load metadata from FILE
--vapidir=DIRECTORY
Look for package bindings in DIRECTORY
--pkg=PACKAGE
Include binding for PACKAGE
-o, --output=FILE
Output to FILE (default is stdout)
-p, --properties
Write properties instead of methods
METADATA FORMAT
The concept of the metadata files is similar to that of vapigen (in fact, the entire sqlheavy-gen-orm tool is largely inspired by vapigen),
but it uses the key file format so that it can use the GLib Key-Value file parser. Databases, tables, and columns are all represented by
groups, each of which may have any number of properties (the key value pairs).
Selectors
The format for the selectors is relatively straightforward. A forward slash ("/") is used as the separator character, and prepending an @
to a token means that token refers to a database, and prepending a % means that token refers to a table. The database name is the name of
the database file, not including the last dot character and anything following it (i.e., the extension). An asterisk can be used as a wild-
card. Several examples, as well as an explanation of each:
@foo/bar/baz
The baz symbol in the bar table in the foo database.
@foo The foo database
%bar/baz
The baz column in the bar table in any database
baz The baz column in any table in any database
@foo/*/baz
The baz column in any table in the foo database
*/bar The bar table in any database
Properties
Properties are represented by key-value pairs. The following is a table of currently implemented properties:
+-------+--------+------------+---------------------------------+
| Name | Type | DB/TBL/COL | Purpose |
+-------+--------+------------+---------------------------------+
|name | string | Y/Y/Y | Rename the symbol |
|type | string | N/N/Y | Set the Vala type of the column |
|hidden | bool | Y/Y/Y | Do not create a binding |
+-------+--------+------------+---------------------------------+
Custom Vala
In addition to providing one or more SQLite database as a basis for code generation, you can provide an existing *.vala file. Theoreti-
cally, this will allow you to place custom code in a separate file, so that you can use sqlheavy-gen-orm to update the generated code with-
out losing whenever the database schema changes, and you will not lose any enhancements you made. The generated code will be merged into
the custom vala file in order to generate the output.
HOMEPAGE AND BUG REPORT
http://code.google.com/p/sqlheavy
AUTHORS
Evan Nemerson
sqlheavy-gen-orm-0.0.1 29 April 2010 sqlheavy-gen-orm(1)