Feature Requests: Browse | Submit New | Admin

[#27157] Allow users to execute external .sql files

Date:
2009-09-21 21:49
Priority:
3
Submitted By:
Daniel Berger (djberg96)
Assigned To:
Nobody (None)
Category:
None
State:
Open
Summary:
Allow users to execute external .sql files

Detailed description
Hi,

With Oracle you can run external .sql files using 'start' or '@' (I'm not sure how other vendors handle this). There
doesn't appear to be a way to do something like:

require 'dbi'
require 'dbi/dbrc'

db = DBI::DBRC.new('gdbt', 'dan')

dbh = DBI.connect(db.dsn, db.user, db.passwd)
dbh.execute('start test.sql')

dbh.disconnect

Can you add support for this please?

Regards,

Dan

Add A Comment: Notepad

Please login


Followup

Message
Date: 2009-09-21 21:53
Sender: Erik Hollensbe

Hi Dan,

I can't see a way of doing this without reading the sql file
in ourselves, is this what you were getting at, or did you mean
something different?

Attached Files:

Name Description Download
No Files Currently Attached

Changes:

No Changes Have Been Made to This Item