GooseDBMS 1.4.11

GooseDBMS

GooseDBMS. Free cloud DBMS based on Google products

<p align="center"> <img width="640" alt="github" src="https://github.com/gttrcr/GooseDBMS/assets/48126017/8cd57f03-a623-4230-96f0-22d830522e47"> </p>

GooseDMBS was created to get around the problem of building cloud database-based applications. The data entry takes place through the automatic sending of a Google form. The solution is particularly useful for all those push only applications such as MQTT or one-way communications (weather stations, IoT devices, sending status data, ...). The entire solution does not require writing specific code but only configuring a file.

Usings

using Goose;
using Goose.Type.Config;
using Goose.Type.DBMS;

Example of goose.json Configuration file

Consider the following configuration file

{
  "ClientSecretFilePath": "client_secret.json",
  "ApiKey": null,
  "Tables": [
    {
      "Name": "list_of_devices_table",
      "Columns": [
        {
          "Entry": 467582135,
          "Value": "device_number",
          "Key": "th38sjj2"
        },
        {
          "Entry": 545400028,
          "Value": "mac_address",
          "Key": "0vbcgdv3"
        }
      ],
      "FormID": "582ufbefRRJT4t28h65h26jJg-hjh83HHFH36j6j",
      "PrefilledFormID": "ghjrkelkjwTHSKHJR54y52yTSHETRH25u25u-w5j5ju5STs55",
      "Dynamic": {              // this is a dynamic object
        "Domain":"database",    // this field is just an example
        "Policy": "tutygh5753", // this field is just an example
        "ID": 676758920656      // this field is just an example
      }
    }
  ]
}

The configuration file can be automatically generated by a utility function in GooseDBMS. Consider the following example

Config.CreateConfig("goose_config.json",
                "client_secret.json",
                new List<string>() { "https://docs.google.com/forms/d/e/ghjrkelkjwTHSKHJR54y52yTSHETRH25u25u-w5j5ju5STs55/viewform?usp=pp_url&entry.5497120025=name&entry.223105871=surname" },
                new List<string>() { "582ufbefRRJT4t28h65h26jJg-hjh83HHFH36j6j" });

The static function GooseConfig.CreateConfig takes as arguments

1. the path of the configuration json file you want for your GooseDBMS application
2. the path of the json client secret file
3. the list of prefilled url for every form
4. the list of form id

Pay attention that in GooseDBMS, every form is a table. When the goose_config.json is saved, then GooseDBMS instance can be created.

User application (client)

In the case of client application, the user can only just push data to DB. So, ClientSecretFilePath and FormID should be null and just PrefilledFormID will be used to create the link to push data.

User goose = new("goose_config_new.json");  //instance of GooseDBMS user
goose.Insert("tablename", new List<string>() { "colum1 value", "column2 value" });  //this equivalent to: INSERT INTO tablename (name, surname) VALUES ('column1 value', 'column2 value')

Owner application (server)

In the case of server application or master application, the user is able to push and pull data to DB. So ClientSecretFilePath and FormID must be not null and valid to create a Google service able to read form body and responses. In any case, the data entered into the database cannot be modified in form response but soon there will be the possibility of replacing previous data with updated data so as to also implement the update functionality as in a real database.

Owner goose = new("goose_config_new.json");  //instance of GooseDBMS owner
GooseTable? gooseTable = goose.Select("SELECT * FROM tablename WHERE name = 'some name value'");  //literally the sql SELECT statement
Owner.Insert("tablename", new List<string>() { "colum1 value", "column2 value" });  //this equivalent to: INSERT INTO tablename (name, surname) VALUES ('column1 value', 'column2 value')

goose.DataReceivedCallback = (gooseDB, previousGooseDB, differenceGooseDB) =>  //callback triggered by new data on DB
{
    Console.WriteLine(differenceGooseDB);
};

GooseDBMS library

Pack with

rm -rf bin
rm -rf obj
dotnet pack -c Release