Code Docta (Nick C.) 638 Posted March 7, 2014 Report Share Posted March 7, 2014 SQLite Database TutorialFeatures:Creates DatabaseSelect/Change DatabaseCreates Projects TableCreates new projectDisplays tablesDeletes tablesCreates profiles tableCreates any tableAdds E-mail and password to profiles tableAssigns random proxies to all accounts or per profileOver 15 commands and functionsSQLite Queries used:CREATE TABLE IF NOT EXISTS PRIMARY KEY AUTOINCREMENT INSERT INTO SELECT SELECT FROM DROP TABLE DELETE FROM FOREIGN KEY ALTER TABLE UPDATE ADD COLUMN COUNTThis is a training bot that is capable of making real databases. It is designed to be user friendly and intuitive. It is heavily commented and all you have to do is press buttons, if necessary fill in the blanks. Plugins used:SQLite Plugin: NOT included, you must buy this from the developer and any support for it is from the developer. I am not affiliated in any way with this plugin. I just learnt how to use this one first.File Management: FreeString Management: FreeDate/Time Manipulation: Free There is a resource tab that has buttons that will take you to these threads and other resources. Best thing about it…it’s FREE...Wait…wuh? Well, If you care to donate PM me and I will give you Paypal info to send donations to.For those who don’t or can’t donate at least hit the like button. Coded in Ubot 4, untested in Ubot 5. I assume it could work in 5. Anyone interested in joining the "SQLite Help" Skype Group,just add me to Skype or shoot me a message "add me to SQLite group" to seoproranker and I will add you ASAPaka Traffik Copper Thank You and Enjoy,TC updated to SQLite-DB-Tutorial-3-7-2014also changed "current database function" the file path should be Database not Databasesin fact where ever the file path is "Databases" should be "Database" but I think I got them now in 3-7-2014 version. added drop table and when you create table te first colomn will now say "yourtablename_ID" instead of Project_ID in 3-7-2014-2SQLite-DB-Tutorial-3-7-2014-2.ubot 16 Quote Link to post Share on other sites
pftg4 102 Posted March 7, 2014 Report Share Posted March 7, 2014 wow holy crap TC nice post 1 Quote Link to post Share on other sites
Aymen 385 Posted March 7, 2014 Report Share Posted March 7, 2014 Very Nice Share!Keep It up! Quote Link to post Share on other sites
dr. dre 23 Posted March 7, 2014 Report Share Posted March 7, 2014 Awesome share TC 1 Quote Link to post Share on other sites
jamesfar 15 Posted March 7, 2014 Report Share Posted March 7, 2014 like it TC Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted March 7, 2014 Author Report Share Posted March 7, 2014 Glad you like it guys, For those that already downloaded. I forgot to add the custom command "Database folder exist" to create database button node. Under the custom commands drag the "Database Folder Exist" into the create DB button and after the first "set" and before "sqlite create database" nodes. TC also noticed the Current Db function in the file path is Databases and should be Database, sorry guys In addition to the custom command database folder exist need to drag APP DATA folder exist and put it before database folder exist. Or just download latest Quote Link to post Share on other sites
Sanjeev 46 Posted March 7, 2014 Report Share Posted March 7, 2014 Thanks Traffik cop! Quote Link to post Share on other sites
giganut 109 Posted March 7, 2014 Report Share Posted March 7, 2014 I have been waiting for this, thanks a bunch! Quote Link to post Share on other sites
blumi40 222 Posted March 7, 2014 Report Share Posted March 7, 2014 thx TCthat one will help many ppl i thing...well done! Quote Link to post Share on other sites
malefic 48 Posted March 7, 2014 Report Share Posted March 7, 2014 Nice one TC, good to see a detailed tutorial! Quote Link to post Share on other sites
Steve 30 Posted March 7, 2014 Report Share Posted March 7, 2014 Awesome share! Quote Link to post Share on other sites
Kreatus (Ubot Ninja) 422 Posted March 7, 2014 Report Share Posted March 7, 2014 Nice one TC! Thanks for this Quote Link to post Share on other sites
don 1 Posted March 7, 2014 Report Share Posted March 7, 2014 Thanks TC, badly needed Quote Link to post Share on other sites
BoosterBots 23 Posted March 7, 2014 Report Share Posted March 7, 2014 Great share! I will be using this to help me learn quite a few things u rock! Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted March 7, 2014 Author Report Share Posted March 7, 2014 ok I found another one. In functions tab under commands In the "define Select Database" first set node in get files function "Databases" needs to be "Database" I will upload new. Thanks everyone especially the Donors!! you will be rewarded TC Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted March 8, 2014 Author Report Share Posted March 8, 2014 see OP I updated again 3-7-2014-2 Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted March 8, 2014 Author Report Share Posted March 8, 2014 anyone is welcome to join the SQLite Help group just throw this in address bar skype:?chat&blob=14QONkmIm02UnfvP9qkl5ltcyonh4j0iQW2hJTJY28HxXOPYXi2UZA or there is button in Resource tab TCSQLite-DB-Tutorial-3-7-2014-2.ubot Quote Link to post Share on other sites
jamesfar 15 Posted March 8, 2014 Report Share Posted March 8, 2014 i have copy paste this skype:?chat&blob=14QONkmIm02UnfvP9qkl5ltcyonh4j0iQW2hJTJY28HxXOPYXi2UZA on address bar ... skype open but seems nothing happen Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted March 8, 2014 Author Report Share Posted March 8, 2014 @jamestar if you put it the message area of skype then press enter then click on the link or put it in the address bar of you browser like a URL then enter it should give you pop up or take you to the group. There is a button in latest update to press inn resource tab for the Skype group as well. If all else fails add me to skype and I will add you to the group my Sk-ype name is seoproranker and lemme know that it's for SQLite so I can add you to the correct group. Quote Link to post Share on other sites
don 1 Posted March 8, 2014 Report Share Posted March 8, 2014 I can not join the group, any other way? Quote Link to post Share on other sites
Frank 177 Posted August 10, 2015 Report Share Posted August 10, 2015 Question regarding the code in the bot. I noticed that in the Delete Project Table section, there are two commands, 'Drop Table Projects' and DELETE FROM Tables WHERE TableName='Projects''. What's the reason for the second command? Frank Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted August 10, 2015 Author Report Share Posted August 10, 2015 DELETE TABLEdeletes a record/records/all recordswith out deleting the table DROP TABLEremoves the whole existence of the table "DELETE FROM Tables WHERE TableName='Projects'' is an example of how to delete a record from a table Does that answer tour question? Quote Link to post Share on other sites
Frank 177 Posted August 11, 2015 Report Share Posted August 11, 2015 Thanks mate, so 'Drop Table' by itself won't do the whole job? Is there a administrative table where this entry is removed by the 'delete table'? Thanks! Frank Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted August 11, 2015 Author Report Share Posted August 11, 2015 DELETE TABLE: does not do the whole job. if you open a .txt file with content and delete the content then save the empty file. DROP TABLE: if you delete the file itself Yes, there is a master table that sqlite uses to keep track of stuffs.It holds the "Tables" table. This is created when you create the DB. There is an add on for Firefox called SQlite Manager, you can test queries and much more. It is wonderful. You can see the master table too. Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted August 11, 2015 Author Report Share Posted August 11, 2015 I will be doing something similar with U5's Python someday. You can play with it now. https://docs.python.org/2/library/sqlite3.html That is the proper version of python syntax to use the example codes. ironpython uses 2.7 python. As you can you will see it is more robust than the PAID PLUGIN. Regards,CD(Nick) Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.