Welcome Guest, Not a member yet? Register   Sign In
Any way to use the query builder without a database connection?
#1

Hi All -


I'm hoping to use the CI query builder (we're in v3) to generate SQL statements. The only problem is that we don't actually have a connection to run them in. Our application sends queries via a web service to have them run against a cloud-hosted MySQL instance (passing the select statement as the HTTP body).

Is there any way to use CI's query builder to simply generate the SQL statement and to return the assembled statements as strings?

Thanks in advance -

Trent
Reply
#2

@trentwritescode,

Checkout the $this->db->get_compiled_select() [link: https://codeigniter.com/user_guide/datab...cting-data ] feature.
Reply
#3

(03-25-2019, 10:56 AM)php_rocs Wrote: @trentwritescode,

Checkout the $this->db->get_compiled_select() [link: https://codeigniter.com/user_guide/datab...cting-data ] feature.

Unfortunately, this requires a properly-configured database connection –– something we do not have.
Reply
#4

The framework unit testing has a mock database that might be the trick...
https://github.com/codeigniter4/CodeIgni...t/Database
Reply
#5

I'll keep this in mind when we moved to CI4. Thanks!
Reply




Theme © iAndrew 2016 - Forum software by © MyBB