LAZIOMATICA – Guida allo Sviluppo Software

To unistall XCode 4.x from OSX Lion you have to digit this command from a terminal:

sudo /Library/Developer/Shared/uninstall-devtools -mode=all

Vi segnalo questo link  a www.computer-vision-software.com per la compilazione di OpenCV, nota libreria per la ricognizione facciale:  guide to openCV compile on Iphone

inoltre qui potrete trovare un interessante articolo al suo utilizzo: realtime-face-detection-on-the-iphone

In questo articolo vedremo come muovere i primi passi nell’utilizzo del noto motore db SQLite all’interno delle nostre applicazioni iPad / iPhone.

Nota.Per iniziare sarà necessario importare la libreria nativa “libsqlite3.dylib” al nostro progetto, e per farlo basta posizionarsi, in XCode, sul folder “Framework” e aggiungere il framework esistente denominato libsqlite3.dylib, che non è nient’altro che un link alla versione più recente della libreria SQLite presente sul vostro dispositivo.

Nell’header file del controller (partiamo sempre dal View – Based template di XCode) imortiuamo l’headerfile di  di sqlite e definiamo una variabile riferita al nostro database SQLite  e un metodo che ci restituisca il percorso del nostro db (ci riferiamo sempre alla cartella Documenti) come segue:

#import <UIKit/UIKit.h>

#import “sqlite3.h”

@interface databasesViewController : UIViewController {

sqlite3 *db;

}

-(NSString *) filePath;

@end

Nel file implementazione del controller avremo scriveremo i seguenti metodi per accedere al db:

// Recupera il percorso del file all’interno della cartella documenti

-(NSString *) filePath {

NSArray *paths = NSSearchPathForDirectoriesInDomains(

NSDocumentDirectory, NSUserDomainMask, YES);

NSString *documentsDir = [paths objectAtIndex:0];

return [documentsDir stringByAppendingPathComponent:@"database.sql"];

}

-(void) openDB {

//—creiamo o aprimo il database—

if (sqlite3_open([[self filePath] UTF8String], &db) != SQLITE_OK ) {

sqlite3_close(db);

NSAssert(0, @”Errore apertura DB.”);

}

}

-(void) createTableNamed:(NSString *) tableName

withField1:(NSString *) field1

withField2:(NSString *) field2 {

char *err;

NSString *sql = [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS '%@' ('%@' TEXT PRIMARY KEY, '%@' TEXT);",tableName, field1, field2];

// Se non esiste crea la tabella indicata in tableName con i campi field1 e field2 (di tipo testo)

if (sqlite3_exec(db, [sql UTF8String], NULL, NULL, &err) != SQLITE_OK) {

sqlite3_close(db);

NSAssert(0, @”Errore nella creazione della tabella.”);

}

}

// procedura inserimento Record nella tabella “tableName” nei campi field1 e field2

-(void) insertRecordIntoTableNamed:(NSString *) tableName

withField1:(NSString *) field1

field1Value:(NSString *) field1Value

andField2:(NSString *) field2

field2Value:(NSString *) field2Value {

NSString *sql = [NSString stringWithFormat:

@"INSERT OR REPLACE INTO '%@' ('%@', '%@') VALUES ('%@','%@')",tableName, field1, field2, field1Value, field2Value];

char *err;

if (sqlite3_exec(db, [sql UTF8String], NULL, NULL, &err) != SQLITE_OK) {

sqlite3_close(db);

NSAssert(0, @”Errore Aggiornamento Tabella”);

}

}

// Procedura di recupero record dalla tabella “tableName”

-(void) getAllRowsFromTableNamed: (NSString *) tableName {

//—recuperiamo le nostre rows—

NSString *qsql = @”SELECT * FROM CONTACTS”;

sqlite3_stmt *statement;

if (sqlite3_prepare_v2( db, [qsql UTF8String], -1, &statement, nil) == SQLITE_OK) {

// Cicliamo nel loop per recuperare tutte le righe

while (sqlite3_step(statement) == SQLITE_ROW) {

char *field1 = (char *) sqlite3_column_text(statement, 0);

NSString *field1Str = [[NSString alloc] initWithUTF8String: field1];

char *field2 = (char *) sqlite3_column_text(statement, 1);

NSString *field2Str = [[NSString alloc] initWithUTF8String: field2];

NSString *str = [[NSString alloc] initWithFormat:@”%@ – %@”,field1Str, field2Str];

// Stampiano nella consolle la stringa formattata

NSLog(@”%@”,str);

// Liberiamo memoria

[field1Str release];

[field2Str release];

[str release];

}

//— Cancelliamo l’istruzione compilata SQLIte dalla memoria—

sqlite3_finalize(statement);

}

}

Ora per provare il tutto, nel delegate “viewDidLoad” del controller, chiamiamo in sequenza e analizziamo i messaggi mostrati da NSLog:

- (void)viewDidLoad {

// Apre il DB o lo crea

[self openDB];

// Crea la Tabella se non esiste

[self createTableNamed:@"Contacts" withField1:@"email" withField2:@"name"];

//effettua inserimento di 2 record

for (int i=0; i<=2; i++) {

NSString *email = [[NSString alloc] initWithFormat:@”user%d@laziomatica.com”,i];

NSString *name = [[NSString alloc] initWithFormat: @”user %d”,i];

[self insertRecordIntoTableNamed:@"Contacts" withField1:@"email" field1Value:email andField2:@"name" field2Value:name];

[email release];

[name release];

}

// Effettua il recupero dei record

[self getAllRowsFromTableNamed:@"Contacts" ];

sqlite3_close(db);

[super viewDidLoad];

}

Al fine di monitorare il comportamento delle istruzioni eseguite dalla libreria SQLite, di seguito sono riportate le codifiche dei “Result Code” definite nell’interfaccia C della libreria SQLite come riportato sul sito ufficiale http://www.sqlite.org/c3ref/c_abort.html

#define SQLITE_OK 0 /* Successful result */

#define SQLITE_ERROR 1 /* SQL error or missing database */

#define SQLITE_INTERNAL 2 /* Internal logic error in SQLite */

#define SQLITE_PERM 3 /* Access permission denied */

#define SQLITE_ABORT 4 /* Callback routine requested an abort */

#define SQLITE_BUSY 5 /* The database file is locked */

#define SQLITE_LOCKED 6 /* A table in the database is locked */

#define SQLITE_NOMEM 7 /* A malloc() failed */

#define SQLITE_READONLY 8 /* Attempt to write a readonly database */

#define SQLITE_INTERRUPT 9 /* Operation terminated by sqlite3_interrupt()*/

#define SQLITE_IOERR 10 /* Some kind of disk I/O error occurred */

#define SQLITE_CORRUPT 11 /* The database disk image is malformed */

#define SQLITE_NOTFOUND 12 /* NOT USED. Table or record not found */

#define SQLITE_FULL 13 /* Insertion failed because database is full */

#define SQLITE_CANTOPEN 14 /* Unable to open the database file */

#define SQLITE_PROTOCOL 15 /* NOT USED. Database lock protocol error */

#define SQLITE_EMPTY 16 /* Database is empty */

#define SQLITE_SCHEMA 17 /* The database schema changed */

#define SQLITE_TOOBIG 18 /* String or BLOB exceeds size limit */

#define SQLITE_CONSTRAINT 19 /* Abort due to constraint violation */

#define SQLITE_MISMATCH 20 /* Data type mismatch */

#define SQLITE_MISUSE 21 /* Library used incorrectly */

#define SQLITE_NOLFS 22 /* Uses OS features not supported on host */

#define SQLITE_AUTH 23 /* Authorization denied */

#define SQLITE_FORMAT 24 /* Auxiliary database format error */

#define SQLITE_RANGE 25 /* 2nd parameter to sqlite3_bind out of range */

#define SQLITE_NOTADB 26 /* File opened that is not a database file */

#define SQLITE_ROW 100 /* sqlite3_step() has another row ready */

#define SQLITE_DONE 101 /* sqlite3_step() has finished executing */

Al prossimo articolo…..

In molte applicazioni capita spesso di dover copiare al primo avvio dell’app un file di partenza, ad esempio un DB di partenza che successivamente verrà consultato e/o modificato, dal pacchetto dell’applicazione alla directory documenti dove l’utenti ha i privilegi necessari per utilizzarlo.
In questo snippet di codice vedremo proprio come fare:

Definiamo nell’application delegate un metodo “copiaFileDalBundleAiDocumenti”

- (void) copiaFileDalBundleAiDocumenti:(NSString *) fileName estensione:(NSString *) ext {

//— Recuperiamo il percorso della cartella Documenti—

NSArray *paths = NSSearchPathForDirectoriesInDomains(

NSDocumentDirectory, NSUserDomainMask, YES);

NSString *documentsDirectory = [paths objectAtIndex:0];

//—percorso del file che vogliamo trasferire —

NSString *filePath = [documentsDirectory stringByAppendingPathComponent:

[NSString stringWithString:fileName]];

filePath = [filePath stringByAppendingString:@"."];

filePath = [filePath stringByAppendingString:ext];

[filePath retain];

//—controlliamo se il file già esiste,

// Solo se non esiste lo copiamo NSFileManager *fileManger = [NSFileManager defaultManager];

if (![fileManger fileExistsAtPath:filePath]) {

//—percorso del file relativo al bundle—

NSString *pathToFileInBundle = [[NSBundle mainBundle] pathForResource:fileName ofType:ext];

//—copy the file in the bundle to the Documents folder—

NSError *error = nil;

//—proviamo ad effettuare la copia

bool success = [fileManger copyItemAtPath:pathToFileInBundle toPath:filePath error:&error];

if (success) {

NSLog(@”File copiato”);

}

else {

NSLog([error localizedDescription]);

}

}

}

A questo punto in fase di avvio dell’applicazione chiamiamo il nostro metodo nel delegate “applicationdidFinishLaunchingWithOptions” in questo modo:

- (BOOL)application:(UIApplication *)application didFinishLaunchingWithOptions:(NSDictionary *)launchOptions {

//—copiamo un db di partenza miodb.sql nella cartella documenti

[self copiaFileDalBundleAiDocumenti:@"miodb" estensione:@"sql"];

// Override point for customization after app launch.

[window addSubview:viewController.view];

[window makeKeyAndVisible];

return YES;

}

Restarting a suspended VM from an external usb disk  i catch this error. To resolve try to delete the .vmss file from the Virtual Machine’s Package. Note that by deleting .vmss file like hard shutdown the physical computer and anything not save to disk will be lost.

I resolve in this way.

original link: http://communities.vmware.com/thread/148306

The ASMailer class sends emails using an SMTP server. ASMailer sends mail without the need of a server side language like PHP or JSP.
The ASMailer class sends emails using an SMTP server. ASMailer sends mail without the need of a server side language like PHP or JSP. This project is in alpha state. Currently sends using SMTP servers that do not require authentication or SSL connection. Currently only test on default port 25.

Usage:

import com.almerblank.fl.net.mail.Email;
import com.almerblank.fl.net.mail.ASMailer;
import com.almerblank.fl.net.mail.events.MailEvent;
import com.almerblank.fl.net.mail.events.MailErrorEvent;

private var mail:ASMailer;

private function init():void
{
mail = new ASMailer( ‘mail.yourserver.com’ );
mail.addEventListener( MailEvent.SMTP_CONNECTION_READY, _connReady );
mail.addEventListener( MailEvent.SMTP_STATUS_EVENT, _handleStatus );
mail.addEventListener( MailEvent.SMTP_EMAILING_COMPLETE, _emailsComplete );
mail.addEventListener( MailEvent.SMTP_DISCONNECTED, _disconn );
mail.addEventListener( MailErrorEvent.SMTP_SERVER_ERROR, _smtpErrorHandler );
mail.addEventListener( MailErrorEvent.SMTP_IOERROR, _smtpIOError );
mail.addEventListener( MailErrorEvent.SMTP_SECURITY_ERROR, _smtpSecError );
}

private function _disconn( event:MailEvent ):void
{
trace( ‘disconnected…’ );
}

private function _emailsComplete( event:MailEvent ):void
{
trace( ‘_emailsComplete()’ );
}

private function _smtpIOError( event:MailErrorEvent ):void
{
trace( ‘event.message = ‘ + event.message );
}

private function _smtpSecError( event:MailErrorEvent ):void
{
trace( ‘event.message = ‘ + event.message );
}

private function _handleStatus( event:MailEvent ):void
{
tf_status.text += event.status;
tf_status.text += ‘\n’;
tf_status.verticalScrollPosition = tf_status.maxVerticalScrollPosition;
}

private function _smtpErrorHandler( event:MailErrorEvent ):void
{
trace( ‘event.code = ‘ + event.code );
trace( ‘event.message = ‘ + event.message );
trace( ‘event.failedOnCommand = ‘ + event.failedOnCommand );
}

private function _connReady( event:MailEvent ):void
{
sendEmails()
}

private function sendEmails():void
{
var lipsum1:String = ‘…text…’;
var lipsum2:String = ‘…text…’;

// one email send to one person
var em:Email = new Email( ‘user@laziomatica.com’, [ 'toUser@laziomatica.com' ], ‘message 1 subject’, lipsum1 );

// one email to two people
var em2:Email = new Email( ‘user@laziomatica.com’, [ 'toUser@laziomatica.com', 'toSecondUser@3life.it' ], ‘message 2 subject’, lipsum2 );

// send multiple in an array
mail.sendMail( [ em, em2 ] );

// send one in an array
//mail.sendMail( [ em ] );

}

This code should work in Flash and Flex. The init() method would start the process.

Another MXML Mailer Application:

<?xml version=”1.0″ encoding=”utf-8″?>
<mx:WindowedApplication xmlns:mx=”http://www.adobe.com/2006/mxml” layout=”absolute” creationComplete=”init()”>
<mx:Script>
<![CDATA[

import com.almerblank.fl.net.mail.Email;
import com.almerblank.fl.net.mail.ASMailer;
import com.almerblank.fl.net.mail.events.MailEvent;
import com.almerblank.fl.net.mail.events.MailErrorEvent;

private var mail:ASMailer;

private function init():void
{
mail = new ASMailer( '10.109.70.11' );
mail.addEventListener( MailEvent.SMTP_CONNECTION_READY, _connReady );
mail.addEventListener( MailEvent.SMTP_STATUS_EVENT, _handleStatus );
mail.addEventListener( MailEvent.SMTP_EMAILING_COMPLETE, _emailsComplete );
mail.addEventListener( MailEvent.SMTP_DISCONNECTED, _disconn );
mail.addEventListener( MailErrorEvent.SMTP_SERVER_ERROR, _smtpErrorHandler );
mail.addEventListener( MailErrorEvent.SMTP_IOERROR, _smtpIOError );
mail.addEventListener( MailErrorEvent.SMTP_SECURITY_ERROR, _smtpSecError );
}

private function _disconn( event:MailEvent ):void
{
trace( 'disconnected...' );
}

private function _emailsComplete( event:MailEvent ):void
{
trace( '_emailsComplete()' );
}

private function _smtpIOError( event:MailErrorEvent ):void
{
trace( 'event.message = ' + event.message );
}

private function _smtpSecError( event:MailErrorEvent ):void
{
trace( 'event.message = ' + event.message );
}

private function _handleStatus( event:MailEvent ):void
{
tf_status.text += event.status;
tf_status.text += '\n';
tf_status.verticalScrollPosition = tf_status.maxVerticalScrollPosition;
}

private function _smtpErrorHandler( event:MailErrorEvent ):void
{
trace( 'event.code = ' + event.code );
trace( 'event.message = ' + event.message );
trace( 'event.failedOnCommand = ' + event.failedOnCommand );
}

private function _connReady( event:MailEvent ):void
{
sendEmails()
}

private function sendEmails():void
{
var lipsum1:String = '...text...';
var lipsum2:String = '...text...';

// one email send to one person
var em:Email = new Email( 'laziomatica@gmail.com', [ 'ideasviluppo@gmail.com' ], ‘message 1 subject’, lipsum1 );

// one email to two people
var em2:Email = new Email( ‘cert@laziomatica.com’, [ 'ideasviluppo@gmail.com', 'info@3life.it' ], ‘message 2 subject’, lipsum2 );

// send multiple in an array
mail.sendMail( [ em, em2 ] );

// send one in an array
//mail.sendMail( [ em ] );

}
]]>
</mx:Script>
<mx:TextArea x=”0″ y=”0″ width=”309″ height=”289″ id=”tf_status”/>

</mx:WindowedApplication>