notebook.community

Edit and run



In [1]:

    
import sqlite3
import requests



In [44]:

    
import dankmeme



In [45]:

    
dankmeme.creatememe('/home/wcmckee/meme/meme/galleries/default/61585.jpg', 
                    "/mnt/c/Users/luke/Downloads/impact.ttf",
                    'CHECKS OVERSEAS WEATHER OF GIRL HE LIKES',
                    'GETS THE COUNTRY WRONG', '/mnt/c/Users/luke/Desktop/t2.jpg')



In [ ]:



In [2]:

    
def createQuizDB(namedb):
    conn = sqlite3.connect('{}.db'.format(namedb))
    c = conn.cursor()

    # Create table
    c.execute('''CREATE TABLE quiz
             (zhch text, english text, image text, pingyin text)''')



In [16]:

    
createQuizDB('china')



In [57]:

    
def createQuiz(zhch, english, wrong, image):
    conn = sqlite3.connect('china.db')
    c = conn.cursor()
    #hashpass = pwd_context.hash(password)
    hanjs = requests.get('https://glosbe.com/transliteration/api?from=Han&dest=Latin&text={}&format=json'.format(zhch))
    pingzh = hanjs.json()
    dankmeme.creatememe('/home/wcmckee/meme/meme/galleries/default/61585.jpg', 
                    "/mnt/c/Users/luke/Downloads/mingliu.ttc",
                    zhch, pingzh['text'], '/mnt/c/Users/luke/Desktop/{}.jpg'.format(english.replace(' ', '-')))
    c.execute("INSERT INTO quiz VALUES ('{}', '{}', '{}', '{}', '{}')".format(zhch, english, wrong, image, pingzh['text']))
    
    conn.commit()

    # We can also close the connection if we are done with it.
    # Just be sure any changes have been committed or they will be lost.
    conn.close()
    #returnCountUsers()



In [49]:

    
def returnQuiz():
    conn = sqlite3.connect('china.db')
    c = conn.cursor()
    allfod = c.execute('SELECT * FROM quiz')
    return(allfod.fetchall())



In [50]:

    
def returnRandomQuiz():
    conn = sqlite3.connect('china.db')
    c = conn.cursor()
    allfod = c.execute('SELECT * FROM quiz ORDER BY RANDOM() LIMIT 1;')
    return(allfod.fetchall())



In [51]:

    
returnran = returnRandomQuiz()



In [52]:

    
returnran[0][0]









    Out[52]:





'我不爱你'



In [53]:

    
returnQuiz()









    Out[53]:





[('你不吃吗？',
  'you do not eat it?',
  'we ate the food',
  'img12.jpg',
  'nǐ bù chī ma？'),
 ('我不爱你', 'I do not love you', '我爱她平', 'test.png', 'wǒ bù ài nǐ'),
 ('奶茶', 'milk tea', '茶爱奶茶', '1.png', 'nǎi chá'),
 ('珍珠奶茶，大杯，去冰，不要糖，謝謝',
  'Pearl (bubble) milk tea, No ice, No sugar, thank you.',
  '我是谢谢不高你杯 天天',
  '1.png',
  'zhēn zhū nǎi chá， dà bēi， qù bīng， bù yào táng， xiè xiè'),
 ('我爱吃珍珠奶茶',
  'I love to drink Pearl (bubble) milk tea',
  '我爱是谢',
  '1.png',
  'wǒ ài chī zhēn zhū nǎi chá')]



In [54]:

    
奶茶









    



---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
<ipython-input-54-9ffa3b842ffe> in <module>
----> 1 奶茶

NameError: name '奶茶' is not defined



In [58]:

    
createQuiz('我是她的哥哥', 'I am her brother', '你不得嘛嘛', '1.png')



In [59]:

    
returnQuiz()









    Out[59]:





[('你不吃吗？',
  'you do not eat it?',
  'we ate the food',
  'img12.jpg',
  'nǐ bù chī ma？'),
 ('我不爱你', 'I do not love you', '我爱她平', 'test.png', 'wǒ bù ài nǐ'),
 ('奶茶', 'milk tea', '茶爱奶茶', '1.png', 'nǎi chá'),
 ('珍珠奶茶，大杯，去冰，不要糖，謝謝',
  'Pearl (bubble) milk tea, No ice, No sugar, thank you.',
  '我是谢谢不高你杯 天天',
  '1.png',
  'zhēn zhū nǎi chá， dà bēi， qù bīng， bù yào táng， xiè xiè'),
 ('我爱吃珍珠奶茶',
  'I love to drink Pearl (bubble) milk tea',
  '我爱是谢',
  '1.png',
  'wǒ ài chī zhēn zhū nǎi chá'),
 ('我爱吃珍珠奶茶',
  'I love to drink Pearl (bubble) milk tea',
  '我爱是谢',
  '1.png',
  'wǒ ài chī zhēn zhū nǎi chá'),
 ('我是她的哥哥', 'I am her brother', '你不得嘛嘛', '1.png', 'wǒ shì tā de gē gē')]



In [37]:

    
returnran[0][4]









    Out[37]:





'nǐ bù chī ma？'



In [ ]:



In [26]:

    
import svgwrite



In [27]:

    
dwg = svgwrite.Drawing('example.svg', profile='tiny')



In [43]:

    
import svgwrite

dwg = svgwrite.Drawing('test.svg', profile='tiny')
dwg.add(dwg.text(returnran[0][0], insert=(0, 0), font_size="12px", fill='red'))
dwg.add(dwg.text(returnran[0][4], insert=(0, 12), font_size="12px", fill='black'))

dwg.save()



In [ ]:



In [36]:

    
#returnq[0][0]









    Out[36]:





'你不吃吗？'



In [73]:

    
#answerq = input('What is "{}" in english? '.format(returnq[0][0]))









    



What is "我是男人" in english? i am man



In [74]:

    
#returnq[0][1]









    Out[74]:





'i am man'



In [ ]:



In [ ]:



In [75]:

    
#if answerq == returnq[0][1]:
#    print('correct')
#else:
#    print('wrong')









    



correct



In [ ]:

    
#SELECT * FROM table ORDER BY RANDOM() LIMIT 1;



In [ ]:



In [27]:

    
#createQuizDB('china')



In [31]:

    
#createQuiz('我不爱你', 'I do not love you', '我爱她平', 'test.png')



In [1]:

    
#def createquiz(zhch, engls, wronganswers, image):
#    hanjs = requests.get('https://glosbe.com/transliteration/api?from=Han&dest=Latin&text={}&format=json'.format(zhch))
#    pingzh = hanjs.json()
#    return({'zh-ch' : zhch, 'englis' : engls, 'wrong' : wronganswers, 'image' : image, 'pinyin' : pingzh['text']})



In [4]:

    
#quizjs = createquiz('我不爱你', 'I do not love you', '我爱她平', 'test.png')



In [5]:

    
#quizjs['wrong']









    Out[5]:





'我爱她平'



In [6]:

    
#quizjs['zh-ch']









    Out[6]:





'我不爱你'



In [7]:

    
#quizjs









    Out[7]:





{'englis': 'I do not love you',
 'image': 'test.png',
 'pinyin': 'wǒ bù ài nǐ',
 'wrong': '我爱她平',
 'zh-ch': '我不爱你'}



In [ ]:

    
#print()



In [ ]:

    
#qweqw



In [5]:

    
#print('你好')