public void TestWithTempFile()
{
SQLiteLib.createDB(@"new-test-3.db", false, false);
bool isConnect = SQLiteLib.connect();
Assert.AreEqual(true, isConnect);
}
public void TestWithCreateDBEncryptJSONFileAndNoPassword()
{
SQLiteLib.createDB(@"new-test.db", true, true);
bool isConnect = SQLiteLib.connect();
Assert.AreEqual(true, isConnect);
}
public void TestWithCreateDBNotEncryptJSONFileAndSetPassword()
{
SQLiteLib.createDB(@"new-test-2.db", "p@ssw0rd", true, false);
bool isConnect = SQLiteLib.connect();
Assert.AreEqual(true, isConnect);
}
static void Main(string[] args)
{
string dbName = "";
string password = "";
bool saveJson = false;
bool isEncrypt = false;
Console.WriteLine("Welcome to SQLiteLib Demo!");
Console.WriteLine("Created by SakaDream");
Console.WriteLine("---------------------------------------------");
Console.WriteLine("Before creating database. Please setting some things...");
Console.Write("Your database name: ");
dbName = Console.ReadLine();
while (true)
{
Console.Write("Create db with password? (y / n)? ");
string ans = Console.ReadLine();
if (ans.Equals("y", StringComparison.InvariantCultureIgnoreCase))
{
Console.WriteLine("If you use Unicode Input Method, such as Unikey, Japanese IME,... Please turn off this or change to English mode");
Console.Write("Your password: "******"^[a-zA-Z0-9]*$");
var key = Console.ReadKey(true);
if (key.Key == ConsoleKey.Enter)
{
Console.WriteLine();
break;
}
else if (regexItem.IsMatch(key.KeyChar.ToString()))
{
password += key.KeyChar;
}
}
break;
}
else if (ans.Equals("n", StringComparison.InvariantCultureIgnoreCase))
{
break;
}
}
while (true)
{
Console.Write("Save connection string to json file? (y / n)? ");
string ans = Console.ReadLine();
if (ans.Equals("y", StringComparison.InvariantCultureIgnoreCase))
{
saveJson = true;
while (true)
{
Console.Write("Encrypt json file? (y / n)? ");
string ansEncrypt = Console.ReadLine();
if (ansEncrypt.Equals("y", StringComparison.InvariantCultureIgnoreCase))
{
isEncrypt = true;
break;
}
else if (ansEncrypt.Equals("n", StringComparison.InvariantCultureIgnoreCase))
{
isEncrypt = false;
break;
}
}
break;
}
else if (ans.Equals("n", StringComparison.InvariantCultureIgnoreCase))
{
saveJson = false;
break;
}
}
Console.WriteLine("Creating test.db file...");
SQLiteLib.createDB(dbName, password, saveJson, isEncrypt);
SQLiteLib.updateQuery(@"CREATE TABLE 'TEST' ('ID' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'NAME' TEXT NOT NULL, 'GENDER' INTEGER NOT NULL DEFAULT 0 CHECK(GENDER == 0 OR GENDER == 1), 'SALARY' REAL DEFAULT 0)");
Console.WriteLine("---------------------------------------------");
string name;
int gender, salary;
Console.WriteLine("Please input some information");
Console.Write("Name: ");
name = Console.ReadLine();
Console.Write("Gender (1 is male, 0 is female) : ");
gender = Convert.ToInt32(Console.ReadLine());
Console.Write("Salary: ");
salary = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("---------------------------------------------");
Console.WriteLine("Inserting record to database...");
SQLiteLib.updateQuery(string.Format(@"INSERT INTO TEST (NAME, GENDER, SALARY) VALUES ('{0}', {1}, {2})", name, gender, salary));
Console.WriteLine("---------------------------------------------");
Console.WriteLine("Show all records in database...");
SQLiteDataReader reader = SQLiteLib.selectQuery(@"SELECT * FROM TEST");
while (reader.Read())
{
Console.WriteLine("ID: " + reader[0]);
Console.WriteLine("Name: " + reader[1]);
Console.WriteLine("Gender: " + reader[2]);
Console.WriteLine("Salary: " + reader[3]);
}
Console.WriteLine("---------------------------------------------");
Console.WriteLine("Press any key to exit...");
Console.Read();
}