Easy Raspberry Pi GUI App Development Beginner Part 1

Use of Sqlite3 --Introduction of Dapper I tried to summarize Dapper --Introduction of Dapper Extension Comparison of Dapper extension libraries --Use Swagger Use Stoplight Studio etc. OpenAPI (Swagger) tool that I'm really glad to use --Run Python from C # Call Python script from C # --Realization of binding between DataGridView and Model URL treeView --How to deploy to Raspberry Pi

Development is done on Visual Sudio Mac on Mac

Up to 5 in the first part

Sample File

Select Gtk # for the project

About GTK #

Download packages from Nuget

Package to download

Dapper DapperExtensions Download Mono.Data.Sqlite. In case of Gtk2 #, System.Data.Sqlite cannot be read.

Query using Dapper

Dapper Tutorial

Query results can be automatically included in the model. Also, Model can be used instead of the argument at the time of Update at Insert.

        static public void _dapperTest() {

            Mono.Data.Sqlite.SqliteConnection connection = new Mono.Data.Sqlite.SqliteConnection();
 
            connection.ConnectionString = @"Data Source=path/test.sqlite";
            connection.Open();

            var query = "select * from testTable;";

            var result = connection.Query<testTable>(query);
            foreach(var p in result) {
                Console.WriteLine("ID:" + p.test_id + "name:" + p.name);
            }

            connection.Close();
        }

Insert Update processing using Dapper Extension

Insert statement and Update statement can be automatically generated and processed from Model

About Dapper Extension

Change the format of the exported Sql statement

DapperExtensions.DapperExtensions.SqlDialect = new DapperExtensions.Sql.SqliteDialect();

        static public void _dapperExtensionTest() {

            //Sql statement[testTable].[test_id]From[test_id]Change to
            DapperExtensions.DapperExtensions.SqlDialect = new DapperExtensions.Sql.SqliteDialect();

            Mono.Data.Sqlite.SqliteConnection connection = new Mono.Data.Sqlite.SqliteConnection();

            connection.ConnectionString = @"Data Source=path/test.sqlite";
            connection.Open();

            //Processing using Dapper Extension
            testTable testTable1 = new testTable();
            testTable1.name = "aaaaaa111";
            connection.Insert<testTable>(testTable1);

            var query = "select * from testTable;";
            var result = connection.QueryFirst<testTable>(query);

            //Processing using Dapper Extension
            result.name += "qqqq111";
            connection.Update<testTable>(result);

            connection.Close();

        }

testTable model

Be sure to write a Getter Setter on the model **

 public　class testTable {

	public int test_id { get; set; }

	public string name { get; set; }
 }

Make Swagger automatically generated

Use Stoplight Studio. Register the API URL and parameters, and Swagger will be generated automatically.

OpenAPI (Swagger) tool that I really liked to use

Automatically generate API client, stub server, HTML definition document with Swagger Codegen

Install Swagger Codegen and export the API client and model file in the specified language. It is convenient to customize the template.

Automatically generate various RESTful API definitions with OpenAPI Generator Swagger Codegen Swagger Codegen Git

swagger-codegen generate -i http://petstore.swagger.io/v2/swagger.json -l Specify the language(csharp) -o Output directory

I touched swagger for the first time

Free product list in Azure

Azure Functions Free

Points for development

Gtk2 # uses Mono.Data.Sqlite. Could be used with Dapper
I had a hard time finding a sample of gtk. ** C # gtk hotexamples When I searched with the method name I want to check **, I found a site that can list the samples posted on git.
Be sure to write a getter setter in the model

DataMapping

Easy Raspberry Pi GUI App Development Beginner Part 2 Easy introduction to Raspberry Pi Gui application development Easy Raspberry Pi GUI application development parts sample collection