net.sf.jabref.sql.importer

Class DBImporter

java.lang.Object

net.sf.jabref.sql.DBImporterExporter

net.sf.jabref.sql.importer.DBImporter

Direct Known Subclasses:

MySQLImporter, PostgreSQLImporter

public abstract class DBImporter
extends DBImporterExporter

Author:

ifsteinm. Jan 20th Abstract Class to provide main features to import entries from a DB. To insert a new DB it is necessary to extend this class and add the DB name the enum available at net.sf.jabref.sql.DBImporterAndExporterFactory (and to the GUI). This class and its subclasses import database, entries and related stuff from a DB to bib. Each exported database is imported as a new JabRef (bib) database, presented on a new tab

Constructor Summary

Constructors

Constructor and Description
DBImporter()

Method Summary

Modifier and Type	Method and Description
protected abstract java.sql.Connection	connectToDB(DBStrings dbstrings) Given a DBStrings it connects to the DB and returns the java.sql.Connection object
java.lang.String	findGroupTypeName(java.lang.String groupId, java.sql.Connection conn) Look up the group type name from the type ID in the database.
void	importGroupsTree(MetaData metaData, java.util.HashMap<java.lang.String,BibtexEntry> entries, java.sql.Connection conn, java.lang.String database_id)
java.util.ArrayList<java.lang.Object[]>	performImport(java.util.Set<java.lang.String> keySet, DBStrings dbs, java.util.List<java.lang.String> listOfDBs) Worker method to perform the import from a database
protected abstract java.sql.ResultSet	readColumnNames(java.sql.Connection conn)

Methods inherited from class net.sf.jabref.sql.DBImporterExporter

getDatabaseIDByName, removeAGivenDB, removeAllRecordsForAGivenDB, removeDB

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DBImporter

public DBImporter()

Method Detail

connectToDB

protected abstract java.sql.Connection connectToDB(DBStrings dbstrings)
                                            throws java.lang.Exception

Given a DBStrings it connects to the DB and returns the java.sql.Connection object

Parameters:

dbstrings - The DBStrings to use to make the connection

Returns:

java.sql.Connection to the DB chosen

Throws:

java.lang.Exception

readColumnNames

protected abstract java.sql.ResultSet readColumnNames(java.sql.Connection conn)
                                               throws java.sql.SQLException

Parameters:

conn - Connection object to the database

Returns:

A ResultSet with column name for the entries table

Throws:

java.sql.SQLException

performImport

public java.util.ArrayList<java.lang.Object[]> performImport(java.util.Set<java.lang.String> keySet,
                                                             DBStrings dbs,
                                                             java.util.List<java.lang.String> listOfDBs)
                                                      throws java.lang.Exception

Worker method to perform the import from a database

Parameters:

keySet - The set of IDs of the entries to export.

dbs - The necessary database connection information

Returns:

An ArrayList containing pairs of Objects. Each position of the ArrayList stores three Objects: a BibtexDatabase, a MetaData and a String with the bib database name stored in the DBMS

Throws:

java.lang.Exception

findGroupTypeName

public java.lang.String findGroupTypeName(java.lang.String groupId,
                                          java.sql.Connection conn)
                                   throws java.sql.SQLException

Look up the group type name from the type ID in the database.

Parameters:

groupId - The database's groups id

conn - The database connection

Returns:

The name (JabRef type id) of the group type.

Throws:

java.sql.SQLException

importGroupsTree

public void importGroupsTree(MetaData metaData,
                             java.util.HashMap<java.lang.String,BibtexEntry> entries,
                             java.sql.Connection conn,
                             java.lang.String database_id)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException