301 Days (redux)

Another metric leap year of gamedev experiments and such

Jan 5, 2016 - OldDays drag-spin-exp

Day 43 - Happy New Year

Retroactive Resolution for 2016: Take a solid week off at the beginning of the year before blogging again.

In truth, I’ve simply lost a bit of time to work and illness and Fallout 4.

Coding

Ok, now to make the server put its log in the database, so we can test it more easily. A table in the database:

DragonsSpine/SQL Scripts/Log.sql GitLab 
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43

CREATE TABLE [dbo].[Log](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [logtime] [datetime] NOT NULL,
    [logtype] [nvarchar](50) NULL,
    [message] [nvarchar](max) NULL,
 CONSTRAINT [PK__Log__03A67F89] PRIMARY KEY NONCLUSTERED 
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE [dbo].[Log] ADD  CONSTRAINT [DF_Log_LogTime]  DEFAULT (getdate()) FOR [logtime]
GO

and a stored procedure to add entries:

DragonsSpine/SQL Scripts/prApp_Log_Add.sql GitLab 
18
19
20
21
22
23
24
25
26
27
28

CREATE PROCEDURE [dbo].[prApp_Log_Add] 
    -- Add the parameters for the stored procedure here
    @logtype nvarchar(50) = '', 
    @message nvarchar(MAX) = ''
AS

    -- Insert statements for procedure here
    INSERT Log(logtype, message)
    VALUES (@logtype, @message);
    
GO

and the code to call it:

DragonsSpine/DAL/DBLog.cs GitLab 
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

internal static int addLogEntry(string message, string logType)
{
    try
    {
        SqlStoredProcedure sp = new SqlStoredProcedure("prApp_Log_Add", DataAccess.GetSQLConnection());
        sp.AddParameter("@logtype", SqlDbType.NVarChar, 50, ParameterDirection.Input, logType);
        sp.AddParameter("@message", SqlDbType.NVarChar, 250, ParameterDirection.Input, message);

        int rc = sp.ExecuteNonQuery();
        // Console.WriteLine("addLogEntry rows affected: " + rc + ".");

        return rc;
    }
    catch (Exception e)
    {
        Utils.LogException(e);
        Console.WriteLine("addLogEntry exception " + e.ToString() + ".");
        return -1;
    }
}

(Are we really creating a new connection for each log call? For the moment, yes.)

DragonsSpine/GameSystems/Utilities/Utils.cs GitLab 
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215

try
{
    int result = DAL.DBLog.addLogEntry(message, logType.ToString());
    if (result < 1)
        Console.WriteLine(DateTime.Now.ToString() + ": Utils.Log(" + message + ", " + logType.ToString() + ") database entry result is " + 
                          result + ".");
}
catch (System.IO.IOException)
{
    Console.WriteLine(DateTime.Now.ToString() + ": Threw an IOException at Utils.Log(" + message + ", " + logType.ToString() + ").");
    Console.Write("> ");
}
catch (Exception)
{
    Console.WriteLine(DateTime.Now.ToString() + ": Threw an Exception at Utils.Log(" + message + ", " + logType.ToString() + ").");
    Console.Write("> ");
}

(Will I ever get an IOException here? Doubtful. Admitted cut-and-paste from other pieces of logging code.)

And presto:

Now this we can use. Now this we can use.

So let’s add some other saved procedures for easy access:

DragonsSpine/SQL Scripts/prApp_Log_Get_MaxID.sql GitLab 
16
17
18
19
20
21
22
23
24

CREATE PROC [dbo].[prApp_Log_Get_MaxID]

AS

SELECT TOP 1 *
  FROM Log
  ORDER BY id DESC

GO
DragonsSpine/SQL Scripts/prApp_Log_By_MinID.sql GitLab 
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

CREATE PROC [dbo].[prApp_Log_By_MinID]
    @minId int

AS

SELECT  *
FROM    Log
WHERE id >= @minId
ORDER BY id

GO

That should make it easy to remember a point in time, run a test, and then grab everything that happened during it. Note my avoidance of using the timestamps, which can sometimes be a pain to deal with. (Should I have made the ID something larger than int? Are the logs that busy? Time will certainly tell.)

Fandom and Jamming and Learning and Stuff

More to come

Day 43 code - server