Skip to content
This repository has been archived by the owner on Jan 8, 2020. It is now read-only.

Ability to support database/schema prefixed tables #6120

Closed
susy11 opened this issue Apr 10, 2014 · 4 comments
Closed

Ability to support database/schema prefixed tables #6120

susy11 opened this issue Apr 10, 2014 · 4 comments

Comments

@susy11
Copy link

susy11 commented Apr 10, 2014

Add the ability to use database prefixed tables for example:

 $sql = new Sql($this->adapter);
        $select = $sql->select();
        $select->from($table);

the from function needs to be able to support prefixed tables. also it doublequotes by default your table so you are not able to add the database manually like this:

$table = $schema."`.`".$table;

this is a major drawback when you have multiple databases that you need to use on the fly whitout the instantion of a new adapter with the required database

@samsonasik
Copy link
Contributor

@susy11 I think you can use TableIdentifier for defining schema

@susy11
Copy link
Author

susy11 commented Apr 14, 2014

@samsonasik Thank you for your answer, it helped me solve my issue.

@samsonasik
Copy link
Contributor

if your issue is solved, maybe you can close this issue ? :)

@susy11 susy11 closed this as completed Apr 14, 2014
@susy11 susy11 reopened this Apr 14, 2014
@susy11 susy11 closed this as completed Apr 14, 2014
@susy11
Copy link
Author

susy11 commented Apr 14, 2014

Done. Thanks

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

3 participants