How to add a table to an extension

Ahrim4n · Nov 22nd 2017

Hello,

I am testing Page Kit and I created a simple test extension. However I would like to link this extension to a new table in the pagekit database. I read that it is possible to create the new table in the database according to the official documentation (https://pagekit.com/docs/developer/database) with Utility::createTable($table, \Closure $callback). But I don't understand where to use this and how.

Maybe it is simple to create it directly in the database without command line? Is there a better documentation that explain how to add a new table in the database and link it to an extension that the one on the official website?

Thank you

SPQRInc · Nov 22nd 2017

Hi Ahrim4n

You should create the tables during the installation/update-process. Just check out the migrations. You can also check out some extensions on GitHub as an example (e.g. https://github.com/SPQRInc/pag…s/blob/master/scripts.php).

Once you created the tables, you can access them using the query builder or - I prefer this way - creating a model and using the ORM.

Ahrim4n · Nov 22nd 2017

Thank you!

I am trying this solution. I put this content in my scripts.php:

Code

return [
'install' => function ($app) {
$util = $app['db']->getUtility();
if ($util->tableExists('@content_post') === false) {
$util->createTable('@content_post', function ($table) {
$table->addColumn('id', 'integer', ['unsigned' => true, 'length' => 10, 'autoincrement' => true]);
$table->addColumn('user_id', 'integer', ['unsigned' => true, 'length' => 10, 'default' => 0]);
$table->addColumn('slug', 'string', ['length' => 255]);
$table->addColumn('title', 'string', ['length' => 255]);
$table->addColumn('status', 'smallint');
$table->addColumn('date', 'datetime', ['notnull' => false]);
$table->addColumn('modified', 'datetime');
$table->addColumn('content', 'text');
$table->addColumn('data', 'json_array', ['notnull' => false]);
$table->addColumn('roles', 'simple_array', ['notnull' => false]);
$table->setPrimaryKey(['id']);
$table->addUniqueIndex(['slug'], '@CONTENT_POST_SLUG');
});
}
},
];

Display More

But when I activate the exention it doesn't create anything in the database.

SPQRInc · Nov 22nd 2017

Two things:

This does only work if you are installing your extension. This does not work on updates (so if you already installed your extension, this part will not be executed)
You need to add the scripts.php to composer.json

Ahrim4n · Nov 22nd 2017

Ok I am going forward

When installing the extension I have the message

Code

Loading composer repositories with package information
Updating dependencies
Your requirements could not be resolved to an installable set of packages.

I think there are missing files in the package that I have to identify.

SPQRInc · Nov 22nd 2017

Okay - this is another problem and has nothing to do with ORM/database.

Please check this topic and, if it does not help, create a new topic :).

How to add a table to an extension

Share

Tags