{"action":"created","issue":{"url":"https://api.github.com/repos/haccer/twint/issues/135","repository_url":"https://api.github.com/repos/haccer/twint","labels_url":"https://api.github.com/repos/haccer/twint/issues/135/labels{/name}","comments_url":"https://api.github.com/repos/haccer/twint/issues/135/comments","events_url":"https://api.github.com/repos/haccer/twint/issues/135/events","html_url":"https://github.com/haccer/twint/issues/135","id":328828095,"node_id":"MDU6SXNzdWUzMjg4MjgwOTU=","number":135,"title":"new  feature implemented and tested -> version 1.1.3.4 with mysql support","user":{"login":"Nestor75","id":12037308,"node_id":"MDQ6VXNlcjEyMDM3MzA4","avatar_url":"https://avatars2.githubusercontent.com/u/12037308?v=4","gravatar_id":"","url":"https://api.github.com/users/Nestor75","html_url":"https://github.com/Nestor75","followers_url":"https://api.github.com/users/Nestor75/followers","following_url":"https://api.github.com/users/Nestor75/following{/other_user}","gists_url":"https://api.github.com/users/Nestor75/gists{/gist_id}","starred_url":"https://api.github.com/users/Nestor75/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Nestor75/subscriptions","organizations_url":"https://api.github.com/users/Nestor75/orgs","repos_url":"https://api.github.com/users/Nestor75/repos","events_url":"https://api.github.com/users/Nestor75/events{/privacy}","received_events_url":"https://api.github.com/users/Nestor75/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2018-06-03T13:18:05Z","updated_at":"2018-06-03T17:19:21Z","closed_at":null,"author_association":"NONE","body":"# Issue Template\r\nPlease use this template!\r\n\r\n### Initial Check \r\n> If the issue is a request please specify that it is a request in the title (Example: [REQUEST] more features). If this is a question regarding 'twint' please specify that it's a question in the title (Example: [QUESTION] What is x?). Please **only** submit issues related to 'twint'. Thanks.\r\n\r\n>Make sure you've checked the following:\r\n\r\n- [x] Python version is 3.5 or higher.\r\n- [x] Using the latest version of Twint.\r\n- [x] I have searched the issues and there are no duplicates of this issue/question/request.\r\n\r\n### Command Ran\r\nimport  twint\r\nc = twint.Config()\r\nc.Count = True\r\nc.Limit = \"5000\"\r\n\"\"\"\r\n#output csv\r\nc.Output = \"file.csv\"\r\nc.Store_csv = True\r\n\"\"\"\r\n#output database\r\nc.hostname=\"localhost\"\r\nc.Database = \"twitterdata_v9\"\r\nc.DB_user = \"root\"\r\nc.DB_pwd = \"password\"\r\n\r\nc.search_name =\"testmysql1_es\"\r\n\r\nc.Search = \"3dprinter\"\r\n\r\nc.Since = \"2017-09-01\"\r\nc.Until = \"2017-11-02\"\r\nc.Lang = \"es\"\r\ntwint.run.Search(c) #busca tweets\r\n\r\n### Description of Issue\r\nFirst thing, I am not a mysql , python and github expert so.... excuseme if my code and methods are not the best ones. \r\n\r\nSo sorry but I could not create a new pull request, new branch or any other thing to share with all of the the code I modified for adding **mysql** support.  I have attached here all the files in a ZIP.\r\nthe mysql database schema for creating the DB is also included. \r\nthe collation is very important to avoid problem inserting many characters and it should be utf8mb4.\r\n\r\nsome improvements pending to insert some date and times like that and not like text.\r\nI included all the modifications on latest  version published 1.1.3.4\r\n\r\nadded a parameter called \"search_name\". this parameter is for identifying to which search result a twitter belongs to. A tweet could belong to more than a search so this field is also PK. if it is not set, the default value will be \"-\"\r\n\r\none of the bets features of using mysql instead of SQLITE3 is that you can execute several instances in parallel and store the data in the same database so so can get all the results more faster. \r\n\r\nIf will be great if you could merge this code with yours. \r\n\r\n\r\n[twint-master1.1.3.4 mysql.zip](https://github.com/haccer/twint/files/2065969/twint-master1.1.3.4.mysql.zip)\r\n\r\n\r\n### Environment Details\r\n>Using Windows, Linux? linux What OS version? ubuntu Running this in Anaconda? no Jupyter Notebook? no Terminal? yes\r\n"},"comment":{"url":"https://api.github.com/repos/haccer/twint/issues/comments/394177031","html_url":"https://github.com/haccer/twint/issues/135#issuecomment-394177031","issue_url":"https://api.github.com/repos/haccer/twint/issues/135","id":394177031,"node_id":"MDEyOklzc3VlQ29tbWVudDM5NDE3NzAzMQ==","user":{"login":"pielco11","id":17363750,"node_id":"MDQ6VXNlcjE3MzYzNzUw","avatar_url":"https://avatars3.githubusercontent.com/u/17363750?v=4","gravatar_id":"","url":"https://api.github.com/users/pielco11","html_url":"https://github.com/pielco11","followers_url":"https://api.github.com/users/pielco11/followers","following_url":"https://api.github.com/users/pielco11/following{/other_user}","gists_url":"https://api.github.com/users/pielco11/gists{/gist_id}","starred_url":"https://api.github.com/users/pielco11/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pielco11/subscriptions","organizations_url":"https://api.github.com/users/pielco11/orgs","repos_url":"https://api.github.com/users/pielco11/repos","events_url":"https://api.github.com/users/pielco11/events{/privacy}","received_events_url":"https://api.github.com/users/pielco11/received_events","type":"User","site_admin":false},"created_at":"2018-06-03T17:19:21Z","updated_at":"2018-06-03T17:19:21Z","author_association":"COLLABORATOR","body":"I suggest you to read [here](https://help.github.com/articles/syncing-a-fork/) to see how syncing a fork works, if you are not really really familiar with terminals you can use [GitKraken](https://www.gitkraken.com/)"}}
{"actor":{"display_login":"pielco11"}}