Client applications

SELECT * FROM getBlockByNumber WHERE blockNumber = 'latest' AND transactionDetailsFlag = false

SELECT transactions FROM getBlockByNumber WHERE '0x1531dbb' AND transactionDetailsFlag = false

SELECT blockNumber, [timestamp], blobGasUsed  FROM getBlockByNumber WHERE blockNumber = '0x152fdd8' AND transactionDetailsFlag = false

SELECT gasUsed  FROM getBlockByNumber WHERE blockNumber = '0x152fdd8' AND transactionDetailsFlag = false

package main

import (
	_ "github.com/alexbrainman/odbc"
	"database/sql"
        "log"
)

func main() {
        // Replace the DSN value with the name of your ODBC data source.
        db, err := sql.Open("odbc",
                "DSN=Ethereum")
        if err != nil {
                log.Fatal(err)
        }

        var (
                blocknumber string
                transactiondetailsflag bool
                transactions string
        )

        rows, err := db.Query("SELECT blockNumber, transactionDetailsFlag, transactions FROM getBlockByNumber WHERE blockNumber = 'latest' AND transactionDetailsFlag = true")
        if err != nil {
                log.Fatal(err)
        }
        defer rows.Close()
        for rows.Next() {
                err := rows.Scan(&blocknumber, &transactiondetailsflag, &transactions)
                if err != nil {
                        log.Fatal(err)
                }
                log.Println(blocknumber, transactiondetailsflag, transactions)
        }

        err = rows.Err()
        if err != nil {
                log.Fatal(err)
        }

        defer db.Close()
}

const odbc = require('odbc');
// Replace Ethereum with the name of your Easysoft ODBC-Ethereum Driver
// data source.
const connection = odbc.connect('DSN=Ethereum', (error, connection) => {
    connection.query('SELECT transactions  FROM getBlockByNumber WHERE blockNumber = \'latest\' AND transactionDetailsFlag = true', (error, result) => {
        if (error) { console.error(error) }
        console.log(result);
    });
});

const odbc = require('odbc');
const connection = odbc.connect('DSN=Ethereum', (error, connection) => {
    connection.tables(null, null, null, null, (error, result) => {
        if (error) { return; }
        const util = require('util');
        console.log(util.inspect(result, {maxArrayLength: null, depth:null}))
    });
});

const odbc = require('odbc');
const connection = odbc.connect('DSN=Ethereum', (error, connection) => {
    connection.columns(null, null, null, null, (error, result) => {
        if (error) { return; }
        const util = require('util');
        console.log(util.inspect(result, {maxArrayLength: null, depth:null}))
    });
});

use strict;
use DBI;
# Replace Ethereum with the name of your Easysoft ODBC-Ethereum Driver data source.
my $dbh = DBI-> connect('dbi:ODBC:Ethereum');

$dbh->{LongReadLen} = 524288;

my $sql = "SELECT * FROM getBlockByNumber WHERE blockNumber = 'latest' AND transactionDetailsFlag = true";
my $sth = $dbh->prepare($sql)
    or die "Can't prepare statement: $DBI::errstr";

$sth->execute();

# Fetch and display the result set values.
my @names = @{$sth->{NAME}};
print "@names\n";

while ( my @row = $sth->fetchrow_array ) {
     print "@row\n";
}

$dbh->disconnect if ($dbh);

use strict;
use DBI;
my $dbh = DBI-> connect('dbi:ODBC:Ethereum');

my $sth = $dbh->table_info()
    or die "Can't prepare statement: $DBI::errstr";

my @row;

while (@row = $sth->fetchrow_array) {
    print join(", ", @row), "\n";
}

$dbh->disconnect if ($dbh);

use strict;
use DBI;
my $dbh = DBI-> connect('dbi:ODBC:Ethereum');

my $sth = $dbh->column_info('','','','')
    or die "Can't prepare statement: $DBI::errstr";

my @row;
while (@row = $sth->fetchrow_array) {
    print join(", ", @row), "\n";
}

$dbh->disconnect if ($dbh);

<?php
  // Replace Ethereum with the name of your Easysoft ODBC-Ethereum Driver data source.
  //  If your database requires a user name and password, supply them in the odbc_connect_call.
  $con = odbc_connect("Ethereum", "", "");
  $stmt = odbc_exec($con, "SELECT * FROM getBlockByNumber WHERE blockNumber = 'latest' AND transactionDetailsFlag = true");
   while($row = odbc_fetch_row($stmt))
   {
      for($i=1;$i<=odbc_num_fields($stmt);$i++)
      {
          echo odbc_result($stmt, $i);
      }
   }
  odbc_close($con);
?>

<?php
$con = odbc_connect("Ethereum", "", "");
$tables = odbc_tables($con);
while (($row = odbc_fetch_array($tables))) {
    print_r($row);
}
odbc_close($con);
?>

<?php
$con = odbc_connect("Ethereum", "", "");
$columns = odbc_columns($con);
while (($row = odbc_fetch_array($columns))) {
    print_r($row);
}
odbc_close($con);
?>

import pyodbc

# Replace Ethereum with the name of your Easysoft ODBC-Ethereum Driver data source.
cnxn = pyodbc.connect("DSN=Ethereum")
cursor = cnxn.cursor()
sql = "SELECT * FROM getBlockByNumber WHERE blockNumber = 'latest' AND transactionDetailsFlag = true"
cursor.execute(sql)
rows = cursor.fetchall()
column_names = [column[0] for column in cursor.description]

print("Columns:", column_names)
for row in rows:
    print(row)

cnxn.close()
exit()

import pyodbc

# Replace Ethereum with the name of your Easysoft ODBC-Ethereum Driver data source.
cnxn = pyodbc.connect("DSN=Ethereum")
cursor = cnxn.cursor()
cursor.tables()
rows = cursor.fetchall()
for row in rows:
     print(row.table_name)
exit()

import pyodbc

# Replace Ethereum with the name of your Easysoft ODBC-Ethereum Driver data source.
cnxn = pyodbc.connect("DSN=Ethereum")
cursor = cnxn.cursor()
cursor.columns()
rows = cursor.fetchall()
for row in rows:
     print(row.table_name, row.column_name)
exit()

library("RODBC")
# Replace Ethereum with the name of your Easysoft ODBC-Ethereum Driver data source.
ch <- odbcConnect("Ethereum")
sqlQuery(ch, paste("SELECT blockNumber, transactionDetailsFlag, transactions FROM getBlockByNumber WHERE blockNumber = 'latest' AND transactionDetailsFlag = true"))
odbcClose(ch)
quit()

library("RODBC")
# Replace Ethereum with the name of your Easysoft ODBC-Ethereum Driver data source.
ch <- odbcConnect("Ethereum")
sqlTables(ch)
odbcClose(ch)
quit()

library("RODBC")
# Replace Ethereum with the name of your Easysoft ODBC-Ethereum Driver data source.
ch <- odbcConnect("Ethereum")
# You may need to change the capitalisation of getBlockByNumber to all upper case or all lower case.
sqlColumns(ch, sqtable="getBlockByNumber")
odbcClose(ch)
quit()