Symfony4 SQLite in memory for testing can't get it to work
-1
I'm trying to use SQLite in memory db to run tests in Symfony 4, but I cant get it to work.
My config looks like this:
doctrine:
dbal:
default_connection: default
connections:
default:
driver: 'pdo_sqlite'
url: ':memory:'
memory: true
#charset: utf8mb4
#default_table_options:
# charset: utf8mb4
# collate: utf8mb4_unicode_ci
php sqlite symfony doctrine in-memory
asked Jan 20 at 11:55
Lord ZedLord Zed
503419
add a comment |
-1
I'm trying to use SQLite in memory db to run tests in Symfony 4, but I cant get it to work.
My config looks like this:
doctrine:
dbal:
default_connection: default
connections:
default:
driver: 'pdo_sqlite'
url: ':memory:'
memory: true
#charset: utf8mb4
#default_table_options:
# charset: utf8mb4
# collate: utf8mb4_unicode_ci
php sqlite symfony doctrine in-memory
asked Jan 20 at 11:55
Lord ZedLord Zed
503419
Which version of Symfony are you using? Is this yourconfig_test.ymlorconfig/packages/test/doctrine.yaml? How does yourphpunit.xml.distlook?
– dbrumann
Jan 20 at 13:44
@dbrumann I've triedconfig/packages/test/doctrine.yamlandphpunit.xml.distbut no success.
– Lord Zed
Jan 23 at 11:33
add a comment |
-1
-1
-1
I'm trying to use SQLite in memory db to run tests in Symfony 4, but I cant get it to work.
My config looks like this:
doctrine:
dbal:
default_connection: default
connections:
default:
driver: 'pdo_sqlite'
url: ':memory:'
memory: true
#charset: utf8mb4
#default_table_options:
# charset: utf8mb4
# collate: utf8mb4_unicode_ci
php sqlite symfony doctrine in-memory
asked Jan 20 at 11:55
Lord ZedLord Zed
503419
I'm trying to use SQLite in memory db to run tests in Symfony 4, but I cant get it to work.
My config looks like this:
doctrine:
dbal:
default_connection: default
connections:
default:
driver: 'pdo_sqlite'
url: ':memory:'
memory: true
#charset: utf8mb4
#default_table_options:
# charset: utf8mb4
# collate: utf8mb4_unicode_ci
php sqlite symfony doctrine in-memory
php sqlite symfony doctrine in-memory
asked Jan 20 at 11:55
Lord ZedLord Zed
503419
asked Jan 20 at 11:55
Lord ZedLord Zed
503419
asked Jan 20 at 11:55
Lord ZedLord Zed
503419
asked Jan 20 at 11:55
Lord ZedLord Zed
503419
asked Jan 20 at 11:55
Lord ZedLord Zed
503419
503419
Which version of Symfony are you using? Is this yourconfig_test.ymlorconfig/packages/test/doctrine.yaml? How does yourphpunit.xml.distlook?
– dbrumann
Jan 20 at 13:44
@dbrumann I've triedconfig/packages/test/doctrine.yamlandphpunit.xml.distbut no success.
– Lord Zed
Jan 23 at 11:33
add a comment |
Which version of Symfony are you using? Is this yourconfig_test.ymlorconfig/packages/test/doctrine.yaml? How does yourphpunit.xml.distlook?
– dbrumann
Jan 20 at 13:44
@dbrumann I've triedconfig/packages/test/doctrine.yamlandphpunit.xml.distbut no success.
– Lord Zed
Jan 23 at 11:33
Which version of Symfony are you using? Is this your
config_test.yml or config/packages/test/doctrine.yaml? How does your phpunit.xml.dist look?– dbrumann
Jan 20 at 13:44
Which version of Symfony are you using? Is this your
config_test.yml or config/packages/test/doctrine.yaml? How does your phpunit.xml.dist look?– dbrumann
Jan 20 at 13:44
@dbrumann I've tried
config/packages/test/doctrine.yaml and phpunit.xml.dist but no success.– Lord Zed
Jan 23 at 11:33
@dbrumann I've tried
config/packages/test/doctrine.yaml and phpunit.xml.dist but no success.– Lord Zed
Jan 23 at 11:33
add a comment |
1 Answer
1
active
oldest
votes
0
[EDITED on 2019-01-27]
In my case,
config/packages/test/doctrine.yaml :
doctrine:
dbal:
driver: pdo_sqlite
memory: true
charset: UTF8
But, for the fonctionnal testing, you need to create dB ( db in memory= not created and not persisted !)
Exemple :
<?php
// tests/Repository/MyRepositoryTest.php
namespace AppTestsController;
use AppRepositoryMyController;
use SymfonyBundleFrameworkBundleTestWebTestCase;
class MyRepositoryTest extend WebTestCase {
public function testSearch()
{
$container = self::$kernel->getContainer();
$entityManager = $container->get('doctrine')->getManager();
// Runs the schema update tool using our entity metadata
$metadatas = $entityManager->getMetadataFactory()->getAllMetadata();
$schemaTool = new SchemaTool($entityManager);
$schemaTool->updateSchema($metadatas);
// @TODO : now you can test !
}
}
answered Jan 22 at 17:42
LasouzeLasouze
262
how does your config file looks like? Because I create and populate db before tests.
– Lord Zed
Jan 23 at 11:32
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54276163%2fsymfony4-sqlite-in-memory-for-testing-cant-get-it-to-work%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
[EDITED on 2019-01-27]
In my case,
config/packages/test/doctrine.yaml :
doctrine:
dbal:
driver: pdo_sqlite
memory: true
charset: UTF8
But, for the fonctionnal testing, you need to create dB ( db in memory= not created and not persisted !)
Exemple :
<?php
// tests/Repository/MyRepositoryTest.php
namespace AppTestsController;
use AppRepositoryMyController;
use SymfonyBundleFrameworkBundleTestWebTestCase;
class MyRepositoryTest extend WebTestCase {
public function testSearch()
{
$container = self::$kernel->getContainer();
$entityManager = $container->get('doctrine')->getManager();
// Runs the schema update tool using our entity metadata
$metadatas = $entityManager->getMetadataFactory()->getAllMetadata();
$schemaTool = new SchemaTool($entityManager);
$schemaTool->updateSchema($metadatas);
// @TODO : now you can test !
}
}
answered Jan 22 at 17:42
LasouzeLasouze
262
how does your config file looks like? Because I create and populate db before tests.
– Lord Zed
Jan 23 at 11:32
add a comment |
0
[EDITED on 2019-01-27]
In my case,
config/packages/test/doctrine.yaml :
doctrine:
dbal:
driver: pdo_sqlite
memory: true
charset: UTF8
But, for the fonctionnal testing, you need to create dB ( db in memory= not created and not persisted !)
Exemple :
<?php
// tests/Repository/MyRepositoryTest.php
namespace AppTestsController;
use AppRepositoryMyController;
use SymfonyBundleFrameworkBundleTestWebTestCase;
class MyRepositoryTest extend WebTestCase {
public function testSearch()
{
$container = self::$kernel->getContainer();
$entityManager = $container->get('doctrine')->getManager();
// Runs the schema update tool using our entity metadata
$metadatas = $entityManager->getMetadataFactory()->getAllMetadata();
$schemaTool = new SchemaTool($entityManager);
$schemaTool->updateSchema($metadatas);
// @TODO : now you can test !
}
}
answered Jan 22 at 17:42
LasouzeLasouze
262
how does your config file looks like? Because I create and populate db before tests.
– Lord Zed
Jan 23 at 11:32
add a comment |
0
0
0
[EDITED on 2019-01-27]
In my case,
config/packages/test/doctrine.yaml :
doctrine:
dbal:
driver: pdo_sqlite
memory: true
charset: UTF8
But, for the fonctionnal testing, you need to create dB ( db in memory= not created and not persisted !)
Exemple :
<?php
// tests/Repository/MyRepositoryTest.php
namespace AppTestsController;
use AppRepositoryMyController;
use SymfonyBundleFrameworkBundleTestWebTestCase;
class MyRepositoryTest extend WebTestCase {
public function testSearch()
{
$container = self::$kernel->getContainer();
$entityManager = $container->get('doctrine')->getManager();
// Runs the schema update tool using our entity metadata
$metadatas = $entityManager->getMetadataFactory()->getAllMetadata();
$schemaTool = new SchemaTool($entityManager);
$schemaTool->updateSchema($metadatas);
// @TODO : now you can test !
}
}
answered Jan 22 at 17:42
LasouzeLasouze
262
[EDITED on 2019-01-27]
In my case,
config/packages/test/doctrine.yaml :
doctrine:
dbal:
driver: pdo_sqlite
memory: true
charset: UTF8
But, for the fonctionnal testing, you need to create dB ( db in memory= not created and not persisted !)
Exemple :
<?php
// tests/Repository/MyRepositoryTest.php
namespace AppTestsController;
use AppRepositoryMyController;
use SymfonyBundleFrameworkBundleTestWebTestCase;
class MyRepositoryTest extend WebTestCase {
public function testSearch()
{
$container = self::$kernel->getContainer();
$entityManager = $container->get('doctrine')->getManager();
// Runs the schema update tool using our entity metadata
$metadatas = $entityManager->getMetadataFactory()->getAllMetadata();
$schemaTool = new SchemaTool($entityManager);
$schemaTool->updateSchema($metadatas);
// @TODO : now you can test !
}
}
answered Jan 22 at 17:42
LasouzeLasouze
262
edited Jan 27 at 13:47
answered Jan 22 at 17:42
LasouzeLasouze
262
answered Jan 22 at 17:42
LasouzeLasouze
262
answered Jan 22 at 17:42
LasouzeLasouze
262
262
how does your config file looks like? Because I create and populate db before tests.
– Lord Zed
Jan 23 at 11:32
add a comment |
how does your config file looks like? Because I create and populate db before tests.
– Lord Zed
Jan 23 at 11:32
how does your config file looks like? Because I create and populate db before tests.
– Lord Zed
Jan 23 at 11:32
how does your config file looks like? Because I create and populate db before tests.
– Lord Zed
Jan 23 at 11:32
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54276163%2fsymfony4-sqlite-in-memory-for-testing-cant-get-it-to-work%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Which version of Symfony are you using? Is this your
config_test.ymlorconfig/packages/test/doctrine.yaml? How does yourphpunit.xml.distlook?– dbrumann
Jan 20 at 13:44
@dbrumann I've tried
config/packages/test/doctrine.yamlandphpunit.xml.distbut no success.– Lord Zed
Jan 23 at 11:33