Ruby DBI fetch can't handle all-zero dates in MySQL -

-

i'm trying access our database simple cgi/ruby , dbi:

#!/usr/bin/ruby -w  require "dbi" dbh = dbi.connect("dbi:mysql:my:mydb", "xxxx", "xxxx")  ...  query = "select eta mydb.mytable id = #{someval}" rows = dbh.execute(query) while row = rows.fetch()     # stuff     ... end

that works fine of time, hit record broke error:

/usr/lib/ruby/vendor_ruby/dbd/mysql.rb:120:in `parse': invalid date (argumenterror)         /usr/lib/ruby/vendor_ruby/dbd/mysql.rb:120:in `parse'         /usr/lib/ruby/vendor_ruby/dbi/row.rb:66:in `block in convert_types'         /usr/lib/ruby/vendor_ruby/dbi/row.rb:65:in `each'         /usr/lib/ruby/vendor_ruby/dbi/row.rb:65:in `each_with_index'         /usr/lib/ruby/vendor_ruby/dbi/row.rb:65:in `convert_types'         /usr/lib/ruby/vendor_ruby/dbi/row.rb:75:in `set_values'         /usr/lib/ruby/vendor_ruby/dbi/handles/statement.rb:226:in `fetch'         /usr/lib/cgi-bin/test:39:in `block in <main>'         /usr/lib/cgi-bin/test:36:in `each'         /usr/lib/cgi-bin/test:36:in `<main>'

after bit of detective work found had date of 0000-00-00 fetch() doesn't like. undefined dates ok, , dbi in perl can handle 0 dates, it's dbi in ruby.

i can fix database, , i'll try app wrote value database fixed too, think ruby should resilient such things. there way work around this, maybe using rescue somehow?

this solution came with:

query = "select eta mydb.mytable id = #{someval}" rows = dbh.execute(query) begin     while row = rows.fetch()         # stuff         ...     end rescue exception => e     puts "#{e}<br>\n"     retry end

this works quite nicely though retry starting new while loop, rows maintains state fetch resumes on next record.

the problem it's hard identify bad record(s). fix issued more queries without offending field. ugly solution:

results = hash.new hit_error = false  query = "select eta,unique_id mydb.mytable id = #{someval}" rows = dbh.execute(query) begin     while row = rows.fetch()         # stuff         ...         results[row[1]] = row[0]     end rescue exception => e     hit_error = true     retry end if hit_error     query = "select unique_id mydb.mytable id = #{someval}"     rows = dbh.execute(query)     while row = rows.fetch()         id = row[0]         unless results.has_key?(id)             begin                 query = "select eta mydb.mytable unique_id = #{id} limit 1"                 error = dbh.execute(query)                 error.fetch()    # expect hit same error before                 puts "unexpected success unique_id #{id}<br>\n"             rescue exception => e                 puts "#{e} @ unique_id #{id}<br>\n"             end         end      end   end

finally i'm not sure how valid use dbi/ruby, seems deprecated. same mysql/ruby. tried sequel little success.


Comments

Post a Comment

Popular posts from this blog

qt - Using float or double for own QML classes -

-
i've created components , helper methods using c++ , qt used in qml gui. of methods calculate gui elements (size, transformations, scene graph items creation). target arm 32 bit using opengl / eglfs render output. opengl using float , qml using real (defined double ). what should use in c++ do not lose precision? if use qreal ( double ) shouldn't lose precision. if git grep float in qtbase.git , can find out bit more: dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0-* important behavior changes * dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0- dist/changes-5.2.0- - qt compiled qreal typedef'ed double on dist/changes-5.2.0: platforms. qreal float on arm chipsets before. guarantees more dist/changes-5.2.0- consistent behavior between platforms qt supports, binary dist/chan...
Read more

Create Outlook appointment via C# .Net -

-
i need create outlook appointment using microsoft.office.interop.outlook , while can work locally on own workstation , works if run web application via server's browser, not work when connect server externally. hence, think might permission issue. i changed application pool identity " localsystem " don't access denied error. unfortunately, doesn't work. the app behaves if appointment created, appointment doesn't appear in outlook. here include file on top of aspx.cs page using outlook = microsoft.office.interop.outlook; here code using pop appointment. outlook.application apptapp = new outlook.application(); outlook.appointmentitem appt = apptapp.createitem(outlook.olitemtype.olappointmentitem) outlook.appointmentitem; appt.subject = txtfirstname.text + " " + txtlastname.text; appt.body = txtcomment.text; appt.alldayevent = false; appt.start = datetime.parse(txtreminderdate.text + " 8:00 am"); appt.end = datetime.p...
Read more

ios - Swift Array Resetting Itself -

-
i have 2 arrays: pointhistory , datehistory . have nstimer , , when timer runs out, action called. in action appending int pointhistory , , current date string datehistory . here timer action: func timeraction() { let steppervalue = int(stepper.value) employee.numberofpoints = steppervalue networking.saveemployee(employee, completion: { (error) -> void in if error != nil { let alert = uialertcontroller(title: "error", message: "there error updating \(self.employee.name)'s points", preferredstyle: .alert) let alertaction = uialertaction(title: "ok", style: .cancel, handler: nil) alert.addaction(alertaction) self.presentviewcontroller(alert, animated: true, completion: nil) } }) var dateformatter = nsdateformatter() dateformatter.dateformat = "mm-dd-yyyy" dateformatter.timezone = nstimezone.localtimezone() var date = nsdate() var ...
Read more