Difference between revisions of "Developing"

From Gestinux Wiki
Jump to navigation Jump to search
Line 22: Line 22:
  
 
*  Zeos DBO  
 
*  Zeos DBO  
** For 32 bits compilers : ZEOSLIB 6.6.6 works fine
+
** For 32 bits compilers : ZEOSLIB 6.6.6 works fine, but
 
*** [https://sourceforge.net/projects/zeoslib/files/Zeos%20Database%20Objects/zeosdbo-6.6.6-stable/ZEOSDBO-6.6.6-stable.zip/download Download] the package and unzip to any directory.
 
*** [https://sourceforge.net/projects/zeoslib/files/Zeos%20Database%20Objects/zeosdbo-6.6.6-stable/ZEOSDBO-6.6.6-stable.zip/download Download] the package and unzip to any directory.
 
*** [http://gestinux.svn.sourceforge.net/viewvc/gestinux/trunk/util/zeos/ZClasses.pas Download a patch for src/core/ZClasses.pas] and replace the file, to work with FPC >= 2.6 (See [http://zeos.firmos.at/viewtopic.php?t=3073 this discussion])
 
*** [http://gestinux.svn.sourceforge.net/viewvc/gestinux/trunk/util/zeos/ZClasses.pas Download a patch for src/core/ZClasses.pas] and replace the file, to work with FPC >= 2.6 (See [http://zeos.firmos.at/viewtopic.php?t=3073 this discussion])
 
*** [http://zeos.firmos.at/download.php?id=662 Download a patch for src/plain/ZPlainMySql5.pas] and replace the file to make installation easier with MySql 5.1 on Linux Ubuntu >= 09.10 (See [http://zeos.firmos.at/viewtopic.php?p=15885 this discussion])
 
*** [http://zeos.firmos.at/download.php?id=662 Download a patch for src/plain/ZPlainMySql5.pas] and replace the file to make installation easier with MySql 5.1 on Linux Ubuntu >= 09.10 (See [http://zeos.firmos.at/viewtopic.php?p=15885 this discussion])
 
*** Then, open packages/lazarus/zcomponent.lpk and click Install
 
*** Then, open packages/lazarus/zcomponent.lpk and click Install
** If you have a 64 bits system, ZEOSLIB 7.0 is requested. Some functionalities are not working. we are currently investigating.
+
** If you want to compile and run on a 64 bits system, ZEOSLIB 7.0.2 is requested and works fine.
*** [http://sourceforge.net/projects/zeoslib/files/Zeos%20Database%20Objects/zeosdbo-7.0.0-alpha/ZEOSDBO-7.0.0-alpha.zip/download Download] the package and unzip to any directory or, better, use SVN to get the latest version.
+
*** Get the sources with svn checkout svn://svn.code.sf.net/p/zeoslib/code-0/trunk zeoslib-code-0
*** Then, open packages/lazarus/zcomponent.lpk and click Install
+
*** Open packages/lazarus/zcomponent.lpk and click Install
 
* Power PDF 0.9.7.1
 
* Power PDF 0.9.7.1
 
** [https://sourceforge.net/projects/lazarus-ccr/files/PowerPDF/PowerPDF%20v0.9.7/powerpdf_0.9.7.1_20111207.tar.gz/download Download] the package and unzip to any directory.
 
** [https://sourceforge.net/projects/lazarus-ccr/files/PowerPDF/PowerPDF%20v0.9.7/powerpdf_0.9.7.1_20111207.tar.gz/download Download] the package and unzip to any directory.

Revision as of 19:06, 20 November 2012

 Français

Developing Gestinux

You are welcome to help making Gestinux better.

Here are some rules to maintain the project. We can discuss about it in the development forum.

Gestinux is developed with Lazarus 1.0.2 and FreePascal 2.6.0.

Get the sources

Sources are managed with subversion. You must use a SVN Client and connect to it as explained by SourceForge.

Version 1.0 is nearly finished and currently released as a beta version. The svn branch is "trunk".

Version 0.5 is probably obsolete, due to changes in FPC, and we don't plan to change anything in this branch.

Packages used

Release 1.0 should compile with the following packages. You can use more recent versions of the packages, but at your own risks !

  • Zeos DBO
  • Power PDF 0.9.7.1
    • Download the package and unzip to any directory.
    • Open pack_powerpdf.lpk
    • Install.
  • LazReport 0.9.8
    • Open components/lazreport/source/lazreport.lpk in the installation folder of Lazarus (/usr/share/lazarus/<version> on Linux)
    • In Options, IDE integration, select "automatically rebuild as needed"
    • Install.
  • LazReportPDFExport 0.7
    • Open components/lazreport/source/addons/pdfexport/lazreportpdfexport.lpk in Lazarus installed files.
    • In Options, IDE integration, select "automatically rebuild as needed"
    • Install
  • Gestinux_util : package containing components used by gestinux
    • Open util/gestinux_util.dpk in the gestinux sources
    • Install.

Sometimes, for unknow reasons, you have to rebuild lazarus with option clean+build all... Installing and rebuilding after each package is longer, but safer. Otherwise you will often get problems.

Rules for development

  • Source must be compilable with : Lazarus 1.0.2, FPC 2.6.0
  • Do not use features available only in Lazarus 1.1 or other SVN.
  • Use only English for identifiers and comments.
  • Use Jedi Code formater to indent your sources, with default options.
  • Read gestinux_util documentation, and do not use component Txxxx when there is a TGxxxx in this package

Ask to be granted a developer profile in SourceForge. Don't forget to lock the files before any change.

What to do

Everyone can help ! If you are a beginner, there are some simple things to do, and this would save time. For gurus, we do need better components.

You can look at Tracker to see what is the most useful to do. But some coordination with the project manager is better before you start anything !

Translation system

Refer to the translation documentation page to learn how you can use it and make translations,

Database

Supported DBMS

MySql 5 and PostgreSQL are supported. My Sql because it is common and administration is simpler. PostgreSql because it is a true free software. In the future, we may try other DBMS, but it requires a larger team to go forward.

In the main sources, avoid SQL statements specific to MySQL or Postgres. When there is no alternative, compatibility procedures should be made. They are all centralized in one unit (unitdatamodule.pas for now).

Table and fields definitions and properties

In Gestinux_util there is a TGTable component used to store metadata of tables used in Gestinux. With this component, there is no need to store table definitions elsewhere, and no sql script is required to initialize or upgrade the database.

The database and tables are created by the main executable, as specified in unitdatamodule.pas properties of TGTable and TFields objects.

Index and constraints are stored in the "properties" property of TGTable, with special processing depending on the DBMS.

To add a new field or index or constraint

To add a new data field to an existing table :

  • Create the new field using any MySql client, with the required and default properties as expected.
  • Add the field in the TGTable object
  • If needed add a line in the property Table.Properties to define index and/or constraint.
  • After that, on a new database, the missing field will be added by TGTable.Check. Test it with old databases, and check in MySql.

Other changes

Some changes of datatype, required and default properties are possible, if really necessary. They must be compatible with older release.

No field or index deletion is possible.