new sql.gif
[phpeclipse.git] / archive / net.sourceforge.phpeclipse.quantum.sql / src / com / quantum / adapters / AdapterFactory.java
1 package com.quantum.adapters;
2
3 import java.util.ArrayList;
4 import java.util.Collections;
5 import java.util.Comparator;
6 import java.util.HashMap;
7 import java.util.List;
8 import java.util.Map;
9
10 /**
11  * Basically this Factory is a Singleton that is used to return the proper adapter
12  * @author root
13  */
14 public class AdapterFactory {
15         
16         static class ComparatorImpl implements Comparator {
17
18                 public int compare(Object arg0, Object arg1) {
19                         DatabaseAdapter adapter0 = (DatabaseAdapter) arg0;
20                         DatabaseAdapter adapter1 = (DatabaseAdapter) arg1;
21                         
22                         if (adapter0 == null && adapter0 != null) {
23                                 return -1;
24                         } else if (adapter0 != null && adapter1 == null) {
25                                 return 1;
26                         } else if (adapter0 == null && adapter1 == null) {
27                                 return 0;
28                         } else {
29                                 return adapter0.getDisplayName().compareTo(adapter1.getDisplayName());
30                         }
31                 }
32         }
33         
34         static class DriverInfo {
35                 private final String type;
36                 private final String urlPattern;
37
38                 DriverInfo(String type) {
39                         this(type, null);
40                 }
41                 DriverInfo(String type, String urlPattern) {
42                         this.type = type;
43                         this.urlPattern = urlPattern;
44                         
45                 }
46                 public String getType() {
47                         return this.type;
48                 }
49                 public String getURLPattern() {
50                         return this.urlPattern;
51                 }
52         }
53         
54         public static final String GENERIC = "GENERIC"; //$NON-NLS-1$
55         public static final String HSQLDB = "HSQLDB"; //$NON-NLS-1$
56     public static final String ORACLE = "ORACLE"; //$NON-NLS-1$
57     public static final String POSTGRES = "POSTGRES"; //$NON-NLS-1$
58     public static final String MYSQL = "MYSQL"; //$NON-NLS-1$
59     public static final String DB2 = "DB2"; //$NON-NLS-1$
60     public static final String DB2AS400 = "DB2AS400"; //$NON-NLS-1$
61         public static final String ADABASD = "ADABASD"; //$NON-NLS-1$
62     public static final String INFORMIX = "INFORMIX"; //$NON-NLS-1$
63         public static final String REDBRICK = "REDBRICK"; //$NON-NLS-1$
64         public static final String POINTBASE = "POINTBASE"; //$NON-NLS-1$
65     public static final String SYBASE = "SYBASE"; //$NON-NLS-1$
66     public static final String JDBC_ODBC_BRIDGE = "JDBC_ODBC_BRIDGE"; //$NON-NLS-1$
67     public static final String MS_SQL_SERVER = "MS_SQL_SERVER"; //$NON-NLS-1$
68
69         private static final Map DRIVER_MAP = Collections.synchronizedMap(new HashMap());
70         
71         static {
72                 DRIVER_MAP.put("com.ddtek.jdbc.informix.InformixDriver", new DriverInfo(INFORMIX));
73                 DRIVER_MAP.put("com.ddtek.jdbc.db2.DB2Driver", new DriverInfo(DB2, "jdbc:datadirect:db2://${hostname}:${port};DatabaseName=${dbname}"));
74                 DRIVER_MAP.put("com.ddtek.jdbc.oracle.OracleDriver", new DriverInfo(ORACLE));
75                 DRIVER_MAP.put("com.ddtek.jdbc.sqlserver.SQLServerDriver", new DriverInfo(GENERIC));
76                 DRIVER_MAP.put("com.ddtek.jdbc.sybase.SybaseDriver", new DriverInfo(SYBASE));
77                 DRIVER_MAP.put("com.ibm.as400.access.AS400JDBCDriver", new DriverInfo(DB2AS400));
78                 DRIVER_MAP.put("COM.ibm.db2.jdbc.app.DB2Driver", new DriverInfo(DB2, "jdbc:db2:{dbname}"));
79                 DRIVER_MAP.put("COM.ibm.db2.jdbc.net.DB2Driver", new DriverInfo(DB2, "jdbc:db2://{hostname}:{port}/{dbname}"));
80                 DRIVER_MAP.put("com.inet.ora.OraDriver", new DriverInfo(ORACLE));
81                 DRIVER_MAP.put("com.inet.drda.DRDADriver", new DriverInfo(DB2, "jdbc:inetdb2:{hostname}:{port}?database={dbname}"));
82                 DRIVER_MAP.put("com.inet.syb.SybDriver", new DriverInfo(SYBASE));
83                 DRIVER_MAP.put("com.inet.tds.TdsDriver", new DriverInfo(MS_SQL_SERVER));
84                 DRIVER_MAP.put("com.informix.jdbc.IfxDriver", new DriverInfo(INFORMIX, "jdbc:informix-sqli://{hostname}:{port}/{dbname}:INFORMIXSERVER={informixserver}"));
85                 DRIVER_MAP.put("com.microsoft.jdbc.sqlserver.SQLServerDriver", new DriverInfo(MS_SQL_SERVER));
86                 DRIVER_MAP.put("com.mysql.jdbc.Driver", new DriverInfo(MYSQL, "jdbc:mysql://{hostname}:{port}/{dbname}"));
87                 DRIVER_MAP.put("com.pointbase.jdbc.jdbcUniversalDriver", new DriverInfo(POINTBASE, "jdbc:pointbase:server://{hostname}:{port}/{dbname}"));
88                 DRIVER_MAP.put("com.sybase.jdbc.SybDriver", new DriverInfo(SYBASE, "jdbc:sybase:Tds:{hostname}:{port}/{dbname}"));
89                 DRIVER_MAP.put("com.sybase.jdbc2.jdbc.SybDriver", new DriverInfo(SYBASE, "jdbc:sybase:Tds:{hostname}:{port}/{dbname}"));
90                 DRIVER_MAP.put("com.sybase.jdbcx.SybDriver", new DriverInfo(SYBASE, "jdbc:sybase:Tds:{hostname}:{port}/{dbname}"));
91                 DRIVER_MAP.put("net.sourceforge.jtds.jdbc.Driver", new DriverInfo(MS_SQL_SERVER));
92                 DRIVER_MAP.put("oracle.jdbc.driver.OracleDriver", new DriverInfo(ORACLE));
93                 DRIVER_MAP.put("org.gjt.mm.mysql.Driver", new DriverInfo(MYSQL, "jdbc:mysql://{hostname}:{port}/{dbname}"));
94                 DRIVER_MAP.put("org.hsqldb.jdbcDriver", new DriverInfo(HSQLDB));
95                 DRIVER_MAP.put("org.postgresql.Driver", new DriverInfo(POSTGRES, "jdbc:postgresql://{hostname}:{port}/{dbname}"));
96                 DRIVER_MAP.put("sun.jdbc.odbc.JdbcOdbcDriver", new DriverInfo(JDBC_ODBC_BRIDGE, "jdbc:odbc:{datasource}"));
97                 DRIVER_MAP.put("weblogic.jdbc.informix.InformixDriver", new DriverInfo(INFORMIX));
98                 DRIVER_MAP.put("weblogic.jdbc.sqlserver.SybaseDriver", new DriverInfo(SYBASE));
99         }
100         
101     private static AdapterFactory instance;
102     
103     private Map adapters = Collections.synchronizedMap(new HashMap());
104     
105     private AdapterFactory() {
106         addAdapter(new GenericAdapter(GENERIC));
107         addAdapter(new GenericAdapter(HSQLDB));
108         addAdapter(new OracleAdapter());
109         addAdapter(new DB2Adapter());
110         addAdapter(new DB2AS400Adapter());
111         addAdapter(new PostgresAdapter());
112         addAdapter(new MySQLAdapter());
113         addAdapter(new AdabasDAdapter());
114         addAdapter(new InformixAdapter());
115         addAdapter(new RedBrickAdapter());
116         addAdapter(new GenericAdapter(SYBASE));
117         addAdapter(new GenericAdapter(POINTBASE));
118         addAdapter(new GenericAdapter(JDBC_ODBC_BRIDGE));
119         addAdapter(new MSSQLServerAdapter());
120     }
121     private void addAdapter(DatabaseAdapter adapter) {
122         this.adapters.put(adapter.getType(), adapter);
123     }
124     
125     public static synchronized AdapterFactory getInstance() {
126         if (instance == null) {
127                 instance = new AdapterFactory();
128         }
129         return instance;
130     }
131
132     public DatabaseAdapter getAdapter(String type){
133         DatabaseAdapter result = (DatabaseAdapter) this.adapters.get(type);
134         if (result == null) {
135                 result = (DatabaseAdapter) this.adapters.get(GENERIC);
136         }
137         return result == null ? null : result;
138     }
139     
140     public DatabaseAdapter[] getDriverList() {
141         List list = new ArrayList(this.adapters.values());
142         Collections.sort(list, new ComparatorImpl());
143         return (DatabaseAdapter[]) list.toArray(new DatabaseAdapter[list.size()]);
144     }
145     
146     /**
147      * 
148      * @param driverClassName
149      * @return the adapter type, or null if the adapter type is not known
150      */
151     public String getAdapterType(String driverClassName) {
152         DriverInfo driverInfo = (DriverInfo) DRIVER_MAP.get(driverClassName);
153                 return driverInfo == null ? null : driverInfo.getType();
154     }
155         /**
156          * @param type
157          * @return
158          */
159         public String getURLPattern(String driverClassName) {
160         DriverInfo driverInfo = (DriverInfo) DRIVER_MAP.get(driverClassName);
161                 return driverInfo == null ? null : driverInfo.getURLPattern();
162         }
163 }