Hi All,
now i am facing one new problem, the problem is i have to check a
specified directory for any number of files that the program will read
and load into the database one file at a time. when the program finishes
a file it should place the file in an archive directory. The program
should also keep a log of it''s activity along with it;s errors.
so, for this i have created one directory called
sampledb("#{RAILS_ROOT}/sampledb"), inside the db contains many files,
so if N number of files is there in the sense, i should read the file
and write into the database, but i don''t know how to write the data
into
the database, so if any one knows, i need the idea how to implement the
task, or please let me know any related site url, it would be great help
for me, thanks in advance.
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
logger = Logger.new("loggfile.log") # open a logger if you are not
inside a controller
begin
dir = Dir.new("#{RAILS_ROOT}/sampledb")
dir.each { |dEntryName|
file = File.new(dEntryName) #open the current entry in the
directory
next unless file.stat.file? # check is this a directory if yes
ignore it.
myDatabaseTable = MyTable.new() #pass argument to new if any
extra columns present in table
myDatabaseTable.file_content = file.read # read all contents
in file
myDatabaseTable.save!
}
rescue Exception => e
logger.error( e.message) #log what ever you want.
return false # return if necessary or else forget it
end
I guess this solves your problem and i assumed MyTable is table where
your going to put your content and column name i assume it as
file_content,
even you can save the file name inside the database, and (return false
may not be necessary.) and also assuming you are using oracle db, and
column type
for file_content as either varchar2, or blob or which ever is
suitable.
Good luck,
On Sep 28, 5:14 pm, Vidya Vidya
<rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:> Hi All,
>
> now i am facing one new problem, the problem is i have to check a
> specified directory for any number of files that the program will read
> and load into the database one file at a time. when the program finishes
> a file it should place the file in an archive directory. The program
> should also keep a log of it''s activity along with it;s errors.
>
> so, for this i have created one directory called
> sampledb("#{RAILS_ROOT}/sampledb"), inside the db contains many
files,
> so if N number of files is there in the sense, i should read the file
> and write into the database, but i don''t know how to write the
data into
> the database, so if any one knows, i need the idea how to implement the
> task, or please let me know any related site url, it would be great help
> for me, thanks in advance.
> --
> Posted viahttp://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
raghukumar wrote:> logger = Logger.new("loggfile.log") # open a logger if you are not > inside a controller > begin > dir = Dir.new("#{RAILS_ROOT}/sampledb") > dir.each { |dEntryName| > file = File.new(dEntryName) #open the current entry in the > directory > next unless file.stat.file? # check is this a directory if yes > ignore it. > myDatabaseTable = MyTable.new() #pass argument to new if any > extra columns present in table > myDatabaseTable.file_content = file.read # read all contents > in file > myDatabaseTable.save! > } > rescue Exception => e > logger.error( e.message) #log what ever you want. > return false # return if necessary or else forget it > end > > I guess this solves your problem and i assumed MyTable is table where > your going to put your content and column name i assume it as > file_content, > even you can save the file name inside the database, and (return false > may not be necessary.) and also assuming you are using oracle db, and > column type > for file_content as either varchar2, or blob or which ever is > suitable. > > Good luck, > > On Sep 28, 5:14 pm, Vidya Vidya <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>hi, Thanks for your reply, and i tried this, its working nice, thank you very much to your idea -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---