kaan0200 / zoodevio_videolibrary Goto Github PK

A color picker like the one on the metadata window should be used, not a string representing color.

Should it? Uncertain. Suggestions?

Currently, what happens is you select a file to be the root. Stuff happens. And the database gets all the folders added correctly. However, the entries in the table are incorrect. The "Parent ID" field is always being set to '0' except for the parent folder which is correctly being set at -1.

Likely application side problem.

I had a way to do this but maybe it hadn't yet been implemented. Fixing.

Right now, the program freezes while it processes, this is not so good.

Hi all,

Did we agree to support thumbnails through the database, or through a directory of files somewhere? We can do either, but I think the files directory thing would be easier, provided we make sure Zoodevio clears/creates that directory on setting the library root.

Please respond with prefs, and I'll implement.

Files are getting date_added as 1/1/0001 12:00:00:00 AM. date_edited is working correctly.

It returns a list of VideoFiles, which should be processed with their associated folder held in a separate object. Temporarily circumvented with commit #ea853ca.

Probably an issue in the Database class processing the files. Will investigate soon.

The gridview needs to stretch to two sizes depending on which windows are open. Currently the control stretches outside of it's parent, it needs to not get larger then the container and stretch wider when the metadata window closes.

File names aren't sanitized in/out of the database. Will have to add a handler.

Example from SetLibraryRoot:
1 12:00:00 AM', '11/6/2015 6:15:18 PM')insert into files (path, date_added, date_edited) values ('G:\Videos\Gossip Girl\Season 1\Gossip Girl - S1E06 - The Handmaiden's Tale.avi', '1/1/0001 12:00:00 AM', '11/6/2015 6:15:18 PM')System.Data.SQLite.SQLiteException (0x80004005): SQLite error near "s": syntax error at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain) at System.Data.SQLite.SQLiteCommand.BuildNextCommand() at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() at Zoodevio.DataModel.Database.SimpleInsertQuery(String table, String[] rows, String[] data) in C:\Users\Max Zimon\Documents\GitHubVisualStudio\Zoodevio_VideoLibrary\Zoodevio\DataModel\Database.cs:line 144Files table addition failed: G:\Videos\Gossip Girl\Season 1\Gossip Girl - S1E06 - The Handmaiden's Tale.avi

Note the apostrophe in "Handmaiden's." Other files in this format (video name - episode code - name) add correctly.

Currently, with the application not correctly writing the files to DB, you have to set this problem up manually. Modify folder parent ID values in the DB to reflect their parents correctly. Then click the force hierarchy context menu button.