Hello,
I want to compare two files. All records in file 2 that are not in file 1 should be output to file 3.
For example:
file 1
123
1234
123456
file 2
123
2345
23456
file 3 should have
2345
23456
I have looked at diff, bdiff, cmp, comm, diff3 without any luck! (2 Replies)
Hi,
svn diff does not work very well with 2 local folders, so I am trying to do this diff using diff locally.
since there's a bunch of meta files in an svn directory, I want to do a diff that excludes everything EXCEPT *.java files. there seems to be only an --exclude option, so I'm not sure... (3 Replies)
Hi Masters,
I have two files named file1 and file2.
Both the files contains the same contents with some difference in comments,space.But no content change.
I tried to find the diff between the two files to make sure that contents are same.
For that i tried
diff -ibw file1 file2
But... (1 Reply)
Hi,
I have 2 files.I want to check if file1 is contained in file2.
A.txt:
-----
AAA
BBB
B.txt:
------
CCC
AAA
BBB
DDD
I want to check if A.txt is contained in B.txt. Can it be done using SED ? (12 Replies)
Hi All,
I have two files which look as below
File1
serial="1" name="abc" type="employee" field="IT"
serial="2" name="cde" type="intern" field="Marketing"
serial="3" name="pqr" type="contractor" field="IT"
serial="4" name="xyz" type="employee" field="Sales"
File2
serial="1"... (3 Replies)
Hi,
I am new to shell scripting.
please help me to find out the solution.
I need a script where we need to read the text file(consists of all file names) and get the file names one by one
and append the date suffix for each file name as 'yyyymmdd' .
Then search each file if exists... (1 Reply)
Hi Experts,
Can you please help me in transposing Datefield from rows to column and calculate the time difference for each of the Jobids:
Input File:
08/23/2012 12:36:09,JOB_5340
08/23/2012 12:36:14,JOB_5340
08/23/2012 12:36:22,JOB_5350
08/23/2012 12:36:26,JOB_5350
Required Output:... (6 Replies)
Dear All
I want to diff between two time(FIRST 4 COLUMN) in hours in last column. Kindly help me for same.
2013-11-23 15:51:23 2013-11-23 12:20:06 BRC023 CG
2013-11-23 15:51:23 2013-11-23 12:20:08 BRC064CG
2013-11-23 15:51:23 2013-11-22 13:17:49 BLM003 NG
2013-11-23 15:51:23 2013-11-22... (9 Replies)
Discussion started by: jaydeep_sadaria
9 Replies
LEARN ABOUT MOJAVE
dbix::class::admin5.18
DBIx::Class::Admin(3) User Contributed Perl Documentation DBIx::Class::Admin(3)NAME
DBIx::Class::Admin - Administration object for schemas
SYNOPSIS
$ dbicadmin --help
$ dbicadmin --schema=MyApp::Schema
--connect='["dbi:SQLite:my.db", "", ""]'
--deploy
$ dbicadmin --schema=MyApp::Schema --class=Employee
--connect='["dbi:SQLite:my.db", "", ""]'
--op=update --set='{ "name": "New_Employee" }'
use DBIx::Class::Admin;
# ddl manipulation
my $admin = DBIx::Class::Admin->new(
schema_class=> 'MY::Schema',
sql_dir=> $sql_dir,
connect_info => { dsn => $dsn, user => $user, password => $pass },
);
# create SQLite sql
$admin->create('SQLite');
# create SQL diff for an upgrade
$admin->create('SQLite', {} , "1.0");
# upgrade a database
$admin->upgrade();
# install a version for an unversioned schema
$admin->install("3.0");
REQUIREMENTS
The Admin interface has additional requirements not currently part of DBIx::Class. See DBIx::Class::Optional::Dependencies for more
details.
ATTRIBUTES
schema_class
the class of the schema to load
schema
A pre-connected schema object can be provided for manipulation
resultset
a resultset from the schema to operate on
where
a hash ref or json string to be used for identifying data to manipulate
set
a hash ref or json string to be used for inserting or updating data
attrs
a hash ref or json string to be used for passing additional info to the ->search call
connect_info
connect_info the arguments to provide to the connect call of the schema_class
config_file
config_file provide a config_file to read connect_info from, if this is provided config_stanze should also be provided to locate where the
connect_info is in the config The config file should be in a format readable by Config::Any.
config_stanza
config_stanza for use with config_file should be a '::' delimited 'path' to the connection information designed for use with catalyst
config files
config
Instead of loading from a file the configuration can be provided directly as a hash ref. Please note config_stanza will still be required.
sql_dir
The location where sql ddl files should be created or found for an upgrade.
sql_type
The type of sql dialect to use for creating sql files from schema
version
Used for install, the version which will be 'installed' in the schema
preversion
Previous version of the schema to create an upgrade diff for, the full sql for that version of the sql must be in the sql_dir
force
Try and force certain operations.
quiet
Be less verbose about actions
trace
Toggle DBIx::Class debug output
METHODS
create
Arguments: $sqlt_type, \%sqlt_args, $preversion
"create" will generate sql for the supplied schema_class in sql_dir. The flavour of sql to generate can be controlled by supplying a
sqlt_type which should be a SQL::Translator name.
Arguments for SQL::Translator can be supplied in the sqlt_args hashref.
Optional preversion can be supplied to generate a diff to be used by upgrade.
upgrade
Arguments: <none>
upgrade will attempt to upgrade the connected database to the same version as the schema_class. MAKE SURE YOU BACKUP YOUR DB FIRST
install
Arguments: $version
install is here to help when you want to move to DBIx::Class::Schema::Versioned and have an existing database. install will take a version
and add the version tracking tables and 'install' the version. No further ddl modification takes place. Setting the force attribute to a
true value will allow overriding of already versioned databases.
deploy
Arguments: $args
deploy will create the schema at the connected database. $args are passed straight to "deploy" in DBIx::Class::Schema.
insert
Arguments: $rs, $set
insert takes the name of a resultset from the schema_class and a hashref of data to insert into that resultset
update
Arguments: $rs, $set, $where
update takes the name of a resultset from the schema_class, a hashref of data to update and a where hash used to form the search for the
rows to update.
delete
Arguments: $rs, $where, $attrs
delete takes the name of a resultset from the schema_class, a where hashref and a attrs to pass to ->search. The found data is deleted and
cannot be recovered.
select
Arguments: $rs, $where, $attrs
select takes the name of a resultset from the schema_class, a where hashref and a attrs to pass to ->search. The found data is returned in
a array ref where the first row will be the columns list.
AUTHOR
See "CONTRIBUTORS" in DBIx::Class.
LICENSE
You may distribute this code under the same terms as Perl itself
perl v5.18.2 2014-01-08 DBIx::Class::Admin(3)