I was practicing the commands on SQLite and wondering how to view the tables of my database, I found a way to do it which is (sqlite3 example12.db ".table"). The example12.db is my database and .table is to view the tables in the database. You will get something similar to this (Actors ActorsMovies Cars cars2 ) depending on what is in your database.
Today also I learn this other command that is (sqlite3 example12.db "dump"). This command will give you something like this:
CREATE TABLE Actors(AId integer primary key autoincrement, Name text);
INSERT INTO "Actors" VALUES(1,'Philip Seymour Hofman');
INSERT INTO "Actors" VALUES(2,'Kate Shindle');
INSERT INTO "Actors" VALUES(3,'Kelci Stephenson');
INSERT INTO "Actors" VALUES(4,'Al Pacino');
INSERT INTO "Actors" VALUES(5,'Gabrielle Anwar');
INSERT INTO "Actors" VALUES(6,'Patricia Arquette');
INSERT INTO "Actors" VALUES(7,'Gabriel Byrne');
INSERT INTO "Actors" VALUES(8,'Max von Sydow');
INSERT INTO "Actors" VALUES(9,'Ellen Burstyn');
INSERT INTO "Actors" VALUES(10,'Jason Miller');
this will varies depending what is in your database and it could be even longer if you have more tables in the same database.
I am following this tutorial and I think that is more useful than this one.
Tuesday, December 21, 2010
Monday, December 20, 2010
Practicing SQLite
I was practicing SQLite commands from the (.help) this is a command on SQLite that hell you with the commands. Some commands that I practiced are
.schema "table name"(this will told you what the table have in)
Example: schema cars (cars is the name of my table ).
I get this message CREATE TABLE Cars(Id integer PRIMARY KEY, Name text, Cost integer);
.mode line "then the (select * from 'name of the table')", and you will get something like this;
Id = 1
Name = Angela
Cost = 21
Id = 2
Name = Mercedes
Cost = 57127
Id = 3
Name = Skoda
Cost = 9000
Id = 4
Name = Volvo
Cost = 29000
Id = 5
Name = Bentley
Cost = 350000
Id = 6
Name = Citroen
Cost = 21000
Id = 7
Name = Hummer
Cost = 41400
Id = 8
Name = Volkswagen
Cost = 21600
this will varies depending on what is in your table and what is about it.
I will try to learn more commands this week.
.schema "table name"(this will told you what the table have in)
Example: schema cars (cars is the name of my table ).
I get this message CREATE TABLE Cars(Id integer PRIMARY KEY, Name text, Cost integer);
.mode line "then the (select * from 'name of the table')", and you will get something like this;
Id = 1
Name = Angela
Cost = 21
Id = 2
Name = Mercedes
Cost = 57127
Id = 3
Name = Skoda
Cost = 9000
Id = 4
Name = Volvo
Cost = 29000
Id = 5
Name = Bentley
Cost = 350000
Id = 6
Name = Citroen
Cost = 21000
Id = 7
Name = Hummer
Cost = 41400
Id = 8
Name = Volkswagen
Cost = 21600
this will varies depending on what is in your table and what is about it.
I will try to learn more commands this week.
Thursday, December 16, 2010
Creat a save a table.
Yesterday I was wondering how to created a table and save it, and today my teacher taught me how to do it. Yesterday I was trying to execute the program (sqlite3) first and then created the table but I didn't know that I new a database file.
The extension of the file you create have to be (.db) which stands for (database).
How you create a database in SQLite?
The way to create it is sqlite3 (name of your file with out parenthesis).db+
The extension of the file you create have to be (.db) which stands for (database).
How you create a database in SQLite?
The way to create it is sqlite3 (name of your file with out parenthesis).db+
Wednesday, December 15, 2010
SQlite
Practicing the SQLite, i know how to open the table, but I don't know how to open the same table after I close the program and enter again. Tomorrow I will look for a tutorial to see how to do it.
Today I was practicing the command (select * from "name of your table"). This command open what is inside your table named Actors (select * from Actors;) this command will show up names of some actors. But you have to create the table and then execute the command.
Today I was practicing the command (select * from "name of your table"). This command open what is inside your table named Actors (select * from Actors;) this command will show up names of some actors. But you have to create the table and then execute the command.
Tuesday, December 14, 2010
SQlite
Yesterday a successful day because I got introduce to this new program SQlite.
I run the program with (sqlite3) just to play around with it and after making some tables about Actors and Movies. After a while wondering how to get out of the program with out closing the terminal,
I try these commands :
but this won't work on SQlite. The right commands that will exit the program are (.quit),(.q), and (.exit) . Something new for me was that when you want to execute a command you need a dot at from of the command.
I run the program with (sqlite3) just to play around with it and after making some tables about Actors and Movies. After a while wondering how to get out of the program with out closing the terminal,
I try these commands :
exit
.exit;but this won't work on SQlite. The right commands that will exit the program are (.quit),(.q), and (.exit) . Something new for me was that when you want to execute a command you need a dot at from of the command.
Monday, December 13, 2010
Staring to learn SQLite.
I found a message from my teacher that said something about the SQLite. I don't have an idea what this means or is, but I look on Google.com for tutorial and I found one. This is a tutorial about SQLite, also this other website but I think the first one is better.
I would try to practice, because it looks really interesting. I would try to get some skills on this new topic.
I will ask my teacher for some advice about this.
I would try to practice, because it looks really interesting. I would try to get some skills on this new topic.
I will ask my teacher for some advice about this.
Friday, December 10, 2010
Reviewing
I was practicing the CSS and HTML codes so I don't forget them but I was looking at the next examples of Linux.I learn how to turn enable the syntax on the terminal.And what is syntax, this is a utility that help you on the terminal by putting the color to the HTML.
How turn on the syntax.
First of all you Type vi vimrc which is going to open a page like this ...
of course there will not we those letter where is said syntax enable
you have to type the syntax enable, so is on any time you want to view a HTML file in terminal.
How turn on the syntax.
First of all you Type vi vimrc which is going to open a page like this ...
of course there will not we those letter where is said syntax enable
you have to type the syntax enable, so is on any time you want to view a HTML file in terminal.
Wednesday, December 8, 2010
New Commands.
Practicing the tutorial I found this two commands, that for me are going to be really useful.
This commands are (mkdir) and (rmdir).
Have you ever ask your self what this two commands are. Well the (mkdir) is to created a folder . The (rmdir) is a command that remove a folder of some file.
I will keep learning more about the commands, this is really interesting.
I learn this commands on a video tutorial, that one of my classmates found.
Link: Video
This commands are (mkdir) and (rmdir).
Have you ever ask your self what this two commands are. Well the (mkdir) is to created a folder . The (rmdir) is a command that remove a folder of some file.
(mk-is a abbreviation of make )
(rm- is the abbreviation of remove )
(dir- is a directory which is the same as a Folder)I will keep learning more about the commands, this is really interesting.
I learn this commands on a video tutorial, that one of my classmates found.
Link: Video
Tuesday, December 7, 2010
Resize problem and learning Unix commands.
I was trying to fix the error on my application new iRock. There is a issues that when you want to resize the image using the (Ctrl +) the image become smaller and (Ctrl -) make the image more bigger but I can't fix it. I will look at Google.com to see if I could find a tutorial about how to fix it.
Today I learn some commands which are,
(Ctrl + z) is to get out of a file that u are editing on the terminal and I you want to edit a file the command is (vim) I was practicing this two commands today. I will practice more commands during this week.
Today I learn some commands which are,
(Ctrl + z) is to get out of a file that u are editing on the terminal and I you want to edit a file the command is (vim) I was practicing this two commands today. I will practice more commands during this week.
Thursday, December 2, 2010
I Finished the application
Today I just could finish the application and not move forward because of the early release.However I make sure that the application was running correctly and not issues.
The next week I will finish the tutorial about the Linux command that I just star reading like two weeks ago. At the end of that week I hope to be done with that tutorial and here the tutorial I will be Practicing.
The next week I will finish the tutorial about the Linux command that I just star reading like two weeks ago. At the end of that week I hope to be done with that tutorial and here the tutorial I will be Practicing.
Wednesday, December 1, 2010
iRock.
I am almost done with the new applications of iRock, and I almost finish with the application; however, there is another Function which is (function resizeRock). This is a function that make the rock resize depending on the side of the web browser.
Here is the Line which help you to resize the image of the application.
function resizeRock(){
document.getElementById("rockImg").style.height=(document.body.clientHeight - 100) * 0.9;
}
Also remembered to add on this line, the parts that are on red.<body onload="resizeRock(); greetUser();" onresize="resizeRock();">
This commands make the applicationl resize to the side of the browser.
Here is the the link of the new and old applications take a look and when u are on the browser make the browser more smaller and see what happen.
Try to do it in both.
The new Application with the resize.
This is the regular Application.
Here is the Line which help you to resize the image of the application.
function resizeRock(){
document.getElementById("rockImg").style.height=(document.body.clientHeight - 100) * 0.9;
}
Also remembered to add on this line, the parts that are on red.<body onload="resizeRock(); greetUser();" onresize="resizeRock();">
This commands make the applicationl resize to the side of the browser.
Here is the the link of the new and old applications take a look and when u are on the browser make the browser more smaller and see what happen.
Try to do it in both.
The new Application with the resize.
This is the regular Application.
Tuesday, November 30, 2010
Working on the Height and Width.
I just star working on the new application of iRock. On this application some on the common errors which are the displayed of an application on different devices.
Some applications will show up, too big or too small. This application I am working it will varies the side depending on your device you are using, not matter if you are using a computer or another electronic devices.
Like I said almost two weeks ago, the commands I will be using are (document.body.clientHeight) and (document.body.clientWidth).
Here is the link where the new iRock application will be.
Some applications will show up, too big or too small. This application I am working it will varies the side depending on your device you are using, not matter if you are using a computer or another electronic devices.
Like I said almost two weeks ago, the commands I will be using are (document.body.clientHeight) and (document.body.clientWidth).
Here is the link where the new iRock application will be.
Friday, November 19, 2010
Practicing Linux Commands
I was practicing some commands of Linux, so I don't forget how to copy files in the computer or connect to the server using the Terminal.
I learn how to copy from a serve to my PC.
Example:
cp index.html Documents/her.html
(cp) is the command copy and the (index.html) is the file I want to copy. The Documents/ is the directory where we want to copy the file and (her.html) is what I named the file after copied it.After Documents you can named the file, any name you want.
This command will work just in the local computer just to move file from one Directory to another Directory.
Second Example:
I learn how to copy from a serve to my PC.
Example:
cp index.html Documents/her.html
(cp) is the command copy and the (index.html) is the file I want to copy. The Documents/ is the directory where we want to copy the file and (her.html) is what I named the file after copied it.After Documents you can named the file, any name you want.
This command will work just in the local computer just to move file from one Directory to another Directory.
Second Example:
Wednesday, November 17, 2010
iRock application.
I was working on my new example which is similar to the older rock example. By the day of tomorrow I will have my first link to the application. Also I will put some examples of the commands I will be using in this application.
Tuesday, November 16, 2010
A new iRock application.
I started a new application on which the rock is going to show a message every certain amount of time when your mouse is inactive.
First I going to to setup the Height and the Width of the page.
This are what we are going to used:
document.body.clientHeight - this will help me to created a how tall the page will look.
document.body.clientWidth - this will to created how long the page will be.
The application will said something like "wake up " or "Lonely" when the mouse is inactive on the wed site.
Tomorrow I will post the commands of the application and explain some of them.
First I going to to setup the Height and the Width of the page.
This are what we are going to used:
document.body.clientHeight - this will help me to created a how tall the page will look.
document.body.clientWidth - this will to created how long the page will be.
The application will said something like "wake up " or "Lonely" when the mouse is inactive on the wed site.
Tomorrow I will post the commands of the application and explain some of them.
Monday, November 15, 2010
Client Side and Server Side
What is a client and server side?
Client sideThe client sever is an application that is just in your computer which won't do anything because the application is not in a sever. This application will not load or return any information because it doesn't know where to get information. The client side you just created the document of any application.
Server side
The server side will return information of what you are asking because this application is on the storage sever and it knows where to get the information you are asking.
Wednesday, November 10, 2010
Wendsday, November 10, 2010
Today I finally finish the example of the Duncan's Donuts . It was hard but I work hard to finish it. Yesterday I couldn't make any progress because I was doing a test, but today I work hard to complete this assignment. I hope that the other example get more harder than this one so we can learn more.
Monday, November 8, 2010
Monday, November 8, 2010
Today I finally move forward on the example of the Donuts. For this week I will try to finish the example and see how it works and try to do another example of something more challenging so I can learn more.
Friday, November 5, 2010
Friday , November 5, 2010
Today I help my class mate Josue with the HTML because he was getting some errors on his page. I didn't make any progress on the example of the donuts today because I need some advice from my teacher. By the next week I will work hard and try to finish the example.
Wednesday, November 3, 2010
Thursday, November 3, 2010
Today I was trying to work on the example of the donuts but i don't how to continue.
I got some issues on the page that I am. On Monday I will talk to my teacher about it, to see what advice he give me .
I got some issues on the page that I am. On Monday I will talk to my teacher about it, to see what advice he give me .
Monday, November 1, 2010
Monday, November 1, 2010
- What did I accomplish during 1st quarter?
- Did my accomplishments meet my expectations? Why or why not?
- What did I learn during 1st quarter?
- In what ways will this knowledge be useful to me in the future?
- What new skills did I acquire? What can I do now that I couldn't do when the 1st quarter began?
- What will be the focus of my learning during 2nd quarter?
- What new skills do I plan to acquire during 2nd quarter?
- What do I plan to accomplish during 2nd quarter?
I accomplish the example of a little rock that ask you for your name. Take a look here it is.
I got more than what i thought last quarter because now i am learning JavaScript which will help me on python
The last Quarter I learn and I still learning. This is a new skill for me and I is a awesome thing because I will get more skills.
This knowledge will help to improve my skills on JavaScript and it will help when i go back to python because python used the same codes like JavaScript.
I got a new skill which is JavaScript, I am learning this because the python use the same codes like JavaScript.Now I can how JavaScript works and know some code and what they using for, this is a new skill for me.
During the 2nd I will focus on learning JavaScript as much I can and try to become a better web site developer.
This quarter I will try to learn the entire codes of JavaScript and learn to used python better.
I would try to become better in python and JavaScript by the end of the 2nd quarter.
Friday, October 29, 2010
Friday , October 29, 2010
Today I didn't much progress because I got stuck with some codes and my application still the same like yesterday .I will wait until Monday to ask my teacher about this issue and see what he said. Maybe he could give me some advise how to continue the application.
Thursday, October 28, 2010
Thursday, October 28, 2010
Today I fix a problem that I noticed in my last example the rock. Try the example and now when the page load it would show (Hello, I am your pet Rock.). The last two days I didn't found out that there was a error but today I noticed and fixed. Also today I work on the example of the (Donuts). This Example will take me a while to finish but I will try my hard.
Wednesday, October 27, 2010
Wendsday, October 27, 2010
Today I was working on the example of the book. Here is the Code. This example need is more complicated that the other rock example. I am working hard to understand everything of JavaScript.
Tuesday, October 26, 2010
Tuesday, October 26, 2010
- Today I will star a new example from the book and try to see how it work. This example is about ordering donuts.This is how far i got today and I will try to finish it by this week. This will be a long example because if has a lot of codes and I want to make sure I know the majority of the codes.
- You can view the code of this Application using (Ctrl + U) when you get to where it said "Donuts".
Monday, October 25, 2010
Monday, October 25, 2010
Today with some help of my teacher I finally finish the example of the rock. And take a look at this example. Also here is the code if you want to take a look at it.
Here are some screenshot that I took of this work that I have done.
this is when the application give you a respond after entering your name. And note that the picture still the same but after you click "OK" the picture will change.
here is the last picture of the application which is a smiling rock.
Here are some screenshot that I took of this work that I have done.
This is the picture when the web page load.
and this is when the application ask you for your name
here is the last picture of the application which is a smiling rock.
Friday, October 22, 2010
Friday , October 22, 2010
Today I was working on some issues that were on the example of yesterday and i make some progress. I will finish this example next week.
Thursday, October 21, 2010
Yesterday i was working on a example of the JavaScript Book. It is about a rock that ask your name and inter act with people. And here is the Example take a look.
Wednesday, October 20, 2010
Thursday, October 20, 2010
Today my teacher teach me about the differences between a client (browser) and server. Client (browser) send a HTTP request to the Server and the server return a HTTP respond to the client. Both of this are different because the Client we used in the computer but the Sever is like a storage place which websites are storages. The Client used the JavaScript programing which is in your PC. In the Server we work on the Server where the data is storage. Today i help one of my classmate to fix his page and make it more organized.
Tuesday, October 19, 2010
Tuesday, October 19, 2010
Today i was helping on of my classmate. He just star today learning about the HTML and I will help him to improve his knowledge about the HTML. I think I am almost ready to go back to web2py.
Friday, October 15, 2010
Friday , October 15, 2010
This week I was studying the forms of this example above. This is a pretty nice example about the form but the are some tags that I don't know like this <fieldset>, <legend>, <small> and <label>. The next week I would ask my teacher about this tags. Here is the code of the picture above. I add the validation button at the bottom.
Thursday, October 14, 2010
Thursday, October 14, 2010
Today I was looking at the example codes and I was searching for a tutorial that show me how to customize the example and make it look better. I couldn't find a good tutorial today but i will spend some time tomorrow to search for a tutorial.
Wednesday, October 13, 2010
Wendsday, October 13, 2010
file:///home/hToday I was trying to edit this example, this example that is from the website www.tizag.com. I want to used this example like my base and made it to my own style. Here is the code. This application just ask you for your name and password and it send if to your self.I want to find out, if there is a option to modify that and send the Name and Password to any email that the people want to send it. This is the goal for this week and so with this I would learn more about forms.
Tuesday, October 12, 2010
Tuesday, October 12, 2010
Today I was reading the tutorial about the forms, on the same website from last week. I am working hard to understand forms but they are kind of hard but still working hard to understand.
Friday, October 8, 2010
Friday , October 8, 2010
Thursday, October 7, 2010
Thursday, October 7, 2010
Today I was reading some tutorial about the forms and I learn that in any form need to have <input type="text">, this define a section where the user can enter any text. The input could ask you about (Password, Name or Last Name). The input have many attributes that are type text field, check box, password, radio button, submit button, and more). There are more commands for the input and I will be looking at them tomorrow and learn what they are for and try then on my website.
Tutorials at this sites:
w3schools
tizag (this website I found it today)
I think this are two good sites to learn about the forms before I get into the web2py programing.
Tutorials at this sites:
w3schools
tizag (this website I found it today)
I think this are two good sites to learn about the forms before I get into the web2py programing.
Wednesday, October 6, 2010
Wendsday, October 6, 2010
Today I apply some of the codes that are in here, and here is my new look of my website. I still have an error when I try to validate the website, but I will work on that tomorrow and try to fix it.
Tuesday, October 5, 2010
Tuesday, October 5, 2010
Today I found a tutorial here in the w3schools , here they have good tutorials about the form. This week I will be trying the form they have and try to apply to my website. Also I will be try to apply some of the effects to my website, that are in this website which is an example here.
Friday, October 1, 2010
Friday , October 1, 2010
Today I was reading the book and I didn't found any error in the application I re-write from the book.The application that I wrote is the same from the book. Next week I will try to get help and found out why it doesn't work the way if suppose to do.
Thursday, September 30, 2010
Thursday, September 30, 2010
Today I was trying to found out if there was any bug in the application House Finder. I was looking in the book to if a made any mistake when I was typing the the application. Here is the text of the application. Tomorrow I will finish reading the book and see what I can do, to fix the errors.
Wednesday, September 29, 2010
Wendsday, September 29
Today I was reading the new book name (Have First "Java Script") and I try an example name House Finder. This is an application that help you to find a house.
I think there was bug in the application. Also I learn that some commands of the terminal.
I think there was bug in the application. Also I learn that some commands of the terminal.
Tuesday, September 28, 2010
Yesterday I learn how to move a file form my desktop to a host.
We move the file using the Terminal and it was kind of hard because if was the first time I was doing it .
We move the file using the Terminal and it was kind of hard because if was the first time I was doing it .
Monday, September 27, 2010
Monday, September 27, 2010
Today i was learning about the Java Script and i learn some codes to change the color of the background. Also a kind of application that ask if for your name and submit your name.
Friday, September 24, 2010
Friday , September 24, 2010
Today I was typing this commands in the terminal, the commands are on this page that I was reading yesterday and they work. I am learning the commands because they are helpful on the language of web2py because I am going to be using them. This picture above is a screenshot that I took from the page.
Thursday, September 23, 2010
Thursday, September 23, 2010
Today I learn how to let other people view my applications on web2py. There is another thing that I learn was that /sbin/ifconfig is the command to view the IP address of my account on the computer. Also I am going to be reading this turorial
to learn more about the Terminal and all the commands.
to learn more about the Terminal and all the commands.
Friday, September 17, 2010
Friday , September 17, 2010
Today I didn't make any progress because all the students were acting for a video about the school.
Thursday, September 16, 2010
Thursday, September 16, 2010
Today I was trying to log into web2py server, but there was a problem and thanks to Mr.Elkner he fix it and I was ready to star the server. My goal for this year is to learn more and more about web2py. tomorrow I would try to make more progress on the web2py language.
Wednesday 15, 2010
Yesterday (Wednesday 15, 2010 ) I was working on the examples of web2py and trying to understand those examples, but those examples are hard. So I think it will take me more longer than what I expected. Also I help my classmate with the HTML. This was the reason I couldn't do my post yesterday.
Wednesday, September 15, 2010
Staring
Yesterday I was trying to do the example that are in web2py.com I got some progress yesterday. Today i would try to get done with those steps.
Subscribe to:
Posts (Atom)