.Maui Blog

October 27, 2017

List all triggers in SQL Server database

SELECT [so].[name] AS [Name], User_name([so].[uid]) AS [Owner], User_name([so2].[uid]) AS [Schema], Object_name([so].[parent_obj]) AS [TableName], Objectproperty([so].[id], ‘execisupdatetrigger’) AS [IsUpdate], Objectproperty([so].[id], ‘execisdeletetrigger’) AS [IsDelete], Objectproperty([so].[id], ‘execisinserttrigger’) AS [IsInsert], Objectproperty([so].[id], ‘execisaftertrigger’) AS [IsAfter], Objectproperty([so].[id], ‘execisinsteadoftrigger’) AS [IsInsteadOf], Objectproperty([so].[id], ‘execistriggerdisabled’)…

October 26, 2017

Golang – Convert a string to an integer

To convert a string to an integer with Golang, the Google programming language, you must use the Atoi function of the strconv package. Here is an example: package main import ( “fmt” “strconv” ) func…

October 25, 2017

Golang – Convert an integer to string

To convert an integer to a string with Golang, the Google programming language, you must use the Itoa function of the strconv package. Here is an example: package main import ( “fmt” “strconv” ) func…

October 24, 2017

Golang – Get the number of rows affected by a Query

How to get the number of rows affected by an update, insert, or delete with Golang. This example is for the Postgres database. package main import ( “database/sql” “fmt” _ “github.com/pq-master” ) func main() {…

October 23, 2017

Free Online Broken Link Checker

.Maui Broken Link Checker is a free online tool without advertising, here are its main features: – Checks your websites for broken links – Can scan up to 1.000.000 of web pages* – Validates both…

October 20, 2017

.Maui CDN API

View or delete your files in the .Maui CDN. Example with GET (Premium Users): https://api.dotmaui.com/client/1.0/cdn/?apikey=YOUR_API_KEY&cmd=ls&limit=0,10 Response: { “resources”: { “0”: { “creationDate”: “2017-10-16T12:14:46.473Z”, “UID”: “7iikf1”, “size”: 44416, “url”: “https://cdn.dotmaui.com/libs/img/33399.jpg” }, “1”: { “creationDate”: “2017-10-16T12:14:46.473Z”, “UID”:…

October 19, 2017

Full-screen Android activity

To view a full-screen Activity in Android I know two methods, the first by executing commands directly from code: import android.app.Activity; import android.os.Bundle; import android.view.Window; import android.view.WindowManager; public class MyActivity extends Activity { @Override public…

October 18, 2017