Project Technical report - Ideas

Post

Posted
Rating:
#1 (In Topic #308)
Avatar
Expert
Quincunxian is in the usergroup ‘Expert’
Greetings all - I'm in the last phases of writing a utility to quickly view information about your Gambas projects.

I have two last objectives before I say 'It's done'

Technical report
I want to be able to create a technical summary report on any selected project.
This would have all the details from the .project file as the header with all the components used, forms, modules and user created class information.
<LIST>
  • <LI>I can simply print out the source code of each of these. (and that may well be enough)</LI>
</LIST>
<LIST>
  • <LI>List any image/multimedia/other files used.</LI>
</LIST>
<LIST>
  • <LI>If a configuration file is used then a copy of the existing file.</LI>
</LIST>
<LIST>
  • <LI>If a database is used then the table schemas</LI>
</LIST>

Is there anything else that you may find useful?

Semi-automated Help Document builder for any Gambas project.
<LIST>
  • <LI>The help document would be html with a css file for a simple menu system if required.</LI>
</LIST>
<LIST>
  • <LI>It can be as simple as a single page for a tiny project to multiple pages for a larger projects.</LI>
</LIST>
<LIST>
  • <LI>The builder will create all the web documents and leave a place holder for a screen shot of any form for you to add later.</LI>
</LIST>
<LIST>
  • <LI>Bookmarks can be added for any input controls on a form by form basis to provide a detailed explanations.</LI>
</LIST>

<LIST>
  • <LI>You can add 'empty' pages for other information that you want to add.</LI>
</LIST>
There would be some sample code to show how to quickly implement a simple help system in your application.

Is there anything else that you think should be added?

Any input would be greatly appreciated.

Cheers - Quin.
I code therefore I am
Online now: No Back to the top

Post

Posted
Rating:
#2
Avatar
Regular
Cedron is in the usergroup ‘Regular’
 How about a third one?  Might be a big one to pile on.

I highly recommend that you provide the ability to divert the reported information to either easily imported files (say tab delimited tables) or directly into a database (SQLite comes to mind).

This could be really useful.

.... and carry a big stick!
Online now: No Back to the top

Post

Posted
Rating:
#3
Avatar
Expert
Quincunxian is in the usergroup ‘Expert’
Hi Cedron,
In the database section of the utility, you can export data from the database applied to your project
in CSV, XML & JSON formats.  [Is that what you are after ? ]

It also create build scripts for a single or all selected tables.
{This allows you to rebuild your database schema from scratch}

Code (gambas)

  1. DROP TABLE IF EXISTS 'BillingMethod';
  2. CREATE TABLE 'BillingMethod' (
  3. 'Id' INTEGER PRIMARY KEY,
  4. 'BillingMethodName' VARCHAR(255),
  5. 'Information' TEXT,
  6. 'DateCreated' DATE,
  7. 'DateChanged' DATE,
  8. 'UserName' VARCHAR(255));
  9.  

Create INSERT INTO scripts.

Code (gambas)

  1. INSERT INTO BillingMethod(
  2. Id,
  3. BillingMethodName,
  4. Information,
  5. DateCreated,
  6. DateChanged,
  7. UserName,
  8. )
  9.  VALUES(
  10. Id,
  11. 'BillingMethodName'
  12. 'Information'
  13. DateCreated,
  14. DateChanged,
  15. 'UserName'
  16. )
  17.  
  18. --Replace field names in the Value area with the actual value variables
  19.  

It will also create general gambas code for : Declaration, Read & Write as per this example below.

Code (gambas)

  1. '------------Declaration------------
  2. Public BillingMethodName As String
  3. Public Information As String
  4. Public DateCreated As Date
  5. Public DateChanged As Date
  6. Public UserName As String
  7. '------------Read-------------------
  8. Id = $Rec!Id
  9. BillingMethodName = $Rec!BillingMethodName
  10. Information = $Rec!Information
  11. DateCreated = $Rec!DateCreated
  12. DateChanged = $Rec!DateChanged
  13. UserName = $Rec!UserName
  14. '------------Write-------------------
  15. $Rec!Id = Id
  16. $Rec!BillingMethodName = BillingMethodName
  17. $Rec!Information = Information
  18. $Rec!DateCreated = DateCreated
  19. $Rec!DateChanged = DateChanged
  20. $Rec!UserName = UserName
  21.  

If I did not understand the question/request correctly - let me know.

Cheers mate.

Cheers - Quin.
I code therefore I am
Online now: No Back to the top
1 guest and 0 members have just viewed this.