This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I plan on using the same model created by LS on PGSql for production and SQLite for unit tests. I'd like to use the actual same UOW generated for both "connections"/providers. The only issue is that my PGSql schema uses two tablespace to separate different entities while SQLite doesn't support table-spaces. I would like to be able to have LS ignore the schema while generating SQL for SQLite since the provider simply doesn't supoort it. Would this sort of a feature make sense to you the LS guys/gals? |
|
|
|
|
You can handle this with a custom naming strategy for SQLite to strip the schema as needed. Have a look at http://www.mindscapehq.com/documentation/lightspeed/Controlling-the-Database-Mapping/Overriding-the-Default-Mapping for an example, you will want to implement the GetSchema method.
|
|
|
|
|
Just to let you know, as of the next nightly build, the designer Update Database will ignore schema specifications when running against SQLite. Note that you will still need to provide a naming strategy at runtime as we have not yet updated the runtime SQLite provider to ignore schemas. |
|
|
|
