import org.sqlite.SQLiteDataSource; //导入依赖的package包/类
public ScoreDatabaseAccessor(String path) throws ClassNotFoundException {
	Class.forName("org.sqlite.JDBC");
	SQLiteConfig conf = new SQLiteConfig();
	conf.setSharedCache(true);
	conf.setSynchronous(SynchronousMode.OFF);
	// conf.setJournalMode(JournalMode.MEMORY);
	SQLiteDataSource ds = new SQLiteDataSource(conf);
	ds.setUrl("jdbc:sqlite:" + path);
	qr = new QueryRunner(ds);
}
 

import org.sqlite.SQLiteDataSource; //导入依赖的package包/类
/**
 * Loads the database used for storing locations of mp3 files contained in the library for later playback
 * If needed creates a new database based on the available tags of the mp3agic library
 *
 * @param databaseLocation Location of the sqlite database
 * @throws SQLException should theoretically not get thrown, if thrown something in generating the tables through SQL went wrong
 * @throws IOException  gets thrown in case the needed folder structure for the database can't be created
 */
public LibraryDatabase(File databaseLocation) throws SQLException, IOException {
    if(!databaseLocation.isAbsolute()) databaseLocation = databaseLocation.getAbsoluteFile();
    if (!databaseLocation.exists()) {
        if (!databaseLocation.getParentFile().mkdirs() && !databaseLocation.getParentFile().exists())
            throw new IOException("Unable to create database directory");

        Connection conn = DriverManager.getConnection("jdbc:sqlite:" + databaseLocation.getAbsolutePath());
        Statement stmt = conn.createStatement();

        stmt.executeUpdate("CREATE TABLE IF NOT EXISTS LibraryFolder (path TEXT PRIMARY KEY)");

        StringBuilder builderFileTable = new StringBuilder();
        builderFileTable.append("CREATE TABLE IF NOT EXISTS LibraryFile (file_id INTEGER PRIMARY KEY AUTOINCREMENT, path TEXT UNIQUE");
        for (ID3Helper.ID3Tag id3Tag : ID3Helper.ID3Tag.values()) {
            builderFileTable
                    .append(", ")
                    .append(id3Tag.toString().toLowerCase())
                    .append(" TEXT");
        }
        builderFileTable.append(")");
        stmt.executeUpdate(builderFileTable.toString());
        conn.close();
    }

    /**/

    SQLiteTemplates sqLiteTemplate = new SQLiteTemplates();
    Configuration config = new Configuration(sqLiteTemplate);

    SQLiteDataSource dataSource = new SQLiteDataSource();
    dataSource.setUrl("jdbc:sqlite:" + databaseLocation.getAbsolutePath());

    queryFactory = new SQLQueryFactory(config, dataSource);

    reloadFiles();
    reloadFolders();
}
 

import org.sqlite.SQLiteDataSource; //导入依赖的package包/类
public SongInformationAccessor(String filepath) throws ClassNotFoundException {
	Class.forName("org.sqlite.JDBC");
	SQLiteConfig conf = new SQLiteConfig();
	conf.setSharedCache(true);
	conf.setSynchronous(SynchronousMode.OFF);
	// conf.setJournalMode(JournalMode.MEMORY);
	ds = new SQLiteDataSource(conf);
	ds.setUrl("jdbc:sqlite:" + filepath);
	qr = new QueryRunner(ds);
	createTable();
}
 

import org.sqlite.SQLiteDataSource; //导入依赖的package包/类
public SQLiteSongDatabaseAccessor(String filepath, String[] bmsroot) throws ClassNotFoundException {
	Class.forName("org.sqlite.JDBC");
	SQLiteConfig conf = new SQLiteConfig();
	conf.setSharedCache(true);
	conf.setSynchronous(SynchronousMode.OFF);
	// conf.setJournalMode(JournalMode.MEMORY);
	ds = new SQLiteDataSource(conf);
	ds.setUrl("jdbc:sqlite:" + filepath);
	qr = new QueryRunner(ds);
	root = Paths.get(".");
	this.bmsroot = bmsroot;
	createTable();		
}
 

import org.sqlite.SQLiteDataSource; //导入依赖的package包/类
public ScoreLogDatabaseAccessor(String path) throws ClassNotFoundException {
	Class.forName("org.sqlite.JDBC");
	SQLiteConfig conf = new SQLiteConfig();
	conf.setSharedCache(true);
	conf.setSynchronous(SynchronousMode.OFF);
	// conf.setJournalMode(JournalMode.MEMORY);
	ds = new SQLiteDataSource(conf);
	ds.setUrl("jdbc:sqlite:" + path);
	qr = new QueryRunner(ds);
	createTable();		
}
 

import org.sqlite.SQLiteDataSource; //导入依赖的package包/类
protected OffHeapPersistence(SimpleAttribute<O, A> primaryKeyAttribute, Properties overrideProperties) {
    Properties effectiveProperties = new Properties(DEFAULT_PROPERTIES);
    effectiveProperties.putAll(overrideProperties);
    SQLiteConfig sqLiteConfig = new SQLiteConfig(effectiveProperties);
    SQLiteDataSource sqLiteDataSource = new SQLiteDataSource(sqLiteConfig);
    String instanceName = "cqengine_" + INSTANCE_ID_GENERATOR.incrementAndGet();
    sqLiteDataSource.setUrl("jdbc:sqlite:file:" + instanceName + "?mode=memory&cache=shared");

    this.primaryKeyAttribute = primaryKeyAttribute;
    this.instanceName = instanceName;
    this.sqLiteDataSource = sqLiteDataSource;
    this.persistentConnection = getConnectionInternal(null, noQueryOptions());
}
 

import org.sqlite.SQLiteDataSource; //导入依赖的package包/类
protected DiskPersistence(SimpleAttribute<O, A> primaryKeyAttribute, File file, Properties overrideProperties) {
    Properties effectiveProperties = new Properties();
    effectiveProperties.putAll(DEFAULT_PROPERTIES);
    effectiveProperties.putAll(overrideProperties);
    SQLiteConfig sqLiteConfig = new SQLiteConfig(effectiveProperties);
    SQLiteDataSource sqLiteDataSource = new SQLiteDataSource(sqLiteConfig);
    sqLiteDataSource.setUrl("jdbc:sqlite:file:" + file);

    this.primaryKeyAttribute = primaryKeyAttribute;
    this.file = file.getAbsoluteFile();
    this.sqLiteDataSource = sqLiteDataSource;
}
 

import org.sqlite.SQLiteDataSource; //导入依赖的package包/类
@Test
public void testEqualsAndHashCode() {
    SQLiteDataSource ds1 = new SQLiteDataSource(new SQLiteConfig());
    ds1.setUrl("foo");
    SQLiteDataSource ds2 = new SQLiteDataSource(new SQLiteConfig());
    ds2.setUrl("bar");
    EqualsVerifier.forClass(OffHeapPersistence.class)
            .suppress(Warning.NULL_FIELDS, Warning.STRICT_INHERITANCE)
            .withPrefabValues(SQLiteDataSource.class, ds1, ds2)
            .verify();
}
 

import org.sqlite.SQLiteDataSource; //导入依赖的package包/类
@Test
public void testEqualsAndHashCode() {
    SQLiteDataSource ds1 = new SQLiteDataSource(new SQLiteConfig());
    ds1.setUrl("foo");
    SQLiteDataSource ds2 = new SQLiteDataSource(new SQLiteConfig());
    ds2.setUrl("bar");
    EqualsVerifier.forClass(DiskPersistence.class)
            .suppress(Warning.NULL_FIELDS, Warning.STRICT_INHERITANCE)
            .withPrefabValues(SQLiteDataSource.class, ds1, ds2)
            .verify();
}
 

import org.sqlite.SQLiteDataSource; //导入依赖的package包/类
@Override
public void before() {
    try {
        super.before();
        dbFile = newFile();
        url = "jdbc:sqlite:" + dbFile.getAbsolutePath();
        dataSource = new SQLiteDataSource(config);
        dataSource.setUrl(url);
    }
    catch (Throwable throwable) {
        throw new IllegalStateException(throwable);
    }
}
 

import org.sqlite.SQLiteDataSource; //导入依赖的package包/类
SQLiteDataSourceWrapper(Properties props) {
	SQLiteConfig config = new SQLiteConfig(props);
	String dbName = props.getProperty(DataSourceFactory.JDBC_DATABASE_NAME);
	
	wrapped = new SQLiteDataSource(config);
	wrapped.setUrl(wrapped.getUrl() + dbName);
}
 

import org.sqlite.SQLiteDataSource; //导入依赖的package包/类
@Override
public DataSource newDataSource() throws SQLException {
    return new SQLiteDataSource();
}