<commit_before>## What is it ?

It's an iOS SQLite 3 Connect API Library to make database with app, that you need to add a framework of Apple named "libsqlite3.0.dylib" first.

## How To Get Started

``` objective-c
#import "KRDatabase.h".
//A sample of making a table.
-(void)createTables{
	KRDatabase *_krDatabase = [[KRDatabase alloc] initWaitingForConnection];
	if( [_krDatabase databaseExists] ){
		[_krDatabase connectDatabase];
		NSDictionary *tableParamsDict = [NSDictionary dictionaryWithObjectsAndKeys:
                                         @"INTEGER PRIMARY KEY AUTOINCREMENT", @"journal_id",
                                         @"TEXT DEFAULT 'NO'", @"journal_title",
                                         @"TEXT DEFAULT 'NO'", @"journal_desc",
                                         @"DATETIME DEFAULT CURRENT_TIMESTAMP", @"journal_date",
                                         @"VARCHAR DEFAULT 'Life'", @"journal_type",
                                         nil];
    	[_krDatabase createTablesWithName:@"journal" andParams:tableParamsDict];        
    }
}

//SELECT
[[KRDatabase sharedManager] execSelect:@"SELECT * FROM sample_table WHERE sample_id = 1"];
//UPDATE
[[KRDatabase sharedManager] execSelect:@"UPDATE sample_table SET sample_name = 'WOW' WHERE sample_id = 1"];
//DELETE
[[KRDatabase sharedManager] execSelect:@"DELETE FROM sample_table WHERE sample_id = 1"];
```

## Version

V1.2
<commit_msg>Fixed Sample Description.<commit_after>## What is it ?

It's an iOS SQLite 3 Connect API Library to make database with app, that you need to add a framework of Apple named "libsqlite3.0.dylib" first.

## How To Get Started

``` objective-c
#import "KRDatabase.h".
//A sample of making a table.
-(void)createTables{
	KRDatabase *_krDatabase = [[KRDatabase alloc] initWaitingForConnection];
	if( [_krDatabase databaseExists] ){
		[_krDatabase connectDatabase];
		NSDictionary *tableParamsDict = [NSDictionary dictionaryWithObjectsAndKeys:
                                         @"INTEGER PRIMARY KEY AUTOINCREMENT", @"journal_id",
                                         @"TEXT DEFAULT 'NO'", @"journal_title",
                                         @"TEXT DEFAULT 'NO'", @"journal_desc",
                                         @"DATETIME DEFAULT CURRENT_TIMESTAMP", @"journal_date",
                                         @"VARCHAR DEFAULT 'Life'", @"journal_type",
                                         nil];
    	[_krDatabase createTablesWithName:@"journal" andParams:tableParamsDict];        
    }
}

//SELECT
NSMutableArray *results = [[KRDatabase sharedManager] execSelect:@"SELECT * FROM sample_table WHERE sample_id = 1"];
for( NSDictionary *_eachRows in results )
{
    NSString *_row1 = [_eachRows objectForKey:@"sample_row1"];
    //...
}
//UPDATE
[[KRDatabase sharedManager] execQuery:@"UPDATE sample_table SET sample_name = 'WOW' WHERE sample_id = 1"];
//DELETE
[[KRDatabase sharedManager] execQuery:@"DELETE FROM sample_table WHERE sample_id = 1"];
```

## Version

V1.2

{'fraction_non_alphanumeric': 0.10865986170563055, 'fraction_numerical': 0.005926901547579849, 'mean_word_length': 2.4759725400457664, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 24, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5841404', 'n_tokens_mistral': 833, 'n_tokens_neox': 757, 'n_words': 239}