Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I'm not a PHP developer, so I'm not going to attempt to show any code, but here's what I would do. I would implement the <a href="http://en.wikipedia.org/wiki/Strategy_pattern" rel="nofollow">Strategy Pattern</a> and create an IServiceProvider interface. That interface could have a GetService() method. Then you would create four new objects: LocationService, ProductService, UserService, and DefaultService, all of which would implement the IServiceProvider interface. </p> <p>Now, in your factory, the constructor would take in a IServiceProvider and have one public GetService() method. When the method is called, it will use the strategy of the injected IServiceProvider. This improves extensability as you won't have to open the Factory everytime you have a new service, you would just create a new class that implements IServiceProvider.</p> <p>I decided quick to mock this up quick in C# so you would have an example. I understand this isn't the language you are using, but maybe it will help clarify what I'm saying. Code shown below.</p> <pre><code>public interface IServiceProvider { Service GetService(); } public class UserServiceProvider : IServiceProvider { public Service GetService() { //perform code to get &amp; return the service } } public class StaticPageTemplateServiceProvider : IServiceProvider { public Service GetService() { //perform code to get &amp; return the service } } public class DynamicPageTemplateServiceProvider : IServiceProvider { public Service GetService() { //perform code to get &amp; return the service } } public class DefaultServiceProvider : IServiceProvider { public Service GetService() { //perform code to get &amp; return the service } } public class ServiceFactory { public ServiceFactory(IServiceProvider serviceProvider) { provider = serviceProvider; } private IServiceProvider provider; public Service GetService() { return provider.GetService(); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POAdvice on Factory Method
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJSprang
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COAt first glance, I really like this solution. But, I'm left with two questions. One, why do I need to send the ServiceProvider to a ServiceFactory when the ServiceProvider actually returns my implementation? Can't I just have the ServiceProvider give the controller the implementation directly? And two, I'm still left with a token in the controller (location, products, news, user, etc) in the controller in which I now need to get a ServiceProvider for. Which seems like a job for a factory and now I'm back to where I started, right?
      singulars
      1. PO
      1. USheath
    2. COYou are correct with your first question, you probably wouldn't need the factory. The idea is that the factory could look at a configuration setting and determine which IServiceProvider to give back, or something like that. For your second question, it seems like each specific instance of IServiceProvider should be able to hold any token that would be needed. However, I don't completely understand what you are trying to do with the token. If you could explain the token a little more, maybe I could help you out. Good luck :)
      singulars
      1. PO
      1. USJSprang
    3. COI updated the original post to clarify (I hope).
      singulars
      1. PO
      1. USheath
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload