PRDb.h

#import <Cocoa/Cocoa.h>
#include "sqlite3.h"
@class PRHistory;
@class PRLibrary;
@class PRPlaylists;
@class PRLibraryViewSource;
@class PRAlbumArtController;
@class PRPlaybackOrder;
@class PRQueue;
@class PRStatement;
@class PRCore;

extern NSString * const PRFilePboardType;
extern NSString * const PRIndexesPboardType;

typedef NSString PRCol;
extern NSString * const PRColFloat;
extern NSString * const PRColInteger;
extern NSString * const PRColString;
extern NSString * const PRColData;

@interface PRDb : NSObject
- (id)initWithCore:(PRCore *)core;

@property (readwrite, assign) sqlite3 *sqlDb;
@property (readonly) PRHistory *history;
@property (readonly) PRLibrary *library;
@property (readonly) PRPlaylists *playlists;
@property (readonly) PRAlbumArtController *albumArtController;
@property (readonly) PRPlaybackOrder *playbackOrder;
@property (readonly) PRQueue *queue;
- (long)lastInsertRowid;

- (void)begin;
- (void)rollback;
- (void)commit;
- (BOOL)zTransaction:(BOOL(^)(void))block;
- (NSArray *)execute:(NSString *)string;
- (NSArray *)execute:(NSString *)string bindings:(NSDictionary *)bindings columns:(NSArray *)columns;
- (NSArray *)executeCached:(NSString *)string;
- (NSArray *)executeCached:(NSString *)string bindings:(NSDictionary *)bindings columns:(NSArray *)columns;
- (NSArray *)attempt:(NSString *)string;
- (NSArray *)attempt:(NSString *)string bindings:(NSDictionary *)bindings columns:(NSArray *)columns;
- (NSArray *)explain:(NSString *)string;
- (NSArray *)explain:(NSString *)string bindings:(NSDictionary *)bindings columns:(NSArray *)columns;

- (BOOL)zExecute:(NSString *)string;
- (BOOL)zExecute:(NSString *)string bindings:(NSDictionary *)bindings columns:(NSArray *)columns out:(NSArray **)outValue;
- (BOOL)zExecuteCached:(NSString *)string;
- (BOOL)zExecuteCached:(NSString *)string bindings:(NSDictionary *)bindings columns:(NSArray *)columns out:(NSArray **)outValue;

- (NSError *)databaseWasMovedError:(NSString *)newPath;
- (NSError *)databaseCouldNotBeMovedError;
- (NSError *)databaseCouldNotBeInitializedError;
@end