package net.smans.loof;

import java.io.File;
import java.io.IOException;
import net.smans.db.Session;
import net.smans.db.Warning;
import net.smans.outfit.ZC;
import android.content.Context;
import android.app.Activity;
import android.os.Bundle;
import android.text.Editable;
import android.view.KeyEvent;
import android.view.View;
import android.widget.EditText;

public class Smansi extends Activity {
    EditText result;
    EditText entry;
    Session ss;
    int result_focus =  0 ;
    int last_position =  0 ;
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        try {
            Context c = getApplicationContext();
            File root = c.getDir("db", Context.MODE_PRIVATE);
            ss = new Session(root.getPath());
        } catch(IOException exc) {
            exc.printStackTrace();
            return;
        }
        result = (EditText) findViewById(R.id.result);
        result.setOnFocusChangeListener(new View.OnFocusChangeListener() {
            @Override
            public void onFocusChange(View v, boolean hasFocus) {
                // TODO Auto-generated method stub
                EditText et = (EditText)v;
                if (hasFocus) {
                    last_position = et.length();
                    if (result_focus ==  0 ) {
                        result_focus =  1 ;
                    } else if (result_focus ==  1 ) {
                        result_focus =  2 ;
                    }
                    et.setSelection(last_position);
                } else {
                    last_position = et.getSelectionStart();
                }
            }
        });
        entry = (EditText) findViewById(R.id.entry);
//      String query = "r[a]/b";
//      String query = "\"RESULT: {= r[b='b2']/a}\";";
        String query = entry.getText().toString();
        if (query.length() >  0 ) {
            String create0 = "$base demo =;";
            String create1 = "r'r1'[a'a1',b'b1'] =;";
            String create2 = "r'r2'[a'a2',b'b2'] =;";
            ss.smans(create0);
            ss.smans(create1);
            ss.smans(create2);
            ss.smans(query);
            String report = ss.report();
            String nl = System.getProperty("line-separator");
            if (nl == null) {
                ZC.NL = " \n";
                System.setProperty("line.separator", ZC.NL);
            }
            result.setText(
                 "-- EXAMPLE WITH XPATH" + ZC.NL +
                 "-- " + create0 + ZC.NL +
                 "-- " + create1 + ZC.NL +
                 "-- " + create2 + ZC.NL +
                 "-- " + query + ZC.NL +
                 report
            );
        }        
        entry.setOnKeyListener(new View.OnKeyListener() {
            public boolean onKey(View v, int key, KeyEvent event) {
                if (key != KeyEvent.KEYCODE_ENTER)
                    return false;
                if (event.getAction() != KeyEvent.ACTION_DOWN)
                    return false;
                result.append(execute());
//                result.bringPointIntoView(result.length());
                return true;
            }
         });
    }

    protected void onPause() {
        try {
            ss.close();
        } catch(Exception exc) {
            result.setText(exc.toString());
        }
    }
    
    String execute() {
        Editable e = entry.getText();
        String script = e.toString();
        if (ss.smans(script) >  0 )
            return ZC.NL + "--" + script + ZC.NL + ss.report();
        Warning w[] = ss.warnings();
        ss.clearWarnings();
        StringBuilder sb = new StringBuilder(ZC.NL + "--" + script);
        for(Warning w1: w) {
            sb.append(ZC.NL).append(w1);
        }
        return sb.toString();
    }

}

Smansi: Simple start of interaction
Following is a simple example describing typical Smansi interaction using Smans language. 
User declares current database (main.sdb) where he wants enter data in:
$base main= ;
He enters into device a new record:
meeting#[person'bob',time'1PM',day'march 11']= ;
Then to find all the meetings on  11  he makes a query: 
$x:=meet%[day='march 11'] ;
Now, the $x variable keeps all the meetings on March  11 . To see only persons, user types query like this: 
$x/person ;
He marks the found $x records as important (by 'remember') and changes date by few statements: 
$x[mark:'remember',day'march 12',]= ; -- adds mark and new day
$x[day'march 11']!= ; -- removes old day 
To see result, user prints correspondent table for all $x meetings:
pt($x) ; -- prints table
Another day. He prints all that marked by 'remember' in other, more suitable than table view:
pr(*'remember'/*) ; -- prints relation

package ...;

import java.io.File;
import java.io.IOException;
//DB import...
import android.content.Context;
import android.app.Activity;
import android.os.Bundle;
import android.text.Editable;
import android.view.KeyEvent;
import android.view.View;
import android.widget.EditText;

public class Smansi extends Activity {
    EditText result;
    EditText entry;
    int last_position =  0 ;
    String nl = System.getProperty("line-separator");
    if (nl == null) {
        nl = " \n");
    }
//DB parameters and variables ...
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        try {
            Context c = getApplicationContext();
            File root = c.getDir("db", Context.MODE_PRIVATE);
//DB connection open ...
        } catch(IOException exc) {
            exc.printStackTrace();
            return;
        }
        result = (EditText) findViewById(R.id.result);
        result.setOnFocusChangeListener(new View.OnFocusChangeListener() {
            @Override
            public void onFocusChange(View v, boolean hasFocus) {
                // TODO Auto-generated method stub
                EditText et = (EditText)v;
                if (hasFocus) {
                    et.setSelection(last_position);
                } else {
                    last_position = et.getSelectionStart();
                }
            }
        });
        entry = (EditText) findViewById(R.id.entry);
        String query = entry.getText().toString();
        if (query.length() >  0 ) {
            String report;
//DB DEMO statement execution query -> report ...
            result.setText(
                 "-- EXAMPLE WITH SQL/XPATH" + nl +
                 "-- " + query + nl +
                 report
            );
        }        
        entry.setOnKeyListener(new View.OnKeyListener() {
            public boolean onKey(View v, int key, KeyEvent event) {
                if (key != KeyEvent.KEYCODE_ENTER)
                    return false;
                if (event.getAction() != KeyEvent.ACTION_DOWN)
                    return false;
                result.append(execute());
                return true;
            }
         });
    }

    protected void onPause() {
        try {
//DB connection close ...
        } catch(Exception exc) {
            result.setText(exc.toString());
        }
    }
    
    String execute() {
        Editable e = entry.getText();
        String script = e.toString();
//DB statement execution of script ...
        return "...REPORT...";
    }

}