kaan0200 / zoodevio_videolibrary Goto Github PK
View Code? Open in Web Editor NEWSoftware Engineering @ CWRU: Video librarying software to scan and tag videos, final project
Software Engineering @ CWRU: Video librarying software to scan and tag videos, final project
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.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.