Database

[sravimohan]

Is there a database creation script somewhere? I could only find the table descriptions in the wiki.

[hkelley]

I manually created a data folder and fido.db file under the application path. That seems to be what it's expecting. Unfortunately that still doesn't create a schema in it. Now I just get the following.

Loaded FIDO DB successfully.
Running test configs.
Fido processing complete... sleeping for 0 seconds.

My guess is that the installer (discussed in another issue thread) is meant to create the DB.

I'm also not clear why there is a "dbrelativepath" in appsettings but also a hard-coded path in the constructor.

     // from Object_Fido_Configs.cs
     var fidoSQLite = new SqLiteDB();


# # # #

    //  from SQLite.cs
    public SqLiteDB()
    {
      const string fidoDB = @"\data\fido.db";
      var sFidoDB = Application.StartupPath + fidoDB;

      if ((string.IsNullOrEmpty(sFidoDB)) | (!File.Exists(sFidoDB)))
      {
        Fido_EventHandler.SendEmail("Fido Error", "Fido Failed: {0} Unable to find Fido local DB.");
        return;
      }

[gpetersen]

From what I gather you're right, you need more than just a fido.db, you need the full schema. Looks like a good chunk of the "config" schema is on the wiki, but no doubt there is significantly more to the schema than just the Config table and the various Configs_ tables as shown here:
https://github.com/Netflix/Fido/wiki/Database

[robfry]

Guys,

Thanks for posting. This was something I wasn't able to get out before release, but I'll have a working DB build script out next week. Thanks.

[TiNico22]

+1
Is there any update planified soon ?
Thanks

[JayRKay]

Hi Rob. I just wanted to check back with you regarding the DB build script.
Thanks.

[Systalians]

Je suis absent(e) du bureau jusqu'au 30/07/2015

Je r�pondrai � votre message d�s mon retour. En cas d'urgence, vous pouvez
utiliser l'adresse : [email protected] .

I'm currently out of office. In case of emergency, please contact this mail
address : [email protected] .

Cdlt / Best regards

N VERDIER

Remarque�: ceci est une r�ponse automatique � votre message "Re: [Fido]
Database (#9)" envoy� le 17/07/2015 17:32:16.

C'est la seule notification que vous recevrez pendant l'absence de cette
personne.