using System;

using System.Threading.Tasks;

#if NETFX_CORE

using Microsoft.VisualStudio.TestPlatform.UnitTestFramework;

using SetUp = Microsoft.VisualStudio.TestPlatform.UnitTestFramework.TestInitializeAttribute;

using TestFixture = Microsoft.VisualStudio.TestPlatform.UnitTestFramework.TestClassAttribute;

using Test = Microsoft.VisualStudio.TestPlatform.UnitTestFramework.TestMethodAttribute;

#else

using NUnit.Framework;

#endif

namespace SQLite.Tests

{

[TestFixture]

public class DateTimeTest

{

const string DefaultSQLiteDateTimeString = "yyyy'-'MM'-'dd'T'HH':'mm':'ss'.'fff";

class TestObj

{

[PrimaryKey, AutoIncrement]

public int Id { get; set; }

public string Name { get; set; }

public DateTime ModifiedTime { get; set; }

}

[Test]

public void AsTicks ()

{

var dateTime = new DateTime (2012, 1, 14, 3, 2, 1, 234);

var db = new TestDb (storeDateTimeAsTicks: true);

TestDateTime (db, dateTime, dateTime.Ticks.ToString ());

}

[Test]

public void AsStrings ()

{

var dateTime = new DateTime (2012, 1, 14, 3, 2, 1, 234);

var db = new TestDb (storeDateTimeAsTicks: false);

TestDateTime (db, dateTime, dateTime.ToString (DefaultSQLiteDateTimeString));

}

[TestCase ("o")]

[TestCase ("MMM'-'dd'-'yyyy' 'HH':'mm':'ss'.'fffffff")]

public void AsCustomStrings (string format)

{

var dateTime = new DateTime (2012, 1, 14, 3, 2, 1, 234);

var db = new TestDb (CustomDateTimeString (format));

TestDateTime (db, dateTime, dateTime.ToString (format, System.Globalization.CultureInfo.InvariantCulture));

}

[Test]

public void AsyncAsTicks ()

{

var dateTime = new DateTime (2012, 1, 14, 3, 2, 1, 234);

var db = new SQLiteAsyncConnection (TestPath.GetTempFileName (), true);

TestAsyncDateTime (db, dateTime, dateTime.Ticks.ToString ());

}

[Test]

public void AsyncAsString ()

{

var dateTime = new DateTime (2012, 1, 14, 3, 2, 1, 234);

var db = new SQLiteAsyncConnection (TestPath.GetTempFileName (), false);

TestAsyncDateTime (db, dateTime, dateTime.ToString (DefaultSQLiteDateTimeString));

}

[TestCase ("o")]

[TestCase ("MMM'-'dd'-'yyyy' 'HH':'mm':'ss'.'fffffff")]

public void AsyncAsCustomStrings (string format)

{

var dateTime = new DateTime (2012, 1, 14, 3, 2, 1, 234);

var db = new SQLiteAsyncConnection (CustomDateTimeString (format));

TestAsyncDateTime (db, dateTime, dateTime.ToString (format,System.Globalization.CultureInfo.InvariantCulture));

}

SQLiteConnectionString CustomDateTimeString (string dateTimeFormat) => new SQLiteConnectionString (TestPath.GetTempFileName (), SQLiteOpenFlags.Create | SQLiteOpenFlags.ReadWrite, false, dateTimeStringFormat: dateTimeFormat);

void TestAsyncDateTime (SQLiteAsyncConnection db, DateTime dateTime, string expected)

{

db.CreateTableAsync<TestObj> ().Wait ();

TestObj o, o2;

//

// Ticks

//

o = new TestObj {

ModifiedTime = dateTime,

};

db.InsertAsync (o).Wait ();

o2 = db.GetAsync<TestObj> (o.Id).Result;

Assert.AreEqual (o.ModifiedTime, o2.ModifiedTime);

var stored = db.ExecuteScalarAsync<string> ("SELECT ModifiedTime FROM TestObj;").Result;

Assert.AreEqual (expected, stored);

}

void TestDateTime (TestDb db, DateTime dateTime, string expected)

{

db.CreateTable<TestObj> ();

TestObj o, o2;

//

// Ticks

//

o = new TestObj {

ModifiedTime = dateTime,

};

db.Insert (o);

o2 = db.Get<TestObj> (o.Id);

Assert.AreEqual (o.ModifiedTime, o2.ModifiedTime);

var stored = db.ExecuteScalar<string> ("SELECT ModifiedTime FROM TestObj;");

Assert.AreEqual (expected, stored);

}

class NullableDateObj

{

public DateTime? Time { get; set; }

}

[Test]

public async Task LinqNullable ()

{

foreach (var option in new[] { true, false }) {

var db = new SQLiteAsyncConnection (TestPath.GetTempFileName (), option);

await db.CreateTableAsync<NullableDateObj> ().ConfigureAwait (false);

var epochTime = new DateTime (1970, 1, 1);

await db.InsertAsync (new NullableDateObj { Time = epochTime });

await db.InsertAsync (new NullableDateObj { Time = new DateTime (1980, 7, 23) });

await db.InsertAsync (new NullableDateObj { Time = null });

await db.InsertAsync (new NullableDateObj { Time = new DateTime (2019, 1, 23) });

var res = await db.Table<NullableDateObj> ().Where (x => x.Time == epochTime).ToListAsync ();

Assert.AreEqual (1, res.Count);

res = await db.Table<NullableDateObj> ().Where (x => x.Time > epochTime).ToListAsync ();

Assert.AreEqual (2, res.Count);

}

}

}

}