sql - Stored procedure for adding a movie -

-

i'm creating stored procedure adding movie (i'm working on application stores , lists movies information), , before getting started input on how create it.

i have following tables:

  1. "movie" (movieid, name, year, length, summary)
  2. "genre", list of genres (genreid, genre)
  3. "moviegenre", list of movies , genre/s. (moviegenreid, genreid, movieid)
  4. "movierole", stores name of actors/directors etc (movieroleid, name)
  5. "movieroletype", stores different kinds of roles movie, actor (movieroletypeid, movieroletype)
  6. "cast", list of movies cast's (castid, movieroletypeid, movieid, movieroleid)

when adding movie must provide information movie, @ least 1 movie role (eg. actor) , genre. should create several sp:s , execute them 1 sp, or how should do?

note: i'm not asking write whole sp me, asking guideline.

thanks in advance!

i create several separate stored procedures , use transaction make sure inserts committed together.

you going need separate sps add additional cast members, genres, etc. doesn't make lot of sense me have 1 large sp , of support code goes calling sp add new movie + role + genre , have separate sps (and support code) duplicate adding of roles , genres. using transaction wrap of separate sps single action making appear single sp giving flexibility use individual sps well.

you're going need support code call each of individual sps anyway. code validate parameters, handle errors, set sp's values, etc. you'll need functions addrole, addgenre, etc. in application. i'd rather have 1 function in code called addmovie started transaction , called each of these individual functions. break job small, testable pieces , build larger functions (addmovie) calling smaller pieces know work. more complicated build addmovie function called different sp lot of same things pieces have do.


Comments

Post a Comment

Popular posts from this blog

jasper reports - Fixed header in Excel using JasperReports -

-
how can create excel report fixed header using japserreports? mean need header fixed when scroll excel file. this possible adding couple properties in jrxml file each report. take @ advanced excel features freeze panes. if wanted freeze after first column header (down left side basically) this: <statictext> <reportelement style="sans_bold" mode="opaque" x="0" y="60" width="104" height="20" forecolor="#ffffff" backcolor="#666666"> <property name="net.sf.jasperreports.export.xls.auto.filter" value="start"/> <property name="net.sf.jasperreports.export.xls.column.width" value="110"/> <property name="net.sf.jasperreports.export.xls.freeze.column.edge" value="left"/> </reportelement> &
Read more

media player - Android: mediaplayer went away with unhandled events -

-
i need duration of audio file series of voice announcements need play app. have added audio files resources , play fine. sample code below works perfect intended purpose: return duration of audio files. here code: float getdurationofaudioresource(locationenum loc, context context){ float duration = 0; try { mediaplayer mp; mp = mediaplayer.create(context, getaudioresource(loc)); duration = mp.getduration(); mp.release(); mp = null; } catch (illegalstateexception e) {e.printstacktrace(); logerror(25, "testdescitem:fault::could not open mediaplayer object audio resource.");} return duration; } here's weird thing. code called in main activity prepares set of audio instructions given test. there no errors within activity. second activity called, long string of errors on logcat. 03-07 13:23:43.820: i/actionlogger(21435): gentest_info_test #0 created. 03-07 13:23:43.830: i/actionlogger(21435): gente
Read more

python - ('The SQL contains 0 parameter markers, but 50 parameters were supplied', 'HY000') or TypeError: 'tuple' object is not callable -

-
import pyodbc,nltk,array cnxn = pyodbc.connect('driver={mysql odbc 5.1 driver};server=127.0.0.1;port=3306;database=information_schema;user=root; password=1234;option=3;') cursor = cnxn.cursor() cursor.execute("use collegedatabase ;") cursor.execute("select * sampledata ; ") cnxn.commit() s=[] j=[] x=[] words = [] w = [] sfq = [] pos=[] entry in cursor: s.append(entry.injury_type),j.append(entry.injury_desc) nltk.tokenize import punktwordtokenizer nltk.corpus import stopwords tokenizer = punktwordtokenizer() english_stops = set(stopwords.words('english')) in range(0,26): # filter stop words tokenizer.tokenize(j[i]) w.append([word word in tokenizer.tokenize(j[i]) if word not in english_stops]) in range(0 , 26):#converting tokenzied text ito string sfq.append(" ".join(w[a])) replacers import regexpreplacer replacer = regexpreplacer() in range (0,26):#pos tagging replacer.repl
Read more