Ruby Sinatra table from MySQL -


i working on project have pull data mysql database , display data in table using ruby sinatra.

i able connect database , pull data , put inside array.

example of table in database

city country dallas usa tokyo japan

example of array looks like

["dallas, usa", "tokyo, japan"]

now, how display array table database. or, there way can copy table database onto webpage?

thanks help!

your_app/routes.rb:

require 'sinatra' require 'slim'  '/'    raw_data = [     "dallas, usa",      "tokyo,japan",      "munich,    germany",   ]    @results = {}    raw_data.each |item|     city, country = item.split(/, \s* /x)     @results[city] = country   end    p results # {"dallas"=>"usa", "tokyo"=>"japan", "munich"=>"germany"}    slim :index   end

your_app/views/layout.slim:

doctype html  html   head      meta charset="utf-8"     title test     css:       th {text-align:left}       table {width: 15em}   body      h1 layout.  find me in your_app/views/layout.slim     == yield

note css, left aligns column headers--otherwise column headers centered.

your_app/views/index.slim:

table    thead     tr       th city       th country    tbody   - @results.each |city, country|     tr       td = city       td = country

result:

enter image description here

edit:

to use jquery program tablesorter, download tablesorter, unzip/untar it, move newly created directory, tablesorter-master, directory your_app/public/.

you can use these files:

your_app/views/layout.slim:

doctype html  html   head      meta charset="utf-8"     title test     link rel="stylesheet" type='text/css' href="tablesorter-master/themes/green/style.css"   body      h1 layout.  find me in your_app/views/layout.slim     == yield       script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js" !<= link     script src="tablesorter-master/jquery.tablesorter.js"     script src="hookup_tablesorter.js"

your_app/public/hookup_tablesorter.js:

$(document).ready(function()    {      $("#mytable").tablesorter();    }  );

your_app/views/index.slim:

table id="mytable" class="tablesorter"   thead     tr       th city       th country    - @results.each |city, country|     tr       td = city       td = country

note changes above. slim adds tbody tag automatically, therefore explicitly adding tbody tag in slim template creates 2 tbody tags screws tablesorter.

then see this:

enter image description here

and clicking on column headers sort rows. need internet connection link jquery file. alternative, can download jquery, , put in directory your_app/public/, link it:

doctype html  html   head      meta charset="utf-8"     title test     link rel="stylesheet" type='text/css' href="tablesorter-master/themes/green/style.css"   body      h1 layout.  find me in your_app/views/layout.slim     == yield       script src="jquery.min.js"     script src="tablesorter-master/jquery.tablesorter.js"     script src="js_ready.js"

if don't table style, tablesorter has blue theme:

enter image description here

and people have created other styles.


Comments

Post a Comment

Popular posts from this blog

powershell Start-Process exit code -1073741502 when used with Credential from a windows service environment -

i'm running strange behavior powershell start-process call. here call: $process = start-process ` "c:\somepath\mybinary.exe" ` -passthru ` -credential $defaultcredential ` -wait ` -workingdirectory "c:\somepath" ` -loaduserprofile if ($process.exitcode -ne 0) { #do } this call return exit code - 1073741502 . after quick search, exit code seems related generic error when program not load required dll (aka. status_dll_init_failed ). when run without -credential $credential program runs correctly. in order isolate problem, manually launched some.exe in prompt target credential , runs smoothly. so problem seems come way start-process cmdlet launch process. i found potential solutions problem tried apply no luck : link , link . would have idea of what's going on here ? edit 1: run proc mon monitoring program activities when launched directly or via powershell script. problem seems occur when loading kernelbase
Read more

twig - Using Twigbridge in a Laravel 5.1 Package -

i'm trying create laravel 5.1 package uses twigbridge instead of .php views. can normal .php views display fine, when try make use of .twig templates i'm met error. possible use twigbridge templates when creating views laravel package or pretty stuck blade , php ? edit 1: loading twig template without extending works. it's when start using {% extends 'file' %} error comes out. i error error loading /virtual/laravel/packages/username/mypackage/src/views/sample.twig: template "templates.master" not defined () in "/virtual/laravel/packages/username/mypackage/src/views/sample.twig" @ line 1. my folders username |_ mypackage |_ src |_ controllers - samplecontroller.php |_ views |_ templates - master.twig - sample.twig twig template sample.twig {% extends 'templates.master' %} {% block content %} {{ parent()
Read more

c# - LINQ join Entities from HashSet's, Join vs Dictionary vs HashSet performance -

i have hashset's each stores t, have written test application compares different relation algorithms can think of, i'm not pleased results getting. does there exist more efficient ways of achieving object relations, once testing? using system; using system.collections.generic; using system.linq; using system.text; using system.threading.tasks; using system.diagnostics; namespace linqtests { class program { static void main(string[] args) { hashset<user> usertable = new hashset<user>(); hashset<userproperty> userpropertytable = new hashset<userproperty>(); #region lets create dummy data. console.writeline("please wait while creating dummy data, can take while..."); console.writeline(""); int rows = 1000000; for(int x = 0; x < rows; x++) { random rnd = new random(); // ad
Read more