Ticket #62 (closed enhancement: fixed)

Opened 1 year ago

Last modified 2 months ago

Logging to a RDBMS

Reported by: fcohen Assigned to: fcohen
Priority: critical Milestone:
Version: 5.1 Keywords: log database schema table
Cc:

Description

Logging to a database, log directly into a database table and PushToTest will publish the schema so users can write custom reports (using Jasper and others). Possibly include the Derby DB in TestMaker or possibly DB4O.com.

Attachments

TM5-ResultSystem.pdf (118.1 kB) - added by fcohen on 07/05/07 20:05:09.
TMDBSchema-1.architect (27.1 kB) - added by fcohen on 07/05/07 20:05:25.
TMDBSchmaDrawing.html.pdf (185.9 kB) - added by fcohen on 07/05/07 20:05:45.
TMDBSchema.architect (23.8 kB) - added by fcohen on 08/07/07 10:41:57.
Updated schema definition

Change History

06/23/07 05:37:51 changed by fcohen

  • owner changed from wmartinez@avantica.net to fcohen.
  • status changed from new to assigned.

07/05/07 20:05:09 changed by fcohen

  • attachment TM5-ResultSystem.pdf added.

07/05/07 20:05:25 changed by fcohen

  • attachment TMDBSchema-1.architect added.

07/05/07 20:05:45 changed by fcohen

  • attachment TMDBSchmaDrawing.html.pdf added.

07/05/07 20:06:49 changed by fcohen

Added the design documents to this ticket for everyone's review, comment, feedback. We will be meeting with DBA InfoPower next week to review the design. After that we should be ready to code. Send feedback to fcohen@pushtotest.com

08/07/07 10:34:15 changed by fcohen

  • priority changed from minor to critical.

Luis Carlos wrote:

The database system works using the standard log system. It's a log type with four values connector, url, loggin and password

<logs>

<log type="console" level="info"/> <log type="file" path="mylog.txt" level="info"/> <log type="database"

connector="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/testmaker" loggin="llara" password="12345"/>

</logs>

There can be many DBs-logging.

The system currently needs the database to be created to log in it. I have added the creation query in tm5\TestMaker\templates/ Standard_DB_for_logging.sql The default name of the db is "testmaker" but it can be easily be changed

08/07/07 10:34:53 changed by fcohen

This needs to be tested and then sent over to DBA InfoPower. -Frank

08/07/07 10:41:57 changed by fcohen

  • attachment TMDBSchema.architect added.

Updated schema definition

08/23/07 09:48:26 changed by fcohen

Need to add to the TM5 documentation. Then it's ready to close this ticket. -Frank

08/24/07 11:21:31 changed by fcohen

  • status changed from assigned to closed.
  • resolution set to fixed.

Added documentation on RDBMS logging. -Frank

03/11/08 10:33:39 changed by root

  • milestone changed.

Milestone release deleted