search

scheb / stock-panel

Symfony application to keep track of your stock portfolio 📈
MIT License
11 stars 1 forks source link

Support for sqlite #638

Open Mte90 opened 2 weeks ago

Mte90 commented 2 weeks ago

So I was planning to use on my local machine but I don't want to run mysql just for that.

The readme doesn't mention that requirement. So on a new git cllone after composer install and running the command for the database:

 !                                                                                                                      
 ! [CAUTION] This operation should not be executed in a production environment!                                         
 !                                                                                                                      

 Creating database schema...

In ToolsException.php line 18:

  Schema-Tool failed with Error 'An exception occurred in the driver: could not find driver' while executing DDL: CREATE TABLE stock (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(50) NOT NULL,   
  symbol VARCHAR(20) NOT NULL, currency VARCHAR(3) NOT NULL, quantity NUMERIC(8, 2) DEFAULT NULL, initialPrice NUMERIC(8, 2) DEFAULT NULL, currentPrice NUMERIC(8, 2) DEFAULT NULL, currentChange NUMERIC(8, 2)   
  DEFAULT NULL, createdAt DATETIME NOT NULL, updatedAt DATETIME DEFAULT NULL, displayChart BOOLEAN NOT NULL)                                                                                                      

In ExceptionConverter.php line 83:

  An exception occurred in the driver: could not find driver  

In Exception.php line 28:

  could not find driver  

In Driver.php line 26:

  could not find driver  

doctrine:schema:create [--em EM] [--dump-sql]
Mte90 commented 2 weeks ago

In my case I was missing the php module for sqlite as the project already use sqlite but it wasn't clear.

Mte90 commented 2 weeks ago

Also to run you need to configure your web server for the public folder. Apache pointing to that folder is not enough.

php -S localhost:8080 from the public folder works with no issues except that the text is in german and not in english