- make a slice of data with length 0
- append data to the slice
the slice will grow to accomodate data. A method for number of rows isn't
really needed. Here's my code
func (self *UserDAO) GetUsers() (users []models.User){
selectStatement,err := self.db.Prepare("SELECT
userid,firstname,lastname,dob,email FROM users");
if(err!=nil){
panic(err.Error());
}
defer selectStatement.Close();
rows,err := selectStatement.Query();
if(err != nil){
panic(err.Error());
}
defer rows.Close();
users = make([]models.User,0);
var id int;
var fname, lname, dob, email string;
for rows.Next(){
err := rows.Scan(&id,&fname,&lname,&dob,&email);
if(err!=nil){
panic(err.Error());
}
users = append(users,*models.NewUser(id,fname,lname,dob,email));
}
return
}
selectStatement,err := self.db.Prepare("SELECT
userid,firstname,lastname,dob,email FROM users");
if(err!=nil){
panic(err.Error());
}
defer selectStatement.Close();
rows,err := selectStatement.Query();
if(err != nil){
panic(err.Error());
}
defer rows.Close();
users = make([]models.User,0);
var id int;
var fname, lname, dob, email string;
for rows.Next(){
err := rows.Scan(&id,&fname,&lname,&dob,&email);
if(err!=nil){
panic(err.Error());
}
users = append(users,*models.NewUser(id,fname,lname,dob,email));
}
return
}
On Saturday, 25 February 2012 22:33:45 UTC+4, Silas Baronda wrote:
Looking through the database/sql package I see no easy way to get the
number of rows the selected query is returning.
I'm looking for something like this:
rows, _ := stmt.Query("SELECT id FROM cars")
res := make(Result, rows.NumberOfRows())
Is easily possible with the current implementation?
If not, maybe a rows.NumberOfRows()
--Looking through the database/sql package I see no easy way to get the
number of rows the selected query is returning.
I'm looking for something like this:
rows, _ := stmt.Query("SELECT id FROM cars")
res := make(Result, rows.NumberOfRows())
Is easily possible with the current implementation?
If not, maybe a rows.NumberOfRows()
You received this message because you are subscribed to the Google Groups "golang-nuts" group.
To unsubscribe from this group and stop receiving emails from it, send an email to golang-nuts+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
