View Single Post
  #2  
Old 09-11-2017, 10:01 PM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: Database questions

Quote:
Originally Posted by classw
First is there any similar data table layout documentation for version 5.3.3? I found this one (https://help.x-cart.com/index.php?title=X-Cartatabase_layout)

The site for X-Cart 5 developers is here:
http://devs.x-cart.com/

There is no database chart for X-Cart 5 because the layout depends on installed modules.
There are many modules that alter the database, so any ready-made chart won't work for most of X-Cart users.

Quote:
Originally Posted by classw
The second question: We are much better mySQL/Nodejs programmers than PHP programmers. What are the implications of just doing direct data inserts and updates into the data tables for adding/updating products, categories, and orders?

By sending direct queries you risk to break the database consistency. It is highly recommended to avoid this in X-Cart 5.

X-Cart 5 uses an ORM library (Doctrine 2). You can start reading about working with the database from there:
http://devs.x-cart.com/en/basics/understanding_models.html
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote