Forum

Tao 3.3 - Database / Tables - Where Items, Tests etc. are saved

edited November 2019 in Developers

Hello.

I have just started using Tao 3.3.

Environment
Windows 10
WAMP Server + MySQL

I have created Items, Tests etc. But do not identify in which table it is stored. Please tell me how this is saved in the database and its corresponding table names.

I am waiting for the reply.

Regards & Thanks,
Amit.

Comments

  • Data is split between the database and generis. The database schema can be found here https://forge.taotesting.com/attachments/396/tao-database-schema.png

    The content for the Items themselves is stored in XML format within the data directory.

  • edited November 2019

    As per this URL https://forge.taotesting.com/attachments/396/tao-database-schema.png I do not find the table 'extensions' in my database, but other tables 'models' and 'statements' are available along with other 9 tables, altogether there are total 11 tables.

    I do not understand what type of data is stored in these tables.

    I found the below folders.
    tao\data\taoItems
    tao\data\taoQtiTest

    Do you mean these folders with xml files inside it? I found the names of items, tests etc. are available in these files.

    1. Where are other information such as Test-takers, Groups, Deliveries, Results are stored?
    2. Is there any information available about database? Nothing is available in user guide https://userguide.taotesting.com/3.3/.

    I am waiting for the reply and help.

  • Please take a look at:

    https://en.wikipedia.org/wiki/Resource_Description_Framework
    and
    https://hub.taotesting.com/articles/rdf-by-example

    Armed with this knowledge take a look at the "statements" table, which is an implementation of RDF in a SQL database. Here you can find item and test metadata and references to the filesystem.

    The results are stored in 2 dedicated tables: results_storage and variables_storage

  • Hi Joel.

    Many thanks for the reply and referencing the resources. I do not aware about this. Now it has stated clearing to me.

    Is there anything stored in files physically?

    Can you tell me how do I use Tao's library in my own PHP code?

    I am waiting for the reply. Please help.

    Regards & Thanks,
    Amit

  • As mentioned there is data stored physically in files under your data location

  • In my installation folder, I find the below folders.

    tao\data\tao\
    tao\data\taoItems\
    tao\data\taoQtiTest\
    tao\data\taoQtiTestSessionFilesystem\
    tao\data\taskQueueStorage\

    Here I find the information I saved using Tao admin for items and test. But where do I get the result information.

    Please help amy. Thanks in advane.

  • The link to the schema (https://forge.taotesting.com/attachments/396/tao-database-schema.png) is dead. Is there a working link for this information?

Sign In or Register to comment.

We use cookies on our website to support technical features that enhance your user experience. Cookie Policy Privacy Policy

×