Jump to content



Latest News: (loading..)

- - - - -

Database Documentation Feedback


  • Please log in to reply
9 replies to this topic

#1 ONLINE   Harald Ponce de Leon

Harald Ponce de Leon

    Healthy Giraffe

  • Core Team
  • 4,028 posts
  • Real Name:Harald Ponce de Leon
  • Gender:Male
  • Location:Solingen, Germany

Posted 17 January 2012 - 09:26 PM

Hi All..

The first draft article documenting the database class is ready for feedback! Please take a look and provide suggestions for improvements.

http://forums.oscommerce.com/page/docs/_/oscom/30/developers/database-connections-and-queries-r9

Thanks,
Harald Ponce de Leon

#2 ONLINE   burt

burt

    Code Monkey

  • Community Team
  • 7,871 posts
  • Real Name:G Burton
  • Gender:Male
  • Location:UK/DEV/on

Posted 19 January 2012 - 01:08 PM

Looks good Harald.

I suspect the typical shop owner will not understand 90% of it, and the typical developer might not need so much information...or in other words;

who is the documentation aimed at?  If it is for the shop owners, perhaps some less technical and more "flowery" words can be used?
Dummies guide to designing osCommerce 2.3 Click Me

Or maybe a ready made theme for your shop ??

Warning: My posts may contain Horsemeat.

#3 ONLINE   Harald Ponce de Leon

Harald Ponce de Leon

    Healthy Giraffe

  • Core Team
  • 4,028 posts
  • Real Name:Harald Ponce de Leon
  • Gender:Male
  • Location:Solingen, Germany

Posted 19 January 2012 - 06:20 PM

Hi Gary..

Thanks for the feedback! The Developers chapter is aimed at those working with the source code and API.

API documentation will also be made available to document class methods and parameters, however it will not provide examples of usage. This is where the Developers chapter comes in to describe how to do stuff with the framework.

More articles will be posted after v3.0.3 - the next ones will document the architecture of the framework and how Sites and Applications work.

Kind regards,
Harald Ponce de Leon

#4   foxp2

foxp2

    strong as a Twig

  • Banned
  • 310 posts
  • Real Name:Laurent
  • Gender:Male
  • Location:France

Posted 20 January 2012 - 07:19 PM

hi harald,
Can I have your permission to translate in french this documentation ?
a forum section was set up : http://www.oscommerce-fr.info/forum/index.php?showforum=34
thanks.
Kind regards,
-------------------

#5   foxp2

foxp2

    strong as a Twig

  • Banned
  • 310 posts
  • Real Name:Laurent
  • Gender:Male
  • Location:France

Posted 21 January 2012 - 12:29 PM

database schema : http://goo.gl/OeXui
designed with Power AMC
-------------------

#6 ONLINE   Harald Ponce de Leon

Harald Ponce de Leon

    Healthy Giraffe

  • Core Team
  • 4,028 posts
  • Real Name:Harald Ponce de Leon
  • Gender:Male
  • Location:Solingen, Germany

Posted 22 January 2012 - 01:11 PM

Hi Laurent..

View Postfoxp2, on 20 January 2012 - 07:19 PM, said:

Can I have your permission to translate in french this documentation ?
a forum section was set up : http://www.oscommerce-fr.info/forum/index.php?showforum=34

It's possible to do that here and have added a new French section to the documentation:

http://forums.oscommerce.com/page/docs-fr

You should have access to add and edit entries in the categories.

This can be further worked on to allow others to help out as well and to do the same for other languages.

Kind regards,
Harald Ponce de Leon

#7   foxp2

foxp2

    strong as a Twig

  • Banned
  • 310 posts
  • Real Name:Laurent
  • Gender:Male
  • Location:France

Posted 23 January 2012 - 12:36 PM

View PostHarald Ponce de Leon, on 22 January 2012 - 01:11 PM, said:


It's possible to do that here and have added a new French section to the documentation:

hi Harald,
great idea ! :thumbsup:
work in progress : https://docs.google.com/document/d/1hdKYUfQ4Gd4MnXWQqtn8hPuvnIsckkrplskj23CiL-w/edit?pli=1
thanks,
Kind regards,
-------------------

#8 ONLINE   Harald Ponce de Leon

Harald Ponce de Leon

    Healthy Giraffe

  • Core Team
  • 4,028 posts
  • Real Name:Harald Ponce de Leon
  • Gender:Male
  • Location:Solingen, Germany

Posted 23 January 2012 - 06:17 PM

Hi Laurent..

You should now be able to edit the English articles to see the raw article with bbcodes. This should make it easier for you to copy and translate. :thumbsup:

Kind regards,
Harald Ponce de Leon

#9   foxp2

foxp2

    strong as a Twig

  • Banned
  • 310 posts
  • Real Name:Laurent
  • Gender:Male
  • Location:France

Posted 23 January 2012 - 06:56 PM

hi Harald,
your suggestion, as usual, is a relevant one.
thanks !
Kind regards,
-------------------

#10   foxp2

foxp2

    strong as a Twig

  • Banned
  • 310 posts
  • Real Name:Laurent
  • Gender:Male
  • Location:France

Posted 24 January 2012 - 12:02 PM

hi harald,

in the end of article, you wrote :

Quote

The MySQL\Standard driver automatically checks and performs the constraint actions each time an update or delete sql query is executed.
i prefer  :

Quote

With the MySQL\Standard driver, the osCommerce\OM\Core\PDO\MySQL\Standard\PDOStatement::execute()
class method automatically checks and performs the constraint actions each time an update or delete sql query is executed.
:mellow:
-------------------